public static List <SMAlert> GetAllAlertsSM(string sortColumn) { List <SMAlert> listSMAlerts = new List <SMAlert>(); string sp_name = "sp_viewalerts_SM"; string dbConnection = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(dbConnection)) { con.Open(); SqlCommand cmd = new SqlCommand(sp_name, con); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 120; SqlDataReader rdr = cmd.ExecuteReader(); String firstalert = ""; string Application = ""; string Instance = ""; string eNote_Monitor = ""; string MSEvent_IM = ""; string MSEvent_SD = ""; string Schedule_agent = ""; string Schedule_ocm = ""; string Schedule_sla3 = ""; while (rdr.Read()) { SMAlert alert = new SMAlert(); //alert.id = Convert.ToInt32(rdr["id"]); if (rdr["BacklogDate"].ToString() == firstalert) { alert.Application = Application; alert.Instance = Instance; alert.BacklogDate = firstalert; if (!string.IsNullOrEmpty(eNote_Monitor)) { alert.eNote_Monitor = " Backlog " + (DateTime.Parse(eNote_Monitor) - DateTime.Parse(rdr["eNote Monitor"].ToString())) + " From - " + eNote_Monitor + " To - " + rdr["eNote Monitor"].ToString(); } if (!string.IsNullOrEmpty(MSEvent_IM)) { alert.MSEvent_IM = " Backlog " + (DateTime.Parse(MSEvent_IM) - DateTime.Parse(rdr["MSEvent_IM"].ToString())) + " From - " + MSEvent_IM + " To - " + rdr["MSEvent_IM"].ToString(); } if (!string.IsNullOrEmpty(MSEvent_SD)) { alert.MSEvent_SD = " Backlog " + (DateTime.Parse(MSEvent_SD) - DateTime.Parse(rdr["MSEvent_SD"].ToString())) + " From - " + MSEvent_SD + " To - " + rdr["MSEvent_SD"].ToString(); } if (!string.IsNullOrEmpty(Schedule_agent)) { alert.Schedule_agent = " Backlog " + (DateTime.Parse(Schedule_agent) - DateTime.Parse(rdr["Schedule agent"].ToString())) + " From - " + Schedule_agent + " To - " + rdr["Schedule agent"].ToString(); } if (!string.IsNullOrEmpty(Schedule_ocm)) { alert.Schedule_ocm = " Backlog " + (DateTime.Parse(Schedule_ocm) - DateTime.Parse(rdr["Schedule ocm"].ToString())) + " From - " + Schedule_ocm + " To - " + rdr["Schedule ocm"].ToString(); } if (!string.IsNullOrEmpty(Schedule_sla3)) { alert.Schedule_sla3 = " Backlog " + (DateTime.Parse(Schedule_sla3) - DateTime.Parse(rdr["Schedule sla3"].ToString())) + " From - " + Schedule_sla3 + " To - " + rdr["Schedule sla3"].ToString(); } listSMAlerts.Add(alert); } else { Application = rdr["Application"].ToString(); Instance = rdr["Instance"].ToString(); firstalert = rdr["BacklogDate"].ToString(); eNote_Monitor = rdr["eNote Monitor"].ToString(); MSEvent_IM = rdr["MSEvent_IM"].ToString(); MSEvent_SD = rdr["MSEvent_SD"].ToString(); Schedule_agent = rdr["Schedule agent"].ToString(); Schedule_ocm = rdr["Schedule ocm"].ToString(); Schedule_sla3 = rdr["Schedule sla3"].ToString(); } } } return(listSMAlerts); }
public DataSet getDashboardBacklogCrosstab(string dbConnection, string application, string instance, string priority, string monitor, string fromDate, string toDate) { //====================== Old Code Not used ======================================================= string sql = "sp_viewalerts_SM"; Logger.writeDebug("getDashboardBacklogCrosstab - " + sql); List <SMAlert> listSMAlerts = new List <SMAlert>(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); try { SqlConnection dbConn = new SqlConnection(dbConnection); SqlCommand cmd = new SqlCommand(sql, dbConn); SqlDataAdapter sqlda = new SqlDataAdapter(sql, dbConn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@p_application", application)); cmd.Parameters.Add(new SqlParameter("@p_instance", instance)); cmd.Parameters.Add(new SqlParameter("@p_priority", Convert.ToInt32(priority))); sqlda.SelectCommand.CommandTimeout = 240; sqlda.SelectCommand = cmd; SqlDataReader rdr = cmd.ExecuteReader(); Logger.writeDebug("getDashboardBacklogCrosstab - sql execute complete "); sqlda.Fill(ds); //foreach (DataTable t in ds.Tables) //{ // Console.WriteLine("Table " + t.TableName + " is in dataset"); // Console.WriteLine("Row 0, column 1: " + t.Rows[0][1]); // Console.WriteLine("Row 1, column 1: " + t.Rows[1][1]); // Console.WriteLine("Row 2, column 1: " + t.Rows[2][1]); //} String firstalert = ""; string Application = ""; string Instance = ""; string eNote_Monitor = ""; string MSEvent_IM = ""; string MSEvent_SD = ""; string Schedule_agent = ""; string Schedule_ocm = ""; string Schedule_sla3 = ""; while (rdr.Read()) { SMAlert alert = new SMAlert(); //alert.id = Convert.ToInt32(rdr["id"]); if (rdr["BacklogDate"].ToString() == firstalert) { alert.Application = Application; alert.Instance = Instance; alert.BacklogDate = firstalert; if (!string.IsNullOrEmpty(eNote_Monitor)) { alert.eNote_Monitor = " Backlog " + (DateTime.Parse(eNote_Monitor) - DateTime.Parse(rdr["eNote Monitor"].ToString())) + " From - " + eNote_Monitor + " To - " + rdr["eNote Monitor"].ToString(); } if (!string.IsNullOrEmpty(MSEvent_IM)) { alert.MSEvent_IM = " Backlog " + (DateTime.Parse(MSEvent_IM) - DateTime.Parse(rdr["MSEvent_IM"].ToString())) + " From - " + MSEvent_IM + " To - " + rdr["MSEvent_IM"].ToString(); } if (!string.IsNullOrEmpty(MSEvent_SD)) { alert.MSEvent_SD = " Backlog " + (DateTime.Parse(MSEvent_SD) - DateTime.Parse(rdr["MSEvent_SD"].ToString())) + " From - " + MSEvent_SD + " To - " + rdr["MSEvent_SD"].ToString(); } if (!string.IsNullOrEmpty(Schedule_agent)) { alert.Schedule_agent = " Backlog " + (DateTime.Parse(Schedule_agent) - DateTime.Parse(rdr["Schedule agent"].ToString())) + " From - " + Schedule_agent + " To - " + rdr["Schedule agent"].ToString(); } if (!string.IsNullOrEmpty(Schedule_ocm)) { alert.Schedule_ocm = " Backlog " + (DateTime.Parse(Schedule_ocm) - DateTime.Parse(rdr["Schedule ocm"].ToString())) + " From - " + Schedule_ocm + " To - " + rdr["Schedule ocm"].ToString(); } if (!string.IsNullOrEmpty(Schedule_sla3)) { alert.Schedule_sla3 = " Backlog " + (DateTime.Parse(Schedule_sla3) - DateTime.Parse(rdr["Schedule sla3"].ToString())) + " From - " + Schedule_sla3 + " To - " + rdr["Schedule sla3"].ToString(); } listSMAlerts.Add(alert); } else { Application = rdr["Application"].ToString(); Instance = rdr["Instance"].ToString(); firstalert = rdr["BacklogDate"].ToString(); eNote_Monitor = rdr["eNote Monitor"].ToString(); MSEvent_IM = rdr["MSEvent_IM"].ToString(); MSEvent_SD = rdr["MSEvent_SD"].ToString(); Schedule_agent = rdr["Schedule agent"].ToString(); Schedule_ocm = rdr["Schedule ocm"].ToString(); Schedule_sla3 = rdr["Schedule sla3"].ToString(); } } //return listSMAlerts; return(ds); } catch (Exception ex) { Logger.writeError("Error encounterd for method getDashboardBacklogCrosstab() ", ex); return(ds); } }