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));
}
