public ActionResult WithdrawalAmount(SavingsTransactionEntity s, SavingsAccountEntities e) { if (Convert.ToInt32(s.Amount) <= 1) { ViewData["status"] = "Amount Invalid"; return(View()); } else { int res = ob.WithdrawalAmount(s, s.AccountId); if (res == 0) { ViewData["status"] = "INVALID ACCOUNT NUMBER"; return(View()); } else if (res == -1) { ViewData["status"] = "INSUFFICIENT AMOUNT "; return(View()); } else { ViewData["status"] = "WITHDRAWAL SUCCESSFULL"; return(View()); } } return(View()); }
public ActionResult DepositAmount(SavingsTransactionEntity s, SavingsAccountEntities e) { if (ModelState.IsValid) { if (Convert.ToInt32(s.Amount) <= 1000) { ViewData["status"] = "Amount cannot be less than 1000"; return(View()); } else { int res = ob.DepositAmount(s, s.AccountId); if (res > 0) { ViewData["status"] = "DEPOSIT SUCCESSFULL"; return(View()); } else { ViewData["status"] = "ENTER VALID ACCOUNTID"; return(View()); } } return(View()); } else { return(View()); } }
public int WithdrawalAmount(SavingsTransactionEntity s, String AccountID) { var res = from c in ob.SavingsAccounts where c.AccountId == AccountID select c; if (res == null) { return(0); } else { string transid; var lasttransID = ob.SavingsTransactions.OrderByDescending(t => t.TransactionId).FirstOrDefault(); if (lasttransID == null) { transid = "00001"; } else { transid = (Convert.ToInt32(lasttransID.TransactionId) + 1).ToString(); } var amount = ob.SavingsAccounts.OrderByDescending(t => t.Balance).Where(f => f.AccountId == AccountID).FirstOrDefault(); if (s.Amount <= (Convert.ToInt32(amount.Balance))) { SavingsTransaction st = new SavingsTransaction() { TransactionId = Int32.Parse(transid), AccountId = AccountID, TransactionDate = DateTime.Now, TransactionType = "W", Amount = s.Amount }; (from p in ob.SavingsAccounts where p.AccountId == AccountID select p).ToList().ForEach(x => x.Balance = x.Balance - s.Amount); ob.SavingsTransactions.Add(st); return(ob.SaveChanges()); } else { return(-1); } } }
public int DepositAmount(SavingsTransactionEntity s, String AccountID) { try { var res = from c in ob.SavingsAccounts where c.AccountId == AccountID select c; if (res == null) { return(0); } else { string transid; var lasttransID = ob.SavingsTransactions.OrderByDescending(t => t.TransactionId).FirstOrDefault(); if (lasttransID == null) { transid = "00001"; } else { transid = (Convert.ToInt32(lasttransID.TransactionId) + 1).ToString(); } SavingsTransaction st = new SavingsTransaction() { TransactionId = Int32.Parse(transid), AccountId = AccountID, TransactionDate = DateTime.Now, TransactionType = "SB", Amount = s.Amount }; (from p in ob.SavingsAccounts where p.AccountId == AccountID select p).ToList().ForEach(x => x.Balance = x.Balance + s.Amount); ob.SavingsTransactions.Add(st); return(ob.SaveChanges()); } } catch (Exception e) { return(0); } }
public int WithdrawalAmount(SavingsTransactionEntity s, string AccountID) { return(ob.WithdrawalAmount(s, AccountID)); }
public int DepositAmount(SavingsTransactionEntity s, string AccountID) { return(ob.DepositAmount(s, AccountID)); }