public void RenewalAlerts()
{
clsAlerts obj = new clsAlerts();
obj.Op = 4;
DataTable dt = obj.Alerts(obj).Tables[0];
Context.Response.Write(JsonConvert.SerializeObject(dt));
}
string Renewal()
{
try
{
clsAlerts obj = new clsAlerts();
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
obj.Op = 4;
DataTable dt = obj.Alerts(obj).Tables[0];
return(dt.Rows.Count.ToString());
}
catch
{
return("");
}
}
void LoadAlerts()
{
clsAlerts obj = new clsAlerts();
obj.Op = 4;
DataTable dt = obj.Alerts(obj).Tables[0];
grdAlerts.DataSource = dt;
grdAlerts.DataBind();
if (grdAlerts.Rows.Count > 0)
{
lblError.Text = "";
}
else
{
lblError.Text = "No records found";
}
}
void LoadAlerts()
{
clsAlerts obj = new clsAlerts();
obj.Op = 7;
obj.SiteID = Convert.ToInt32(Request.Cookies["SiteID"].Value);
DataTable dt = obj.Alerts(obj).Tables[0];
grdAlerts.DataSource = dt;
grdAlerts.DataBind();
if (grdAlerts.Rows.Count > 0)
{
lblError.Text = "";
}
else
{
lblError.Text = "No Records found";
}
}
/*
* Op=1 New Parts Alert for Admin
* Op=2 New indent alerts for Admin
* Op=3 Purchase Order alers for Site
* Op=4 Renewal alers for admin
* Op=5 Parts Alert for Site
* Op=6 indent alerts for Site
* Op=7 Renewal alers for Site*/
public DataSet Alerts(clsAlerts obj)
{
try
{
connect();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@SiteID", obj._SiteID);
param[1] = new SqlParameter("@Op", obj._Op);
DataSet ds = SqlHelper.ExecuteDataset(co, "procAlerts", param);
return(ds);
}
catch
{
return(null);
}
finally
{
co.Close();
}
}
