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