public static void InsertSpecification(Specification spe) { using (var db = new ShopSmartPhoneConnectionDB()) { db.Insert(spe); } }
public static IEnumerable <Product> ListOfManufacturer(int id) { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.Query <Product>("SELECT * FROM Product WHERE ManufacturerID = @0 and Status = True", id)); } }
public static void Insert(Product sp) { using (var db = new ShopSmartPhoneConnectionDB()) { db.Insert(sp); } }
public static Page <Product> getListProductFollowManu(int pageNumber, int itemPerPage, int id) { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.Page <Product>(pageNumber, itemPerPage, "SELECT * FROM Product WHERE ManufacturerID = @0", id)); } }
public static Product GetProduct(int id) { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.SingleOrDefault <Product>("SELECT * FROM Product WHERE ID=@0 AND Status = 1", id)); } }
public static IEnumerable <MoreImage> getListImage(int id) { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.Query <MoreImage>("SELECT * FROM MoreImage WHERE Product_ID = @0", id)); } }
public static void UpdateSpecification(Specification spec) { using (var db = new ShopSmartPhoneConnectionDB()) { db.Update(spec); } }
public static void UpdateImage(String filename, int imageID) { using (var db = new ShopSmartPhoneConnectionDB()) { db.Update <MoreImage>("SET ImageName = @0 WHERE Image_ID = @1", filename, imageID); } }
public static IEnumerable <Categogy> getListManufacturer() { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.Query <Categogy>("SELECT * FROM Manufacturer WHERE Status = 1")); } }
public static DetailProduct getDetailProduct(int id) { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.SingleOrDefault <DetailProduct>("Select sp.*, l.CategogyName, h.ManufacturerName from Product sp, Categogy l, Manufacturer h WHERE sp.CategogyID = l.ID and sp.ManufacturerID = h.ID and sp.Status = 1 and sp.ID = @0", id)); } }
public static IEnumerable <Categogy> getListCategogy() { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.Query <Categogy>("SELECT * FROM Categogy")); } }
public static IEnumerable <Manufacturer> getListManufacturer() { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.Query <Manufacturer>("SELECT * FROM Manufacturer")); } }
public static void UpdateNoImage(int id, Product sp) { using (var db = new ShopSmartPhoneConnectionDB()) { db.Update <Product>("SET ProductName=@0, Price=@1, CategogyID=@2, ManufacturerID=@3, Description=@4, Specifications=@5, Warranty=@6, Accessories=@7, Evaluate=@8 WHERE ID=@9", sp.ProductName, sp.Price, sp.CategogyID, sp.ManufacturerID, sp.Description, sp.Specifications, sp.Warranty, sp.Accessories, sp.Evaluate, id); } }
public static void Delete(int id) { using (var db = new ShopSmartPhoneConnectionDB()) { db.Update <Product>("SET Status = 0 WHERE ID=@0", id); } }
public static Specification GetSpecification(int id) { using (var db = new ShopSmartPhoneConnectionDB()) { return(db.SingleOrDefault <Specification>("SELECT * FROM Specifications WHERE ProductID = @0", id)); } }
public static void InsertImage(MoreImage mi) { using (var db = new ShopSmartPhoneConnectionDB()) { db.Insert(mi); } }
public static int getIDProductNew() { using (var db = new ShopSmartPhoneConnectionDB()) { var query = db.Query <Product>("SELECT * FROM Product ORDER BY ID DESC"); return(query.First().ID); } }
public static Page <Product> getListProductPage(int pageNumber, int itemPerPage) { var db = new ShopSmartPhoneConnectionDB(); return(db.Page <Product>(pageNumber, itemPerPage, "Select * from Product")); }
public static IEnumerable <Product> getListProduct() { var db = new ShopSmartPhoneConnectionDB(); return(db.Query <Product>("Select * from Product")); }
public static IEnumerable <Product> DanhSach() { var db = new ShopSmartPhoneConnectionDB(); return(db.Query <Product>("Select * from Product WHERE Status = 1")); }
public static IEnumerable <Manufacturer> GetListManufacturer() { var db = new ShopSmartPhoneConnectionDB(); return(db.Query <Manufacturer>("SELECT * FROM Manufacturer WHERE Status = 1")); }
public static IEnumerable <Categogy> GetListCategogy() { var db = new ShopSmartPhoneConnectionDB(); return(db.Query <Categogy>("Select * FROM Categogy WHERE Status = 1")); }