public ActionResult PatientPrivilegeCard(PatientPrivilegeCard obj, FormCollection fc) { BL_PatientPrivilegeCard _PatientPrivilegeCard = new BL_PatientPrivilegeCard(); obj.CardName = ""; obj.CardName = fc["CardName1"].ToString(); obj.PrivilegeCardID = Convert.ToInt32(fc["CardName"].ToString()); obj.PriceAmt = Convert.ToInt32(fc["Price"].ToString()); obj.PriceName = fc["PriceName1"].ToString(); obj.PrivilegePriceDetailID = fc["PrivilegePriceDetailID"].ToString(); // obj.PatientPrivilegeCardID =Convert.ToInt32(fc["PatientPrivilegeCardID"].ToString()); //obj.AmountName = fc["AccountName1"].ToString(); if (_PatientPrivilegeCard.Save(obj)) { ModelState.Clear(); TempData["msg"] = "Record Saved Successfully"; } else { ViewData["flag"] = "Error"; } return(RedirectToAction("PatientPrivilegeCard", "PatientPrivilegeCard")); // return View(); }
public bool Save(PatientPrivilegeCard obj) { Connect(); con.Open(); if (obj.CardName != null) { #region PatientPrivilegeCard SqlCommand cmd = new SqlCommand("IUPatientPrivilegeCard", con); cmd.CommandType = CommandType.StoredProcedure; if (obj.PatientRegNo != null) { cmd.Parameters.AddWithValue("@PatientRegNo", obj.PatientRegNo); } else { cmd.Parameters.AddWithValue("@PatientRegNo", 0); } cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@PrivilegeCardID", obj.PrivilegeCardID); if (obj.PatientPrivilegeCardID == 0) { cmd.Parameters.AddWithValue("@PatientPrivilegeCardID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@PatientPrivilegeCardID", obj.PatientPrivilegeCardID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } if (obj.PrivilegePriceDetailID.ToString() != "0") { cmd.Parameters.AddWithValue("@PrivilegePriceDetailID", obj.PrivilegePriceDetailID); } else { cmd.Parameters.AddWithValue("@PrivilegePriceDetailID", 0); } // cmd.Parameters.AddWithValue("@PatientRegNo", Convert.ToInt32(obj.PatientRegNo)); cmd.Parameters.AddWithValue("@PrivilegeDate", Convert.ToDateTime(obj.PrivilegeDate)); cmd.Parameters.AddWithValue("@PatientName", obj.PFirstName + " " + obj.PMiddleName + " " + obj.PLastName); if (obj.CardName == null) { cmd.Parameters.AddWithValue("@CardName", ""); } else { cmd.Parameters.AddWithValue("@CardName", obj.CardName); } if (obj.PriceName == null) { cmd.Parameters.AddWithValue("@PriceName", ""); } else { cmd.Parameters.AddWithValue("@PriceName", obj.PriceName); } if (obj.PriceAmt == null) { cmd.Parameters.AddWithValue("@PriceAmt", ""); } else { cmd.Parameters.AddWithValue("@PriceAmt", obj.PriceAmt); } // cmd.Parameters.AddWithValue("@PriceAmt", obj.PriceAmt); if (obj.AmountName == null || obj.AmountName == "") { cmd.Parameters.AddWithValue("@AccountName", ""); } else { cmd.Parameters.AddWithValue("@AccountName", obj.AmountName); } if (obj.PaidAmt == null) { cmd.Parameters.AddWithValue("@PaidAmt", 0); } else { cmd.Parameters.AddWithValue("@PaidAmt", obj.PaidAmt); } cmd.Parameters.AddWithValue("@ValidDate", Convert.ToDateTime(obj.ValidDate)); if (obj.Remark == null) { cmd.Parameters.AddWithValue("@Remark", ""); } else { cmd.Parameters.AddWithValue("@Remark", obj.Remark); } // cmd.Parameters.AddWithValue("@Remark", obj.Remark); cmd.Parameters.AddWithValue("@CreationID", UserID); // cmd.Parameters.AddWithValue("@Mode", "Add"); int i = cmd.ExecuteNonQuery(); #endregion #region IUVoucharEntry SqlCommand cmd1 = new SqlCommand("[IUVoucharEntry]", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@HospitalID", HospitalID); cmd1.Parameters.AddWithValue("@LocationID", LocationID); cmd1.Parameters.AddWithValue("@ReferenceCode", 0); cmd1.Parameters.AddWithValue("@VoucharEntryID", obj.VoucharEntryID); cmd1.Parameters.AddWithValue("@AccountsID", 1); cmd1.Parameters.AddWithValue("@VoucharID", 5); cmd1.Parameters.AddWithValue("@VoucharName", "CASH RECEIPTS"); cmd1.Parameters.AddWithValue("@RefVoucharNo", ""); cmd1.Parameters.AddWithValue("@CurrentDate", Convert.ToDateTime(obj.PrivilegeDate)); cmd1.Parameters.AddWithValue("@VoucharDate", Convert.ToDateTime(obj.PrivilegeDate)); cmd1.Parameters.AddWithValue("@Narration", obj.PatientRegNo + "--" + obj.PFirstName + "--" + obj.CardName); cmd1.Parameters.AddWithValue("@VoucharAccountName", "HOSPITAL CASH"); cmd1.Parameters.AddWithValue("@VoucharDrAmount", obj.PaidAmt); cmd1.Parameters.AddWithValue("@VoucharCrAmount", "0.00"); cmd1.Parameters.AddWithValue("@CreationID", UserID); cmd1.Parameters.AddWithValue("@Mode", "Add"); int Vouchar = cmd1.ExecuteNonQuery(); #endregion #region IUVoucharEntryDetails SqlCommand cmd2 = new SqlCommand("IUVoucharEntryDetail", con); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@HospitalID", HospitalID); cmd2.Parameters.AddWithValue("@LocationID", LocationID); // cmd2.Parameters.AddWithValue("@ReferenceCode", 0); cmd2.Parameters.AddWithValue("@VoucharEntryID", obj.VoucharEntryID); cmd2.Parameters.AddWithValue("@VoucharID", obj.VoucharID); cmd2.Parameters.AddWithValue("@InvNo", ""); cmd2.Parameters.AddWithValue("@VoucharEntryDetailID", obj.VoucharEntryDetailID); cmd2.Parameters.AddWithValue("@VoucharName", "CASH RECEIPTS"); if (obj.AccountsID == null) { cmd2.Parameters.AddWithValue("@AccountsID", 0); } else { cmd2.Parameters.AddWithValue("@AccountsID", obj.AccountsID); } if (obj.AmountName == null || obj.AmountName == "") { cmd2.Parameters.AddWithValue("@AccountName", ""); } else { cmd2.Parameters.AddWithValue("@AccountName", obj.AmountName); } cmd2.Parameters.AddWithValue("@DrAmount", "0.00"); if (obj.PaidAmt == null) { cmd2.Parameters.AddWithValue("@CrAmount", 0); } else { cmd2.Parameters.AddWithValue("@CrAmount", obj.PaidAmt); } cmd2.Parameters.AddWithValue("@ChequeNo", ""); cmd2.Parameters.AddWithValue("@Name", ""); cmd2.Parameters.AddWithValue("@Date", Convert.ToDateTime(obj.PrivilegeDate)); cmd2.Parameters.AddWithValue("@Narration", obj.PatientRegNo + "--" + obj.PFirstName + "--" + obj.CardName); cmd2.Parameters.AddWithValue("@CreationID", UserID); cmd2.Parameters.AddWithValue("@Mode", "Add"); int VoucharDetails = cmd2.ExecuteNonQuery(); #endregion } con.Close(); return(true); }