public ActionResult MISServiceWiseCollectionReport(MISServiceWiseCollectionReport Model_obj) { BL_MISServiceWiseCollectionReport BlReport1 = new BL_MISServiceWiseCollectionReport(); Model_obj.FromDate = Convert.ToDateTime(Request.Form["Fromdate"]); Model_obj.ToDate = Convert.ToDateTime(Request.Form["Todate"]); Model_obj.PatientType = Request.Form["patient_type"]; Model_obj.ServiceGroupName = Request.Form["ServiceGroupID"]; Model_obj.ServiceName = Request.Form["ServiceID"]; Model_obj.PatientRegNo = Request.Form["PatientRegNo"]; if (Model_obj.PatientType == "") { Model_obj.PatientType = "All"; } if (Model_obj.ServiceGroupName == "") { Model_obj.ServiceGroupName = "%"; } if (Model_obj.ServiceName == "") { Model_obj.ServiceName = "%"; } HospitlLocationID(); Session["ServiceGroupName"] = Model_obj.ServiceGroupName; Session["Fromdate"] = Model_obj.FromDate; Session["Todate"] = Model_obj.ToDate; Model_obj.ds = BlReport1.ReportMISServicesWiseCollection(HospitalID, LocationID, Model_obj.FromDate, Model_obj.ToDate, Model_obj.ServiceName, Model_obj.ServiceGroupName, Model_obj.PatientType, Model_obj.PatientRegNo); Session["ServiceID"] = Model_obj.ServiceName; Session["ServiesGroupID"] = Model_obj.ServiceGroupName; if (Session["PatientType"] == "") { Session["PatientType"] = "All"; } else { Session["PatientType"] = Model_obj.PatientType; } foreach (DataRow dr in Model_obj.ds.Tables[0].Rows) { if (Model_obj.PatientType == "UnDischarge") { } } return(View(Model_obj)); }
public JsonResult GetClick(string ServiceID) { BL_MISServiceWiseCollectionReport BL_obj = new BL_MISServiceWiseCollectionReport(); MISServiceWiseCollectionReport obj = new MISServiceWiseCollectionReport(); obj.ServiceGroupName = Session["ServiceGroupName"].ToString(); obj.FromDate = Convert.ToDateTime(Session["FromDate"]); obj.ToDate = Convert.ToDateTime(Session["ToDate"]); //obj.PatientType = Session["PatientType"].ToString(); HospitlLocationID(); DataSet ds = BL_obj.ReportMISServicesWiseCollection(HospitalID, LocationID, obj.FromDate, obj.ToDate, ServiceID, obj.ServiceGroupName, "", ""); List <MISServiceWiseCollectionReport> searchList = new List <MISServiceWiseCollectionReport>(); foreach (DataRow dr in ds.Tables[2].Rows) { searchList.Add(new MISServiceWiseCollectionReport { 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 }); }
public ActionResult MISServiceWiseCollectionReport() { MISServiceWiseCollectionReport obj = new MISServiceWiseCollectionReport(); return(View()); }