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);
}
