System.Data;
System.Data.OracleClient;

public class oracleDataAccess
{
	public DataTable dataTable { get; set; }
	public string queryString { get; set; }
	public string oracleConnectionString { get; set; }
	private OracleConnection oracleConnection { get; set;}
	private OracleCommand oracleCommand { get; set; } 
	private OracleTransaction oracleTransaction { get; set; }
	private OracleDataAdapter oracleAdapter { get; set; }

	//INITIATE CONNECTION TO ORACLE DATABASE
	public void OpenConnection(oracleConnectionString)
	{
		try
		{
			using(oracleConnection = new OracleConnection(oracleConnectionString))
			{
				oracleConnection.Open();
			}
		}
		catch
		{
			throw exception
		}
	}


	//CLOSE CONNECTION TO ORACLE DATABASE
	public void CloseConnection()
	{
		try
		{
			oracleConnection.Close();
		}
		catch
		{
			throw exception
		}
	}

	//ORACLE TRANSACTIONS(INSERT/CREATE, UPDATE, DELETE)
	public bool oracleTransact(queryString)
	{
		oracleCommand = oracleConnection.CreateCommand();
		oracleTransaction = Begin.Transaction();
		oracleCommand.Transaction = oracleTransaction;
		
		try
		{
			oracleCommand.CommandText = queryString;
			oracleCommand.ExecuteNonQuery();
			oracleTransaction.Commit();
			return true;
		}
		catch(Exception e)
		{
			oracleTransaction.Rollback();
			return false;
			//get the error
			//e.Message.ToString();
		}
	}
	
	//ORACLE SELECT QUERY(RETRIEVE DATA)
	public bool oracleQuery(queryString)
	{
		oracleCommand = oracleConnection.CreateCommand();
		DataSet dataSet = new DataSet();
		
		try
		{
			oracleCommand.CommandText = queryString;
			oracleAdapter = new OracleDataAdapter(oracleCommand);
			oracleAdapter.Fill(dataSet);
			dataTable = dataSet.Tables[0]; //this will hold all the data retrieved
			
			return true;
		}
		catch(Exception e)
		{
			return false;
			//get the error message
			//e.Message.ToString();
		}
	}
}