public JsonResult GetReportLabTestByCategoryDetails(DateTime FromDate, DateTime ToDate, string PatientType, int CategoryID) { var Cat = ""; var type = ""; DataSet dsPatientBillNo = new DataSet(); List <ReportLabTestByCategory> searchlist = new List <ReportLabTestByCategory>(); BL_ReportLabTestByCategory objBL = new BL_ReportLabTestByCategory(); if (PatientType == "All") { type = "%"; } else { type = (PatientType).ToString(); } if (CategoryID == 0) { Cat = "%"; } else { Cat = Convert.ToInt32(CategoryID).ToString(); } dsPatientBillNo = objBL.GetReportLabTestByCategory(FromDate, ToDate, type, Cat); if (dsPatientBillNo.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsPatientBillNo.Tables[0].Rows) { searchlist.Add(new ReportLabTestByCategory { ParentCategoryName = dr["ParentCategoryName"].ToString(), TestName = dr["TestName"].ToString(), TestDate = (dr["TestDate"]).ToString(), CategoryName = dr["CategoryName"].ToString(), PatientName = dr["PatientName"].ToString(), PatientType = dr["PatientType"].ToString(), Gender = dr["Gender"].ToString(), Count = dr["Count"].ToString() }); } } return(new JsonResult { Data = searchlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult GetAllCategory(string DisReason) { BL_ReportLabTestByCategory obj = new BL_ReportLabTestByCategory(); List <ReportLabTestByCategory> searchlist = new List <ReportLabTestByCategory>(); DataSet ds = obj.GetAllCategoryData(); foreach (DataRow dr in ds.Tables[0].Rows) { searchlist.Add(new ReportLabTestByCategory { CategoryID = dr["CategoryID"].ToString(), CategoryName = dr["CategoryName"].ToString() }); } return(new JsonResult { Data = searchlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }