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