public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer) { var jsonObject = JObject.Load(reader); var accounts = AccountFactory.CreateAccount(jsonObject.Value <int>("AccountNumber"), jsonObject.Value <char>("AccountType"), jsonObject.Value <int>("CustomerID"), jsonObject.Value <decimal>("Balance")); serializer.Populate(jsonObject.CreateReader(), accounts); return(accounts); }
public Account SelectById(int id) { using (var conn = GetConnection()) { conn.Open(); SqlCommand AccCmd = new SqlCommand("SELECT * FROM ACCOUNT WHERE AccountNumber = @AccountNumber", conn); AccCmd.Parameters.AddWithValue("@AccountNumber", id); AccCmd.ExecuteNonQuery(); read = AccCmd.ExecuteReader(); Account a = null; while (read.Read()) { a = AccountFactory.CreateAccount(read.GetInt32(0), read.GetString(1)[0], read.GetInt32(2), read.GetDecimal(3)); } return(a); } }
public List <Account> SelectAll(int id) { using (var conn = GetConnection()) { conn.Open(); List <Account> list = new List <Account>(); SqlCommand AccCmd = new SqlCommand("SELECT * FROM ACCOUNT WHERE CustomerID = @CustomerID", conn); AccCmd.Parameters.AddWithValue("@CustomerID", id); AccCmd.ExecuteNonQuery(); read = AccCmd.ExecuteReader(); while (read.Read()) { Account a = AccountFactory.CreateAccount(read.GetInt32(0), read.GetString(1)[0], read.GetInt32(2), read.GetDecimal(3)); list.Add(a); } return(list); } }
static Account AccountCreationMenu() { AccountFactory acctFactory = new AccountFactory(); int opt; do { Console.WriteLine("\t*-------------Create Account Menu-------------*"); Console.WriteLine("Choose an account type to create: "); Console.WriteLine("1) Checking Account"); Console.WriteLine("2) Businness Account"); Console.WriteLine("3) Loan Account"); Console.WriteLine("4) Term Deposit Account"); Console.WriteLine("0) Go Back"); Console.Write("Enter Option: "); string st = Console.ReadLine(); if (!int.TryParse(st, out opt)) { Console.WriteLine($"Error: [{st}] is not a option"); } else if (opt == 0) { break; } else if (opt < 1 || opt > 4) { Console.WriteLine($"Error: {opt} is not an option"); } else { //Console.WriteLine("INSIDE CREATE"); Console.WriteLine((AccountFactory.AccountsType)opt); Account createdAccount = acctFactory.CreateAccount((AccountFactory.AccountsType)opt); return(createdAccount); } } while (true); return(null); }