public void UpdateShopItem(entites.ShopItem item)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
var current = db.ShopItems.Where(x => x.Id == item.Id).FirstOrDefault();
current.Title = item.Title;
current.Price = (decimal)item.Price;
current.ImageURL = item.ImageURL;
current.InStock = item.InStock;
current.Description = item.Description;
db.SaveChanges();
}
}
public void AddShopItem(entites.ShopItem item)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
ShopItem adding = new ShopItem();
adding.Id = Guid.NewGuid();
adding.Title = item.Title;
adding.Description = item.Description;
adding.ImageURL = item.ImageURL;
adding.Price = (decimal)item.Price;
adding.InStock = item.InStock;
db.ShopItems.Add(adding);
db.SaveChanges();
}
}
public entites.ShopItem FindShopItem(Guid id)
{
using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities())
{
entites.ShopItem item = db.ShopItems.Where(x => x.Id == id).Select(x => new entites.ShopItem {
Id = x.Id,
Title = x.Title,
Description = x.Description,
ImageURL = x.ImageURL,
Price = (double)x.Price,
InStock = x.InStock.Value
}).FirstOrDefault();
return(item);
}
}
