public ActionResult Deposits([Bind(Include = "TransactionID,TransactionNumber,Date,Description,TransactionType,EmployeeComment,Status,Amount")] Checking SelectedCheckingDepositAccount, Decimal Amount, Transaction transaction)
{
string Id4 = User.Identity.GetUserId();
AppUser UserAccounts = db.Users.Find(Id4);
AppUser SelectedUser = db.Users.Find(Id4);
UserAccounts.Checkings = UserAccounts.Checkings;
//find the users associated selected account
Checking SelectedCheckings = SelectedCheckingDepositAccount;
//create variable/link to that accounts balance
transaction.TransactionNumber = 1000;
Int32 NewTransactionNumber = transaction.TransactionNumber += 1;
transaction.User = SelectedUser;
if (ModelState.IsValid)
{
db.TransactionsDbSet.Add(transaction);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AllCheckingDeposits = GetAllCheckingDepositAccounts();
//update balance in account
//property from actual account balance + amount that user entered
return(View());
}
public async Task <IActionResult> Edit(int id, [Bind("type,accountNumber,InterestRate,Balance,createdAt,CustomerId")] Checking checking)
{
if (id != checking.accountNumber)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(checking);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CheckingExists(checking.accountNumber))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(CheckingView)));
}
return(View(checking));
}
public async Task <IActionResult> CreateChecking([Bind("Balance")] Checking account)
{
account.CustomerId = _context.Users.Where(x => x.Email == User.Identity.Name).FirstOrDefault().Id;
account.AccountNumber = NumberGenerator.rnd.Next(100000000, 1000000000);
account.RoutingNumber = NumberGenerator.rnd.Next(10000000, 100000000);
account.Interest = 0.02;
account.IsActive = true;
account.AccountType = "Checking";
account.DateOpened = DateTime.Now;
if (ModelState.IsValid)
{
_context.Add(account);
await _context.SaveChangesAsync();
Transaction tran = new Transaction()
{
AccId = account.Id,
Operation = "Open",
Amount = account.Balance,
Date = account.DateOpened
};
_context.Add(tran);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(GetChecking)));
}
ViewData["CustomerId"] = new SelectList(_context.Set <ApplicationUser>(), "Id", "Id", account.CustomerId);
return(View(account));
}
public void Test_Checking_Account_CTR()
{
var ckAcct = new Checking();
var response = ckAcct.AcctBal = 110;
Assert.That(response, Is.EqualTo(110));
}
public async Task <IActionResult> Create([Bind("type,accountNumber,InterestRate,Balance,createdAt,CustomerId")] Checking checking)
{
if (ModelState.IsValid)
{
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
checking.CustomerId = userId;
checking.createdAt = DateTime.Now;
checking.InterestRate = 5;
checking.type = "Checking";
_context.Add(checking);
await _context.SaveChangesAsync();
Transaction transaction = new Transaction();
transaction.accountNumber = checking.accountNumber;
transaction.accountType = "Checking";
transaction.amount = checking.Balance;
transaction.date = DateTime.Now;
transaction.type = "Account Open";
transaction.balance = checking.Balance;
_context.Add(transaction);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(CheckingView)));
}
return(View(checking));
}
public static void AddAccounts(AppDbContext db)
{
Saving s1 = new Saving();
s1.SavingsAccountNumber = 1000000001;
s1.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**");
s1.SavingsName = "William's Savings";
s1.SavingsBalance = 40035.5m;
db.SavingsDbSet.AddOrUpdate(s => s.SavingsAccountNumber, s1);
StockPortfolio sp1 = new StockPortfolio(); sp1.StockAccountNumber = 1000000000; sp1.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); sp1.Name = "Shan's Stock"; sp1.PortfolioCashBalance = 0m; db.StockPortfoliosDbSet.AddOrUpdate(sp => sp.StockAccountNumber, sp1);
Checking c1 = new Checking(); c1.CheckingsAccountNumber = 1000000002; c1.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); c1.CheckingsName = "Gregory's Checking"; c1.CheckingsBalance = 39779.49m; db.CheckingsDbSet.AddOrUpdate(c => c.CheckingsAccountNumber, c1);
Checking c2 = new Checking(); c2.CheckingsAccountNumber = 1000000003; c2.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); c2.CheckingsName = "Allen's Checking"; c2.CheckingsBalance = 47277.33m; db.CheckingsDbSet.AddOrUpdate(c => c.CheckingsAccountNumber, c2);
Checking c3 = new Checking(); c3.CheckingsAccountNumber = 1000000004; c3.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); c3.CheckingsName = "Reagan's Checking"; c3.CheckingsBalance = 70812.15m; db.CheckingsDbSet.AddOrUpdate(c => c.CheckingsAccountNumber, c3);
Saving s2 = new Saving(); s2.SavingsAccountNumber = 1000000005; s2.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); s2.SavingsName = "Kelly's Savings"; s2.SavingsBalance = 21901.97m; db.SavingsDbSet.AddOrUpdate(s => s.SavingsAccountNumber, s2);
Checking c4 = new Checking(); c4.CheckingsAccountNumber = 1000000006; c4.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); c4.CheckingsName = "Eryn's Checking"; c4.CheckingsBalance = 70480.99m; db.CheckingsDbSet.AddOrUpdate(c => c.CheckingsAccountNumber, c4);
Saving s3 = new Saving(); s3.SavingsAccountNumber = 1000000007; s3.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); s3.SavingsName = "Jake's Savings"; s3.SavingsBalance = 7916.4m; db.SavingsDbSet.AddOrUpdate(s => s.SavingsAccountNumber, s3);
StockPortfolio sp2 = new StockPortfolio(); sp2.StockAccountNumber = 1000000008; sp2.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); sp2.Name = "Michelle's Stock"; sp2.PortfolioCashBalance = 0m; db.StockPortfoliosDbSet.AddOrUpdate(sp => sp.StockAccountNumber, sp2);
Saving s4 = new Saving(); s4.SavingsAccountNumber = 1000000009; s4.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); s4.SavingsName = "Jeffrey's Savings"; s4.SavingsBalance = 69576.83m; db.SavingsDbSet.AddOrUpdate(s => s.SavingsAccountNumber, s4);
StockPortfolio sp3 = new StockPortfolio(); sp3.StockAccountNumber = 1000000010; sp3.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); sp3.Name = "Kelly's Stock"; sp3.PortfolioCashBalance = 0m; db.StockPortfoliosDbSet.AddOrUpdate(sp => sp.StockAccountNumber, sp3);
Checking c5 = new Checking(); c5.CheckingsAccountNumber = 1000000011; c5.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); c5.CheckingsName = "Eryn's Checking 2"; c5.CheckingsBalance = 30279.33m; db.CheckingsDbSet.AddOrUpdate(c => c.CheckingsAccountNumber, c5);
IRA r1 = new IRA(); r1.IRAAccountNumber = 1000000012; r1.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); r1.IRAName = "Jennifer's IRA"; r1.IRACashBalance = 5000m; db.IRAsDbSet.AddOrUpdate(r => r.IRAAccountNumber, r1);
Saving s5 = new Saving(); s5.SavingsAccountNumber = 1000000013; s5.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); s5.SavingsName = "Sarah's Savings"; s5.SavingsBalance = 11958.08m; db.SavingsDbSet.AddOrUpdate(s => s.SavingsAccountNumber, s5);
Saving s6 = new Saving(); s6.SavingsAccountNumber = 1000000014; s6.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); s6.SavingsName = "Jeremy's Savings"; s6.SavingsBalance = 72990.47m; db.SavingsDbSet.AddOrUpdate(s => s.SavingsAccountNumber, s6);
Saving s7 = new Saving(); s7.SavingsAccountNumber = 1000000015; s7.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); s7.SavingsName = "Elizabeth's Savings"; s7.SavingsBalance = 7417.2m; db.SavingsDbSet.AddOrUpdate(s => s.SavingsAccountNumber, s7);
IRA r2 = new IRA(); r2.IRAAccountNumber = 1000000016; r2.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); r2.IRAName = "Allen's IRA"; r2.IRACashBalance = 5000m; db.IRAsDbSet.AddOrUpdate(r => r.IRAAccountNumber, r2);
StockPortfolio sp4 = new StockPortfolio(); sp4.StockAccountNumber = 1000000017; sp4.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); sp4.Name = "John's Stock"; sp4.PortfolioCashBalance = 0m; db.StockPortfoliosDbSet.AddOrUpdate(sp => sp.StockAccountNumber, sp4);
Saving s8 = new Saving(); s8.SavingsAccountNumber = 1000000018; s8.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); s8.SavingsName = "Clarence's Savings"; s8.SavingsBalance = 1642.82m; db.SavingsDbSet.AddOrUpdate(s => s.SavingsAccountNumber, s8);
Checking c6 = new Checking(); c6.CheckingsAccountNumber = 1000000019; c6.User = db.Users.FirstOrDefault(u => u.UserName == "*****@*****.**"); c6.CheckingsName = "Sarah's Checking"; c6.CheckingsBalance = 84421.45m; db.CheckingsDbSet.AddOrUpdate(c => c.CheckingsAccountNumber, c6);
}
public void VerifyToViewAccountWithdrawBalance(double Withdarww)
{
checking = new Checking(5000);
double Withdarw = checking.Bal;
Assert.AreEqual(Withdarww, Withdarw);
}
public void VerifyToViewAccountDepositBalance(double Depositt)
{
checking = new Checking(5000);
double Deposit = checking.Bal;
Assert.AreEqual(Depositt, Deposit);
}
public ActionResult Edit([Bind(Include = "CheckingID,CheckingsName,CheckingsBalance")] Checking @checking, string Id, string[] SelectedUsers)
{
if (ModelState.IsValid)
{
//find associated user
Checking checkingToChange = db.CheckingsDbSet.Find(@checking.CheckingID);
//edit error is there becauase there's no users in the database: check this after seeding to see if edit works
if (checkingToChange.User.Id != Id)
{
//find user
AppUser SelectedUser = db.Users.Find(Id);
//update user
checkingToChange.User = SelectedUser;
}
checkingToChange.CheckingsName = @checking.CheckingsName;
db.Entry(checkingToChange).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AllUsers = GetAllUsers(@checking);
return(View(@checking));
}
public ActionResult Withdraw(Checking checking)
{
if (ModelState.IsValid)
{
int withdrawamount = checking.AccountBalance;
checking.AccountBalance = (int)TempData["Balance"];
if (checking.AccountBalance - withdrawamount < 0)
{
return(View());
}
else
{
checking.AccountBalance -= withdrawamount;
_context.Entry(checking).State = EntityState.Modified;
_context.CheckingTrans.Add(new CheckingTrans
{
Time = DateTime.Now,
Amount = withdrawamount,
CheckingId = checking.CheckingId,
Type = "Withdrawal"
});
_context.SaveChanges();
}
}
return(View());
}
public void VerifyToViewAccountCheckingBalance(double Cbalence)
{
checking = new Checking(2000);
double currentbal = checking.Bal;
Assert.AreEqual(Cbalence, currentbal);
}
public async Task <IActionResult> Create([Bind("type,accountNumber,InterestRate,Balance,createdAt")] Checking checking)
{
if (ModelState.IsValid)
{
Transaction transaction = new Transaction();
transaction.Customers = checking.Customers;
transaction.accountNumber = checking.accountNumber;
transaction.accountType = "checking";
transaction.amount = checking.Balance;
transaction.date = DateTime.Now;
transaction.type = "Opening";
_context.Update(transaction);
await _context.SaveChangesAsync();
checking.accountNumber = ListEnums.accntNumberChk;
_context.Add(checking);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(checking));
}
public async Task <IActionResult> DepositChecking(int id, int amount)
{
try
{
Checking checking = new Checking();
checking = await _context.Checking.FirstOrDefaultAsync(c => c.AccountID == id);
var newBalance = (checking.Balance + amount);
checking.Balance = newBalance;
Transaction transaction = new Transaction();
transaction.AccountID = id;
transaction.AccountType = "checking";
transaction.Amount = amount;
transaction.Date = DateTime.Now;
transaction.Type = "deposit";
_context.Update(checking);
await _context.SaveChangesAsync();
_context.Update(transaction);
await _context.SaveChangesAsync();
}
catch
{
ViewData["ErrorMessage"] = "There was a problem with your deposit please try again";
return(View());
}
return(RedirectToAction(nameof(MyChecking)));
}
// Create
public bool CreateChecking(CheckingCreate model)
{
var entity =
new Checking()
{
OwnerId = _userId,
CheckingName = model.CheckingName,
MonthlyBill = model.MonthlyBill,
ChargeDate = model.CheckingName,
DateCleared = model.DateCleared,
Cleared = model.Cleared,
CreatedUtc = DateTimeOffset.Now,
CategoryId = model.CategoryId,
UtilityCompanyId = model.UtilityCompanyId,
DescriptionId = model.DescriptionId,
PayingById = model.PayingById,
};
using (var ctx = new ApplicationDbContext())
{
ctx.Entries.Add(entity);
return(ctx.SaveChanges() == 1);
}
}
private void cboLop_SelectedIndexChanged(object sender, EventArgs e)
{
loadDataGridView();
DateTime ngayBatDau = NamHocBLL.GetNgayBatDau(KeyHandle.GetKeyFromCombobox(cboNamHoc.SelectedItem.ToString()));
DateTime ngayKetThuc = NamHocBLL.GetNgayKetThuc(KeyHandle.GetKeyFromCombobox(cboNamHoc.SelectedItem.ToString()));
if (LopBLL.GetSiSo(KeyHandle.GetKeyFromCombobox(cboLop.SelectedItem.ToString())) > 0 &&
Checking.IsInOfDate(ngayBatDau, ngayKetThuc))
{
//btnLuuDiemDanh.Enabled = true;
btnTaoBangMoi.Enabled = true;
}
else if (LopBLL.GetSiSo(KeyHandle.GetKeyFromCombobox(cboLop.SelectedItem.ToString())) <= 0)
{
lbThongBao.Text += "\nLớp không có học sinh, không thể tạo phiếu mới";
lbThongBao.Visible = true;
btnLuuDiemDanh.Enabled = false;
btnTaoBangMoi.Enabled = false;
}
else if (!Checking.IsInOfDate(ngayBatDau, ngayKetThuc))
{
lbThongBao.Text += "\nNiên khóa đã qua, không thể tạo phiếu mới";
lbThongBao.Visible = true;
btnLuuDiemDanh.Enabled = false;
btnTaoBangMoi.Enabled = false;
}
}
// GET: Checkings/Edit/5
// id = checkingID
public ActionResult Edit(int?id)
{
var CustomerQuery = from c in db.Users
where c.UserName == User.Identity.Name
select c;
// Get the Customer
AppUser customer = CustomerQuery.FirstOrDefault();
//Return frozen view if no go
if (customer.ActiveStatus == false)
{
return(View("Frozen"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Checking checking = db.CheckingAccount.Find(id);
if (checking == null)
{
return(HttpNotFound());
}
return(View(checking));
}
public ActionResult CheckTransfer(Loan loan, Checking checking)
{
if (ModelState.IsValid)
{
int withdrawamount = loan.AccountBalance;
loan.AccountBalance = (int)TempData["LBalance"];
loan.AccountBalance -= withdrawamount;
_context.Entry(loan).State = EntityState.Modified;
_context.LoanTrans.Add(new LoanTrans
{
Time = DateTime.Now,
Amount = withdrawamount,
LoanId = loan.LoanId,
Type = "TransferSub"
});
_context.SaveChanges();
int depositamount = checking.AccountBalance;
checking.AccountBalance += (int)TempData["CBalance"];
_context.Entry(checking).State = EntityState.Modified;
_context.CheckingTrans.Add(new CheckingTrans
{
Time = DateTime.Now,
Amount = depositamount,
CheckingId = checking.CheckingId,
Type = "TransferAdd"
});
_context.SaveChanges();
}
return(View());
}
/*
* chekcing account related
*/
public void OpenChecking()
{
//create account id
string id;
//loop unitl the new id didn't exist
while (true)
{
id = IDgen.GenerateID();
if (new Validation().UniqueID(id))
{
break;
}
}
//create a checking object
Checking ac = new Checking()
{
AccountID = id,
Date = DateTime.Now
};
//add to currentAccount
currentAccount.CheckingList.Add(ac);
//save to json file
dal.SaveToFile();
Console.WriteLine("new chekcing account created!!\n");
}
public void Withdrawal_AmountLargerThanAccountBalance_ArgumentExceptionThrown()
{
Account account = new Checking(new AccountHolder("Obi-Wan", "Kenobi"));
account.Deposit(50);
account.Withdrawal(100, "Kroger");
}
private void cbAccounts_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbAccounts.SelectedItem != null)
{
switch (cbAccounts.SelectedItem.ToString())
{
case "CHECKINGS":
Checking checkingAccount = (Checking)LoginInformation.customerSignedIn.AccountsList[0];
checkingAccount.UpdateBalance(TransTypes.DEPOSIT, 0.0d);
tbDisplay.Text = checkingAccount.AccountType.ToString() + "\r\n\r\nAccount Balance: " + checkingAccount.AccountBalance + "\r\nNumber of Transactions Today: " + checkingAccount.DetermineDailyTransactions().ToString() + "\r\nOpen Date: " + checkingAccount.AccountOpenDate;
break;
case "SAVINGS":
Saving savingAccount = (Saving)LoginInformation.customerSignedIn.AccountsList[1];
savingAccount.UpdateBalance(TransTypes.DEPOSIT, 0.0d);
tbDisplay.Text = savingAccount.AccountType.ToString() + "\r\n\r\nAccount Balance: " + savingAccount.AccountBalance + "\r\nOpen Date: " + savingAccount.AccountOpenDate;
break;
default:
tbDisplay.Clear();
break;
}
}
else
{
tbDisplay.Clear();
}
}
static void Main(string[] args)
{
try
{
Account checking = new Checking("BankName", "bob", 200);
checking.deposit(200);
checking.withdraw(10);
Investment inv = new Individual("Bank", "bob", 600);
inv.deposit(1000);
Investment cap = new Corporate("Sam's Bank", "Sam", 10000);
cap.tranfer(1000, inv);
Console.WriteLine(checking);
Console.WriteLine(inv);
Console.WriteLine(cap);
Console.WriteLine("Press any key to continue");
Console.ReadKey();
}
catch (ArithmeticException e)
{
Console.WriteLine(e.Message);
}
catch (Exception e)
{
Console.WriteLine("Something happened!");
}
}
public void CheckingAccount_WithdrawInsufficientFundsExceptionError_ShouldSucceed()
{
//arrange
var checkingAccount = new Checking("Jeffries", 2000m, 233456);
checkingAccount.Withdraw(3000m);
}
public ActionResult Edit([Bind(Include = "CheckingID,AccountNumber,Name")] Checking checking)
{
if (ModelState.IsValid)
{
// Find the CustomerID Associated with the Account
var CheckingCustomerQuery = from ca in db.CheckingAccount
where ca.CheckingID == checking.CheckingID
select ca.Customer.Id;
// Execute the Find
List <String> CustomerID = CheckingCustomerQuery.ToList();
String IntCustomerID = CustomerID[0];
Checking CustomerChecking = db.CheckingAccount.Find(checking.CheckingID);
// updated the checking account
CustomerChecking.Name = checking.Name;
db.Entry(CustomerChecking).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Portal", "Home"));
}
return(RedirectToAction("Index", "Checkings"));
}
public async Task <IActionResult> Edit(int id, [Bind("CheckingId,Interest,AccountBalance")] Checking checking)
{
if (id != checking.CheckingId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(checking);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CheckingExists(checking.CheckingId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(checking));
}
public void VerifyToViewAccountReserveBalance(double Rab)
{
checking = new Checking(2000);
double reserveacountbal = checking.MinBalance;
Assert.AreEqual(Rab, reserveacountbal);
}
public ActionResult DeleteConfirmed(int id)
{
Checking @checking = db.Checkings.Find(id);
db.Checkings.Remove(@checking);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void CreateChecking(Checking checking)
{
checking.UserId = uid;
//add to the database
_context.Add(checking);
_context.SaveChanges();
}
public void Add(int ingredientId, string userId)
{
var checking = new Checking();
checking.IngredientId = ingredientId;
checking.UserId = userId;
CheckingRepo.Add(checking);
}
public ActionResult Withdraw()
{
Checking checking = _context.Checking.Find(1);
TempData["Balance"] = checking.AccountBalance;
return(View());
}
public void SavingsAccount_TransferInsufficientFundsExceptionError_ShouldSucceed()
{
//arrange
var savingsAccount = new Savings("Jeffries", 20000m, 233456);
var checkingAccount = new Checking("Jeffries", 3000m, 123456);
savingsAccount.Transfer(3000000m, checkingAccount);
}
public static Checking CreateChecking(string ID, global::System.DateTime date, Oembed oembed)
{
Checking checking = new Checking();
checking.Id = ID;
checking.Date = date;
if ((oembed == null))
{
throw new global::System.ArgumentNullException("oembed");
}
checking.Oembed = oembed;
return checking;
}
public ActionResult Edit(Checking account)
{
try {
db.Entry(account).State = EntityState.Modified;
db.SaveChanges();
} catch (DbUpdateConcurrencyException cex) {
// Reload new value from database
cex.Entries.Single().Reload();
// Update model state to show original balance
ModelState.Clear();
ModelState.AddModelError("Balance", "Concurrency Exception - you are too slow!");
return View(account);
}
// Get request
return RedirectToAction("Edit");
}
public static Account[] AccountData()
{
Person[] p = PersonData();
Account p1Savings = new Savings(1500.00,p[0],4.0);
Account p1Checking = new Checking(p[0],2500.00,.50);
Account p2Savings = new Savings(1000.00,p[1],3.5);
Account[] a = {p1Savings,p1Checking,p2Savings};
return a;
}
public void AddToCheckins(Checking checking)
{
base.AddObject("Checkins", checking);
}
