public static void Delete(int ItemID)
{
var cs = ConfigurationManager.AppSettings["ShopDB"];
using (var ItemDC = new ItemDataContext(cs))
{
var ItemToDelete = (from i in ItemDC.Items
where i.id == ItemID
select i).First();
ItemDC.Items.DeleteOnSubmit(ItemToDelete);
ItemDC.SubmitChanges();
}
}
public static void Update(Item UpdatedItem)
{
var cs = ConfigurationManager.AppSettings["ShopDB"];
using (var ItemDC = new ItemDataContext(cs))
{
Item OldItem = (from i in ItemDC.Items
where i.id == UpdatedItem.id
select i).First();
//OldItem = UpdatedItem;
OldItem.name = UpdatedItem.name;
OldItem.description = UpdatedItem.description;
OldItem.price = UpdatedItem.price;
OldItem.image = UpdatedItem.image;
ItemDC.SubmitChanges();
}
}
