public HighChartData GetForMonth(DateTime?filterDate)
{
var month = filterDate.HasValue ? filterDate.Value.Month : DateTime.Now.Month;
var year = filterDate.HasValue ? filterDate.Value.Year : DateTime.Now.Year;
List <int> days = new List <int>();
days = GenerateListForMonth(filterDate);
var categoriesPerDay = (from i in itemRepo.Get(null, null, "")
group i by i.CategoryCode into cc
join d in days on 1 equals 1
select new
{
Category = cc.Key,
Day = d
}).ToList();
var data = (from o in orderRepo.Get(x => x.Date.Year == year && x.Date.Month == month, null, "")
join so in subOrderRepo.Get(null, null, "") on o.Id equals so.OrderId
join oi in orderItemRepo.Get(null, null, "") on so.Id equals oi.Id
join i in itemRepo.Get(null, null, "Catalog") on oi.ItemId equals i.Id
where o.Date.Year == year && o.Date.Month == month
select new
{
Category = i.CategoryCode,
Price = i.Price * (1 - (decimal)0.01 * oi.CatalogDiscount) * oi.Qty,
Day = o.Date.Day
} into p
group p by new { p.Category, p.Day } into dailyPerCategory
select new
{
Category = dailyPerCategory.Key.Category,
Day = dailyPerCategory.Key.Day,
Price = dailyPerCategory.Sum(x => x.Price)
}).ToList();
var final = (from cm in categoriesPerDay
from d in data.Where(x => x.Day == cm.Day && x.Category.Equals(cm.Category)).DefaultIfEmpty()
select new
{
Category = cm.Category,
Day = cm.Day,
Price = d != null ? d.Price : 0
} into hh
group hh by hh.Category into perCategory
select new HighChartSerie()
{
Id = perCategory.Key,
Name = perCategory.Key,
Data = perCategory.Select(x => x.Price).ToList()
}).ToList();
HighChartData result = new HighChartData()
{
Series = final
};
return(result);
}
public HighChartData GetForYear(int year)
{
List <int> months = new List <int>();
for (int i = 1; i <= 12; i++)
{
months.Add(i);
}
var categoriesPerMonth = (from i in itemRepo.Get(null, null, "")
group i by i.CategoryCode into cc
join m in months on 1 equals 1
select new {
Category = cc.Key,
Month = m
}).ToList();
var data = (from o in orderRepo.Get(x => x.Date.Year == year, null, "")
join so in subOrderRepo.Get(null, null, "") on o.Id equals so.OrderId
join oi in orderItemRepo.Get(null, null, "") on so.Id equals oi.Id
join i in itemRepo.Get(null, null, "Catalog") on oi.ItemId equals i.Id
select new
{
Category = i.CategoryCode,
Price = i.Price * (1 - (decimal)0.01 * oi.CatalogDiscount) * oi.Qty,
Month = o.Date.Month
} into p
group p by new { p.Category, p.Month } into montlyPerCategory
select new
{
Category = montlyPerCategory.Key.Category,
Month = montlyPerCategory.Key.Month,
Price = montlyPerCategory.Sum(x => x.Price)
}).ToList();
var final = (from cm in categoriesPerMonth
from d in data.Where(x => x.Month == cm.Month && x.Category.Equals(cm.Category)).DefaultIfEmpty()
select new
{
Category = cm.Category,
Month = cm.Month,
Price = d != null ? d.Price : 0
} into hh
group hh by hh.Category into perCategory
select new HighChartSerie()
{
Id = perCategory.Key,
Name = perCategory.Key,
Data = perCategory.Select(x => x.Price).ToList()
}).ToList();
HighChartData result = new HighChartData()
{
Series = final
};
return(result);
}
public JsonResult GetMonthlyCosts(DateTime?filterDate, string period)
{
HighChartData data = null;
List <string> cat = null;
if (period.Equals("year"))
{
data = new MonthlyCostByCategory().GetForYear(filterDate.HasValue ? filterDate.Value.Year : DateTime.Now.Year);
cat = new List <string> {
"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"
};
}
else if (period.Equals("month"))
{
data = new MonthlyCostByCategory().GetForMonth(filterDate);
cat = GenerateListForMonth(filterDate);
}
return(Json(new { data, cat }));
}
