private void UserChanges() { try { using (var dbcontext = new BankingSystemV3Entities()) { Console.WriteLine("Please select the account ID : "); int id = Convert.ToInt32(Console.ReadLine()); Customer c = dbcontext.Customers .First(i => i.customerID == id); Console.WriteLine("Please enter the new name "); string newFirstName = Console.ReadLine(); c.customerName = newFirstName; Console.Write("Please enther the second name \n"); string newSecondName = Console.ReadLine(); c.customerSurname = newSecondName; dbcontext.SaveChanges(); Console.WriteLine("Customer personal data" + " modified"); } } catch (Exception ex) { Console.WriteLine(ex.InnerException); } }
private void WithdrawMoney() { try { using (var dbcontext = new BankingSystemV3Entities()) { Console.WriteLine("Please select the account ID which u want to withdraw money "); int id = Convert.ToInt32(Console.ReadLine()); Account account = dbcontext.Accounts .First(i => i.accountID == id); Console.WriteLine("Please enter the sum which you want to withdraw "); int withdraw = Convert.ToInt32(Console.ReadLine()); if (withdraw <= 0 || withdraw > account.sum) { Console.WriteLine("Withdraw can't be completed, try again."); } else { account.sum -= withdraw; Console.WriteLine("You have withdrawed " + withdraw + " from your account. Now you have " + account.sum); } dbcontext.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.InnerException); } }
private void AddMoney() { try { using (var dbcontext = new BankingSystemV3Entities()) { Console.WriteLine("Please select the account ID which u want to add money to"); int id = Convert.ToInt32(Console.ReadLine()); Account account = dbcontext.Accounts .First(i => i.accountID == id); Console.WriteLine("Input the sum which you want to add to account"); int add = Convert.ToInt32(Console.ReadLine()); if (add <= 0) { Console.WriteLine("Can't deposit non positive amount"); } else { account.sum += add; } dbcontext.SaveChanges(); Console.WriteLine("You have added " + add + " to your account. Now you have " + account.sum); } } catch (Exception ex) { Console.WriteLine(ex.InnerException); } }
private void DeleteCustomer() { var dbcontext = new BankingSystemV3Entities(); using (dbcontext) { try { Console.WriteLine("Type the customer id which u want to delete"); int input = Convert.ToInt32(Console.ReadLine()); Customer customer = dbcontext.Customers.First(i => i.customerID == input); dbcontext.Customers.Remove(customer); dbcontext.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.InnerException); } } }
private void DeleteAccount() { var dbcontext = new BankingSystemV3Entities(); using (dbcontext) { try { Console.WriteLine("Type the account ID which u want to delete"); int input = Convert.ToInt32(Console.ReadLine()); Account account = dbcontext.Accounts.First(i => i.accountID == input); dbcontext.Accounts.Remove(account); dbcontext.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.InnerException); } } }
private void CreateAccount() { var dbcontext = new BankingSystemV3Entities(); try { Console.WriteLine("Please enter the bank where you want to open account : "); string bname = Console.ReadLine(); Console.WriteLine("Please enter the bank city location: "); string blocation = Console.ReadLine(); Console.WriteLine("Account type: "); string accountType1 = Console.ReadLine(); Console.WriteLine("Sum: "); int basicDeposit = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Please enter your first name:"); string firstName = Console.ReadLine(); Console.WriteLine("Please enter your second name: "); string secondName = Console.ReadLine(); Console.WriteLine("Please enter your address: "); string address = Console.ReadLine(); Console.WriteLine("Please enter your phone: "); int phoneNumber = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Please enter your accountNumber: "); int customerAccNumber = Convert.ToInt32(Console.ReadLine()); using (dbcontext) { var bank = new Bank { bankName = bname, bankLocation = blocation }; var account = new Account { accountType = accountType1, sum = basicDeposit }; var customer = new Customer { customerName = firstName, customerSurname = secondName, customerAddress = address, customerPhone = phoneNumber, customerAccNo = customerAccNumber, Bank = bank, Account = account }; dbcontext.Customers.Add(customer); dbcontext.SaveChanges(); Console.WriteLine("Customer account was created. Thank you for using our services. Have a nice day."); Console.ReadKey(); } } catch (Exception ex) { Console.WriteLine(ex.InnerException); } }