void ganDuLieu(NhanVienObjTH Obj)
{
Obj.manv = txt_manv.Text.Trim();;
Obj.tennv = txt_tennv.Text.Trim();
Obj.ngaysinh = dt_ngaysinh.Text.Trim();
Obj.diachi = txt_diachi.Text.Trim();
Obj.gioitinh = cb_gioitinh.Text.Trim();
Obj.sdt = txt_sdt.Text.Trim();
}
public bool AddData(NhanVienObjTH Obj)
{
cmd.CommandText = " insert into NhanVien (MaNV,TenNV,NgaySinh,GioiTinh,DiaChi,SDT) values('" + Obj.manv + "',N'" + Obj.tennv + "',convert(date,'" + Obj.ngaysinh + "'),N'" + Obj.gioitinh + "',N'" + Obj.diachi + "','" + Obj.sdt + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool UpDate(NhanVienObjTH Obj)
{
cmd.CommandText = " update NhanVien set TenNV = N'" + Obj.tennv + "' , NgaySinh = '" + Obj.ngaysinh + "' , GioiTinh = '" + Obj.gioitinh + "' , DiaChi = N'" + Obj.diachi + "' , SDT = '" + Obj.sdt + "' where MaNV = '" + Obj.manv + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public bool upData(NhanVienObjTH nvObj)
{
return(nvMod.UpDate(nvObj));
}
public bool addData(NhanVienObjTH nvObj)
{
return(nvMod.AddData(nvObj));
}
