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()); }