public void doimk(Entity_NguoiDung et)
{
cn.ThucthiSQL(@"update tblNguoiDung set MatKhau=N'" + et.MatKhau + "' where TaiKhoan=N'" + et.TaiKhoan + "' and MaXacNhan=N'" + et.MaXacNhan + "'");
}
public void suadulieu(Entity_NguoiDung et)
{
cn.ThucthiSQL(@"UPDATE tblNguoiDung SET TenNguoiDung=N'" + et.TenNguoiDung + "',LoaiNguoiDung=N'" + et.LoaiNguoiDung + "',MatKhau =N'" + et.MatKhau + "' where TaiKhoan=N'" + et.TaiKhoan + "' and MaXacNhan=N'" + et.MaXacNhan + "'");
}
public void xoadulieu(Entity_NguoiDung et)
{
cn.ThucthiSQL(@"DELETE from tblNguoiDung where TaiKhoan=N'" + et.TaiKhoan + "'");
}
public void themdulieu(Entity_NguoiDung et)
{
cn.ThucthiSQL(@"INSERT INTO tblNguoiDung (TaiKhoan,TenNguoiDung, MatKhau, LoaiNguoiDung, MaXacNhan) VALUES (N'" + et.TaiKhoan + "',N'" + et.TenNguoiDung + "',N'" + et.MatKhau + "',N'" + et.LoaiNguoiDung + "',N'" + et.MaXacNhan + "')");
}