//--------------------------------------------------------------------------------------------- /// <summary> /// Log a message to the log file /// </summary> /// <param name="aSeverity"></param> /// <param name="aMessage"></param> public void Log(severities aSeverity, string aMessage) { DateTime timeNow = DateTime.Now; string logMsg = string.Empty; if (aSeverity == severities.sevDebug) { logMsg = string.Format("{0,12} : {1}\r\n", severityStrings[(int)aSeverity], aMessage); } else { logMsg = string.Format("{0} : {1,12} : {2}\r\n", timeNow.ToString(), severityStrings[(int)aSeverity], aMessage); // PKR. 22/09/2015. ABSEXCH-16655. Error reported: Invalid account code // Set a flag if an error or warning was logged. if ((aSeverity == severities.sevWarning) || (aSeverity == severities.sevError)) { LogContainsErrors = true; } } try { sw.Write(logMsg); lineCount++; sw.Flush(); } catch (Exception Ex) { MessageBox.Show("Log error : " + Ex.Message); } }
public ActionResult Index(int connId = 0) { LoggerModel List = new LoggerModel(); if (connId == 0) { List.ConStringId = 1; } else { List.ConStringId = connId; } List.HoursList = ((Common.HoursBeforeEnum[])Enum.GetValues(typeof(Common.HoursBeforeEnum))).Select(c => new SelectListItem() { Value = Convert.ToString((int)c), Text = c.ToString() }).ToList(); List.ConnectionList = ((Common.ConnectionStringName[])Enum.GetValues(typeof(Common.ConnectionStringName))).Select(c => new SelectListItem() { Value = Convert.ToString((int)c), Text = c.ToString() }).ToList(); string ConnString = Enum.GetName(typeof(Common.ConnectionStringName), List.ConStringId); List.Hours = (int)Common.HoursBeforeEnum.OneHours; using (SqlConnection conn = new SqlConnection(GetConnectionString(ConnString))) { SqlCommand cmd = new SqlCommand("GetLoggerCount"); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter(); param.ParameterName = "@hours"; param.Value = 10; cmd.Parameters.Add(param); cmd.Connection = conn; cmd.CommandTimeout = 120; conn.Open(); SqlDataAdapter MyDataAdapter = new SqlDataAdapter(); MyDataAdapter.SelectCommand = cmd; DataSet oDataset = new DataSet(); DataTable oDatatable = new DataTable(); cmd.ExecuteNonQuery(); MyDataAdapter.Fill(oDataset); oDatatable = oDataset.Tables[0]; conn.Close(); foreach (DataRow dr in oDatatable.Rows) { if (Convert.ToInt32(dr["SeverityCount"].ToString()) > 0) { Loggers obj = new Loggers(); obj.Logger = dr["Logger"].ToString(); obj.LoggerCount = Convert.ToInt32(dr["LoggerCount"].ToString()); if (List.LoggerList.Where(t => t.Logger == obj.Logger && t.LoggerCount == obj.LoggerCount).Count() == 0) { List.LoggerList.Add(obj); } severities Objs = new severities(); Objs.Logger = dr["Logger"].ToString(); Objs.Severity = dr["Severity"].ToString(); Objs.SeverityCount = Convert.ToInt32(dr["SeverityCount"].ToString()); List.SeverityList.Add(Objs); } } } List.ApplicationList = GetApplicationList(List.ConStringId, List.ApplicationCode); return(View(List)); }