private String Get_Val(String no) { String s = ""; if (no.Equals("-999")) { for (int i = 0; i < details.Count; i++) { Case_Details c = details.ElementAt(i); if (!c.alert.Equals("")) { s = s + c.alert + "$" + c.stage + "$" + c.Case_Type + "$" + c.case_no + "$" + c.date.Date.ToString("d") + "#"; } } } else { for (int i = 0; i < details.Count; i++) { Case_Details c = details.ElementAt(i); if (!c.alert.Equals("") && c.case_no.Equals(no)) { s = s + c.alert + "$" + c.stage + "$" + c.Case_Type + "$" + c.case_no + "$" + c.date.Date.ToString("d") + "#"; } } } return(s); }
private void Generate_Alert() { if (Execute_Query()) { for (int i = 0; i < dt.Rows.Count; i++) { String stat = dt.Rows[i][dt.Columns.Count - 11].ToString(); String ext = dt.Rows[i][dt.Columns.Count - 10].ToString(); int ex = 0; if (!ext.Equals("0")) { ex = Int32.Parse(ext); } int p = Find_Phase(i, stat); for (int j = p; j < dt.Columns.Count - 12; j++) { Case_Details c = new Case_Details(); c.case_no = dt.Rows[i][0].ToString(); String s = dt.Rows[i][j].ToString(); s = s.Replace("/", "#"); DateTime d = new DateTime(Int32.Parse(s.Split('#')[2]), Int32.Parse(s.Split('#')[0]), Int32.Parse(s.Split('#')[1])); d = d.AddDays(ex); c.date = d; c.Case_Type = this.Case_Type; c.stage = dt.Columns[j].ColumnName.ToString().Split('_')[0]; if (DateTime.Compare(System_Date, d) > 0) { c.alert = "Pending"; } else { c.alert = ""; } j++; details.Add(c); } } } else if (Case_Type.Equals("Verification_Admin")) { for (int i = 0; i < dt.Rows.Count; i++) { String stat = dt.Rows[i][4].ToString().ToLower(); if (stat.Equals("pending")) { Case_Details c = new Case_Details(); c.case_no = dt.Rows[i][0].ToString(); String s = dt.Rows[i][1].ToString(); s = s.Replace("/", "#"); DateTime d = new DateTime(Int32.Parse(s.Split('#')[2]), Int32.Parse(s.Split('#')[0]), Int32.Parse(s.Split('#')[1])); c.date = d; c.Case_Type = this.Case_Type; c.stage = ""; d = d.AddDays(15); if (DateTime.Compare(System_Date, d) > 0) { c.alert = "Pending"; } else { c.alert = ""; } details.Add(c); } } } else { for (int i = 0; i < dt.Rows.Count; i++) { String stat = dt.Rows[i][dt.Columns.Count - 9].ToString().ToLower(); if (stat.Equals("pending")) { Case_Details c = new Case_Details(); c.case_no = dt.Rows[i][0].ToString(); String s = dt.Rows[i][4].ToString(); s = s.Replace("/", "#"); DateTime d = new DateTime(Int32.Parse(s.Split('#')[2]), Int32.Parse(s.Split('#')[0]), Int32.Parse(s.Split('#')[1])); c.date = d; c.Case_Type = this.Case_Type; c.stage = ""; d = d.AddDays(15); if (DateTime.Compare(System_Date, d) > 0) { c.alert = "Pending"; } else { c.alert = ""; } details.Add(c); } } } }