public bool CreateCustomer(Customers model) { using (BankDBEntities db = new BankDBEntities()) { db.Customers.Add(model); db.SaveChanges(); return(db.SaveChanges() == 1); } }
public Accounts MakeDeposit(Accounts model, int deposit) { var entity = db .Accounts .Where(e => e.AccountNumber == model.AccountNumber && e.PIN == model.PIN) .Single(); entity.Balance += deposit; UpdateTables(model, 1, deposit); db.SaveChanges(); return(entity); }
public bool Deposit(decimal amount, Account account) { using (var ctx = new BankDBEntities()) { var transaction = new Transaction { TransactionType = "Deposit", AccountID = account.AccountID }; ctx.Transactions.Add(transaction); var deposit = new Deposit { Amount = amount, }; ctx.Deposits.Add(deposit); ctx.Accounts.SingleOrDefault(e => e.AccountID == account.AccountID).Balance += amount; account.Balance += amount; return(ctx.SaveChanges() == 3); } }
public bool Withdraw(decimal amount, Account account) { using (var ctx = new BankDBEntities()) { var transaction = new Transaction { TransactionType = "Withdrawl", AccountID = account.AccountID }; ctx.Transactions.Add(transaction); var withdrawl = new Withdrawl { Amount = amount, }; ctx.Withdrawls.Add(withdrawl); ctx.Accounts.SingleOrDefault(e => e.AccountID == account.AccountID).Balance -= amount; account.Balance -= amount; return(ctx.SaveChanges() == 3); } }
public ActionResult Create([Bind(Include = "OperationID,InID,OutID,Amount,OperationTime")] Operations operations) { try { Card card = new Card(); if (ModelState.IsValid) { if ((db.Card.FirstOrDefault(u => u.CardID == operations.OutID && u.Balance >= operations.Amount) != null)) //Проверка баланса карточки. { operations.OperationTime = System.DateTime.Now; db.Operations.Add(operations); db.SaveChanges(); return(RedirectToAction("Index")); } } } catch (Exception ex) { } ViewBag.InID = new SelectList(db.Card, "CardID", "CardID", operations.InID); ViewBag.OutID = new SelectList(db.Card, "CardID", "CardID", operations.OutID); return(View(operations)); }
public ActionResult TransferFund([Bind(Include = "CustomerId, MoneyTransfered, TransferType")] TransactionHistory transactiondetail) { try { // TODO: Add insert logic here var currentUser = dbcontext.AspNetUsers.FirstOrDefault(u => u.Email == User.Identity.Name); // transactiondetail.Customer = ; transactiondetail.Customer = dbcontext.Customers.FirstOrDefault(c => c.UserId == currentUser.Id); transactiondetail.CustomerId = transactiondetail.Customer.Id; dbcontext.TransactionHistories.Add(transactiondetail); if (transactiondetail.TransferType == 1) { transactiondetail.Customer.AccountBalance -= transactiondetail.MoneyTransfered; } else { transactiondetail.Customer.AccountBalance += transactiondetail.MoneyTransfered; } dbcontext.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { return(View()); } }
public void CreateAccount(Accounts model) { using (BankDBEntities db = new BankDBEntities()) { db.Accounts.Add(model); db.SaveChanges(); } }
public Accounts ChangePin(Accounts model, int newPin) { using (BankDBEntities db = new BankDBEntities()) { var entity = db .Accounts .Where(e => e.AccountNumber == model.AccountNumber && e.PIN == model.PIN) .Single(); entity.PIN = newPin; db.SaveChanges(); return(entity); } }
public bool CreateCustomer(string name, int id, int pin) { using (var ctx = new BankDBEntities()) { var newCustomer = new Customers { CustomerName = name, CustomerID = id, CustomerPin = pin }; ctx.Customers.Add(newCustomer); return(ctx.SaveChanges() == 1); } }
public bool CreateAccount(int num, int id, string type) { using (var context = new BankDBEntities()) { var newAccount = new Accounts { AccountNumber = num, CustomerID = id, AccountType = type, AccountBalance = 0 }; context.Accounts.Add(newAccount); return(context.SaveChanges() == 1); } }
public ActionResult Create([Bind(Include = "AccountNumber, AccountBalance,UserId")] Customer customer) { try { // TODO: Add insert logic here if (ModelState.IsValid) { customer.IsActive = true; customer.CreateDate = DateTime.Now; dbcontext.Customers.Add(customer); dbcontext.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }