public void Sua_DiemKhachHang(KhachHang_MODEL KH) { string NGAY_SINH = string.Format("{0:MM/dd/yyyy}", KH.NGAY_SINH1); string sql = "UPDATE KHACH_HANG SET DIEM_TICH_LUY='" + KH.DIEM_TICH_LUY1 + "' WHERE MA_KHACH_HANG='" + KH.MA_KHACH_HANG1 + "'"; K.Thao_Tac_Du_Lieu(sql); }
public void Them_KhachHang(KhachHang_MODEL KH) { string NGAY_SINH = string.Format("{0:MM/dd/yyyy}", KH.NGAY_SINH1); string sql = "INSERT INTO KHACH_HANG VALUES('" + KH.MA_KHACH_HANG1 + "',N'" + KH.HO_TEN1 + "',N'" + KH.GIOI_TINH1 + "','" + NGAY_SINH + "','" + KH.SO_DIEN_THOAI1 + "','" + KH.SCMND1 + "','" + KH.DIEM_TICH_LUY1 + "','" + KH.EMAIL1 + "',N'" + KH.DIA_CHI1 + "','" + KH.ANH1 + "')"; K.Thao_Tac_Du_Lieu(sql); }
public void Sua_KhachHang(KhachHang_MODEL KH) { string NGAY_SINH = string.Format("{0:MM/dd/yyyy}", KH.NGAY_SINH1); string sql = "UPDATE KHACH_HANG SET HO_TEN=N'" + KH.HO_TEN1 + "',GIOI_TINH=N'" + KH.GIOI_TINH1 + "',NGAY_SINH='" + NGAY_SINH + "',SO_DIEN_THOAI='" + KH.SO_DIEN_THOAI1 + "',SCMND='" + KH.SCMND1 + "',DIEM_TICH_LUY='" + KH.DIEM_TICH_LUY1 + "',EMAIL='" + KH.EMAIL1 + "',DIA_CHI=N'" + KH.DIA_CHI1 + "',ANH='" + KH.ANH1 + "'WHERE MA_KHACH_HANG='" + KH.MA_KHACH_HANG1 + "'"; K.Thao_Tac_Du_Lieu(sql); }
public void Xoa_KhachHang(KhachHang_MODEL KH) { string sql = "DELETE FROM KHACH_HANG WHERE MA_KHACH_HANG='" + KH.MA_KHACH_HANG1 + "'"; K.Thao_Tac_Du_Lieu(sql); }