private void Loans_listView_SelectedIndexChanged(object sender, EventArgs e) { // get selected item value Loan loan = Loans_listView.SelectedItems.Count > 0 ? (Loan)Loans_listView.SelectedItems[0].Tag : null; if (loan == null) { return; } // to handle listView idiot 2 step item selection process // search DB for loan and update textBoxes var rdr = DB_API.SelectLoan(account_id, loan.Name); while (rdr.Read()) { Name_textBox.Text = rdr[DB_API.LoanEnt.name.ToString()].ToString(); Name_textBox.ForeColor = Color.Black; InitialAmount_textBox.Text = DB_API.Moneyfy(rdr[DB_API.LoanEnt.initial_amount.ToString()].ToString()); InitialAmount_textBox.ForeColor = Color.Black; CurrentDebt_textBox.Text = DB_API.Moneyfy(rdr[DB_API.LoanEnt.current_debt.ToString()].ToString()); CurrentDebt_textBox.ForeColor = Color.Black; Enddate_dateTimePicker.Value = DateTime.Parse(rdr[DB_API.LoanEnt.term.ToString()].ToString()); Interest_textBox.Text = Double.Parse(rdr[DB_API.LoanEnt.interest.ToString()].ToString()).ToString() + "%"; Interest_textBox.ForeColor = Color.Black; } }
private void Accounts_listbox_SelectedIndexChanged(object sender, EventArgs e) { // get selected item value string account_name = (string)accounts_listbox.SelectedItem; int account_id = CURRENT_USER_ACCOUNTS[account_name]; // set account_name label account_textbox.Text = account_name; account_textbox.ForeColor = Color.Black; // get account complete info var rdr = DB_API.SelectMoneyAccountById(account_id); while (rdr.Read()) { balance_textbox.Text = DB_API.Moneyfy(Double.Parse(rdr[DB_API.MoneyAccountEnt.balance.ToString()].ToString())); patrimony_textbox.Text = DB_API.Moneyfy(Double.Parse(rdr[DB_API.MoneyAccountEnt.patrimony.ToString()].ToString())); } // get associated user of selected account rdr = DB_API.SelectMoneyAccountUsers(account_id); List <String> res = new List <string>(); while (rdr.Read()) { res.Add(rdr["user_email"].ToString()); } associatedusers_listbox.DataSource = res; }
private void Transactions_listView_SelectedIndexChanged(object sender, EventArgs e) { // get selected item value Transaction tr = Transactions_listView.SelectedItems.Count > 0 ? (Transaction)Transactions_listView.SelectedItems[0].Tag : null; if (tr == null) { return; } // to handle listView idiot 2 step item selection process // update TextBoxes // category and subcategory int category_id = (int)tr.CategoryID; if (category_id % 100 == 0) // is category { category_comboBox.Text = categoriesIntStr[category_id]; subcategory_comboBox.Text = this.none; } else { category_comboBox.Text = categoriesIntStr[category_id / 100 * 100]; subcategory_comboBox.Text = categoriesIntStr[category_id]; } // transaction type type_comboBox.Text = DB_API.SelectTransactionTypeNameById((int)tr.TransactionTypeID); // wallet var rdr = DB_API.SelectWallet((int)tr.WalletID); while (rdr.Read()) { wallet_comboBox.Text = rdr[DB_API.WalletEnt.name.ToString()].ToString(); break; } if ((int)tr.TransactionTypeID == 0) { rdr = DB_API.SelectWallet((int)tr.RecipientWalletID); while (rdr.Read()) { wallet2_comboBox.Text = rdr[DB_API.WalletEnt.name.ToString()].ToString(); break; } } // amount amount_textBox.Text = DB_API.Moneyfy(tr.Amount); amount_textBox.ForeColor = Color.Black; // date dateTimePicker.Value = (DateTime)tr.Date; // notes and location notes_textBox.Text = tr.Notes; notes_textBox.ForeColor = Color.Black; location_textBox.Text = tr.Location; location_textBox.ForeColor = Color.Black; }
private void Filtermaxamount_textBox_Leave(object sender, EventArgs e) { filtermaxamount_textBox.Text = DB_API.Moneyfy(filtermaxamount_textBox.Text); if (filtermaxamount_textBox.Text.Equals("")) { filtermaxamount_textBox.Text = "max amount"; filtermaxamount_textBox.ForeColor = Color.Gray; } }
private void Amount_textBox_Leave(object sender, EventArgs e) { amount_textBox.Text = DB_API.Moneyfy(amount_textBox.Text); if (amount_textBox.Text.Equals("")) { amount_textBox.Text = "amount"; amount_textBox.ForeColor = Color.Gray; } }
private void Goalamount_textBox_Leave(object sender, EventArgs e) { goalamount_textBox.Text = DB_API.Moneyfy(goalamount_textBox.Text); if (goalamount_textBox.Text.Equals("")) { goalamount_textBox.Text = "goal value"; goalamount_textBox.ForeColor = Color.Gray; } }
private void Pay_textBox_Leave(object sender, EventArgs e) { Pay_textBox.Text = DB_API.Moneyfy(Pay_textBox.Text); if (Pay_textBox.Text.Equals("")) { Pay_textBox.Text = "payment"; Pay_textBox.ForeColor = Color.Gray; } }
private void CurrentDebt_textBox_Leave(object sender, EventArgs e) { CurrentDebt_textBox.Text = DB_API.Moneyfy(CurrentDebt_textBox.Text); if (CurrentDebt_textBox.Text.Equals("")) { CurrentDebt_textBox.Text = "current debt"; CurrentDebt_textBox.ForeColor = Color.Gray; } }
private void Budgets_listBox_SelectedIndexChanged(object sender, EventArgs e) { // get selected item value string budget = (string)Budgets_listBox.SelectedItem; int budget_id = this.budgetsDict[budget]; // search DB for budgets var rdr = DB_API.SelectBudget(budget_id); var res = new Dictionary <string, int>(); while (rdr.Read()) { StartMonth_comboBox.Text = months[DateTime.Parse(rdr[DB_API.BudgetEnt.start_date.ToString()].ToString()).Month]; StartYear_numericBox.Value = DateTime.Parse(rdr[DB_API.BudgetEnt.start_date.ToString()].ToString()).Year; EndMonth_comboBox.Text = months[DateTime.Parse(rdr[DB_API.BudgetEnt.start_date.ToString()].ToString()).Month]; EndYear_numericBox.Value = DateTime.Parse(rdr[DB_API.BudgetEnt.start_date.ToString()].ToString()).Year; Budget_textBox.Text = DB_API.Moneyfy(rdr[DB_API.BudgetEnt.amount.ToString()].ToString()); } }
// ------------------------------------------------------------------- // 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); } }
private void Budget_textBox_Leave(object sender, EventArgs e) { Budget_textBox.Text = DB_API.Moneyfy(Budget_textBox.Text); }
private void PrivatePopulateTransactionsListView(DataTableReader rdr) { // clear Transactions listView Transactions_listView.Items.Clear(); while (rdr.Read()) { int transaction_id = (int)rdr[DB_API.TransactionEnt.transaction_id.ToString()]; int category_id = (int)rdr[DB_API.TransactionEnt.category_id.ToString()]; int account_id = (int)rdr[DB_API.TransactionEnt.account_id.ToString()]; int transaction_type_id = (int)rdr[DB_API.TransactionEnt.transaction_type_id.ToString()]; int wallet_id = (int)rdr[DB_API.TransactionEnt.wallet_id.ToString()]; DateTime date = (DateTime)rdr[DB_API.TransactionEnt.date.ToString()]; string category = categoriesIntStr[category_id]; double amount = Double.Parse(rdr[DB_API.TransactionEnt.amount.ToString()].ToString()); string notes = rdr[DB_API.TransactionEnt.notes.ToString()].ToString(); string location = rdr[DB_API.TransactionEnt.location.ToString()].ToString(); // correct amount for negative or positive if expense or income amount = transaction_type_id >= 0 ? amount : -amount; if (transaction_type_id == 0) { int recipient_wallet_id = (int)rdr[DB_API.TransactionEnt.recipient_wallet_id.ToString()]; var row1 = new string[] { transaction_id.ToString(), date.ToString("dd/MM/yyyy"), "Transfer", DB_API.Moneyfy(-amount) }; var row2 = new string[] { transaction_id.ToString(), date.ToString("dd/MM/yyyy"), "Transfer", DB_API.Moneyfy(amount) }; var item1 = new ListViewItem(row1); var item2 = new ListViewItem(row2); item1.Tag = new Transaction(transaction_id, -amount, date, notes, location, category_id, account_id, transaction_type_id, wallet_id, recipient_wallet_id); item2.Tag = new Transaction(transaction_id, amount, date, notes, location, category_id, account_id, transaction_type_id, wallet_id, recipient_wallet_id); Transactions_listView.Items.Add(item1); Transactions_listView.Items.Add(item2); } else { var row = new string[] { transaction_id.ToString(), date.ToString("dd/MM/yyyy"), category, DB_API.Moneyfy(amount) }; var item = new ListViewItem(row); item.Tag = new Transaction(transaction_id, amount, date, notes, location, category_id, account_id, transaction_type_id, wallet_id, null); Transactions_listView.Items.Add(item); } } }
private void Goals_listBox_SelectedIndexChanged(object sender, EventArgs e) { // get selected item value string goal_name = Goals_listBox.SelectedItem.ToString(); var rdr = DB_API.SelectGoal(account_id, goal_name); while (rdr.Read()) { int category_id = (int)rdr[DB_API.GoalEnt.category_id.ToString()]; string cat_name = ""; string sub_cat_name = ""; if (category_id % 100 == 0) { foreach (KeyValuePair <string, int> entry in this.categories) { if (entry.Value == category_id) { cat_name = entry.Key; sub_cat_name = this.none; break; } } } else { int cat_id = -1; foreach (KeyValuePair <string, int> entry in this.categories) { if (entry.Value == category_id) { sub_cat_name = entry.Key; cat_id = category_id / 100 * 100; break; } } foreach (KeyValuePair <string, int> entry in this.categories) { if (entry.Value == cat_id) { cat_name = entry.Key; break; } } } // update TextBoxes Categories_comboBox.Text = cat_name; Subcategories_comboBox.Text = sub_cat_name; goalname_textBox.Text = goal_name; goalname_textBox.ForeColor = Color.Black; double goal_amount = Double.Parse(rdr[DB_API.GoalEnt.amount.ToString()].ToString()); goalamount_textBox.Text = DB_API.Moneyfy(goal_amount); goalamount_textBox.ForeColor = Color.Black; term_dateTimePicker.Value = DateTime.Parse(rdr[DB_API.GoalEnt.term.ToString()].ToString()); // change GoalState Label rdr = DB_API.SelectWalletByName(account_id, goal_name); double balance = 0.0; while (rdr.Read()) { balance = Double.Parse(rdr[DB_API.WalletEnt.balance.ToString()].ToString()); } if (balance < goal_amount) { Goalstate_label2.Text = "Keep going!\r\n" + (balance / goal_amount * 100) + "% complete!\r\n" + (goal_amount - balance) + "$ to go!"; } if (balance >= goal_amount) { Goalstate_label2.Text = "Congratulations!\r\nGoal reached!\r\nSaved " + balance + "!"; } } }