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