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