public IDictionary <string, string> GetTopCustomer()
{
var topCustomer = _buyingAgentContext.Transactions
.Include(e => e.Customer)
.GroupBy(e => e.Customer)
.Select(e =>
new
{
//profit = e.Sum(s => s.Charged) - e.Sum(s => s.Price),
profit = e.Sum(s => s.Profit),
name = e.Key.Name,
province = e.Key.Province,
relationship = e.Key.Relationship,
gender = e.Key.Gender,
customerSince = e.Key.CustomerSince
}).OrderByDescending(x => x.profit)
.Take(1);
IDictionary <string, string> customerToReturn = _converter.Convert(topCustomer).First();
return(customerToReturn);
}
