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