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