public ActionResult PaymentAndDeposit(Deposit obj, FormCollection fc)
{
BL_Deposit obj1 = new BL_Deposit();
string chk = "";
if (fc["securitydeposit"] == null)
{
chk = "";
}
else
{
chk = (fc["securitydeposit"].ToString());
}
if (chk == "on")
{
obj.BillType = "SecurityDeposit RefundBills";
}
else
{
obj.BillType = "RefundBills";
}
int RowID = obj1.IURefoundAmount(obj);
if (RowID > 0)
{
Session["OtherAccountRowID"] = RowID;
return(RedirectToAction("RptRefundAmount", "PatientReport"));
}
else
{
return(View());
}
}
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);
}
