public JsonResult GetReportLabTestWithDetails(DateTime FromDate, DateTime ToDate, string PatientType, string TestID) { var id = ""; DataSet dsPatientBillNo = new DataSet(); List <ReportLabTestByName> searchlist = new List <ReportLabTestByName>(); BL_ReportLabTestByName objBL = new BL_ReportLabTestByName(); if (TestID == "0") { id = "%"; } else { id = Convert.ToInt32(TestID).ToString(); } dsPatientBillNo = objBL.ReportLabTestByName(FromDate, ToDate, PatientType, id); if (dsPatientBillNo.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsPatientBillNo.Tables[0].Rows) { searchlist.Add(new ReportLabTestByName { IPDNO = dr["IPDNO"].ToString(), Regno = dr["RegNo"].ToString(), TestName = dr["TestName"].ToString(), Qty = dr["Qty"].ToString(), PatientType = dr["PatientType"].ToString(), Patient = dr["Patient"].ToString(), ContactNo = dr["ContactNo"].ToString(), // OPDIPDID = dr["OPDIPDID"].ToString() }); } } return(new JsonResult { Data = searchlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult GetReportTestForPatientLabTestDetails(string prefix) { DataSet dsPatientBillNo = new DataSet(); List <ReportLabTestByName> searchlist = new List <ReportLabTestByName>(); BL_ReportLabTestByName objBL = new BL_ReportLabTestByName(); dsPatientBillNo = objBL.GetAllTestMasterForProfile(); if (dsPatientBillNo.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsPatientBillNo.Tables[0].Rows) { searchlist.Add(new ReportLabTestByName { TestName = dr["TestName"].ToString(), TestID = dr["TestID"].ToString() }); } } return(new JsonResult { Data = searchlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }