/// <summary>
/// load budget tracker labels from the BudgetTracker table
/// </summary>
/// <param name="budgetTrack"></param>
public void loadTextBoxs(BudgetTrack budgetTrack)
{
labelTotal1.Text = budgetTrack.Total.ToString();
labelRent1.Text = budgetTrack.Rent.ToString();
labelBills1.Text = budgetTrack.Bills.ToString();
labelFood1.Text = budgetTrack.Food.ToString();
labelSavings1.Text = budgetTrack.Saving.ToString();
labelMiscellaneous1.Text = budgetTrack.Miscellaneous.ToString();
}
/// <summary>
/// Initalize all values for form
/// </summary>
/// <param name="id"></param>
public BudgetTracker(int id)
{
InitializeComponent();
comboBox1.Items.Add("Rent");
comboBox1.Items.Add("Bills");
comboBox1.Items.Add("Food");
comboBox1.Items.Add("Savings");
comboBox1.Items.Add("Miscellaneous");
comboBox1.SelectedItem = "Rent";
manager = new DataManager();
user = new User();
budgetTrack = new BudgetTrack();
Welcome welcome = new Welcome();
user = manager.LoadUserById(id);
Id = id;
budget = new Budget();
budget = manager.LoadBudgetByUserId(Id);
budgetTrack = manager.LoadBudgetTrack(Id);
loadLabels(budget);
loadTextBoxs(budgetTrack);
if (budget.Total != 0)
{
updateBudgetToolStripMenuItem.Enabled = false;
}
List <Items> itemsList = manager.LoadItems(Id);
int size = itemsList.Count;
int i = 0;
while (i < size)
{
listBox1.Items.Add(i + ". " + itemsList[i].Item);
i++;
}
nameLabel.Text = user.Username;
manager.clearItems();
}
/// <summary>
/// Allow user to add items to items Table and update the information in the BudgetTrack Table
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
if (textBoxItem.Text != "")
{
if (comboBox1.SelectedItem.ToString() == "Rent")
{
User user = new User();
user = manager.LoadUserById(Id);
budgetTrack = new BudgetTrack();
budgetTrack = manager.LoadBudgetTrack(Id);
budgetTrack.Total = Convert.ToInt32(labelTotal1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Rent = Convert.ToInt32(labelRent1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Bills = Convert.ToInt32(labelBills1.Text);
budgetTrack.Food = Convert.ToInt32(labelFood1.Text);
budgetTrack.Saving = Convert.ToInt32(labelSavings1.Text);
budgetTrack.Miscellaneous = Convert.ToInt32(labelMiscellaneous1.Text);
manager.saveToDatabase();
}
else if (comboBox1.SelectedItem.ToString() == "Bills")
{
User user = new User();
user = manager.LoadUserById(Id);
budgetTrack = new BudgetTrack();
budgetTrack = manager.LoadBudgetTrack(Id);
budgetTrack.Total = Convert.ToInt32(labelTotal1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Rent = Convert.ToInt32(labelRent1.Text);
budgetTrack.Bills = Convert.ToInt32(labelBills1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Food = Convert.ToInt32(labelFood1.Text);
budgetTrack.Saving = Convert.ToInt32(labelSavings1.Text);
budgetTrack.Miscellaneous = Convert.ToInt32(labelMiscellaneous1.Text);
manager.saveToDatabase();
}
else if (comboBox1.SelectedItem.ToString() == "Food")
{
User user = new User();
user = manager.LoadUserById(Id);
budgetTrack = new BudgetTrack();
budgetTrack = manager.LoadBudgetTrack(Id);
budgetTrack.Total = Convert.ToInt32(labelTotal1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Rent = Convert.ToInt32(labelRent1.Text);
budgetTrack.Bills = Convert.ToInt32(labelBills1.Text);
budgetTrack.Food = Convert.ToInt32(labelFood1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Saving = Convert.ToInt32(labelSavings1.Text);
budgetTrack.Miscellaneous = Convert.ToInt32(labelMiscellaneous1.Text);
manager.saveToDatabase();
}
else if (comboBox1.SelectedItem.ToString() == "Savings")
{
User user = new User();
user = manager.LoadUserById(Id);
budgetTrack = new BudgetTrack();
budgetTrack = manager.LoadBudgetTrack(Id);
budgetTrack.Total = Convert.ToInt32(labelTotal1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Rent = Convert.ToInt32(labelRent1.Text);
budgetTrack.Bills = Convert.ToInt32(labelBills1.Text);
budgetTrack.Food = Convert.ToInt32(labelFood1.Text);
budgetTrack.Saving = Convert.ToInt32(labelSavings1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Miscellaneous = Convert.ToInt32(labelMiscellaneous1.Text);
manager.saveToDatabase();
}
else if (comboBox1.SelectedItem.ToString() == "Miscellaneous")
{
User user = new User();
user = manager.LoadUserById(Id);
budgetTrack = new BudgetTrack();
budgetTrack = manager.LoadBudgetTrack(Id);
budgetTrack.Total = Convert.ToInt32(labelTotal1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
budgetTrack.Rent = Convert.ToInt32(labelRent1.Text);
budgetTrack.Bills = Convert.ToInt32(labelBills1.Text);
budgetTrack.Food = Convert.ToInt32(labelFood1.Text);
budgetTrack.Saving = Convert.ToInt32(labelSavings1.Text);
budgetTrack.Miscellaneous = Convert.ToInt32(labelMiscellaneous1.Text) + Convert.ToInt32(maskedTextBoxAddItem.Text);
manager.saveToDatabase();
}
loadTextBoxs(budgetTrack);
Items item = new Items();
manager.SaveItems(textBoxItem.Text, Id);
manager.saveToDatabase();
manager.clearItems();
}
else
{
MessageBox.Show("Please enter name of Item");
}
List <Items> itemsList = manager.LoadItems(Id);
int size = itemsList.Count;
int i = 0;
listBox1.Items.Clear();
while (i < size)
{
listBox1.Items.Add(i + ". " + itemsList[i].Item);
i++;
}
manager.clearItems();
updateChart();
}
