Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- entities.ExportRecords.AsEnumerable()
- .Where(x =>
- (x.UserId != null) &&
- (x.DateOfOrder.Year == d.Year) &&
- (x.DateOfOrder.Month == d.Month))
- .Select(x => new
- {
- ManagerName = entities.Users
- .Where(u => u.Id == x.UserId)
- .FirstOrDefault().Username,
- Weight = x.Weight,
- Price = Math.Round(x.Price / 100.0, 0)
- })
- .Where(x => (x.Price >= val1) && (x.Price <= val2))
- .GroupBy(x => new { x.ManagerName, x.Price })
- .Select(x => new PriceDistributionInMonthPoint
- {
- ManagerName = x.Key.ManagerName,
- TotalWeight = x.Sum(z => z.Weight),
- Price = x.Key.Price
- })
- .ToList();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement