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);
}
