private TopStatistic GetTopUsersByorder() { TopStatistic result = new TopStatistic(); result.Id = 0; result.Title = "Top users by order"; result.Count = 10; result.ValueTitle = "Orders"; result.Data = db.UserChoices .Where(uc => uc.confirm) .GroupBy(uс => uс.UserID) .Select(uc => new UserData { UserId = uc.Key, UserName = "", Value = uc.Count().ToString() }) .Take(10) .OrderByDescending(ud => ud.Value) .ToList(); Dictionary<string, ApplicationUser> users = UserManager.Users.ToDictionary(user => user.Id); foreach (var data in result.Data) { data.UserName = users[data.UserId].UserName; } return result; }
public IHttpActionResult GetTop(int id) { TopStatistic top = new TopStatistic(); return Ok(top); }