private void btn_Newemployee_Click(object sender, EventArgs e) { if (txt_employeename.Text == String.Empty) { MessageBox.Show("Enter Name:"); } else if (txt_employeecity.Text == String.Empty) { MessageBox.Show("enter city:"); } else if (txt_employeesalary.Text == String.Empty) { MessageBox.Show("enter salary:"); } else if (txt_employeepassword.Text == String.Empty) { MessageBox.Show("enter password:"******"employee added:id:" + id); } }
private void btn_search_Click(object sender, EventArgs e) { if (txt_enterkey.Text == string.Empty) { MessageBox.Show("enter a key"); } else { EmployeesDAL dal = new EmployeesDAL(); string key = txt_enterkey.Text; List <Employeemodel> list = dal.Searchemployee(key); dg_employees.DataSource = list; } }
private void btn_delete_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txt_enteremployeeid.Text); EmployeesDAL dal = new EmployeesDAL(); bool status = dal.Deleteemployee(id); if (status == true) { MessageBox.Show("employee deleted"); } else { MessageBox.Show("employee not deleted"); } }
private void button1_Click(object sender, EventArgs e) { string id = txt_loginid.Text; string password = txt_password.Text; EmployeesDAL dal = new EmployeesDAL(); bool status = dal.LoginSQLInjection(id, password); if (status == true) { MessageBox.Show("Valid user"); } else { MessageBox.Show("Invalid user"); } }
private void btn_update_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txt_enteremployeeid.Text); string city = txt_employeecity.Text; int salary = Convert.ToInt32(txt_employeesalary.Text); EmployeesDAL dal = new EmployeesDAL(); bool status = dal.Updateemployee(id, city, salary); if (status == true) { MessageBox.Show("employee details updated"); } else { MessageBox.Show("not updated"); } }
private void btn_login_Click(object sender, EventArgs e) { if (txt_loginid.Text == string.Empty) { MessageBox.Show("enter login id:"); } else if (txt_password.Text == String.Empty) { MessageBox.Show("enter password:"******"Valid User"); Frm_Home obj = new Frm_Home(); obj.Show(); } else { MessageBox.Show("Invalid User"); } } catch (System.Data.SqlClient.SqlException exp) { MessageBox.Show("Database error:" + exp.Message); } catch (Exception exp) { MessageBox.Show("wrong input:" + exp.Message); } //finally //{ MessageBox.Show("finally block"); // } } }
private void btn_find_Click(object sender, EventArgs e) { if (txt_enteremployeeid.Text == String.Empty) { MessageBox.Show("enter id:"); } else { int id = Convert.ToInt32(txt_enteremployeeid.Text); EmployeesDAL dal = new EmployeesDAL(); Employeemodel model = dal.Findemployee(id); if (model != null) { txt_employeename.Text = model.employeename; txt_employeecity.Text = model.employeecity; txt_employeesalary.Text = model.employeesalary.ToString(); txt_employeepassword.Text = model.employeepassword; } else { MessageBox.Show("employee not found"); } } }