public ActionResult Transfer(long id, long cid, addaccount_group2 acctable) { try { sp_selectCustomerAccountIdforTransfer_group2_Result cusacc = new sp_selectCustomerAccountIdforTransfer_group2_Result(); if (acctable.DepositAmount > Convert.ToDecimal(Session["SAccBal"]) || acctable.DepositAmount <= 0) { TempData["transferfailed"] = "Cannot transfer the entered amount or check your balance!"; return(RedirectToAction("Transfer")); } else { cusacc = bank.sp_selectCustomerAccountIdforTransfer_group2(cid, id).FirstOrDefault(); ObjectParameter balsrc = new ObjectParameter("up_balS", typeof(decimal)); ObjectParameter baldes = new ObjectParameter("up_balD", typeof(decimal)); int result; string type = Convert.ToString(Session["SAccType"]); if (type == "Savings") { result = bank.sp_transfer_group2(Convert.ToInt64(Session["SAccId"]), cusacc.AccountId, Convert.ToInt32(Session["SAccType"]), Convert.ToInt32(Session["SAccidsource"]), Convert.ToDecimal(Session["SAccBal"]), cusacc.DepositAmount, acctable.DepositAmount, balsrc, baldes); } else { result = bank.sp_transfer_group2(Convert.ToInt64(Session["SAccId"]), cusacc.AccountId, Convert.ToInt32(Session["SAccType"]), Convert.ToInt32(Session["SAccidsource"]), Convert.ToDecimal(Session["SAccBal"]), cusacc.DepositAmount, acctable.DepositAmount, balsrc, baldes); } if (result > 0) { this.bank.SaveChanges(); TempData["Messtransferred"] = "Successfully Transferred! The new available balance is Rs. " + balsrc.Value; } return(RedirectToAction("cashierView")); } } catch (Exception e) { throw e; } }
public ActionResult Transfer(long?id, long?cid, int?acctype, decimal?bal) { try { ViewBag.username = Session["userName"]; if (Session["userName"] != null && Session["userroleId"].ToString() == "2") { sp_selectCustomerAccountIdforTransfer_group2_Result cusacc = new sp_selectCustomerAccountIdforTransfer_group2_Result(); int NoOfacc = Convert.ToInt32(bank.sp_checknoofAccounts_group2(cid).FirstOrDefault()); if (NoOfacc == 2) { if (id != null) { cusacc = bank.sp_selectCustomerAccountIdforTransfer_group2(cid, id).FirstOrDefault(); int?transctns = bank.sp_Totaltransactions(cusacc.CustomerID, DateTime.Today.Date).FirstOrDefault(); int a = transctns.GetValueOrDefault(); //ALTER proc [dbo].[sp_Totaltransactions] //@CustomerId bigint, //@date date //as //begin //select count(*) as TransactionsCount from addaccount_group2 //inner join transactiontable_group2 on addaccount_group2.AccountId=transactiontable_group2.AccountId //where (addaccount_group2.CustomerID=@CustomerId and transactiontable_group2.dateoftransaction=@date) //end if (a > 3) { TempData["msg"] = "transactions limit has been reached"; return(RedirectToAction("cashierView")); } Session["SAccidsource"] = cusacc.AccountType; Session["SAccId"] = id; Session["SAccBal"] = bal; Session["SAccType"] = acctype; if (cusacc.AccountType == 1) { Session["DAccType"] = "Savings"; } else { Session["DAccType"] = "Current"; } } return(View(cusacc)); } else { TempData["notransfer"] = "This customer has only one account"; return(RedirectToAction("cashierView")); } } else { return(Redirect("../login/login")); } } catch (Exception e) { throw e; } }