public IActionResult Index()
{
ViewBag.News = _uw.NewsRepository.CountNews();
ViewBag.FuturePublishedNews = _uw.NewsRepository.CountFuturePublishedNews();
ViewBag.NewsPublished = _uw.NewsRepository.CountNewsPublishedOrDraft(true);
ViewBag.DraftNews = _uw.NewsRepository.CountNewsPublishedOrDraft(false);
var month = StringExtensions.GetMonth();
int numberOfVisit;
var year = DateTimeExtensions.ConvertMiladiToShamsi(DateTime.Now, "yyyy");
DateTime StartDateTimeMiladi;
DateTime EndDateTimeMiladi;
var numberOfVisitList = new List <NumberOfVisitChartViewModel>();
for (int i = 0; i < month.Length; i++)
{
StartDateTimeMiladi = DateTimeExtensions.ConvertShamsiToMiladi($"{year}/{i + 1}/01");
if (i < 11)
{
EndDateTimeMiladi = DateTimeExtensions.ConvertShamsiToMiladi($"{year}/{i + 2}/01");
}
else
{
EndDateTimeMiladi = DateTimeExtensions.ConvertShamsiToMiladi($"{year}/01/01");
}
numberOfVisit = _uw._Context.News.Where(n => n.PublishDateTime < EndDateTimeMiladi && StartDateTimeMiladi <= n.PublishDateTime).Include(v => v.Visits).Select(k => k.Visits.Sum(v => v.NumberOfVisit)).AsEnumerable().Sum();
numberOfVisitList.Add(new NumberOfVisitChartViewModel {
Name = month[i], Value = numberOfVisit
});
}
ViewBag.NumberOfVisitChart = numberOfVisitList;
return(View());
}