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); } }
public int AddEmployee(Employeemodel model) { SqlCommand com_add_employee = new SqlCommand("proc_addemployee", con); com_add_employee.Parameters.AddWithValue("@name", model.employeename); com_add_employee.Parameters.AddWithValue("@city", model.employeecity); com_add_employee.Parameters.AddWithValue("@salary", model.employeesalary); com_add_employee.Parameters.AddWithValue("@password", model.employeepassword); com_add_employee.CommandType = CommandType.StoredProcedure; SqlParameter para_return = new SqlParameter(); para_return.Direction = ParameterDirection.ReturnValue; com_add_employee.Parameters.Add(para_return); con.Open(); com_add_employee.ExecuteNonQuery();//exec proc con.Close(); int id = Convert.ToInt32(para_return.Value); return(id); }
public List <Employeemodel> Searchemployee(string key) { SqlCommand com_search = new SqlCommand("proc_searchemployee", con); com_search.Parameters.AddWithValue("@key", key); com_search.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader dr = com_search.ExecuteReader(); List <Employeemodel> list = new List <Employeemodel>(); while (dr.Read()) { Employeemodel model = new Employeemodel(); model.employeeid = dr.GetInt32(0); model.employeename = dr.GetString(1); model.employeecity = dr.GetString(2); model.employeesalary = dr.GetInt32(3); model.employeepassword = dr.GetString(4); list.Add(model); } con.Close(); return(list); }
public Employeemodel Findemployee(int id) { SqlCommand com_find = new SqlCommand("proc_findemployee", con); com_find.Parameters.AddWithValue("@id", id); com_find.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader dr = com_find.ExecuteReader(); if (dr.Read()) { Employeemodel model = new Employeemodel(); model.employeeid = dr.GetInt32(0); model.employeename = dr.GetString(1); model.employeecity = dr.GetString(2); model.employeesalary = dr.GetInt32(3); model.employeepassword = dr.GetString(4); con.Close(); return(model); } con.Close(); return(null); }
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"); } } }