public void UpdateQuantity(int id, int quantity) { db_1525596_co5027Entities db = new db_1525596_co5027Entities(); BootCart cart = db.BootCarts.Find(id); cart.Price = quantity; db.SaveChanges(); }
public void MarkBootsAsPaid(List <BootCart> carts) { db_1525596_co5027Entities db = new db_1525596_co5027Entities(); if (carts != null) { foreach (BootCart cart in carts) { BootCart PreviousCart = db.BootCarts.Find(cart.ID); PreviousCart.DateBought = DateTime.Now; PreviousCart.InsideCart = false; } db.SaveChanges(); } }
public string InsertCart(BootCart cart) { try { db_1525596_co5027Entities db = new db_1525596_co5027Entities(); db.BootCarts.Add(cart); db.SaveChanges(); return(cart.DateBought + " Inserted Successfull"); } catch (Exception e) { return("Error:" + e); } }
public string DeleteCart(int id) { try { db_1525596_co5027Entities db = new db_1525596_co5027Entities(); BootCart cart = db.BootCarts.Find(id); db.BootCarts.Attach(cart); db.BootCarts.Remove(cart); db.SaveChanges(); return(cart.DateBought + "Deleted Successfull"); } catch (Exception e) { return("Error:" + e); } }
public string UpdateCart(int id, BootCart cart) { try { db_1525596_co5027Entities db = new db_1525596_co5027Entities(); //get the info from the db BootCart p = db.BootCarts.Find(id); p.DateBought = cart.DateBought; p.CustomerID = cart.CustomerID; p.Price = cart.Price; p.InsideCart = cart.InsideCart; p.ProductID = cart.ProductID; db.SaveChanges(); return(cart.DateBought + " Updated Successfull"); } catch (Exception e) { return("Error:" + e); } }