private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DatabaseConnect db = new DatabaseConnect();
string id = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
string Command = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if (Command.ToLower() == "delete")
{
DialogResult DialogDecision = MessageBox.Show("Are you sure you want to delete the entire row?", "", MessageBoxButtons.YesNo);
if (DialogDecision == DialogResult.Yes)
{
string query = "Delete from expense_tbl where id=" + id;
db.Executequery(query);
string query1 = "Delete from chart_tbl where id=" + id;
db.Executequery(query1);
MessageBox.Show("Expense deleted successfully");
}
else if (DialogDecision == DialogResult.No)
{
MessageBox.Show("Be sure and come next time");
}
}
try
{
string query = "Select * from expense_tbl";
DataTable values = db.data(query);
dataGridView1.DataSource = values;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnsave_Click(object sender, EventArgs e)
{
try
{
expenses ep = new expenses();
ep.title = comboBox1.Text;
ep.money = txtmoney.Text;
ep.date = DateTime.Now;
ep.description = rchdescription.Text;
chart1 cc = new chart1();
cc.title = comboBox1.Text;
cc.total = txtmoney.Text;
if (errorTest.PresenceOfTitle(comboBox1.Text))
{
MessageBox.Show("Sorry need a title of expenses");
return;
}
if (errorTest.PresenceOfmoney(txtmoney.Text))
{
MessageBox.Show("Sorry you need to insert the amount you've spent");
return;
}
String query1 = "Insert into expense_tbl values('" + ep.title + "','" + ep.money + "','" + ep.date + "','" + ep.description + "')";
DatabaseConnect db = new DatabaseConnect();
db.Executequery(query1);
String query2 = "Insert into chart_tbl values('" + cc.title + "','" + cc.total + "')";
DatabaseConnect dt = new DatabaseConnect();
dt.Executequery(query2);
MessageBox.Show(" Expense successfully registered");
comboBox1.Text = "";
txtmoney.Text = "";
rchdescription.Text = "";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnregister_Click(object sender, EventArgs e)
{
try
{
register r = new register();
r.FirstName = txtfirstname.Text;
r.LastName = txtlastname.Text;
r.Username = txtusername.Text;
r.Password = txtpassword.Text;
r.Hint = txthint.Text;
string command = "insert into register_tbl (Firstname,Lastname,Username,Password,Hint) values ('" + r.FirstName + "','" + r.LastName + "'," +
"" + "'" + r.Username + "','" + r.Password + "','" + r.Hint + "')";
DatabaseConnect dc = new DatabaseConnect();
dc.Executequery(command);
MessageBox.Show("Your account has been registered");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}