public static void XoaDSLoaiSP(int lsp)
{
var db = new FashionShopConectionDB();
db.Delete("LoaiSanPham", "idLoai", null, lsp);
}
public static List <NhaSanXuat> DanhSach()
{
var db = new FashionShopConectionDB();
return(db.Query <NhaSanXuat>("SELECT * FROM NhaSanXuat ORDER BY TenNSX").ToList());
}
public static List <SanPham> LoadDSLoaiSP(int lsp)
{
var db = new FashionShopConectionDB();
return(db.Query <SanPham>("SELECT * FROM SanPham Where MaLoai =@0 ORDER BY idSP DESC", lsp).ToList());
}
public static void EditLSP(LoaiSanPham a)
{
var db = new FashionShopConectionDB();
db.Update("LoaiSanPham", "idLoai", a);
}
public static SanPham LoadSanPham(int sp)
{
var db = new FashionShopConectionDB();
return(db.SingleOrDefault <SanPham>("SELECT * FROM SanPham Where idSP=@0", sp));
}
public static void SuaSP(SanPham sp)
{
var db = new FashionShopConectionDB();
db.Update("SanPham", "idSP", sp);
}
public static List <SanPham> DanhSachLoai(int n)
{
var db = new FashionShopConectionDB();
return(db.Query <SanPham>("SELECT * FROM SanPham Where MaLoai =@0 ORDER BY idSP DESC", n).ToList());
}
public static void EditNSX(NhaSanXuat a)
{
var db = new FashionShopConectionDB();
db.Update("NhaSanXuat", "idNSX", a);
}
public static void EditSP(SanPham a)
{
var db = new FashionShopConectionDB();
db.Update("SanPham", "idSP", a);
}
public static void DeleteSP(int a)
{
var db = new FashionShopConectionDB();
db.Delete("SanPham", "idSP", null, a);
}
public static void SaveSP(SanPham a)
{
var db = new FashionShopConectionDB();
db.Insert("SanPham", "idSP", a);
}
public static List <SanPham> DanhSach()
{
var db = new FashionShopConectionDB();
return(db.Query <SanPham>("SELECT * FROM SanPham ORDER BY idSP DESC").ToList());
}
public static ChiTietSanPham LoadSP(int ma)
{
var db = new FashionShopConectionDB();
return(db.SingleOrDefault <ChiTietSanPham>("SELECT * FROM ChiTietSanPham Where idSP=@0", ma));
}
public static NhaSanXuat LoadNSX(int ma)
{
var db = new FashionShopConectionDB();
return(db.SingleOrDefault <NhaSanXuat>("SELECT * FROM NhaSanXuat Where idNSX=@0", ma));
}
public static List <SanPham> DanhSachLoaiLienQuan(int id, int ml)
{
var db = new FashionShopConectionDB();
return(db.Query <SanPham>("SELECT * FROM SanPham Where idSP != @0 and MaLoai =@1 ORDER BY idSP DESC", id, ml).ToList());
}
public static void SaveNSX(NhaSanXuat a)
{
var db = new FashionShopConectionDB();
db.Insert("NhaSanXuat", "idNSX", a);
}
public static List <LoaiSanPham> LoadDSLoaiSP()
{
var db = new FashionShopConectionDB();
return(db.Query <LoaiSanPham>("Select * from LoaiSanPham ORDER BY TenLoai").ToList());
}
public static void DeleteNSX(int a)
{
var db = new FashionShopConectionDB();
db.Delete("NhaSanXuat", "idNSX", null, a);
}
public static LoaiSanPham LoadLoaiSP(int id)
{
var db = new FashionShopConectionDB();
return(db.SingleOrDefault <LoaiSanPham>("SELECT * FROM LoaiSanPham Where idLoai=@0", id));
}
public static void ThemSP(SanPham sp)
{
var db = new FashionShopConectionDB();
db.Insert("SanPham", "idSP", sp);
}
public static void ThemDSLoaiSP(LoaiSanPham lsp)
{
var db = new FashionShopConectionDB();
db.Insert("LoaiSanPham", "idLoai", lsp);
}
public static void XoaSP(int sp)
{
var db = new FashionShopConectionDB();
db.Delete("SanPham", "idSP", null, sp);
}
public static void SuaDSLoaiSP(LoaiSanPham lsp)
{
var db = new FashionShopConectionDB();
db.Update("LoaiSanPham", "idLoai", lsp);
}
public static List <SanPham> LoadTop3SP()
{
var db = new FashionShopConectionDB();
return(db.Query <SanPham>("SELECT Top 3 * FROM SanPham ORDER BY idSP ASC").ToList());
}
public static void SaveLSP(LoaiSanPham a)
{
var db = new FashionShopConectionDB();
db.Insert("LoaiSanPham", "idLoai", a);
}
