private void LoadStart()
{
try
{
string query = "Select * from expense_tbl";
DatabaseConnect db = new DatabaseConnect();
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);
}
}
public static bool CheckDuplicateUsername(string Username)
{
try
{
string query = "select * from register_tbl where Username='******'";
DatabaseConnect dc = new DatabaseConnect();
DataTable deuser = dc.data(query);
if (deuser.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnsearch_Click(object sender, EventArgs e)
{
try
{
if (txtsearch.Text == null)
{
MessageBox.Show("Enter a word to search Thank You!!!");
}
else
{
string query = "Select * from expense_tbl where title like'" + txtsearch.Text + "%'or description like'" + txtsearch.Text + "%' ";
DatabaseConnect db = new DatabaseConnect();
DataTable dt = db.data(query);
dataGridView1.DataSource = dt;
txtsearch.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}