private void button7_Click(object sender, EventArgs e) { if (txttim.Text != "") { DOT_nhanvien a = new DOT_nhanvien(0, txttim.Text, null, null, null, txttim.Text, null, null); dgv.DataSource = nv.nhanvien_tim(a); } }
public bool nhanvien_xoa(DOT_nhanvien nv) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_delete_nhanvien", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@manv", nv.manv)); cmd.ExecuteNonQuery(); } return(true); }
private void buttonUpdate_Click(object sender, EventArgs e) { if (field_hoten.Text != "" && field_ngaysinh.Text != " " && field_diachi.Text != " " && field_chucvu.Text != " ") { DOT_nhanvien m = new DOT_nhanvien(Convert.ToInt32(field_id.Text), field_hoten.Text, field_ngaysinh.Text, field_diachi.Text, field_sdt.Text, field_chucvu.Text, field_taikhoan.Text, field_matkhau.Text); nv.nhanvien_sua(m); MessageBox.Show(" Sửa thành công"); dgv.DataSource = nv.Get_nhanvien(); } else { MessageBox.Show("Xin hãy nhập đầy đủ"); } }
private void buttonInsert_Click(object sender, EventArgs e) { if (field_hoten.Text != "" && field_ngaysinh.Text != " " && field_diachi.Text != " " && field_chucvu.Text != " ") { DOT_nhanvien m = new DOT_nhanvien(0, field_hoten.Text, field_ngaysinh.Text, field_diachi.Text, field_sdt.Text, field_chucvu.Text, field_taikhoan.Text, field_matkhau.Text); Convert.ToString(nv.nhanvien_them(m)); MessageBox.Show("Thêm thành công"); dgv.DataSource = nv.Get_nhanvien(); } else { MessageBox.Show("Xin hãy nhập đầy đủ"); } }
public DataTable nhanvien_tim(DOT_nhanvien nv) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("nhanvien_tim", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@tennv", nv.tennv)); cmd.Parameters.Add(new SqlParameter("@chucvu", nv.chucvu)); cmd.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } }
public int nhanvien_them(DOT_nhanvien nv) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_insert_nhanvien", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@tennv", nv.tennv)); cmd.Parameters.Add(new SqlParameter("@ngaysinh", nv.ngaysinh)); cmd.Parameters.Add(new SqlParameter("@diachi", nv.diachi)); cmd.Parameters.Add(new SqlParameter("@taikhoan", nv.taikhoan)); cmd.Parameters.Add(new SqlParameter("@matkhau", nv.matkhau)); cmd.Parameters.Add(new SqlParameter("@chucvu", nv.chucvu)); cmd.Parameters.Add(new SqlParameter("@sdt", nv.sdt)); return(Convert.ToInt32(cmd.ExecuteScalar())); } }
public bool nhanvien_sua(DOT_nhanvien nv) { using (SqlConnection conn = getConnect()) { SqlCommand cmd = new SqlCommand("sp_update_nhanvien", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@manv", nv.manv)); cmd.Parameters.Add(new SqlParameter("@tennv", nv.tennv)); cmd.Parameters.Add(new SqlParameter("@ngaysinh", nv.ngaysinh)); cmd.Parameters.Add(new SqlParameter("@diachi", nv.diachi)); cmd.Parameters.Add(new SqlParameter("@taikhoan", nv.taikhoan)); cmd.Parameters.Add(new SqlParameter("@matkhau", nv.matkhau)); cmd.Parameters.Add(new SqlParameter("@chucvu", nv.chucvu)); cmd.Parameters.Add(new SqlParameter("@sdt", nv.sdt)); cmd.ExecuteNonQuery(); } return(true); }
public DataTable nhanvien_tim(DOT_nhanvien nhanvien) { return(ma.nhanvien_tim(nhanvien)); }
public bool nhanvien_xoa(DOT_nhanvien nhanvien) { return(ma.nhanvien_xoa(nhanvien)); }
public int nhanvien_them(DOT_nhanvien nv) { return(ma.nhanvien_them(nv)); }