//lay du lieu tu controller
void ganDL(NhanVien_Object dtNV)
{
dtNV.MaNV = txtMaNV.Text.Trim();
dtNV.TenNV = txtTenNV.Text.Trim();
dtNV.Diachi = txtDiaChi.Text.Trim();
dtNV.Ngaysinh = txtNgaySinh.Text.Trim();
dtNV.Gioitinh = txtGioiTinh.Text.Trim();
dtNV.Dienthoai = txtDienThoai.Text.Trim();
dtNV.Matkhau = txtMatKhau.Text.Trim();
}
public bool AddData(NhanVien_Object nvObj)
{
cmd.CommandText = "INSERT INTO nhanvien values ('" + nvObj.MaNV + "', N'" + nvObj.TenNV + "', N '" + nvObj.Diachi + "', CONVERT(DATE,'" + nvObj.Ngaysinh + "',103),'" + nvObj.Gioitinh + "', '" + nvObj.Dienthoai + "', '" + nvObj.Matkhau + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenCon();
cmd.ExecuteNonQuery();
conn.CloseCon();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
conn.CloseCon();
}
return(false);
}
//sua du lieu
public bool UpdateData(NhanVien_Object nvObj)
{
cmd.CommandText = "UPDATE nhanvien SET MaNV= '" + nvObj.MaNV + "',TenNV = N'" + nvObj.TenNV + "',DiaChi= N '" + nvObj.Diachi + "', NgaySinh=CONVERT(DATE,'" + nvObj.Ngaysinh + "',103), GioiTinh= '" + nvObj.Gioitinh + "', DienThoai='" + nvObj.Dienthoai + "', MatKhau='" + nvObj.Matkhau + "' WHERE MaNV='" + nvObj.MaNV + "' ";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn.Connection;
try
{
conn.OpenCon();
cmd.ExecuteNonQuery();
conn.CloseCon();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
conn.CloseCon();
}
return(false);
}
public bool UpdateData(NhanVien_Object nvObj)
{
return(nvMo.UpdateData(nvObj));
}
public bool AddData(NhanVien_Object nvObj)
{
return(nvMo.AddData(nvObj));
}
