Ejemplo n.º 1
0
        //---------------------------------------------------------------------------------------------
        /// <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));
        }