public DataReturnValue ExecuteNonQuery(string strSqlCommand)
{
DataReturnValue rv = new DataReturnValue();
try
{
DataSet DS = new DataSet();
DataTable DT = new DataTable();
DbCommand Comm = Factory.CreateCommand();
Comm.CommandText = strSqlCommand;
Comm.Connection = Connection;
FillParameters(Comm);
Comm.ExecuteNonQuery();
Comm.Dispose();
rv.Status = DataProcessState.Success;
}
catch (Exception Ex)
{
rv.Status = DataProcessState.Error;
rv.Error = Ex;
}
Return = rv;
WriteLog(Return);
return(rv);
}
public DataReturnValue ExecuteDataset(string strSqlCommand)
{
DataReturnValue rv = new DataReturnValue();
try
{
DataSet DS = new DataSet();
DbDataAdapter DAP = Factory.CreateDataAdapter();
DbCommand Comm = Factory.CreateCommand();
Comm.CommandText = strSqlCommand;
Comm.Connection = Connection;
FillParameters(Comm);
DAP.SelectCommand = Comm;
DAP.Fill(DS);
rv.Value = DS;
rv.Status = DataProcessState.Success;
}
catch (Exception Ex)
{
rv.Error = Ex;
rv.Status = DataProcessState.Error;
}
Return = rv;
WriteLog(Return);
return(rv);
}
/// <summary>
/// If return value status type is Error then write log.
/// </summary>
/// <param name="returnValue"></param>
private void WriteLog(DataReturnValue returnValue)
{
if (returnValue.Status == DataProcessState.Error)
{
BSLog l = new BSLog();
l.CreateDate = DateTime.Now;
l.LogID = Guid.NewGuid();
l.LogType = BSLogType.Error;
l.Message = returnValue.Error.Message;
l.RawUrl = HttpContext.Current.Request.RawUrl;
l.Source = returnValue.Error.Source;
l.StackTrace = returnValue.Error.StackTrace;
l.TargetSite = returnValue.Error.TargetSite;
l.Url = HttpContext.Current.Request.Url.ToString();
l.UserID = Blogsa.ActiveUser != null ? Blogsa.ActiveUser.UserID : 0;
l.Save();
}
}
/// <summary>
/// If return value status type is Error then write log.
/// </summary>
/// <param name="returnValue"></param>
private void WriteLog(DataReturnValue returnValue)
{
if (returnValue.Status == DataProcessState.Error)
{
BSLog l = new BSLog();
l.CreateDate = DateTime.Now;
l.LogID = Guid.NewGuid();
l.LogType = BSLogType.Error;
l.Message = returnValue.Error.Message;
l.RawUrl = HttpContext.Current.Request.RawUrl;
l.Source = returnValue.Error.Source;
l.StackTrace = returnValue.Error.StackTrace;
l.TargetSite = returnValue.Error.TargetSite;
l.Url = HttpContext.Current.Request.Url.ToString();
l.UserID = Blogsa.ActiveUser != null ? Blogsa.ActiveUser.UserID : 0;
l.Save();
}
}
public DataReturnValue ExecuteScalar(string strSqlCommand)
{
DataReturnValue rv = new DataReturnValue();
try
{
DbCommand Comm = Factory.CreateCommand();
Comm.CommandText = strSqlCommand;
Comm.Connection = Connection;
FillParameters(Comm);
rv.Value = Comm.ExecuteScalar();
Comm.Dispose();
rv.Status = DataProcessState.Success;
}
catch (Exception Ex)
{
rv.Status = DataProcessState.Error;
rv.Error = Ex;
}
Return = rv;
WriteLog(Return);
return rv;
}
public DataReturnValue ExecuteReader(string strSqlCommand)
{
DataProcessLog dpl = new DataProcessLog();
DataReturnValue rv = new DataReturnValue();
try
{
dpl.ExecutionStart = DateTime.Now;
dpl.Command = strSqlCommand;
DataSet DS = new DataSet();
DataTable DT = new DataTable();
using (DbCommand Comm = Factory.CreateCommand())
{
if (Comm != null)
{
Comm.CommandText = strSqlCommand;
Comm.Connection = Connection;
FillParameters(Comm);
rv.Value = Comm.ExecuteReader();
}
}
rv.Status = DataProcessState.Success;
}
catch (Exception Ex)
{
rv.Status = DataProcessState.Error;
rv.Error = Ex;
}
Return = rv;
WriteLog(Return);
dpl.ExecutionEnd = DateTime.Now;
dpl.ExecutionTime = dpl.ExecutionStart - dpl.ExecutionEnd;
WriteDPLog(dpl);
return rv;
}
public DataReturnValue ExecuteDataset(string strSqlCommand)
{
DataReturnValue rv = new DataReturnValue();
try
{
DataSet DS = new DataSet();
DbDataAdapter DAP = Factory.CreateDataAdapter();
DbCommand Comm = Factory.CreateCommand();
Comm.CommandText = strSqlCommand;
Comm.Connection = Connection;
FillParameters(Comm);
DAP.SelectCommand = Comm;
DAP.Fill(DS);
rv.Value = DS;
rv.Status = DataProcessState.Success;
}
catch (Exception Ex)
{
rv.Error = Ex;
rv.Status = DataProcessState.Error;
}
Return = rv;
WriteLog(Return);
return rv;
}
