private void GetClientE2ESeasonReleaseCaseno(HttpContext context)
{
string Year = context.Request["Year"];
if (string.IsNullOrEmpty(Year))
{
Year = DateTime.Now.Year.ToString();
}
BLL.QBR bll = new BLL.QBR();
DataSet ds = bll.GetClientE2ESeasonReleaseCaseno(Year);
List <Model.QBR.LSReleaseCaseNo> list = new List <Model.QBR.LSReleaseCaseNo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.QBR.LSReleaseCaseNo()
{
SeasonNum = dr["SeasonNum"].ToString(),
TT_Release = dr["TT_Release"].ToString(),
CaseNo = Convert.ToInt32(dr["CaseNo"].ToString() == "" ? 0 : dr["CaseNo"])
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
context.Response.Write(strJson);
}
private void GetSeasonTotalCaseno(HttpContext context)
{
BLL.QBR bll = new BLL.QBR();
DataSet ds = bll.GetSeasonTotalCaseno();
List <Model.QBR.LSReleaseCaseNo> list = new List <Model.QBR.LSReleaseCaseNo>();
DataRow dr = ds.Tables[0].Rows[0];
list.Add(new Model.QBR.LSReleaseCaseNo()
{
SeasonNum = dr["SeasonNum"].ToString(),
TT_Release = dr["TT_Release"].ToString(),
CaseNo = Convert.ToInt32(dr["CaseNo"].ToString() == "" ? 0 : dr["CaseNo"])
});
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list).TrimStart('[').TrimEnd(']');
context.Response.Write(strJson);
}
