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();
}
