public void ExecuteNonQuery(string command)
{
try
{
using (var orclDbManager = new OrclDBManager())
{
using (var orclTranManager = new OrclTranManager(orclDbManager, OrclTranOption.None))
{
try
{
orclTranManager.CommandType = CommandType.Text;
orclTranManager.CommandText = command;
orclTranManager.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}
catch (Exception)
{
throw;
}
}
public DataTable GetDatatable(string command)
{
DataSet dataSet;
try
{
using (var orclDbManager = new OrclDBManager())
{
using (var orclTranManager = new OrclTranManager(orclDbManager, OrclTranOption.None))
{
try
{
orclTranManager.CommandType = CommandType.Text;
orclTranManager.CommandText = command;
dataSet = orclTranManager.GetData();
}
catch (Exception)
{
throw;
}
}
}
}
catch (Exception ex)
{
throw;
}
if (dataSet.Tables.Count == 0)
{
return new DataTable();
}
return dataSet.Tables[0];
}
