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 InsertProduct(Product product) { try { db_1430683_co5027_productEntities db = new db_1430683_co5027_productEntities(); db.Products.Add(product); db.SaveChanges(); return(product.GpuName + "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 DeleteProduct(int id) { try { db_1430683_co5027_productEntities db = new db_1430683_co5027_productEntities(); Product product = db.Products.Find(id); db.Products.Attach(product); db.Products.Remove(product); db.SaveChanges(); return(product.GpuName + "was successfully deleted"); } catch (Exception e) { return("Error:" + e); } }
public string Updateproductspec(int id, ProductSpec productspec) { try { db_1430683_co5027_productEntities db = new db_1430683_co5027_productEntities(); //Retrieve from database ProductSpec p = db.ProductSpecs.Find(id); p.GpuId = productspec.GpuId; db.SaveChanges(); return(productspec.GpuId + "was successfully updated"); } 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); } }
public string UpdateProduct(int id, Product product) { try { db_1430683_co5027_productEntities db = new db_1430683_co5027_productEntities(); //Retrieve from database Product p = db.Products.Find(id); p.GpuName = product.GpuName; p.Price = product.Price; p.GpuId = product.GpuId; p.Descriptionofgpu = product.Descriptionofgpu; p.Image = product.Image; db.SaveChanges(); return(product.GpuName + "was successfully updated"); } catch (Exception e) { return("Error:" + e); } }