public static bool XoaitemGH(string maHoa) { string query = "DELETE GioHang where MaHoa=@mahoa"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@mahoa", maHoa); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static bool XoaGioHang(string tenTK) { string query = "DELETE FROM tblGioHang WHERE TenTaiKhoan=@TenTaiKhoan"; SqlParameter[] parameter = new SqlParameter[1]; parameter[0] = new SqlParameter("@TenTaiKhoan", tenTK); return(DataProvider.ExecuteDeleteQuery(query, parameter) == 1); }
public static bool XoaGH(string maSP) { string query = "DELETE FROM GioHang WHERE MaSP=@maSP"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@maSP", maSP); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static bool XoaSanPham(string maSP) { string query = "update SanPham set TrangThai = 1 where MaSP = @MaSP"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@MaSP", maSP); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
//Xóa tất cả món ăn trong CTHD của 1 HD public static bool XoaTatCaMonAnHD(int maHD) { string query = "DELETE FROM tblCTHDBanHang WHERE MaHD = @MaHD"; SqlParameter[] pars = new SqlParameter[1]; pars[0] = new SqlParameter("@MaHD", maHD); return(DataProvider.ExecuteDeleteQuery(query, pars) > 0); }
public static bool XoaLoaiVideo(string maLoaiVideo) { string query = "UPDATE LoaiVideo SET TrangThai = 0 WHERE MaLoaiVideo = @MaLoaiVideo"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@MaLoaiVideo", maLoaiVideo); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static bool XoaSV(SinhVienDTO sv) { string query = "DELETE FROM ThongTinSV WHERE Ma_SV=@Ma_SV"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@Ma_SV", sv.Ma_SV); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static bool LamMoiDanhSach(SinhVienDTO sv) { string query = "DELETE FROM ThongTinSV WHERE MaLop=@MaLop"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@MaLop", sv.Ma_Lop); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static bool XoaCTSP(string masp) { string query = "DELETE FROM SizeGiay WHERE ID=@ID"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID", masp); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static int XoaSP(string masp) { string query = "UPDATE SanPham SET TrangThai=0 WHERE MaSP=@ma"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("ma", masp); return(DataProvider.ExecuteDeleteQuery(query, param)); }
public static bool XoaLop(LopHocDTO lh) { string query = "DELETE FROM LopHoc WHERE Ma_Lop=@Ma_Lop AND SoSinhVien = 0"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@Ma_Lop", lh.Ma_Lop); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static Boolean Delete(String tenTaiKhoan, String maSP) { String query = "DELETE FROM GioHang WHERE TenTaiKhoan = @TenTaiKhoan AND MaSP = @MaSP"; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@TenTaiKhoan", tenTaiKhoan); param[1] = new SqlParameter("@MaSP", maSP); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
//public static int soluongSP(string tenTK) //{ // string query = "select count(*) from GioHang where TenTaiKhoan = @TenTaiKhoan"; // SqlParameter[] param = new SqlParameter[1]; // param[0] = new SqlParameter("@TenTaiKhoan", tenTK); // return Convert.ToInt32(DataProvider.ExecuteSelectQuery(query, param).Rows[0][0]); //} public static bool xoagh(string tentk) { string query = "delete GioHang where TenTaiKhoan = @TenTaiKhoan"; SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@TenTaiKhoan", tentk); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static bool xoasp(string tentk, string masp) { string query = "delete GioHang where TenTaiKhoan = @TenTaiKhoan and MaSP = @MaSP"; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@TenTaiKhoan", tentk); param[1] = new SqlParameter("@MaSP", masp); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
public static Boolean Delete(String maHD, String maSP) { String query = "DELETE FROM CTHoaDon WHERE MaHD = @MaHD AND MaSP = @MaSP"; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@MaHD", maHD); param[1] = new SqlParameter("@MaSP", maSP); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }
//Xóa 1 món ăn trong CTHD public static bool XoaMonAn(int maHD, string maMon) { string query = "DELETE FROM tblCTHDBanHang WHERE MaHD = @MaHD AND MaMon = @MaMon"; SqlParameter[] pars = new SqlParameter[2]; pars[0] = new SqlParameter("@MaHD", maHD); pars[1] = new SqlParameter("@MaMon", maMon); return(DataProvider.ExecuteDeleteQuery(query, pars) == 1); }
public static bool XoaSP(clsGioHangDTO gioHangDTO) { string query = "DELETE FROM tblGioHang WHERE TenTaiKhoan=@TenTaiKhoan AND MaSP=@MaSP"; SqlParameter[] parameter = new SqlParameter[2]; parameter[0] = new SqlParameter("@TenTaiKhoan", gioHangDTO.TenTaiKhoan); parameter[1] = new SqlParameter("@MaSP", gioHangDTO.MaSP); return(DataProvider.ExecuteDeleteQuery(query, parameter) == 1); }
public static bool XoaCTHDNhap(int maHDNhap, string maNL) { string query = "DELETE FROM tblCTHDNhap WHERE MaHDNhap = @MaHDNhap AND MaNL = @MaNL"; SqlParameter[] pars = new SqlParameter[2]; pars[0] = new SqlParameter("@MaHDNhap", maHDNhap); pars[1] = new SqlParameter("@MaNL", maNL); return(DataProvider.ExecuteDeleteQuery(query, pars) == 1); }
public static int XoaLoaiSP(string malsp) { string query = "UPDATE LoaiSanPham SET TrangThai=0 WHERE MaLoaiSP=@malsp"; SqlParameter[] param = new SqlParameter[1] { new SqlParameter("malsp", malsp) }; return(DataProvider.ExecuteDeleteQuery(query, param)); }
public static bool XoaGH(GioHangDTO gh) { string query = "DELETE FROM GIOHANG WHERE TenTaiKhoan = @TenTaiKhoan AND MaSP = @MaSP "; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@TenTaiKhoan", gh.TenTaiKhoan); param[1] = new SqlParameter("@MaSP", gh.MaSP); return(DataProvider.ExecuteDeleteQuery(query, param) == 1); }