internal void FetchCABErrors(CABErrors ErrorLog, SafeDataReader dr) { ErrorLog.ID = dr.GetInt32("ID"); ErrorLog.ERROR_NUMBER = dr.GetString("ERROR_NUMBER"); ErrorLog.ERROR_SEVERITY = dr.GetString("ERROR_SEVERITY"); ErrorLog.ERROR_STATE = dr.GetString("ERROR_STATE"); ErrorLog.ERROR_PROCEDURE = dr.GetString("ERROR_PROCEDURE"); ErrorLog.ERROR_LINE = dr.GetString("ERROR_LINE"); ErrorLog.ERROR_MESSAGE = dr.GetString("ERROR_MESSAGE"); ErrorLog.SCCode = dr.GetString("SCCode"); ErrorLog.ONDate = dr.GetString("ONDate"); ErrorLog.Client = dr.GetString("Client"); ErrorLog.FeeCode = dr.GetString("FeeCode"); ErrorLog.CREATEDATE = dr.GetDateTime("CREATEDATE").ToString("dd MMM yyyy hh:mm:ss tt"); }
/// <summary> /// Created By : Pavan /// Created Date : 1 July 2015 /// Modified By : /// Modified Date : /// </summary> /// <returns>Error Log List</returns> public static List<CABErrors> GetCABErrors() { List<CABErrors> ErrLogs = new List<CABErrors>(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetCABErrorDetails"); var safe = new SafeDataReader(reader); while (reader.Read()) { var ErrorLog = new CABErrors(); ErrorLog.FetchCABErrors(ErrorLog, safe); ErrLogs.Add(ErrorLog); } log.Debug("End: " + methodBase.Name); return ErrLogs; }