public void InsertUserInformation(UserInformation info) { var context = new GarageEntities(); context.UserInformation.AddOrUpdate(info); context.SaveChanges(); }
public void InsertUserDetail(UserDetail userDetail) { GarageEntities db = new GarageEntities(); db.UserDetails.Add(userDetail); db.SaveChanges(); }
public void InsertUserInformation(UserInformation info) { GarageEntities db = new GarageEntities(); db.UserInformations.Add(info); db.SaveChanges(); }
public UserInformation GetUserInformation(string guID) { GarageEntities context = new GarageEntities(); var userInfo = context.UserInformation.FirstOrDefault(i => i.GUID.Equals(guID)); return(userInfo); }
public IList <Purchase> GetOrdersInCart(string userID) { var context = new GarageEntities(); var orders = context.Purchase.Where(p => p.UserId.Equals(userID) && p.IsInCart).ToList(); return(orders); }
public void UpdateQuantity(int id, int quantity) { GarageEntities db = new GarageEntities(); Cart p = db.Carts.Find(id); p.Amount = quantity; db.SaveChanges(); }
public void UpdateQuantity(int id, int quantity) { GarageEntities db = new GarageEntities(); // Connection to the DB Cart cart = db.Carts.Find(id); cart.Amount = quantity; db.SaveChanges(); }
public UserDetail GetUserInformation(string guId) { GarageEntities db = new GarageEntities(); var info = (from x in db.UserDetails where x.Guid == guId select x).FirstOrDefault(); return(info); }
public UserInformation GetUserInformation(string guId) { GarageEntities db = new GarageEntities(); UserInformation info = (from x in db.UserInformations where x.GUID == guId select x).FirstOrDefault(); return(info); }
public void UpdateQuantity(int id, int quantity) { var context = new GarageEntities(); var cart = context.Purchase.Find(id); cart.Amount = quantity; context.SaveChanges(); }
public List<Cart> GetOrdersInCart(string clientId) { GarageEntities db = new GarageEntities(); List<Cart> orders = (from x in db.Carts where x.ClientID == clientId && x.IsInCart orderby x.DatePurchased descending select x).ToList(); return orders; }
public List <Cart> GetOrdersInCart(string clientId) { GarageEntities db = new GarageEntities(); List <Cart> orders = (from x in db.Carts where x.ClientID == clientId && x.IsInCart orderby x.DatePurchased descending select x).ToList(); return(orders); }
public List <Cart> GetOrdersInCart(string userId) { GarageEntities db = new GarageEntities(); // Connection to the DB // A list of not paid items in the cart of the current user List <Cart> orders = (from x in db.Carts where x.ClientID == userId && x.IsInCart // Not paid yet orderby x.DatePurchased select x).ToList(); return(orders); }
public void MarkOrderAsPaid(IList <Purchase> carts) { var context = new GarageEntities(); foreach (var cart in carts) { var oldCart = context.Purchase.Find(cart.ID); oldCart.Date = DateTime.Now; oldCart.IsInCart = false; } context.SaveChanges(); }
public int GetAmountOfOrders(string userId) { try { var context = new GarageEntities(); return(context.Purchase.Where(p => p.UserId.Equals(userId) && p.IsInCart).Select(p => p.Amount) .Sum()); } catch (Exception ex) { return(0); } }
public Product GetProduct(int id) { try { using (GarageEntities db = new GarageEntities()) { Product product = db.Products.Find(id); return product; } } catch (Exception) { return null; } }
public void MarkOrdersAsPaid(List <Cart> carts) { GarageEntities db = new GarageEntities(); if (carts != null) { foreach (Cart cart in carts) { Cart oldCart = db.Carts.Find(cart.ID); oldCart.DatePurchased = DateTime.Now; oldCart.IsInCart = false; } db.SaveChanges(); } }
public string InsertProductType(ProductType productType) { try { GarageEntities db = new GarageEntities(); db.ProductTypes.Add(productType); db.SaveChanges(); return productType.Name + "was succesfully inserted"; } catch (Exception e) { return "Error:" + e; } }
public string InsertProduct(Product product) { try { GarageEntities db = new GarageEntities(); db.Products.Add(product); db.SaveChanges(); return(product.Name + " fue agregado con exito"); } catch (Exception e) { return("Error:" + e); } }
public string InsertCart(Cart cart) { try { GarageEntities db = new GarageEntities(); db.Carts.Add(cart); db.SaveChanges(); return("Order was succesfully inserted"); } catch (Exception e) { return("Error:" + e); } }
public string InsertCart(Cart cart) { try { GarageEntities db = new GarageEntities(); db.Carts.Add(cart); db.SaveChanges(); return("La orden fue agregada con exito"); } catch (Exception e) { return("Error:" + e); } }
public void MarkOrdersAsPaid(List<Cart> carts) { GarageEntities db = new GarageEntities(); if (carts != null) { foreach (Cart cart in carts) { Cart oldCart = db.Carts.Find(cart.ID); oldCart.DatePurchased = DateTime.Now; oldCart.IsInCart = false; } db.SaveChanges(); } }
public string InsertCart(Cart cart) { try { GarageEntities db = new GarageEntities(); db.Carts.Add(cart); db.SaveChanges(); return "Order was succesfully inserted"; } catch (Exception e) { return "Error:" + e; } }
public Product GetProduct(int id) { try { using (var context = new GarageEntities()) { var product = context.Product.Find(id); return(product); } } catch (Exception e) { return(null); } }
public string InsertPurchase(Purchase purchase) { try { GarageEntities db = new GarageEntities(); db.Purchase.Add(purchase); db.SaveChanges(); return(purchase.Date + "was succesfully inserted"); } catch (Exception e) { return("Error" + e); } }
public string InsertProduct(Product product) { try { GarageEntities db = new GarageEntities(); db.Product.Add(product); db.SaveChanges(); return(product.Name + "was succesfully inserted"); } catch (Exception e) { return("Error" + e); } }
public string DeleteProduct(int id) { try { GarageEntities db = new GarageEntities(); var prod = db.Product.Find(id); db.Product.Attach(prod); db.SaveChanges(); return(prod.Name + "was succesfully removed"); } catch (Exception e) { return("Error" + e); } }
public string DeletePurchase(int id) { try { GarageEntities db = new GarageEntities(); var purchase = db.Purchase.Find(id); db.Purchase.Attach(purchase); db.SaveChanges(); return(purchase.Date + "was succesfully removed"); } catch (Exception e) { return("Error" + e); } }
public Product GetProduct(int id) { try { using (GarageEntities db = new GarageEntities()) { Product product = db.Products.Find(id); return(product); } } catch (Exception) { return(null); } }
public List <Purchase> GetAllPurchases() { try { using (GarageEntities db = new GarageEntities()) { List <Purchase> purchases = (from x in db.Purchases select x).ToList(); BeforeGetList(purchases); return(purchases); } } catch (Exception) { return(null); } }
public string UpdateProductType(int id, ProductType productType) { try { GarageEntities db = new GarageEntities(); var toEdit = db.ProductType.FirstOrDefault(p => p.ID == id); toEdit.Name = productType.Name; db.SaveChanges(); return(productType.Name + "was succesfully updated."); } catch (Exception e) { return("Error" + e); } }
public List<Product> GetAllProducts() { try { using (GarageEntities db = new GarageEntities()) { List<Product> products = (from x in db.Products select x).ToList(); return products; } } catch (Exception) { return null; } }
public ProductType GetProductType(int id) { try { using (GarageEntities db = new GarageEntities()) { ProductType producttype = db.ProductTypes.Find(id); BeforeGetDetails(producttype); return(producttype); } } catch (Exception) { return(null); } }
public List <ProductType> GetAllProductTypes() { try { using (GarageEntities db = new GarageEntities()) { List <ProductType> producttypes = (from x in db.ProductTypes select x).ToList(); BeforeGetList(producttypes); return(producttypes); } } catch (Exception) { return(null); } }
public List <Product> GetAllProducts() { try { using (GarageEntities db = new GarageEntities()) { List <Product> products = (from x in db.Products select x).ToList(); return(products); } } catch (Exception) { return(null); } }
public string InsertProductType(ProductType producttype) { try { GarageEntities db = new GarageEntities(); db.ProductTypes.Add(producttype); BeforeInsert(producttype); db.SaveChanges(); return(producttype.ID + " was succesufully inserted."); } catch (Exception e) { return("Error: " + e); } }
public int GetAmountOfOrders(string clientId) { try { GarageEntities db = new GarageEntities(); int amount = (from x in db.Carts where x.ClientID == clientId && x.IsInCart select x.Amount).Sum(); return amount; } catch { return 0; } }
public List<Product> GetProductsByType(int typeId) { try { using (GarageEntities db = new GarageEntities()) { List<Product> products = (from x in db.Products where x.TypeID == typeId select x).ToList(); return products; } } catch (Exception) { return null; } }
public string DeleteCart(int id) { try { GarageEntities db = new GarageEntities(); Cart cart = db.Carts.Find(id); db.Carts.Attach(cart); db.Carts.Remove(cart); db.SaveChanges(); return cart.DatePurchased + "was succesfully deleted"; } catch (Exception e) { return "Error:" + e; } }
public string DeleteProductType(int id) { try { GarageEntities db = new GarageEntities(); ProductType productType = db.ProductTypes.Find(id); db.ProductTypes.Attach(productType); db.ProductTypes.Remove(productType); db.SaveChanges(); return productType.Name + "was succesfully deleted"; } catch (Exception e) { return "Error:" + e; } }
public string UpdateProductType(int id, ProductType productType) { try { GarageEntities db = new GarageEntities(); //Fetch object from db ProductType p = db.ProductTypes.Find(id); p.Name = productType.Name; db.SaveChanges(); return productType.Name + "was succesfully updated"; } catch (Exception e) { return "Error:" + e; } }
public string UpdateCart(int id, Cart cart) { try { GarageEntities db = new GarageEntities(); //Fetch object from db Cart p = db.Carts.Find(id); p.DatePurchased = cart.DatePurchased; p.ClientID = cart.ClientID; p.Amount = cart.Amount; p.IsInCart = cart.IsInCart; p.ProductID = cart.ProductID; db.SaveChanges(); return cart.DatePurchased + " was succesfully updated"; } catch (Exception e) { return "Error:" + e; } }
public string UpdateProduct(int id, Product product) { try { GarageEntities db = new GarageEntities(); //Fetch object from db Product p = db.Products.Find(id); p.Name = product.Name; p.Price = product.Price; p.TypeID = product.TypeID; p.Description = product.Description; p.Image = product.Image; db.SaveChanges(); return product.Name + " was succesfully updated"; } catch (Exception e) { return "Error:" + e; } }