private void RmvBtn_Click(object sender, EventArgs e) { try { if (dataGridView1.SelectedRows.Count != 0) { DialogResult result = MessageBox.Show("Do You Want to Delete?", "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result.Equals(DialogResult.OK)) { DataGridViewRow row = this.dataGridView1.SelectedRows[0]; string id = row.Cells["id"].Value.ToString(); ExpenseDao d = new ExpenseDao(); d.delete(id); showlist(); MessageBox.Show("Deleted"); Expense_Load(sender, e); } else { ///leave } } else { MessageBox.Show("Select the row you want to delete"); Expense_Load(sender, e); } } catch (SqlException error) { MessageBox.Show(error.Message.ToString()); } }
private void AUbtn_Click(object sender, EventArgs e) { if (AUbtn.Text == "Edit") { if (Nametxt.Text.Equals("") || Amounttext.Text.Equals("") || DateText.Text.Equals("")) { MessageBox.Show("Required Fields are empty"); } else { ExpenseDao Exp = new ExpenseDao(); String ID = idtext.Text; String name = Nametxt.Text; String amount = Amounttext.Text; String date = DateText.Text; Exp.Update(ID, name, amount, date); MessageBox.Show("Edited!"); Expense_Load(sender, e); } } if (AUbtn.Text == "Add") { if (Nametxt.Text.Equals("") || Amounttext.Text.Equals("") || DateText.Text.Equals("")) { MessageBox.Show("Required Fields are empty"); } else { ExpenseDao Exp = new ExpenseDao(); String name = Nametxt.Text; String amount = Amounttext.Text; String date = DateText.Text; Exp.insert(name, amount, date); AddBtn.Enabled = true; EditBtn.Enabled = true; MessageBox.Show("Added!"); Expense_Load(sender, e); } } }
public ExpenseManagerImpl(ExpenseManager expenseManager) { dao = ExpenseDao.getInstance(); this.expenseManager = expenseManager; }
public ExpenseManagerImpl() { dao = ExpenseDao.getInstance(); }