public int Delete(DBConnection Connection, ref List <EXCEPTIONDC> lstExceptions, List <DAILYDC> objDAILs)
{
int deleteCount = 0;
foreach (DAILYDC objDAIL in objDAILs)
{
try
{
Connection.Open(true);
deleteCount = Delete(Connection, objDAIL);
Connection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = objDAIL.DAILY_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
}
finally { Connection.Close(); }
}
return(deleteCount);
}
public int Delete(DBConnection Connection, List <JOBDC> objMANAGE_JOBs, ref List <EXCEPTIONDC> lstExceptions)
{
int deleteCount = 0;
try
{
foreach (JOBDC objMANAGE_JOB in objMANAGE_JOBs)
{
try
{
Connection.Open(true);
deleteCount = Delete(Connection, objMANAGE_JOB);
Connection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = objMANAGE_JOB.JOB_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
Connection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception("Excption Occure");
}
}
catch (Exception exp)
{
throw exp;
}
return(deleteCount);
}
//public int Insert(DBConnection Connection, List<ErrorLogDC> objErrorLogs)
//{
// int insertCount = 0;
// foreach (ErrorLogDC errLog in objErrorLogs)
// {
// insertCount = Insert(Connection, errLog);
// }
// return insertCount;
//}
public int Insert(ErrorLogDC objErrorLog)
{
DBConnection Connection = new DBConnection();
Connection.Open(false);
int insertCount = 0;
try
{
if (objErrorLog.On == DateTime.MinValue)
{
objErrorLog.On = DateTime.Now;
}
StringBuilder sql = new StringBuilder();
sql.Append("proc_ErrorLogInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddOutParameter("EL_ID", DbType.Int32, objErrorLog.ErrorLogID);
dbCommandWrapper.AddInParameter("AU_ERROR_RECEIVER", DbType.Int32, objErrorLog.ErrorReceiver);
dbCommandWrapper.AddInParameter("EL_ERROR_ON", DbType.DateTime, objErrorLog.On);
dbCommandWrapper.AddInParameter("EL_ERROR_FROM", DbType.String, objErrorLog.From);
dbCommandWrapper.AddInParameter("EL_ERROR_DESCRIP", DbType.String, objErrorLog.Description);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
Connection.Commit();
return(insertCount);
}
catch (Exception ex)
{
objErrorLog.SetError(ex);
throw ex;
}
}