public JsonResult GetPatientNameValue(string prefix) { BL_MISPatientIPDDischargeSummary BlReport = new BL_MISPatientIPDDischargeSummary(); return(new JsonResult { Data = BlReport.GetPatientName(prefix), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult MISPatientIPDDischargeSummary(DateTime DateFrom, DateTime DateTo, string PatientType, string SearchName, string EndResult) { if (SearchName == "") { SearchName = "%"; } if (EndResult == "" || EndResult == null) { EndResult = "%"; } BL_MISPatientIPDDischargeSummary BlReport1 = new BL_MISPatientIPDDischargeSummary(); HospitalLocation(); return(new JsonResult { Data = BlReport1.MISPatientIPDDischargeSummary(HospitalID, LocationID, DateFrom, DateTo, PatientType, SearchName, EndResult), JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult GetClick(string ServiceID) { BL_MISPatientIPDDischargeSummary BL_obj = new BL_MISPatientIPDDischargeSummary(); MISPatientIPDDischargeSummary obj = new MISPatientIPDDischargeSummary(); obj.PatientType = Session["PatientType"].ToString(); obj.SearchName = Session["SearchName"].ToString(); obj.EndResult = Session["EndResult"].ToString(); obj.FromDate = Convert.ToDateTime(Session["FromDate"]); obj.ToDate = Convert.ToDateTime(Session["ToDate"]); //obj.PatientType = Session["PatientType"].ToString(); // HospitlLocationID(); //DataSet ds = BL_obj.MISPatientIPDDischargeSummary(HospitalID, LocationID, obj.FromDate, obj.ToDate, obj.PatientType, obj.SearchName, obj.EndResult); List <MISPatientIPDDischargeSummary> searchList = new List <MISPatientIPDDischargeSummary>(); //foreach (DataRow dr in ds.Tables[2].Rows) //{ // searchList.Add(new MISPatientIPDDischargeSummary // { // PatientRegNo = dr["PatientRegNo"].ToString(), // PatientName = dr["PatientName"].ToString(), // ServiceName = dr["ServiceName"].ToString(), // Qty = dr["QTY"].ToString(), // TotalAmount = dr["Total Amount"].ToString(), // TotalAmt1 = Convert.ToString(ds.Tables[2].Compute("sum([Total Amount])", string.Empty).ToString()) // // DoctorPrintName = dr["DoctorPrintName"].ToString() // }); //} return(new JsonResult { Data = searchList, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }