public ViewResult Management(DateTime?begin, DateTime?end, int prevnext = 0, int step = 5, string cat = "all", string rep = "", string title = "", int weektab = 0)
{
var now = DateTime.Now;
var articlesQuery = _articleRepository.GetMany(art => art.ArticleStatus > 0, art => art.PublishedTime);
if (begin == null || end == null)
{
end = Utilities.GetLastDateOfWeek(now, DayOfWeek.Sunday);
begin = end.Value.AddDays(-7 * step).AddDays(1);
}
else
{
if (prevnext == 0)
{
end = Utilities.GetLastDateOfWeek(now, DayOfWeek.Sunday);
begin = end.Value.AddDays(-7 * step);
}
else if (prevnext == -1)
{
end = Utilities.GetFirstDateOfWeek(begin.Value, DayOfWeek.Monday).AddDays(-1);
begin = end.Value.AddDays(-7 * step).AddDays(1);
}
else if (prevnext == 1)
{
begin = Utilities.GetLastDateOfWeek(end.Value, DayOfWeek.Sunday).AddDays(1);
end = begin.Value.AddDays(7 * step);
}
}
articlesQuery = articlesQuery.Where(v => v.PublishedTime.HasValue && v.PublishedTime.Value.Date >= begin && v.PublishedTime.Value.Date <= end);
int catId;
if (cat != "all" && int.TryParse(cat, out catId))
{
articlesQuery = articlesQuery.Where(v => v.Categories.Any(c => c.Id == catId));
}
if (rep != "")
{
articlesQuery = articlesQuery.Where(v => v.Reporters.Any(r => r.Name.Contains(rep)));
}
if (title != "")
{
articlesQuery = articlesQuery.Where(v => v.Title.Contains(title));
}
var startDate = begin.Value;
var endDate = end.Value;
var list = new List <ArticleCustomDateView>();
for (int i = 0; i < 5; i++)
{
endDate = startDate.AddDays(6);
var view = new ArticleCustomDateView
{
Week = cal.GetWeekOfYear(startDate, System.Globalization.CalendarWeekRule.FirstFullWeek, DayOfWeek.Monday),
StartDate = startDate,
EndDate = endDate,
Articles = articlesQuery.Where(art => art.PublishedTime.HasValue && art.PublishedTime.Value.Date >= startDate && art.PublishedTime.Value.Date <= endDate)
.GroupJoin(_articleSeriesRepository.All, art => art.ArticleSeriesId, asr => asr.Id, (art, asr) => new { Art = art, Srs = asr })
.SelectMany(xy => xy.Srs.DefaultIfEmpty(), (x, y) => new { Art = x.Art, Srs = y })
.Select(a => new ArticleCustomView()
{
Id = a.Art.Id,
ArticleName = a.Art.Title,
SeriesName = a.Srs != null && a.Srs.Articles.Count > 0 ? a.Srs.Name : "",
SeriesId = a.Srs != null ? a.Srs.Id : 0,
IsPublished = a.Art.IsPublished,
Order = a.Art.Order,
PublishedTime = a.Art.PublishedTime,
Thumbnail = a.Art.Thumbnail,
CatThumbnail = a.Art.Categories.Count > 0? a.Art.Categories.ElementAt(0).ProfilePhoto:"",
CatName = String.Join(", ", a.Art.Categories.OrderBy(r => r.Order).Select(r => r.Name)),
Reporters = a.Art.Reporters.ToList(),
UniqueTitle = a.Art.UniqueTitle,
ArticleStatus = a.Art.ArticleStatus,
}).ToList()
};
foreach (var art in view.Articles)
{
var hlAll = _articleHighlightAllRepository.Find(art.Id);
var hlCat = _articleHighlightCatRepository.Find(art.Id);
art.IsHighlightAll = hlAll == null ? false : true;
art.IsHighlightCat = hlCat == null ? false : true;
var firstWeekReport = _articleRepository.GetFirstWeekReport(art.Id);
var allTimeReport = _articleRepository.GetAllTimeReport(art.Id);
art.AllTimeCount = allTimeReport.PageView;
art.FirstWeekCount = firstWeekReport.PageView;
}
list.Add(view);
startDate = endDate.AddDays(1);
}
var filterView = new ArticleFilterView
{
Category = cat,
Reporter = rep,
Title = title,
Begin = begin,
End = end,
CustomArticles = list
};
ViewBag.weektab = weektab;
ViewBag.ArticleCat = _articleCategoryRepository.All.ToList();
return(View(filterView));
}
