public bool Add(ErrorLogDC errorLog)
{
DBConnection conn = null;
conn = new DBConnection();
bool success = true;
ErroLogDA errorLogHandler = new ErroLogDA();
// ErrorLogDC errorLogList = new ErrorLogDC();
try
{
conn.Open(false);
errorLogHandler.Insert(errorLog);
}
catch (Exception exp)
{
success = false;
throw exp;
}
finally
{
conn.Close();
}
return(success);
}
public static void InsertIntoErrorLog(String source, String StrStackTrace, int UserID)
{
//Write into database
try
{
ErrorLogBL errorLog
= new ErrorLogBL();
ErrorLogDC errorLogDC = new ErrorLogDC();
if (StrStackTrace.Length > 1999)
{
errorLogDC.Description = StrStackTrace.Substring(0, 1999);
}
else
{
errorLogDC.Description = StrStackTrace;
}
errorLogDC.On = DateTime.Now;
if (source.Length > 99)
{
errorLogDC.From = source.Substring(0, 99);
}
else
{
errorLogDC.From = source;
}
errorLogDC.ErrorReceiver = UserID;
errorLog.Add(errorLogDC);
}
catch (Exception)
{
}
//Write into File
try
{
String logFile = System.Web.HttpContext.Current.Server.MapPath("~/ErrorLog.txt");
System.IO.FileStream file = new
System.IO.FileStream(logFile, System.IO.FileMode.Append);
System.IO.StreamWriter sw = new System.IO.StreamWriter(file);
sw.WriteLine("DateTime: " + DateTime.Now.ToString());
sw.WriteLine("Error Receiver ID: " + UserID);
//sw.WriteLine("Message: " + expection.Message);
//sw.WriteLine("InnerException: " + expection.InnerException);
sw.WriteLine("From: " + source);
sw.WriteLine("Description: " + StrStackTrace);
sw.WriteLine("--------------------------------------------------");
sw.Close();
file.Close();
}
catch (Exception ex)
{
}
}
//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;
}
}
