public string InsertCart(GVGCart cart) { try { db_1430683_co5027_productEntities db = new db_1430683_co5027_productEntities(); db.GVGCarts.Add(cart); db.SaveChanges(); return(cart.DatePurchased + "was successfully inserted"); } catch (Exception e) { return("Error:" + e); } }
public string DeleteGVGCart(int id) { try { db_1430683_co5027_productEntities db = new db_1430683_co5027_productEntities(); GVGCart GVGCart = db.GVGCarts.Find(id); db.GVGCarts.Attach(GVGCart); db.GVGCarts.Remove(GVGCart); db.SaveChanges(); return(GVGCart.DatePurchased + "was successfully deleted"); } catch (Exception e) { return("Error:" + e); } }
public string UpdateCart(int id, GVGCart GVGCart) { try { db_1430683_co5027_productEntities db = new db_1430683_co5027_productEntities(); //Retrieve from database GVGCart p = db.GVGCarts.Find(id); p.DatePurchased = GVGCart.DatePurchased; p.CustomerId = GVGCart.CustomerId; p.AmountCost = GVGCart.AmountCost; p.ItemsInCart = GVGCart.ItemsInCart; p.GpuID = GVGCart.GpuID; db.SaveChanges(); return(GVGCart.DatePurchased + "was successfully updated"); } catch (Exception e) { return("Error:" + e); } }