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