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