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