public static void Delete(int id)
{
using (var db = new ShopSmartPhoneConnectionDB())
{
db.Update <Product>("SET Status = 0 WHERE ID=@0", id);
}
}
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 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 UpdateSpecification(Specification spec)
{
using (var db = new ShopSmartPhoneConnectionDB())
{
db.Update(spec);
}
}