public string Report2()
{
TopSeller topSeller = new TopSeller();
topSeller.label.AddRange(new string[] { "Styczeń", "Luty", "Marzec", "Kwiecień", "Maj", "Czerwiec", "Lipiec", "Sierpień", "Wrzesień", "Październik", "Listopad", "Grudzień" });
for (int i = 1; i <= 12; i++)
{
DateTime dateStart = new DateTime(2014, i, 1);
DateTime dateEnd = new DateTime(2014, i, DateTime.DaysInMonth(2014, i));
List <decimal> ordersPrice = db.Orders.Where(o => o.StartDate >= dateStart && o.StartDate <= dateEnd).Select(o => o.PurchasePrice).ToList();
decimal price = 0;
foreach (decimal item in ordersPrice)
{
price += item;
}
topSeller.value.Add(price);
}
return(JsonConvert.SerializeObject(topSeller));
}
public string Report3()
{
bool flag = true;
TopSeller topSeller = new TopSeller();
var list = from c in db.Clients
from o in db.Orders
where (c.ClientId == o.Client.ClientId)
select new { c.FirstName, c.LastName, o.PurchasePrice };
var result = list
.GroupBy(a => new { a.FirstName, a.LastName })
.Select(a => new { Amount = a.Sum(b => b.PurchasePrice), Name = a.Key })
.OrderByDescending(a => a.Amount)
.ToList();
foreach (var item in result)
{
topSeller.label.Add(item.Name.FirstName + " " + item.Name.LastName);
topSeller.value.Add(item.Amount);
}
return(JsonConvert.SerializeObject(topSeller));
}
public string Report1()
{
TopSeller topSeller = new TopSeller();
List <User> usersList = db.Users.ToList();
foreach (User item in usersList)
{
//Add Label
string seller = item.FirstName + " " + item.LastName;
topSeller.label.Add(seller);
List <decimal> ordersPrice = db.Orders.Where(o => o.Seller == seller).Select(o => o.PurchasePrice).ToList();
decimal Price = 0;
foreach (decimal price in ordersPrice)
{
Price += price;
}
topSeller.value.Add(Price);
}
return(JsonConvert.SerializeObject(topSeller));
}
