public static CustomerAccount CreateAccount(string custname, int driv_lic, decimal amount, AccountType accountType)
{
using (var db = new CarRentalModel())
{
CustomerAccount custaccount = new CustomerAccount(custname, amount);
custaccount.DrivingLicense = driv_lic;
custaccount.TypeOfAccount = accountType;
//custaccounts.Add(custaccount);
db.CustomerAccounts.Add(custaccount);
db.SaveChanges();
return custaccount;
}
}
//private static List<CustomerAccount> custaccounts = new List<CustomerAccount>();
public static CustomerAccount CreateAccount(string custname, int driv_lic)
{
using (var db = new CarRentalModel())
{
var custaccount = new CustomerAccount(custname);
custaccount.DrivingLicense = driv_lic;
//custaccounts.Add(custaccount);
//adds a row to the database, or entry to the table
db.CustomerAccounts.Add(custaccount);
db.SaveChanges();
return custaccount;
}
}
/* deposit */
public static decimal PayBalance(int custAccount, decimal amount)
{
using (var db = new CarRentalModel())
{
var custaccount = db.CustomerAccounts.Where(a => a.CustomerNumber == custAccount).First();
var originalcopy = custaccount;
custaccount.PayBalance(amount);
db.Entry(originalcopy).CurrentValues.SetValues(custaccount);
var transactionSuccess = CreateTransaction(DateTime.Now, "Deposit", amount, custAccount, TransactionType.Credit);
if (transactionSuccess)
{
db.SaveChanges();
}
return custaccount.Balance;
}
}
private static bool CreateTransaction(DateTime transactionDate,string description, decimal amount, int accountnumber, TransactionType transactionType)
{
try
{
using (var db = new CarRentalModel())
{
var transaction = new RentalTransaction
{
CustomerNumber = accountnumber,
TransactionDate = transactionDate,
Description = description,
Debit = (transactionType == TransactionType.Debit)
? amount : 0.0M,
Credit = (transactionType == TransactionType.Credit)
? amount : 0.0M
};
db.Transactions.Add(transaction);
db.SaveChanges();
return true;
}
}
catch (Exception)
{
return false;
}
}
public static IEnumerable<CustomerAccount> GetAllAccountsByDL(int driv_lic)
{
var db = new CarRentalModel();
return db.CustomerAccounts.Where(a => a.DrivingLicense == driv_lic);
}