public IEnumerable <IMarketerShopFactorChart> GetMarketerShopMonthlyCharts(long marketerId)
{
var date = DateTime.Now;
var startDate = date.AddDays(-30);
var shopFactorDailyCharts = new List <MarketerShopFactorChart>();
foreach (var day in EachDay(startDate, date))
{
var endDate = day.AddDays(1);
var shopFactorDailyChart = new MarketerShopFactorChart
{
Label = day.ToFa("m"),
TotalCount = _factorRepository.AsQuery().Count(p => p.CreationTime >= day && p.CreationTime <= endDate && p.Shop.MarketerId == marketerId && p.FactorState == FactorState.Paid),
TotalSum = _factorRepository.AsQuery().Where(p => p.CreationTime >= day && p.CreationTime <= endDate && p.Shop.MarketerId == marketerId && p.FactorState == FactorState.Paid).ToList()
.Sum(p => p.DiscountPrice)
};
shopFactorDailyCharts.Add(shopFactorDailyChart);
}
return(shopFactorDailyCharts);
}
public IEnumerable <IMarketerShopFactorChart> GetMarketerShopDailyCharts(long marketerId)
{
var date = DateTime.Now;
var startDate = new DateTime(date.Year, date.Month, date.Day, 0, 0, 0);
var shopFactorDailyCharts = new List <MarketerShopFactorChart>();
var label = 1;
foreach (var day in EachHours(startDate, date))
{
var endDate = day.AddHours(1);
var shopFactorDailyChart = new MarketerShopFactorChart
{
Label = Convert.ToString(label),
TotalCount = _factorRepository.AsQuery().Count(p => p.CreationTime >= day && p.CreationTime <= endDate && p.Shop.MarketerId == marketerId && p.FactorState == FactorState.Paid),
TotalSum = _factorRepository.AsQuery().Where(p => p.CreationTime >= day && p.CreationTime <= endDate && p.Shop.MarketerId == marketerId && p.FactorState == FactorState.Paid).ToList()
.Sum(p => p.DiscountPrice)
};
shopFactorDailyCharts.Add(shopFactorDailyChart);
label++;
}
return(shopFactorDailyCharts);
}
