public static Dictionary<string, int> getCategoriesDictionary() { ProductRepository _p_repo = new ProductRepository(); IQueryable<Category> categ_list = _p_repo.getAllCategories(); Dictionary<string, int> dictionary = new Dictionary<string, int>(); foreach (var item in categ_list) { dictionary.Add(item.Name, 0); } return dictionary; }
public ProductWrapper(Models.Product product) { this.product = product; ProductRepository productRepo = new ProductRepository(); var list = productRepo.getAllCategories().ToList(); var list2 = new List<String>(); foreach (Category c in list) { list2.Add(c.Name); } categories = new SelectList(list2, product.Category); }
public ActionResult Index() { ProductRepository product_repo = new ProductRepository(); Dictionary<string, int> dictionary = Utils.getCategoriesDictionary(); IQueryable<Rating> list = product_repo.getAllUserRatings(User.Identity.Name); foreach (Rating item in list) { dictionary[item.Product.Category]++; } string categ = ""; int max = 0; foreach (var item in dictionary) { if (item.Value > max) { max = item.Value; categ = item.Key; } } IQueryable<Statistic> list2 = product_repo.getCategoryStatistics(categ); var sorted_list = list2.OrderByDescending(i => i.Views); List<Models.Product> product_list = new List<Models.Product>(); foreach (var item in sorted_list) { product_list.Add(item.Product); } ViewBag.Message = "Welcome to WantThis - Your no.1 bargain destination!"; ViewBag.TwitterFeed = TwitterRSSReader.GetFeed(); if (product_list.Count == 0) ViewBag.SortedList = null; else ViewBag.SortedList = product_list; return View(); }
public ActionResult Stats() { ProductRepository p_repo = new ProductRepository(); Dictionary<string, int> dictionary = Utils.getCategoriesDictionary(); IQueryable<Rating> rating_list = p_repo.getAllRatings(); IQueryable<WantThis.Models.Product> product_list = p_repo.getAllProducts(null); List<WantThis.Models.Product> lst = product_list.ToList<WantThis.Models.Product>(); foreach (var item in rating_list) { WantThis.Models.Product p = lst.Find(delegate(WantThis.Models.Product pr) { return pr.ProductID == item.ProductID; }); dictionary[p.Category]++; } TwoDimensionalData data = new TwoDimensionalData(); foreach (var item in dictionary) { data.Data.Add(new ChartDataEntry(item.Key, item.Value)); } return View(data); }