public ActionResult newfund(valuesto_sp_funds_ofMember tab)
{
try
{
//if (ModelState.IsValid)
//{
if (tab.loan_amt != null)
{
long avl_bl = Convert.ToInt64(db.sp_checkbal().FirstOrDefault());
if (tab.loan_amt <= avl_bl)
{
ObjectParameter retbal = new ObjectParameter("bal_amt", 0);
ObjectParameter rettrans_type = new ObjectParameter("trans_type", 0);
ObjectParameter retsl_no = new ObjectParameter("sl_no", 0);
ObjectParameter ret_avl_bal = new ObjectParameter("avl_bal", 0);
ObjectParameter ret_loan_id = new ObjectParameter("loan_idout", 0);
//int res = db.sp_fund_collection_new(Convert.ToInt32(Session["new_id"]), tab.name,Convert.ToInt64(Session["new_mob"]), tab.loan_amnt, 0,0, tab.dt, trans_type, retsl_no, ret_avl_bal);
int result = db.sp_funds_ofMember(tab.loan_id, tab.id, tab.name, tab.loan_amt, 0, retbal, 0, tab.paid_dt, rettrans_type, retsl_no, ret_avl_bal, ret_loan_id);
this.db.SaveChanges();
TempData["Trans_message"] = "Loan amount of 'Rs:" + tab.loan_amt + "' has been given to '" + tab.name + "'.";
//return RedirectToAction("fundlist", new { id = (Convert.ToInt32(Session["id"])) });
return(RedirectToAction("fundlist", new { id = tab.id }));
}
else
{
TempData["insufficient_bal"] = "There is no Sufficient balance for this loan amount.";
return(RedirectToAction("fundlist", new { id = (Convert.ToInt32(Session["id"])) }));
}
}
else
{
ViewBag.loanamt_null = "please select loan amount";
return(View());
}
//}
}
catch (Exception)
{
throw;
}
}
public ActionResult collectfund(valuesto_sp_funds_ofMember tab)
{
try
{
if (ModelState.IsValid)
{
//DateTime date_pass=Convert.ToDateTime(tab.paid_dt);
long avl_bl = Convert.ToInt64(db.sp_checkbal().FirstOrDefault());
if (0 < tab.inst_amt || tab.inst_amt != 0)
{
ObjectParameter retbal = new ObjectParameter("bal_amt", 0);
ObjectParameter trans_type = new ObjectParameter("trans_type", 0);
ObjectParameter retsl_no = new ObjectParameter("sl_no", 0);
ObjectParameter ret_avl_bal = new ObjectParameter("avl_bal", 0);
ObjectParameter ret_loan_id = new ObjectParameter("loan_idout", typeof(int));
// DateTime resdate = Convert.ToDateTime(retdate.Value);
int no_ofdue = Convert.ToInt32(db.sp_no_ofweeks(tab.name, tab.paid_dt).FirstOrDefault());
if (0 == no_ofdue || no_ofdue == 1)
{
//suppose,if i'm paying for next week. The above procedure will return 1.
//but,there will be no dues.
//if the member skips one week it will return 2. then, due =1
//because,one week skipped
//int res = db.sp_fund_collection_new(Convert.ToInt32(Session["id"]), tab.name, Convert.ToInt64(Session["mob"]),
//Convert.ToInt32(Session["loan"]), tab.inst_amt,
// 0, tab.paid_dt, trans_type, retsl_no, ret_avl_bal);
int result = db.sp_funds_ofMember(tab.loan_id, Convert.ToInt32(Session["col_id"]), tab.name, Convert.ToInt32(Session["col_loan"]),
tab.inst_amt, retbal, 0, tab.paid_dt, trans_type, retsl_no, ret_avl_bal, ret_loan_id);
}
else
{
int due = no_ofdue - 1;
//int res = db.sp_fund_collection_new(Convert.ToInt32(Session["id"]), tab.name, Convert.ToInt64(Session["mob"]),
//Convert.ToInt32(Session["loan"]), tab.inst_amt,
// due, tab.paid_dt, trans_type, retsl_no, ret_avl_bal);
int result = db.sp_funds_ofMember(tab.loan_id, Convert.ToInt32(Session["col_id"]), tab.name, Convert.ToInt32(Session["col_loan"]),
tab.inst_amt, retbal, due, tab.paid_dt, trans_type, retsl_no, ret_avl_bal, ret_loan_id);
}
this.db.SaveChanges();
TempData["Trans_message"] = "Amount of 'Rs:" + tab.inst_amt + "' has been credited by '" + tab.name + "'.";
return(RedirectToAction("fundlist", new { id = (Convert.ToInt32(Session["col_id"])) }));
}
else
{
TempData["amt_negtive_or_zero"] = "Invalid amount.";
return(RedirectToAction("collectfund", new { id = (Convert.ToInt32(Session["col_id"])) }));
}
}
ViewBag.nonullvaluestoaddmember = "please enter the details correctly..!";
return(View());
}
catch (Exception)
{
throw;
}
}