public bool Add(ClassUser.User user)
{
string query = "INSERT INTO KHACHHANG VALUES ( @MaKH , @TenKH , @GioiTinh , @NgaySinh , @SDT , @Email , @DiaChi )";
object[] para = new object[] { user.MaKH, user.TenKH, user.GioiTinh, user.NgaySinh, user.SDT, user.Email, user.DiaChi };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public bool Edit(ClassUser.User user)
{
string MaKH = user.MaKH;
string query = "UPDATE KHACHHANG SET TenKH = @TenKH , GioiTinh = @GioiTinh , NgaySinh = @NgaySinh , SDT = @SDT , Email = @eEmail , DiaChi = @DiaChi WHERE MaKH = @MaKH ";
object[] para = new object[] { user.TenKH, user.GioiTinh, user.NgaySinh, user.SDT, user.Email, user.DiaChi, user.MaKH };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
