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 IEnumerable <MoreImage> getListImage(int id)
{
using (var db = new ShopSmartPhoneConnectionDB())
{
return(db.Query <MoreImage>("SELECT * FROM MoreImage WHERE Product_ID = @0", id));
}
}
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 IEnumerable <Categogy> getListManufacturer()
{
using (var db = new ShopSmartPhoneConnectionDB())
{
return(db.Query <Categogy>("SELECT * FROM Manufacturer WHERE Status = 1"));
}
}
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 IEnumerable <Product> getListProduct()
{
var db = new ShopSmartPhoneConnectionDB();
return(db.Query <Product>("Select * from Product"));
}
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"));
}
public static IEnumerable <Product> DanhSach()
{
var db = new ShopSmartPhoneConnectionDB();
return(db.Query <Product>("Select * from Product WHERE Status = 1"));
}
