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);
}
