public ActionResult PatientMedicalReturn(PatientMedicalReturn obj, FormCollection fc) { try { obj.postingAccount = fc["postingAccount"].ToString(); obj.tblProductName = fc["tblProductName"].ToString(); obj.tblProductID = fc["tblProductID"].ToString(); obj.tblbatchNumber = fc["tblbatchNumber"].ToString(); obj.tblmrp = fc["tblmrp"].ToString(); obj.tblexpiryDate = fc["tblexpiryDate"].ToString(); obj.tblnetRate = fc["tblnetRate"].ToString(); obj.tblQtyU = fc["tblQtyU"].ToString(); obj.tblQtyL = fc["tblQtyL"].ToString(); obj.tbldiscountPercentage = fc["tbldiscountPercentage"].ToString(); obj.tbltotalAmount = fc["tbltotalAmount"].ToString(); obj.tblfreeQuantity = fc["tblfreeQuantity"].ToString(); int saleID = obj.medicalReturnID; if (BL_obj.Save(obj)) { if (saleID == 0) { ModelState.Clear(); TempData["msg"] = "Medical Bill Return Saved Successfully !"; Session["medID"] = obj.medicalReturnID; return(RedirectToAction("medicalBillReturn", "PharmacyReport")); } else { ModelState.Clear(); TempData["msg"] = "Medical Bill Return Updated Successfully !"; Session["medID"] = obj.medicalReturnID; return(RedirectToAction("medicalBillReturn", "PharmacyReport")); } } else { ModelState.Clear(); TempData["msg"] = "Medical Bill Return Not Saved !"; } } catch (Exception ex) { return(RedirectToAction("PatientMedicalReturn", "PatientMedicalReturn")); } return(RedirectToAction("PatientMedicalReturn", "PatientMedicalReturn")); }
public bool Save(PatientMedicalReturn obj) { try { int regno = Convert.ToInt32(obj.patientRegNo); DataTable dt = Bind_patDetail(regno); Connect(); SqlCommand cmd = new SqlCommand("IUPatientBillsMedicalReturn", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (obj.medicalReturnID == 0) { cmd.Parameters.AddWithValue("@MedicalBillID", 0); cmd.Parameters["@MedicalBillID"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@Mode", "ADD"); } else { cmd.Parameters.AddWithValue("@MedicalBillID", obj.medicalReturnID); cmd.Parameters.AddWithValue("@Mode", "EDIT"); } if (obj.oldBillNumber == null || obj.oldBillNumber == "" || obj.oldBillNumber == "--New--") { cmd.Parameters.AddWithValue("@BillNo", 0); } else { cmd.Parameters.AddWithValue("@BillNo", obj.oldBillNumber); } if (obj.referenceDate == null || obj.referenceDate == "") { cmd.Parameters.AddWithValue("@BillDate", ""); } else { cmd.Parameters.AddWithValue("@BillDate", obj.referenceDate); } if (obj.patientRegNo == 0) { cmd.Parameters.AddWithValue("@PatientRegNo", 0); cmd.Parameters.AddWithValue("@BillType", "GeneralMedicalBill"); } else { cmd.Parameters.AddWithValue("@PatientRegNo", obj.patientRegNo); cmd.Parameters.AddWithValue("@BillType", dt.Rows[0]["PatientType"].ToString() + "MedicalBill"); } if (obj.patientName == null) { cmd.Parameters.AddWithValue("@PatientName", ""); } else { cmd.Parameters.AddWithValue("@PatientName", obj.patientName); } if (obj.address == null) { cmd.Parameters.AddWithValue("@Address", ""); } else { cmd.Parameters.AddWithValue("@Address", obj.address); } if (obj.remark == null) { cmd.Parameters.AddWithValue("@Remarks", ""); } else { cmd.Parameters.AddWithValue("@Remarks", obj.remark); } if (obj.doctorID == 0) { cmd.Parameters.AddWithValue("@DoctorID", 0); } else { cmd.Parameters.AddWithValue("@DoctorID", obj.doctorID); } if (obj.doctorName == null) { cmd.Parameters.AddWithValue("@DoctorName", ""); } else { cmd.Parameters.AddWithValue("@DoctorName", obj.doctorName); } if (obj.salesPersonID == 0) { cmd.Parameters.AddWithValue("@SalesPersonID", 0); } else { cmd.Parameters.AddWithValue("@SalesPersonID", obj.salesPersonID); } if (obj.salesPerson == null) { cmd.Parameters.AddWithValue("@SalesPersonName", ""); } else { cmd.Parameters.AddWithValue("@SalesPersonName", obj.salesPerson); } cmd.Parameters.AddWithValue("@PaymentType", "Cash"); cmd.Parameters.AddWithValue("@Number", "Cash"); cmd.Parameters.AddWithValue("@Name", "Cash"); cmd.Parameters.AddWithValue("@ChequeDate", DateTime.Now.Date); cmd.Parameters.AddWithValue("@Other", ""); cmd.Parameters.AddWithValue("@Message", "Cash"); if (obj.grossTotal == 0) { cmd.Parameters.AddWithValue("@GrossAmount", 0); } else { cmd.Parameters.AddWithValue("@GrossAmount", obj.grossTotal); } if (obj.discountAmount == 0) { cmd.Parameters.AddWithValue("@DiscountAmount", 0); } else { cmd.Parameters.AddWithValue("@DiscountAmount", obj.discountAmount); } if (obj.vatAmount == 0) { cmd.Parameters.AddWithValue("@TaxAmount", 0); } else { cmd.Parameters.AddWithValue("@TaxAmount", obj.vatAmount); } cmd.Parameters.AddWithValue("@SalesReturn", 0); if (obj.totalAmount == 0) { cmd.Parameters.AddWithValue("@TotalAmount", 0); } else { cmd.Parameters.AddWithValue("@TotalAmount", obj.totalAmount); } if (obj.discountPercentage == 0) { cmd.Parameters.AddWithValue("@DiscountPercent", 0); } else { cmd.Parameters.AddWithValue("@DiscountPercent", obj.discountPercentage); } if (obj.otherLess == 0) { cmd.Parameters.AddWithValue("@OtherLess", 0); } else { cmd.Parameters.AddWithValue("@OtherLess", obj.otherLess); } if (obj.netAmount == 0) { cmd.Parameters.AddWithValue("@NetAmount", 0); } else { cmd.Parameters.AddWithValue("@NetAmount", obj.netAmount); } cmd.Parameters.AddWithValue("@CashReceived", 0); if (obj.postingAccount == null || obj.postingAccount == "") { cmd.Parameters.AddWithValue("@PostingAccount", ""); } else { cmd.Parameters.AddWithValue("@PostingAccount", obj.postingAccount); } if (obj.referenceNumber == 0) { cmd.Parameters.AddWithValue("@RefNo", 0); } else { cmd.Parameters.AddWithValue("@RefNo", obj.referenceNumber); } if (obj.referenceDate == null || obj.referenceDate == "") { cmd.Parameters.AddWithValue("@RefDate", 0); } else { cmd.Parameters.AddWithValue("@RefDate", obj.referenceDate); } cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); obj.medicalReturnID = Convert.ToInt32(cmd.Parameters["@MedicalBillID"].Value); con.Close(); if (i > 0) { string[] prdctID = obj.tblProductID.Split(','); string[] prdctNm = obj.tblProductName.Split(','); for (int k = 0; k < prdctNm.Length; k++) { if (prdctNm[k].Trim() != "") { SqlCommand cmd1 = new SqlCommand("IUPatientBillsDetailsMedicalReturn", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@HospitalID", HospitalID); cmd1.Parameters.AddWithValue("@LocationID", LocationID); cmd1.Parameters.AddWithValue("@Mode", "ADD"); cmd1.Parameters.AddWithValue("@PatientBillsDetailsMedicalID", 0); cmd1.Parameters.AddWithValue("@MedicalBillID", Convert.ToInt32(obj.medicalReturnID)); if (obj.oldBillNumber == null || obj.oldBillNumber == "" || obj.oldBillNumber == "--New--") { cmd1.Parameters.AddWithValue("@BillNo", 0); } else { cmd1.Parameters.AddWithValue("@BillNo", obj.oldBillNumber); } cmd1.Parameters.AddWithValue("@ProductID", obj.tblProductID.Split(',')[k]); cmd1.Parameters.AddWithValue("@ProductName", obj.tblProductName.Split(',')[k]); cmd1.Parameters.AddWithValue("@ProductUnitID", 1); cmd1.Parameters.AddWithValue("@ProductDetailID", obj.ProductDetailsID); cmd1.Parameters.AddWithValue("@BatchNo", obj.tblbatchNumber.Split(',')[k]); cmd1.Parameters.AddWithValue("@ExpiryDate", obj.tblexpiryDate.Split(',')[k]); cmd1.Parameters.AddWithValue("@MRP", obj.tblmrp.Split(',')[k]); cmd1.Parameters.AddWithValue("@SalesRate", obj.tblnetRate.Split(',')[k]); cmd1.Parameters.AddWithValue("@Quantity", obj.tblQtyU.Split(',')[k]); cmd1.Parameters.AddWithValue("@QuantityL", obj.tblQtyL.Split(',')[k]); cmd1.Parameters.AddWithValue("@FreeQuantity", obj.tblfreeQuantity.Split(',')[k]); if (obj.patientRegNo == 0) { cmd1.Parameters.AddWithValue("@BillType", "GeneralMedicalBill"); } else { cmd1.Parameters.AddWithValue("@BillType", dt.Rows[0]["PatientType"].ToString() + "MedicalBill"); } cmd1.Parameters.AddWithValue("@TotalAmount", obj.tbltotalAmount.Split(',')[k]); cmd1.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int j = cmd1.ExecuteNonQuery(); con.Close(); } } } } catch (Exception ex) { throw ex; } return(true); }