public bool BOOL_AccountNumberAvailable(int id) { using (var ctx = new BankDBEntities()) { return((from c in ctx.Accounts where c.AccountNumber == id select c).Count() == 0); } }
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 bool BOOL_CustomerIdAvailable(int id) { using (var ctx = new BankDBEntities()) { return((from c in ctx.Customers where c.CustomerID == id select c).Count() == 0); } }
public IEnumerable <Customers> GetCustomers() { using (var ctx = new BankDBEntities()) { return(ctx.Customers); } }
public void CreateAccount(Accounts model) { using (BankDBEntities db = new BankDBEntities()) { db.Accounts.Add(model); db.SaveChanges(); } }
public bool CreateCustomer(Customers model) { using (BankDBEntities db = new BankDBEntities()) { db.Customers.Add(model); db.SaveChanges(); return(db.SaveChanges() == 1); } }
public Customer GetCustomer(int customerId) { using (var ctx = new BankDBEntities()) { return(ctx .Customers .SingleOrDefault(e => e.CustomerID == customerId)); } }
public Accounts GetAccount(int num, int pin) { BankDBEntities db = new BankDBEntities(); return (db .Accounts .Where(e => e.AccountNumber == num && e.PIN == pin) .Single()); }
public Account GetAccount(string accountId) { int id = Int32.Parse(accountId); using (var ctx = new BankDBEntities()) { return(ctx .Accounts .SingleOrDefault(e => e.AccountID == id)); } }
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 override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); context.OwinContext.Response.Headers.Add("Access-Control-Allow-Headers", new[] { "Content-Type" }); string errorStatus = ""; User user = null; try { using (var db = new BankDBEntities()) { user = db.Users .Where(s => s.Email == context.UserName && s.Password == context.Password) .FirstOrDefault <User>(); } } catch (Exception ex) { errorStatus = ex.Message; } if (user == null) { context.SetError("invalid_grant", errorStatus); return; } var identity = new ClaimsIdentity(context.Options.AuthenticationType); identity.AddClaim(new Claim("sub", context.UserName)); identity.AddClaim(new Claim("role", "user")); if (user != null) { identity.AddClaim(new Claim(ClaimTypes.NameIdentifier, user.Id.ToString())); } context.Validated(identity); }
public ActionResult SignIn(LoginModel model) { if (ModelState.IsValid) { // поиск пользователя в бд Card card = null; using (BankDBEntities db = new BankDBEntities()) { card = db.Card.FirstOrDefault(c => c.CardID == model.CardId && c.PinCode == model.PinCode); //Ищем карточку с таким ID и PinCode. } if (card != null) { FormsAuthentication.SetAuthCookie(model.CardId, false); return(RedirectToAction("Index", "Operations", model)); } else { ModelState.AddModelError("", "Login information was incorrect or non existent"); } } return(View(model)); }