public decimal GetBalance(IAccount account)
{
account = new HomeLoanAccount();
decimal bal = account.Balance;
return(bal);
}
public IAccount OpenHomeLoanAccount(string customerName, DateTimeOffset openedDate)
{
IAccount homeLoan = new HomeLoanAccount();
DataTable dt = new DataTable();
SQLiteConnection conn = new SQLiteConnection(this.source);
conn.Open();
//in order to generate account number
//we need to keep track of the number of account in the db
String homeQuery = "UPDATE accountType SET counter = counter + 1 where name='homeLoan'";
SQLiteDataAdapter sda = new SQLiteDataAdapter(homeQuery, conn);
sda.Fill(dt);
dt.Clear();
//now select the last element in the db
//so we can assign the account number correctly
homeQuery = "SELECT counter FROM accountType where name='homeLoan' ";
SQLiteDataAdapter da = new SQLiteDataAdapter(homeQuery, conn);
da.Fill(dt);
int number = Int32.Parse(dt.Rows[0].ItemArray[0].ToString());
//gather the account number
string code = "LN";
string accountNo = accNoGenerator(code, number);
Console.WriteLine(accountNo);
dt.Clear();
string date = DateTime.Now.ToString();
//insert new account into the db
homeQuery = "Insert into account(dateOpened, accountNumber, balance, customerName) " +
"values ('" + date + "', '" + accountNo + "', '" + 0.0 + "', '" + customerName + "')";
SQLiteDataAdapter newDa = new SQLiteDataAdapter(homeQuery, conn);
newDa.Fill(dt);
Response.Redirect("AccountLister");
return(homeLoan);
}
