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