public PreBalanceAmount SavePrebalAmt(PreBalanceAmount PreBalAmt)
{
PreBalAmt.TpaParticular = "";
if (PreBalAmt.chkTPA == "true" && PreBalAmt.TDSAmount > 0)
{
PreBalAmt.TpaParticular = "TPA";
}
// PreBalAmt.TpaParticular = "";
if (PreBalAmt.chkTPA == "true" && PreBalAmt.TPAOtherDeduction > 0)
{
PreBalAmt.TpaParticular = "TPA";
}
int i = 0;
string[] tblPaymentType = PreBalAmt.PaymentType.Split(',');
string[] tblName = PreBalAmt.Name.Split(',');
string[] tblDate = PreBalAmt.Date.Split(',');
string[] tblRemarks = PreBalAmt.Remarks.Split(',');
string[] tblNumber = PreBalAmt.Number.Split(',');
string[] tblPaid = PreBalAmt.PaidAmount.Split(',');
Connect();
int PatientRegNo = Convert.ToInt32(PreBalAmt.PatientRegNo);
DataSet dsPatientPrintIPDOpdID = new DataSet();
dsPatientPrintIPDOpdID = GetRefoundIPDOPDID(PatientRegNo);
DataSet dsPatientIPDOpdID = new DataSet();
string[] PrintOPDIPDNoAndType = PreBalAmt.OPDIPDNO.Split('-');
// PreBalAmt.OPDIPDNO.Split()
string PatientType = PrintOPDIPDNoAndType[1];
string PrintOPDIPDNo = dsPatientPrintIPDOpdID.Tables[0].Rows[0]["OPDIPDNO"].ToString();
// string PrintOPDIPDNo = PrintOPDIPDNoAndType[0];
// string PrintOPDIPDNo = dsPatientPrintIPDOpdID.Tables[0].Rows[0]["OPDIPDNO"].ToString();
dsPatientIPDOpdID = GetIPDOPDIDForPrintIPDNo(PatientRegNo, Convert.ToInt32(PrintOPDIPDNo), PatientType);
try
{
con.Open();
if (dsPatientIPDOpdID.Tables[0].Rows.Count > 0)
{
// PreBalAmt.OPDIPDID = dsPatientIPDOpdID.Tables[0].Rows[0]["[OPD/IPDID]"].ToString();
PreBalAmt.OPDIPDID = PrintOPDIPDNoAndType[0];
// PreBalAmt.PatinetType = dsPatientIPDOpdID.Tables[0].Rows[0]["PatientType"].ToString();
PreBalAmt.PatinetType = PatientType;
}
//PreBalAmt.Name = "";
//PreBalAmt.Number = "";
//PreBalAmt.Remarks = "";
//PreBalAmt.Date = "";
for (int j = 0; j < tblPaymentType.Length; j++)
{
PreBalAmt.Name = tblName[j];
PreBalAmt.Number = tblNumber[j];
PreBalAmt.Remarks = tblRemarks[j];
PreBalAmt.Date = tblDate[j];
PreBalAmt.PaidAmount = tblPaid[j];
decimal PaidAmount = Convert.ToDecimal(tblPaid[j]);
if (PreBalAmt.BillType == "IPD SecurityDeposit RefundBills" || PreBalAmt.BillType == "IPD RefundBills" || PreBalAmt.BillType == "OPD RefundBills")
{
if (PreBalAmt.BillType == "IPD SecurityDeposit RefundBills")
{
PreBalAmt.BillType = "SecurityDeposit RefundBills";
}
else
{
PreBalAmt.BillType = "RefundBills";
}
SqlCommand cmd = new SqlCommand("IURefoundAmount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@PatientAccountRowID", PreBalAmt.PatientAccountRowID);
if (PreBalAmt.BillType == "SecurityDeposit RefundBills")
{
cmd.Parameters.AddWithValue("@BillType", PreBalAmt.BillType);
}
else
{
cmd.Parameters.AddWithValue("@BillType", PreBalAmt.BillType);
}
// cmd.Parameters["@PatientAccountRowID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@PatientRegNo", PreBalAmt.PatientRegNo);
cmd.Parameters.AddWithValue("@PaidAmount", Convert.ToDecimal(PreBalAmt.PaidAmount));
cmd.Parameters.AddWithValue("@BillDate", Convert.ToDateTime(PreBalAmt.BillDate).ToString("dd-MMM-yyyy"));
cmd.Parameters.AddWithValue("@PaymentType", PreBalAmt.PaymentType);
cmd.Parameters.AddWithValue("@OPDIPDID", PreBalAmt.OPDIPDNO.Split('-')[0]);
switch (PreBalAmt.PaymentType)
{
case "Cheque":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
break;
case "Dedit Card":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
break;
case "Credit Card":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
break;
case "E-Money":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
break;
case "EFT":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
break;
default:
cmd.Parameters.AddWithValue("@Number", "Cash");
cmd.Parameters.AddWithValue("@Name", "Cash");
cmd.Parameters.AddWithValue("@Date", System.DateTime.Now);
cmd.Parameters.AddWithValue("@Remarks", "Cash");
break;
}
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
// con.Open();
i = cmd.ExecuteNonQuery();
// int OtherAccountRowID = Convert.ToInt32(cmd.Parameters["@PatientAccountRowID"].Value);
}
else
{
SqlCommand cmd = new SqlCommand("IUPreBalanceAmount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@TpaParticular", PreBalAmt.TpaParticular);
if (PreBalAmt.Mode != "Add")
{
cmd.Parameters.AddWithValue("@PatientAccountRowID", PreBalAmt.PatientAccountRowID);
}
else
{
cmd.Parameters.AddWithValue("@PatientAccountRowID", 0);
cmd.Parameters["@PatientAccountRowID"].Direction = ParameterDirection.Output;
}
cmd.Parameters.AddWithValue("@PatientRegNo", PreBalAmt.PatientRegNo);
if (Convert.ToString(PreBalAmt.OPDIPDID) == null)
{
cmd.Parameters.AddWithValue("@OPDIPDID", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@OPDIPDID", PreBalAmt.OPDIPDID);
}
if (PreBalAmt.PatinetType != null)
{
if (PreBalAmt.TPAStatus == "on")
{
cmd.Parameters.AddWithValue("@PatinetType", PreBalAmt.PatinetType + " " + "SecurityDeposit");
}
else
{
cmd.Parameters.AddWithValue("@PatinetType", PreBalAmt.PatinetType);
}
}
else
{
cmd.Parameters.AddWithValue("@PatinetType", "");
}
cmd.Parameters.AddWithValue("@PaymentType", tblPaymentType[j]);
cmd.Parameters.AddWithValue("@BillDate", Convert.ToDateTime(PreBalAmt.BillDate));
cmd.Parameters.AddWithValue("@PaidAmount", PaidAmount);
if (PreBalAmt.Narrection == null)
{
cmd.Parameters.AddWithValue("@Narrection", "");
}
else
{
cmd.Parameters.AddWithValue("@Narrection", PreBalAmt.Narrection);
}
if (PreBalAmt.TDSAmount != null)
{
cmd.Parameters.AddWithValue("@TDSAmount", PreBalAmt.TDSAmount);
}
else
{
cmd.Parameters.AddWithValue("@TDSAmount", "");
}
if (PreBalAmt.TPAOtherDeduction != null)
{
cmd.Parameters.AddWithValue("@TPAOtherDeduction", PreBalAmt.TPAOtherDeduction);
}
else
{
cmd.Parameters.AddWithValue("@TPAOtherDeduction", "");
}
#region PaymentType
if (PreBalAmt.Name == null)
{
PreBalAmt.Name = "";
}
if (PreBalAmt.Remarks == null)
{
PreBalAmt.Remarks = "";
}
switch (tblPaymentType[j])
{
case "Cheque":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(PreBalAmt.Date));
break;
case "Debit Card":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(PreBalAmt.Date));
break;
case "Credit Card":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(PreBalAmt.Date));
break;
case "E-Money":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(PreBalAmt.Date));
break;
case "EFT":
cmd.Parameters.AddWithValue("@Number", PreBalAmt.Number);
cmd.Parameters.AddWithValue("@Name", PreBalAmt.Name);
cmd.Parameters.AddWithValue("@Remarks", PreBalAmt.Remarks);
cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(PreBalAmt.Date));
break;
default:
cmd.Parameters.AddWithValue("@Number", "Cash");
cmd.Parameters.AddWithValue("@Name", "Cash");
cmd.Parameters.AddWithValue("@Remarks", "Cash");
cmd.Parameters.Add(new SqlParameter("@Date", DateTime.ParseExact(DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"), "dd/MM/yyyy hh:mm:ss", null)));
break;
}
#endregion
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", PreBalAmt.Mode);
i = cmd.ExecuteNonQuery();
int PatientAccountRowID = Convert.ToInt32(cmd.Parameters["@PatientAccountRowID"].Value);
PreBalAmt.PatientAccountRowID = PatientAccountRowID;
PreBalAmt.PrintPaymentTypeCount += PatientAccountRowID.ToString() + ",";
}
if (PreBalAmt.TPAStatus == "on")
{
if (PreBalAmt.Mode == "Add")
{
SqlCommand cmdSecurityDeposite = new SqlCommand("IUSecurityDeposite", con);
cmdSecurityDeposite.CommandType = CommandType.StoredProcedure;
cmdSecurityDeposite.Parameters.AddWithValue("@HospitalID", HospitalID);
cmdSecurityDeposite.Parameters.AddWithValue("@LocationID", LocationID);
cmdSecurityDeposite.Parameters.AddWithValue("@PatientRegNO", PreBalAmt.PatientRegNo);
cmdSecurityDeposite.Parameters.AddWithValue("@OPDIPDID", PreBalAmt.OPDIPDID);
cmdSecurityDeposite.Parameters.AddWithValue("@SecurityDeposityID", 0);
cmdSecurityDeposite.Parameters["@SecurityDeposityID"].Direction = ParameterDirection.Output;
cmdSecurityDeposite.Parameters.AddWithValue("@PatientAccountRowID", PreBalAmt.PatientAccountRowID);
cmdSecurityDeposite.Parameters.AddWithValue("@Mode", "Add");
cmdSecurityDeposite.Parameters.AddWithValue("@PaymentType", "Cash");
cmdSecurityDeposite.Parameters.AddWithValue("@Number", "");
cmdSecurityDeposite.Parameters.AddWithValue("@Name", "");
// PatientIPDDetails.Parameters.AddWithValue("@Date", "");//ucPatientOPD1.dtpRegDate.Text + " " + ucPatientOPD1.dtpTime.Text;
//PatientIPDDetails.Parameters.Add(new SqlParameter("@Date", DateTime.ParseExact(obj.AddmissionDate, "dd/MM/yyyy hh:mm:ss", null)));
cmdSecurityDeposite.Parameters.Add(new SqlParameter("@Date", DateTime.ParseExact(DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"), "dd/MM/yyyy hh:mm:ss", null)));
cmdSecurityDeposite.Parameters.AddWithValue("@Remark", "");
cmdSecurityDeposite.Parameters.AddWithValue("@BillType", "IPDSecurityDeposit PreBalanceBills");
//cmdSecurityDeposite.Parameters.AddWithValue("@PrintSecurityDeposite", obj.PrintSecurityDeposite);
cmdSecurityDeposite.Parameters.AddWithValue("@DrAmount", PreBalAmt.PaidAmount);
cmdSecurityDeposite.Parameters.AddWithValue("@CrAmount", 00);
cmdSecurityDeposite.Parameters.AddWithValue("@FinancialYearID", 2);
cmdSecurityDeposite.Parameters.AddWithValue("@CreationID", UserID);
// cmdSecurityDeposite.Parameters.AddWithValue("Mode", Mode);
// con.Open();
int Value = cmdSecurityDeposite.ExecuteNonQuery();
}
else
{
SqlCommand cmdSecurityDeposite = new SqlCommand("IUSecurityDeposite", con);
cmdSecurityDeposite.CommandType = CommandType.StoredProcedure;
cmdSecurityDeposite.Parameters.AddWithValue("@HospitalID", HospitalID);
cmdSecurityDeposite.Parameters.AddWithValue("@LocationID", LocationID);
cmdSecurityDeposite.Parameters.AddWithValue("@PatientRegNO", PreBalAmt.PatientRegNo);
cmdSecurityDeposite.Parameters.AddWithValue("@OPDIPDID", PreBalAmt.OPDIPDID);
cmdSecurityDeposite.Parameters.AddWithValue("@SecurityDeposityID", 0);
cmdSecurityDeposite.Parameters["@SecurityDeposityID"].Direction = ParameterDirection.Output;
cmdSecurityDeposite.Parameters.AddWithValue("@PatientAccountRowID", PreBalAmt.PatientAccountRowID);
cmdSecurityDeposite.Parameters.AddWithValue("@Mode", "Edit");
cmdSecurityDeposite.Parameters.AddWithValue("@PaymentType", "Cash");
cmdSecurityDeposite.Parameters.AddWithValue("@Number", "");
cmdSecurityDeposite.Parameters.AddWithValue("@Name", "");
// PatientIPDDetails.Parameters.AddWithValue("@Date", "");//ucPatientOPD1.dtpRegDate.Text + " " + ucPatientOPD1.dtpTime.Text;
//PatientIPDDetails.Parameters.Add(new SqlParameter("@Date", DateTime.ParseExact(obj.AddmissionDate, "dd/MM/yyyy hh:mm:ss", null)));
cmdSecurityDeposite.Parameters.Add(new SqlParameter("@Date", DateTime.ParseExact(DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"), "dd/MM/yyyy hh:mm:ss", null)));
cmdSecurityDeposite.Parameters.AddWithValue("@Remark", "");
cmdSecurityDeposite.Parameters.AddWithValue("@BillType", "IPDSecurityDeposit PreBalanceBills");
//cmdSecurityDeposite.Parameters.AddWithValue("@PrintSecurityDeposite", obj.PrintSecurityDeposite);
cmdSecurityDeposite.Parameters.AddWithValue("@DrAmount", PreBalAmt.PaidAmount);
cmdSecurityDeposite.Parameters.AddWithValue("@CrAmount", 00);
cmdSecurityDeposite.Parameters.AddWithValue("@FinancialYearID", 2);
cmdSecurityDeposite.Parameters.AddWithValue("@CreationID", UserID);
// cmdSecurityDeposite.Parameters.AddWithValue("Mode", Mode);
// con.Open();
int Value = cmdSecurityDeposite.ExecuteNonQuery();
}
}
}
con.Close();
if (i > 0)
{
// PreBalAmt.PatientAccountRowID = PatientAccountRowID;
return(PreBalAmt);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult PreBalanceAmount(PreBalanceAmount PrebalAmt, FormCollection fc)
{
//if (fc["Mode"].ToString() == "Add")
//{
// PrebalAmt.Mode = "ADD";
//}
//else
//{
// PrebalAmt.Mode = "Edit";
// PrebalAmt.PatientAccountRowID = Convert.ToInt32(fc["PatientaccRowID"]);
//}
if (PrebalAmt.Mode == null)
{
PrebalAmt.Mode = "Add";
}
else
{
PrebalAmt.Mode = "Edit";
PrebalAmt.PatientAccountRowID = Convert.ToInt32(fc["PatientaccRowID"]);
if (fc["TDSAmtedit"].ToString() == "")
{
PrebalAmt.TDSAmount = 0;
}
else
{
PrebalAmt.TDSAmount = Convert.ToInt32(fc["TDSAmtedit"].ToString());
}
if (fc["TDSOtherdecdit"].ToString() == "")
{
PrebalAmt.TPAOtherDeduction = 0;
}
else
{
PrebalAmt.TPAOtherDeduction = Convert.ToInt32(fc["TDSOtherdecdit"].ToString());
}
PrebalAmt.BillType = Request.Form["Bill"];
}
if (PrebalAmt.Mode != "Add")
{
if (Request.Form["tblPayEditType"] != null)
{
PrebalAmt.PaymentType = Request.Form["tblPayEditType"].ToString();
PrebalAmt.Number = Request.Form["tblEditNumber"];
PrebalAmt.Name = Request.Form["tblEditName"].ToString();
PrebalAmt.Date = Request.Form["tblpayDateEdit"].ToString();
PrebalAmt.Remarks = Request.Form["tblEditRemarks"].ToString();
PrebalAmt.PaidAmount = Request.Form["tblPayEditTotal"].ToString();
PrebalAmt.Mode = "Edit";
//if(Request.Form["tblPayEditTotal"].ToString()==null || Request.Form["tblPayEditTotal"].ToString()=="")
//{
//}
// PrebalAmt.PaidAmount = fc["PaidAmtedit"];
PrebalAmt.BillDate = fc["editModalDate"];
}
else
{
PrebalAmt.BillDate = fc["editModalDate"];
switch (PrebalAmt.PaymentType)
{
case "Cheque":
PrebalAmt.Number = Request.Form["No"];
PrebalAmt.Name = Request.Form["Namepay"];
PrebalAmt.Date = Request.Form["payDate"].ToString();
PrebalAmt.Remarks = Request.Form["payRemarks"];
break;
case "Debit Card":
PrebalAmt.Number = Request.Form["No"];
PrebalAmt.Name = Request.Form["Namepay"];
PrebalAmt.Date = Request.Form["payDate"].ToString();
PrebalAmt.Remarks = Request.Form["payRemarks"];
break;
case "Credit Card":
PrebalAmt.Number = Request.Form["No"];
PrebalAmt.Name = Request.Form["Namepay"];
PrebalAmt.Date = Request.Form["payDate"].ToString();
PrebalAmt.Remarks = Request.Form["payRemarks"];
break;
case "EFT":
PrebalAmt.Number = Request.Form["No"];
PrebalAmt.Name = Request.Form["Namepay"];
PrebalAmt.Date = Request.Form["payDate"].ToString();
PrebalAmt.Remarks = Request.Form["payRemarks"];
break;
case "E-Money":
PrebalAmt.Number = Request.Form["No"];
PrebalAmt.Name = Request.Form["Namepay"];
PrebalAmt.Date = Request.Form["payDate"].ToString();
PrebalAmt.Remarks = Request.Form["payRemarks"];
break;
default:
PrebalAmt.Number = "Cash";
PrebalAmt.Name = "Cash";
PrebalAmt.Date = System.DateTime.Now.ToString();
PrebalAmt.Remarks = "Cash";
break;
}
PrebalAmt.Mode = "Edit";
PrebalAmt.PaidAmount = fc["PaidAmtedit"];
}
}
if (PrebalAmt.Mode == "Add")
{
if (Request.Form["tblPaymentType"] != null)
{
PrebalAmt.PaymentType = Request.Form["tblPaymentType"].ToString();
PrebalAmt.Number = Request.Form["tblNumber"];
PrebalAmt.Name = Request.Form["tblName"].ToString();
PrebalAmt.Date = Request.Form["tblpaymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["tblRemarks"].ToString();
PrebalAmt.PaidAmount = Request.Form["tblPaymentTotal"].ToString();
PrebalAmt.Mode = "Add";
}
else
{
#region PaymentType
switch (PrebalAmt.PaymentType)
{
case "Cheque":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["paymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
case "Debit Card":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["paymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
case "Credit Card":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["paymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
case "EFT":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["Date"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
case "E-Money":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["paymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
default:
PrebalAmt.Number = "Cash";
PrebalAmt.Name = "Cash";
PrebalAmt.Date = System.DateTime.Now.ToString();
PrebalAmt.Remarks = "Cash";
break;
}
}
}
#endregion
PreBalanceAmount PreBal = new Models.Patient.PreBalanceAmount();
if (Request.Form["SecurityDepositeTPA"] != null)
{
PrebalAmt.TPAStatus = Request.Form["SecurityDepositeTPA"].ToString();
}
if (Request.Form["chkTPA"] == "true")
{
PrebalAmt.chkTPA = "true";
}
else
{
PrebalAmt.chkTPA = "false";
}
if (fc["chkAllpaidAmt"] != null)
{
string chkAllpaidAmt = fc["chkAllpaidAmt"].ToString();
AllPaidAmtOPDIPDNo(fc, PrebalAmt);
}
else
{
PreBal = objblamt.SavePrebalAmt(PrebalAmt);
}
if (PreBal.PatientAccountRowID > 0)
{
PatientAccountRowID = PreBal.PatientAccountRowID;
TempData["Msg"] = "Saved Successfully";
Session["PrintPaymentTypeCount"] = PreBal.PatientAccountRowID;
return(RedirectToAction("RptPreBalanceAmount"));
// return RedirectToAction("PreBalanceAmount", "PreBalanceAmount");
}
// PreBal.PatientAccountRowID = PrebalAmt.PatientAccountRowID;
Connect();
return(RedirectToAction("PreBalanceAmount", "PreBalanceAmount"));
}
public ActionResult OtherPreBalanceAmount(PreBalanceAmount PrebalAmt, FormCollection fc)
{
PrebalAmt.Mode = "ADD";
if (Request.Form["tblPaymentType"] != null)
{
PrebalAmt.PaymentType = Request.Form["tblPaymentType"].ToString();
PrebalAmt.Number = Request.Form["tblNumber"];
PrebalAmt.Name = Request.Form["tblName"].ToString();
PrebalAmt.Date = Request.Form["tblpaymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["tblRemarks"].ToString();
PrebalAmt.PaidAmount = Request.Form["tblPaymentTotal"].ToString();
}
else
{
#region PaymentType
switch (PrebalAmt.PaymentType)
{
case "Cheque":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["paymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
case "Debit Card":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["paymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
case "Credit Card":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["paymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
case "EFT":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["Date"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
case "E-Money":
PrebalAmt.Number = Request.Form["Number"];
PrebalAmt.Name = Request.Form["Name"];
PrebalAmt.Date = Request.Form["paymentDate"].ToString();
PrebalAmt.Remarks = Request.Form["Remarks"];
break;
default:
PrebalAmt.Number = "Cash";
PrebalAmt.Name = "Cash";
PrebalAmt.Date = System.DateTime.Now.ToString();
PrebalAmt.Remarks = "Cash";
break;
}
}
#endregion
//string number = fc["Number1"].ToString();
//string name = fc["Name1"].ToString();
//string date = fc["Date1"].ToString();
//string remark = fc["Remarks"].ToString();
//string mode = fc["Mode"].ToString();
//String[] number_1 = number.Split(',');
//String[] name_1 = name.Split(',');
//String[] date_1 = date.Split(',');
//String[] remark_1 = remark.Split(',');
//PreBalanceAmount[] obj_array = new PreBalanceAmount[number_1.Length];
//for (int i = 0; i < number_1.Length; i++)
//{
// obj_array[i] = new PreBalanceAmount();
// obj_array[i].Number = number_1[i].ToString();
// obj_array[i].Name = name_1[i].ToString();
// obj_array[i].Date = Convert.ToDateTime(date_1[i].ToString());
// obj_array[i].Remarks = remark_1[i].ToString();
//}
// PrebalAmt.Date = Convert.ToDateTime(Request.Form["paymentDate"]);
PreBalanceAmount PreBal = new Models.Patient.PreBalanceAmount();
if (Request.Form["SecurityDepositeTPA"] != null)
{
PrebalAmt.TPAStatus = Request.Form["SecurityDepositeTPA"].ToString();
}
//if (fc["chkAllpaidAmt"] != null)
//{
// string chkAllpaidAmt = fc["chkAllpaidAmt"].ToString();
// AllPaidAmtOPDIPDNo(fc, PrebalAmt);
//}
//else
//{
PreBal = objblamt.SavePrebalAmt(PrebalAmt);
//}
if (PreBal.PatientAccountRowID > 0)
{
Session["PrintPaymentTypeCount"] = PreBal.PrintPaymentTypeCount;
return(RedirectToAction("RptPreBalanceAmount"));
}
// PreBal.PatientAccountRowID = PrebalAmt.PatientAccountRowID;
Connect();
return(RedirectToAction("OtherPreBalanceAmount", "OtherPreBalanceAmount"));
}
public bool AllPaidAmtOPDIPDNo(FormCollection fc, PreBalanceAmount PreBal)
{
HospitlLocationID();
DataSet ds = new System.Data.DataSet();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@PatientRegNo", SqlDbType.Int);
param[0].Value = fc["PatientRegNO"];
param[1] = new SqlParameter("@LocationID", SqlDbType.Int);
param[1].Value = LocationID;
param[2] = new SqlParameter("@HospitalID", SqlDbType.Int);
param[2].Value = HospitalID;
ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "GetRefoundIPDOPDID", param);
string paidAmt = fc["PaidAmount"].ToString();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SqlCommand cmd = new SqlCommand("GetRefoundAmountOPDIPD", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OPDIPDNo", dr["OPDIPDNO"]);
cmd.Parameters.AddWithValue("@PatientType", dr["PatientType"]);
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds1 = new DataSet();
con.Open();
da.Fill(ds1);
con.Close();
if (Convert.ToDecimal(ds1.Tables[0].Rows[0][0]) < 0)
{
BL_Deposit obj1 = new BL_Deposit();
Deposit objDeposit = new Models.Patient.Deposit();
objDeposit.PatientRegNo = fc["PatientRegNO"];
objDeposit.BillDate = Convert.ToDateTime(DateTime.Now);
objDeposit.PaymentType = PreBal.PaymentType;
objDeposit.PatinetType = dr["PatientType"].ToString();
objDeposit.OPDIPDNO = dr["OPDIPDNO"].ToString();
objDeposit.PaidAmount = Convert.ToDecimal(ds1.Tables[0].Rows[0][0].ToString().Replace("-", ""));
int RowID = obj1.IURefoundAmount(objDeposit);
//Deposit
}
else
{
//pribalence
PreBal.PatientRegNo = fc["PatientRegNO"];
PreBal.BillDate = DateTime.Now.ToString();
PreBal.PaymentType = "Cash";
PreBal.OPDIPDNO = dr["OPDIPDNO"].ToString() + "-" + dr["PatientType"].ToString();
PreBal.PaidAmount = ds1.Tables[0].Rows[0][0].ToString();
if (Convert.ToDecimal(PreBal.PaidAmount) > 0)
{
decimal TotalPaid = Convert.ToDecimal(paidAmt) - Convert.ToDecimal(PreBal.PaidAmount);
paidAmt = TotalPaid.ToString();
PreBal = objblamt.SavePrebalAmt(PreBal);
}
}
}
return(true);
}
