private void TransactionEntry_Load(object sender, EventArgs e)
{
//connStr = MainForm.ReturnConnectionString();
conn = new MySqlConnection(connStr);
cmd = new MySqlCommand();
List <string> budgetLst = new List <string>();
//Populate listview with current budget entries.
myBudget.BudgetTableGetExpenseCategoryCurrentMonth(ref budgetLst);
cmbo_BudgetName.DataSource = budgetLst;
//Determine if modify or add btn was pressed for transaction entries
if (isModifyTransactionEntry)
{
int selectedIndex;
selectedIndex = cmbo_BudgetName.FindString(myTransaction.SelectedTransaction.transactionName);
cmbo_BudgetName.SelectedIndex = selectedIndex;
cmbo_BudgetName.Enabled = false;
//TODO add modification of Transaction Entry
//if modify
//get selected item from the transaction listview and show it in the
//list box on the transaction entry form
}
}
private void FillBudgetDataGridView()
{
//https://stackoverflow.com/questions/29148568/filling-a-liststring-with-mysql-query
//https://docs.microsoft.com/en-us/dotnet/framework/winforms/controls/how-to-bind-objects-to-windows-forms-datagridview-controls
BindingSource bindingSource = new BindingSource();
List <string> budgetLst = new List <string>();
BudgetDB myBudget = new BudgetDB();
TransactionDB myTransaction = new TransactionDB();
int errNbr = 0;
decimal budgetAmount = 0;
decimal budgetSpent = 0;
decimal budgetRemaing = 0;
//Get list of budgets that money is spent from
errNbr = myBudget.BudgetTableGetExpenseCategoryCurrentMonth(ref budgetLst);
//For each budget item get the budget amount, budget spent, and budget remaining
if (errNbr == 0)
{
foreach (string budgetName in budgetLst)
{
//Get budget amount from budget table
errNbr = myBudget.BudgetTableGetBudgetAmtForCategory(ref budgetAmount, budgetName);
//Get budget spent from transaction table
errNbr = myTransaction.TransactionTableGetTotalBudgetAmtSpent(ref budgetSpent, budgetName);
//Get budget remaining by subtracting total spent from total budget amount
budgetRemaing = budgetAmount - budgetSpent;
//Create new BudgetTable object initialized with above values
BudgetTableEntry tmpEntry = new BudgetTableEntry(budgetName, budgetAmount.ToString(), budgetSpent.ToString(), budgetRemaing.ToString());
//Add BudgetTable to Binding source
bindingSource.Add(tmpEntry);
}
dgv_BudgetReport.DataSource = bindingSource;
}
}