public async Task <ActionResult <ExpenseView> > PostExpenseView(ExpenseView expenseView)
{
_context.ExpenseView.Add(expenseView);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetExpenseView", new { id = expenseView.ExpenseId }, expenseView));
}
public async Task <IActionResult> PutExpenseView(int id, ExpenseView expenseView)
{
if (id != expenseView.ExpenseId)
{
return(BadRequest());
}
_context.Entry(expenseView).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ExpenseViewExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
/// <summary>
/// Handles navigating to the <see cref="Views.ExpenseEdit"/>
/// </summary>
/// <param name="sender">The sender object</param>
/// <param name="e">Event arguments</param>
public static void EditButtonClicked(object sender, EventArgs e)
{
if (ExpenseEdit == null)
{
ExpenseEdit = new ExpenseEdit();
ExpenseEdit.FormClosed += ExpenseEditViewOnFormClosed;
}
var selectedListItems = ExpenseView.ExpenseListView.SelectedItems;
if (selectedListItems.Count > 0)
{
var selectedItem = selectedListItems[0];
var expenseId = Guid.Parse(selectedItem.SubItems[0].Text);
var expense = ListAccessHelper.FindExpense(expenseId);
EditExpense = expense;
}
else
{
EditExpense = null;
}
ExpenseEdit.Show(ExpenseView);
ExpenseView.Hide();
}
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();
}
/// <summary>
/// Handles navigating to <see cref="Views.ExpenseAdd"/>
/// </summary>
/// <param name="sender">The sender object</param>
/// <param name="e">Event arguments</param>
public static void AddButtonClicked(object sender, EventArgs e)
{
if (ExpenseAdd == null)
{
ExpenseAdd = new ExpenseAdd();
ExpenseAdd.FormClosed += ExpenseAddViewOnFormClosed;
}
ExpenseAdd.Show(ExpenseView);
ExpenseView.Hide();
}
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();
}
public Window4()
{
InitializeComponent();
DataContext = new ExpenseView(bd, this);
}
/// <summary>
/// Handles backward navigation
/// </summary>
/// <param name="sender">The sender object</param>
/// <param name="e">Event arguments</param>
public static void ViewBackButton(object sender, EventArgs e)
{
ExpenseView.Owner.Show();
ExpenseView.Close();
}
/// <summary>
/// Handles the <see cref="Views.ExpenseAdd"/> form being closed
/// </summary>
/// <param name="sender">The sender argument</param>
/// <param name="e">Event arguments</param>
private static void ExpenseAddViewOnFormClosed(object sender, FormClosedEventArgs e)
{
ExpenseAdd = null;
ExpenseView.Show();
}
