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; } }