Carrotware.CMS.Core.SiteNavHelperReal.GetSingleMonthBlogUpdateList C# (CSharp) Method

        public List<ContentDateLinks> GetSingleMonthBlogUpdateList(SiteData currentSite, DateTime monthDate, bool bActiveOnly)
        {
            List<ContentDateLinks> lstContent = new List<ContentDateLinks>();
            DateTime dateBegin = monthDate.AddDays(0 - monthDate.Day).AddDays(1);
            DateTime dateEnd = dateBegin.AddMonths(1).AddMilliseconds(-1);

            if (currentSite != null) {
                dateBegin = currentSite.ConvertSiteTimeToUTC(dateBegin);
                dateEnd = currentSite.ConvertSiteTimeToUTC(dateEnd);
            }

            IQueryable<vw_carrot_Content> query1 = CannedQueries.GetLatestBlogListDateRange(db, currentSite.SiteID, dateBegin, dateEnd, bActiveOnly);

            lstContent = (from p in query1
                          group p by p.GoLiveDateLocal.Date into g
                          select new ContentDateLinks { PostDate = g.Key, UseCount = g.Count() }).ToList();

            lstContent.ToList().ForEach(q => q.TheSite = currentSite);

            return lstContent;
        }