// -------------------------------------------------------------------
// LIST BOXES --------------------------------------------------------
// -------------------------------------------------------------------
private void PopulateLoansListView()
{
// clear listView items
Loans_listView.Items.Clear();
// get loans from DB
var rdr = DB_API.SelectAccountLoans(account_id);
// populate listView
while (rdr.Read())
{
string name = rdr[DB_API.LoanEnt.name.ToString()].ToString();
//double account_id = (double)(int)rdr[DB_API.LoanEnt.account_id.ToString()];
DateTime term = (DateTime)rdr[DB_API.LoanEnt.term.ToString()];
double initial_amount = Double.Parse(rdr[DB_API.LoanEnt.initial_amount.ToString()].ToString());
double current_debt = Double.Parse(rdr[DB_API.LoanEnt.current_debt.ToString()].ToString());
double interest = Double.Parse(rdr[DB_API.LoanEnt.interest.ToString()].ToString());
var row = new string[] { name, term.ToString("dd/MM/yyyy"), DB_API.Moneyfy(current_debt) };
var item = new ListViewItem(row);
item.Tag = new Loan(name, null, initial_amount, current_debt, term, interest);
Loans_listView.Items.Add(item);
}
}
