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