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());
}
}
//
// GET: /RefundAmount/
public ActionResult PaymentAndDeposit(string IPDNo)
{
Deposit objmodl = new Deposit();
BL_Deposit obj1 = new BL_Deposit();
if (IPDNo != null)
{
objmodl.ds1 = obj1.GetOtherRefundAmount(IPDNo);
if (objmodl.ds1.Tables[1].Rows.Count > 0)
{
objmodl.PatientRegNoPrint = objmodl.ds1.Tables[1].Rows[0]["P_RegNo"].ToString();
objmodl.PatientRegNo = objmodl.ds1.Tables[1].Rows[0]["PatientRegNO"].ToString();
//ucOtherRefundAmount1.txtPrintRegNo.Text = dsRefoundAmount.Tables[0].Rows[0]["PrintRegNO"].ToString();
// objmodl. = objmodl.ds1.Tables[0].Rows[0]["FinancialYearID"].ToString();
objmodl.OPDIPDID = Convert.ToInt32(objmodl.ds1.Tables[1].Rows[0]["OPD/IPDID"]);
string[] Type = IPDNo.Split(',');
objmodl.PatientName = objmodl.ds1.Tables[1].Rows[0]["PatientName"].ToString();
// ucRefoundAmount2.txtRefundableAmount .Text = dsRefoundAmount.Tables[1].Rows[0]["Amount"].ToString();
if (Type[1] != "OPD")
{
if (objmodl.ds1.Tables[3].Rows.Count > 0)
{
if (Convert.ToDecimal(objmodl.ds1.Tables[3].Rows[0]["CrAmount"]) > Convert.ToDecimal(objmodl.ds1.Tables[0].Rows[0]["PreBalance"]))
{
objmodl.Refundsecurity = objmodl.ds1.Tables[0].Rows[0]["PreBalance"].ToString().Replace("-", "");
}
}
else
{
objmodl.PreBalance = objmodl.ds1.Tables[0].Rows[0]["PreBalance"].ToString().Replace("-", "");
}
//if(objmodl.ds1.Tables[2].Rows[0]["SecurityDeposit"].ToString()!="")
//{
// objmodl.PaidAmount = Convert.ToDecimal(objmodl.ds1.Tables[2].Rows[0]["SecurityDeposit"].ToString().Replace("-", ""));
//}
//objmodl.PaidAmount=Convert.ToDecimal(objmodl.ds1.Tables[2].Rows[0]["SecurityDeposit"].ToString().Replace("-", ""));
if (objmodl.ds1.Tables[2].Rows[0]["SecurityDeposit"].ToString() != "")
{
objmodl.PaidAmount = Convert.ToDecimal(objmodl.ds1.Tables[2].Rows[0]["SecurityDeposit"].ToString().Replace("-", ""));
}
}
else
{
objmodl.PreBalance = objmodl.ds1.Tables[0].Rows[0]["PreBalance"].ToString().Replace("-", "");
}
}
}
return(View(objmodl));
}
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);
}
