private void button1_Click(object sender, EventArgs e) { //Add Expense button if (Owners.Text == "" || Amount.Text == "" || Reason.Text == "") { MessageBox.Show("Please enter all fields."); return; } string amount = Amount.Text; int result; Int32.TryParse(amount, out result); if (!(Int32.TryParse(amount, out result))) { MessageBox.Show("Please enter a numerical amount in the Amount field."); return; } if (Leases.Text != "") { int query_result = contobj.AddExpense(Convert.ToInt32(Owners.SelectedValue), Convert.ToInt32(amount), date.Value, Reason.Text, Convert.ToInt32(Leases.Text)); if (query_result == 1) { contobj.TakeExpenseFromDeposit(Convert.ToInt32(amount), int.Parse(Leases.Text.ToString())); MessageBox.Show("Expense created successfully."); } else { MessageBox.Show("Expense not added."); } } else { int query_result = contobj.AddExpense1(Convert.ToInt32(Owners.Text), Convert.ToInt32(amount), date.Value, Reason.Text); if (query_result == 1) { MessageBox.Show("Expense created successfully."); contobj.TakeExpenseFromOwner(Convert.ToInt32(amount), int.Parse(Owners.SelectedValue.ToString())); } else { MessageBox.Show("Expense not added."); } } ExpenseID.DataSource = contobj.GetAllExpenses(); ExpenseID.ValueMember = "Expense_TranID"; ExpenseID.DisplayMember = "Expense_TranID"; ExpenseView.DataSource = contobj.ShowAllExpenses(); ExpenseView.Columns[0].HeaderText = "ID"; ExpenseView.Columns[1].HeaderText = "Amount"; ExpenseView.Columns[2].HeaderText = "Date"; ExpenseView.Columns[3].HeaderText = "Reason"; ExpenseView.Columns[4].HeaderText = "LeaseID"; ExpenseView.Columns[5].HeaderText = "OwnerID"; ExpenseView.Refresh(); }
private void ViewAllOwners_Click(object sender, EventArgs e) { ExpenseView.DataSource = contobj.ShowAllExpenses(); ExpenseView.Columns[0].HeaderText = "ID"; ExpenseView.Columns[1].HeaderText = "Amount"; ExpenseView.Columns[2].HeaderText = "Date"; ExpenseView.Columns[3].HeaderText = "Reason"; ExpenseView.Columns[4].HeaderText = "LeaseID"; ExpenseView.Columns[5].HeaderText = "OwnerID"; ExpenseView.Refresh(); }
private void UpdateExpense_Click(object sender, EventArgs e) { if (Owners.Text == "" || Amount.Text == "" || Reason.Text == "") { MessageBox.Show("Please enter all fields."); return; } string amount = Amount.Text; int result; Int32.TryParse(amount, out result); if (!(Int32.TryParse(amount, out result))) { MessageBox.Show("Please enter a numerical amount in the Amount field."); return; } if (Leases.Text != "") { int query_result = contobj.UpdateExpense(Convert.ToInt32(ExpenseID.SelectedValue), Convert.ToInt32(Owners.Text), Convert.ToInt32(amount), date.Value, Reason.Text, Convert.ToInt32(Leases.Text)); if (query_result == 1) { MessageBox.Show("Expense updated successfully."); } else { MessageBox.Show("Expense not updated."); } } else { int query_result = contobj.UpdateExpense1(Convert.ToInt32(ExpenseID.SelectedValue), Convert.ToInt32(Owners.Text), Convert.ToInt32(amount), date.Value.Date, Reason.Text); if (query_result == 1) { MessageBox.Show("Expense updated successfully."); } else { MessageBox.Show("Expense not updated."); } } ExpenseView.DataSource = contobj.ShowAllExpenses(); ExpenseView.Columns[0].HeaderText = "ID"; ExpenseView.Columns[1].HeaderText = "Amount"; ExpenseView.Columns[2].HeaderText = "Date"; ExpenseView.Columns[3].HeaderText = "Reason"; ExpenseView.Columns[4].HeaderText = "LeaseID"; ExpenseView.Columns[5].HeaderText = "OwnerID"; ExpenseView.Refresh(); }
private void DeleteExpense_Click(object sender, EventArgs e) { if (contobj.DeleteExpense(Convert.ToInt16(ExpenseID.Text)) == 1) { MessageBox.Show("Expense deleted"); } else { MessageBox.Show("Expense not deleted."); } ExpenseID.DataSource = contobj.GetAllExpenses(); ExpenseID.ValueMember = "Expense_TranID"; ExpenseID.DisplayMember = "Expense_TranID"; ExpenseView.DataSource = contobj.ShowAllExpenses(); ExpenseView.Columns[0].HeaderText = "ID"; ExpenseView.Columns[1].HeaderText = "Amount"; ExpenseView.Columns[2].HeaderText = "Date"; ExpenseView.Columns[3].HeaderText = "Reason"; ExpenseView.Columns[4].HeaderText = "LeaseID"; ExpenseView.Columns[5].HeaderText = "OwnerID"; ExpenseView.Refresh(); }