public ActionResult deposit(long?id, decimal?balamt)
{
try
{
ViewBag.username = Session["userName"];
if (Session["userName"] != null && Session["userroleId"].ToString() == "2")
{
cashierViewAccountbyId_group2_Result objAccount = new cashierViewAccountbyId_group2_Result();
if (id != null)
{
objAccount = bank.cashierViewAccountbyId_group2(id).FirstOrDefault();
return(View(objAccount));
}
return(View());
}
else
{
return(Redirect("../login/login"));
}
}
catch (Exception e)
{
throw e;
}
}
public ActionResult Withdraw(addaccount_group2 withd, long id, decimal?balamt)
{
try
{
cashierViewAccountbyId_group2_Result objAccount = new cashierViewAccountbyId_group2_Result();
if (withd.DepositAmount < 0 || withd.DepositAmount > balamt || withd.DepositAmount == 0 || withd.DepositAmount == null)
{
objAccount.AccountId = withd.AccountId;
objAccount.DepositAmount = withd.DepositAmount;
ViewBag.messageinsuf = "invalid amount";
return(View());
}
else
{
// @AccountId bigint,
//@AccountType varchar(50),
//@TransactionType varchar(50),
//@amount money,
//@beforebalance money,
//@latestbalance money out
ObjectParameter objParam = new ObjectParameter("latestbalance", typeof(decimal));
int result;
if (withd.AccountType == 1)
{
result = bank.sp_WithdrawAmount_group2(id, "Savings", "withdraw", withd.DepositAmount, balamt, objParam);
}
else
{
result = bank.sp_WithdrawAmount_group2(id, "Current", "withdraw", withd.DepositAmount, balamt, objParam);
}
if (result > 0)
{
this.bank.SaveChanges();
TempData["Messwith"] = "Successfully Withdrawn! The new available balance is Rs." + objParam.Value;
}
return(RedirectToAction("cashierView"));
}
}
catch (Exception e)
{
throw e;
}
}
public ActionResult withdraw(long?id, decimal?balamt)
{
try
{
ViewBag.username = Session["userName"];
if (Session["userName"] != null && Session["userroleId"].ToString() == "2")
{
cashierViewAccountbyId_group2_Result objaccount = new cashierViewAccountbyId_group2_Result();
if (balamt == 0)
{
TempData["Messagewithdraw"] = "Your balance is RS." + balamt;
return(RedirectToAction("cashierView"));
}
else
{
if (id != null)
{
objaccount = bank.cashierViewAccountbyId_group2(id).FirstOrDefault();
int?transctns = bank.sp_Totaltransactions(objaccount.CustomerID, DateTime.Today.Date).FirstOrDefault();
int a = transctns.GetValueOrDefault();
if (a > 3)
{
TempData["msg"] = "transactions limit has been reached";
return(RedirectToAction("cashierView"));
}
return(View(objaccount));
}
}
return(RedirectToAction("cashierView"));
}
else
{
return(Redirect("../login/login"));
}
}
catch (Exception e)
{
throw e;
}
}
public ActionResult deposit(addaccount_group2 objTran, long id, decimal balamt)
{
try
{
ViewBag.username = Session["userName"];
cashierViewAccountbyId_group2_Result objAccount = new cashierViewAccountbyId_group2_Result();
if (objTran.DepositAmount <= 0 || objTran.DepositAmount > 100000 || objTran.DepositAmount == null)
{
objAccount.AccountId = objTran.AccountId;
objAccount.DepositAmount = objTran.DepositAmount;
ViewBag.message = "enter valid amount";
return(View(objAccount));
}
else
{
ObjectParameter objParam = new ObjectParameter("latestbalance", typeof(decimal));
int result;
if (objTran.AccountType == 1)
{
result = bank.sp_Deposit_group2(id, "Savings ", "deposit", objTran.DepositAmount, balamt, objParam);
}
else
{
result = bank.sp_Deposit_group2(id, "Current ", "deposit", objTran.DepositAmount, balamt, objParam);
}
if (result > 0)
{
this.bank.SaveChanges();
TempData["Messdep"] = "Successfully Deposited! The new available balance is Rs." + objParam.Value;
}
return(RedirectToAction("cashierView"));
}
}
catch (Exception e)
{
throw e;
}
}
