public List<OrderLine> getOrder(int id) { Debug.WriteLine("OrdreID: " + id); var db = new DatabaseContext(); var lines = db.OrderLines.Include(p => p.Products).Where(o => o.OrdersId == id).ToList(); Debug.WriteLine("Antall ordrelinjer fra db"); Debug.WriteLine(lines.Count); List<OrderLine> list = new List<OrderLine>(); foreach (var item in lines) { var itemProduct = new Product() { itemnumber = item.Products.Id, name = item.Products.Name, price = item.Products.Price, description = item.Products.Description }; list.Add(new OrderLine() { product = itemProduct, quantity = item.Quantity }); } return list; }
public List<Product> getAll(int? id, String sc, int? sort) { var db = new DatabaseContext(); List<Product> allProducts = new List<Product>(); var products = db.Products.Include(p => p.SubCategories.Categories).Where(p => p.SubCategoriesId == id).OrderBy(p => p.Name).ToList(); switch (sort) { case 1: products = db.Products.Include(p => p.SubCategories.Categories).Where(p => p.SubCategoriesId == id).OrderBy(p => p.Name).ToList(); break; case 2: products = db.Products.Include(p => p.SubCategories.Categories).Where(p => p.SubCategoriesId == id).OrderBy(p => p.Price).ToList(); break; case 3: products = db.Products.Include(p => p.SubCategories.Categories).Where(p => p.SubCategoriesId == id).OrderByDescending(p => p.Price).ToList(); break; } foreach (var p in products) { var product = new Product() { itemnumber = p.Id, name = p.Name, description = p.Description, price = p.Price, volum = p.Volum, producer = p.Producers.Name, pricePerLitre = pricePerLitre(p.Price, p.Volum), category = p.SubCategories.Categories.Name, categoryid = p.SubCategories.Categories.Id, subCategory = p.SubCategories.Name, subCategoryid = p.SubCategories.Id, country = p.Countries.Name }; allProducts.Add(product); } return allProducts; }
public ShoppingCartItem(Product p, int qty) { product = p; quantity = qty; price = qty * product.price; }
public List<Product> getMostSold() { var db = new DatabaseContext(); List<int> topOrders = db.OrderLines .GroupBy(p => p.ProductsId) .OrderByDescending(gp => gp.Count()) .Take(4) .Select(g => g.Key).ToList(); List<Products> products = new List<Products>(); foreach (var i in topOrders) { products.Add(db.Products.Where(p => p.Id == i).First()); } List<Product> prod = new List<Product>(); foreach (var p in products) { var product = new Product() { itemnumber = p.Id, name = p.Name, description = p.Description, price = p.Price, volum = p.Volum, producer = p.Producers.Name, subCategory = p.SubCategories.Name, subCategoryid = p.SubCategories.Id, country = p.Countries.Name }; prod.Add(product); } return prod; }
public List<Product> getResult(string searchString) { var db = new DatabaseContext(); List<Product> foundProducts = new List<Product>(); var products = db.Products.Include(p => p.SubCategories.Categories).Where(p => p.Name.ToUpper().Contains(searchString.ToUpper()) || p.Description.ToUpper().Contains(searchString.ToUpper())).ToList(); foreach (var p in products) { var product = new Product() { itemnumber = p.Id, name = p.Name, description = p.Description, price = p.Price, volum = p.Volum, producer = p.Producers.Name, pricePerLitre = pricePerLitre(p.Price, p.Volum), category = p.SubCategories.Categories.Name, categoryid = p.SubCategories.Categories.Id, subCategory = p.SubCategories.Name, subCategoryid = p.SubCategories.Id, country = p.Countries.Name }; foundProducts.Add(product); } return foundProducts; }