public ActionResult MISConsultantDrService(MISConsultantDrService objCon, FormCollection fc) { try { BL_MISConsultantDrService obj = new BL_MISConsultantDrService(); MISConsultantDrService objModel = new MISConsultantDrService(); objCon.PaidAmtID = fc["PaidID"]; objCon.PaidDate = fc["PaidDate"]; objCon.PaidAmount = fc["ConAmt"]; objCon.ServiceID = fc["SerID"]; objCon.ServiceName = fc["SerName"]; objCon.ServiceAmount = fc["SerAmt"]; objCon.PatientID = fc["Regno"]; objCon.PatientName = fc["PatName"]; objCon.DrID = fc["DocrID"]; objCon.DrName = fc["DocName"]; objCon.BillAmt = fc["BillAmt"]; objCon.BillDt = fc["BillDt"]; objCon.BillNo = fc["Billno"]; if (objCon.PaidAmount != "") { // objCon.PaidDate=fc[""]; //objCon.PaidAmount = fc["PaidAmt"]; if (obj.Save(objCon)) { ModelState.Clear(); ViewData["flag"] = "Done"; TempData["msg"] = "Save Changes"; } } return(RedirectToAction("MISConsultantDrService", "MISConsultantDrService")); } catch (Exception Ex) { return(RedirectToAction("MISConsultantDrService", "MISConsultantDrService")); } return(View()); }
public ActionResult Save(string servicename, string id, string type) { string message = ""; try { BL_MISConsultantDrService obj = new BL_MISConsultantDrService(); MISConsultantDrService ConSer = new MISConsultantDrService(); //objReschedule.HospitalID = HospitalID; //objReschedule.LocationID = LocationID; ConSer.HospitalID = Convert.ToInt32(Session["HospitalID"]); ConSer.LocationID = Convert.ToInt32(Session["LocationID"]); int UserID = Convert.ToInt32(Session["UserID"]); ConSer.ServiceID = id; ConSer.ServiceName = servicename; ConSer.ServiceType = type; ConSer.Mode = "Add"; DataSet ds = obj.Getservicename(type); if (ds.Tables[0].Rows.Count > 0) { if (ConSer.Mode == "Add") { string ServiceType = ds.Tables[0].Rows[0]["ServiceType"].ToString(); Connect(); SqlCommand cmd = new SqlCommand("Delete from Getservicename where ServiceType like '" + ServiceType + '%' + "'", con); con.Open(); int a = cmd.ExecuteNonQuery(); con.Close(); } } if (obj.IUGetServices(ConSer)) { TempData["msg"] = "Successfully"; } //return RedirectToAction("MISConsultantDrService", "MISConsultantDrService"); return(new JsonResult { Data = "Successfully", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } catch (Exception ex) { message = ex.Message; } //return RedirectToAction("MISConsultantDrService", "MISConsultantDrService"); return(new JsonResult { Data = "Successfully", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public bool IUGetServices(MISConsultantDrService obj) { Connect(); SqlCommand cmd = new SqlCommand("IUGetServices", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (obj.ServiceID == "") { cmd.Parameters.AddWithValue("@ServiceID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@ServiceID", obj.ServiceID); } cmd.Parameters.AddWithValue("@ServiceType", obj.ServiceType); cmd.Parameters.AddWithValue("@ServiceName", obj.ServiceName); cmd.Parameters.AddWithValue("@Mode", "Add"); cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } }
public bool Save(MISConsultantDrService obj) { try { Connect(); if (obj.PaidAmtID == "") { string[] ConAmt = obj.PaidAmount.Split(','); string[] SerID = obj.ServiceID.Split(','); string[] SerName = obj.ServiceName.Split(','); string[] SerAmt = obj.ServiceAmount.Split(','); string[] Regno = obj.PatientID.Split(','); string[] PatName = obj.PatientName.Split(','); string[] DocrID = obj.DrID.Split(','); string[] DocName = obj.DrName.Split(','); string[] BillAmt = obj.BillAmt.Split(','); string[] BillDt = obj.BillDt.Split(','); string[] Billno = obj.BillNo.Split(','); for (int row = 0; row < ConAmt.Length; row++) { if (ConAmt[row].ToString() != "") { SqlCommand cmd = new SqlCommand("IUConsultantPaidAmount", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (obj.PaidAmtID == "" || obj.PaidAmtID == null) { cmd.Parameters.AddWithValue("@PaidAmtID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@PaidAmtID", obj.PaidAmtID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@BillDate", BillDt[row]); cmd.Parameters.AddWithValue("@ConsultantName", DocName[row]); cmd.Parameters.AddWithValue("@DoctorID", DocrID[row]); cmd.Parameters.AddWithValue("@patientname", PatName[row]); cmd.Parameters.AddWithValue("@PatientRegNo", Regno[row]); cmd.Parameters.AddWithValue("@ServiceName", SerName[row]); cmd.Parameters.AddWithValue("@serviceamount", SerAmt[row]); cmd.Parameters.AddWithValue("@ConsultantAmount", ConAmt[row]); cmd.Parameters.AddWithValue("@PaidDate", obj.PaidDate); cmd.Parameters.AddWithValue("@ServiceID", SerID[row]); cmd.Parameters.AddWithValue("@BillNo", Billno[row]); cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); } } } else { string[] PaidID = obj.PaidAmtID.Split(','); for (int i = 0; i < PaidID.Length; i++) { if (PaidID[i] != "") { SqlCommand cmd = new SqlCommand("update ConsultantPaidAmount set RowStatus = 1 where HospitalID = '" + HospitalID + "' and LocationID = '" + LocationID + "' and PaidAmtID =" + PaidID[i], con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } } return(true); } catch (Exception ex) { return(false); } }