public int Add(Account account) //insert account obj into datbase { _context.Accounts.Add(account); _context.SaveChanges(); return(account.CustomerID); }
public int Add(Payee payee) //insert Payee obj into datbase { _context.Payees.Add(payee); _context.SaveChanges(); return(payee.PayeeID); }
public int Add(BillPay bill) //insert billpay obj into datbase { _context.BillPays.Add(bill); _context.SaveChanges(); return(bill.BillPayID); }
public int Add(Customer customer) //insert customer obj into datbase { _context.Customers.Add(customer); _context.SaveChanges(); return(customer.CustomerID); }
public int Add(Transaction transaction) //insert transaction obj into datbase { _context.Transactions.Add(transaction); _context.SaveChanges(); return(transaction.TransactionID); }
public int Add(Login login) //insert login obj into datbase { _context.Logins.Add(login); _context.SaveChanges(); return(Convert.ToInt32(login.LoginID)); }
public async Task <bool> InsertPayment(int?id, int PayeeID, decimal Amount, DateTime ScheduleDate, Period Period) { Account account = await _context.Accounts.FindAsync(id); if (account.Balance < Amount) { controller.ModelState.AddModelError(nameof(Amount), "Your account balance is not enough."); } if (!await CheckNull(id)) {//check if the customer own this account controller.ModelState.AddModelError("AccountNotExsit", "Account not exsit in your name."); } if (CountDecimalPlaces(Amount) > 2) { controller.ModelState.AddModelError(nameof(Amount), "Amount cannot have more than 2 decimal places."); } if (Amount <= 0) { controller.ModelState.AddModelError(nameof(Amount), "Amount must be positive."); } if (!(CheckPayee(PayeeID))) {//check if the customer own this account controller.ModelState.AddModelError("AccountNotExsit", "Payee not exsit"); } if (ScheduleDate < DateTime.Today) { controller.ModelState.AddModelError("ScheduleDate", "Schedule Date cannot be ealier than today"); } if (!controller.ModelState.IsValid) { return(false); } BillPay billPay = new BillPay { AccountNumber = (int)id, PayeeID = PayeeID, Amount = Amount, ModifyDate = DateTime.UtcNow, //default modfied today ScheduleDate = ScheduleDate.ToUniversalTime(), Period = Period }; _context.BillPays.Add(billPay); _context.SaveChanges(); return(true); }