public object ExecuteScalar(string query)
{
object result = null;
OracleCommand cmd = null;
try
{
if (ConnectionOpen())
{
cmd = _Connection.CreateCommand();
cmd.CommandText = query;
result = cmd.ExecuteScalar();
if (result == null)
{
result = "";
}
}
}
catch (Exception ex)
{
LogIslemleri.LogYaz(ex.Message);
result = "";
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
CloseConnection();
}
return(result);
}
public int StartDBListening(string query, OnChangeEventHandler func)
{
int result = -1;
OracleCommand cmd = null;
try
{
if (ConnectionOpen())
{
cmd = new OracleCommand(query, _Connection);
cmd.AddRowid = true;
//OracleDependency dep = new OracleDependency(cmd);
dep.AddCommandDependency(cmd);
cmd.Notification.IsNotifiedOnce = false;
bool buldu = false;
foreach (var item in dep.RegisteredResources)
{
if (item.ToString() == query)
{
buldu = true;
}
}
if (buldu == false)
{
dep.OnChange += new OnChangeEventHandler(func);
}
cmd.ExecuteNonQuery();
}
}
catch (OracleException oex)
{
}
catch (Exception ex)
{
LogIslemleri.LogYaz(ex.Message);
result = -1;
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
CloseConnection();
}
return(result);
}
