public async Task <List <ViewModels.TopicPreview> > GetPreviews(List <int> topicIds) { var topicsQuery = from topic in DbContext.Topics where topicIds.Contains(topic.Id) where !topic.Deleted select topic; var topics = await topicsQuery.ToListAsync(); var topicBoardsQuery = from topicBoard in DbContext.TopicBoards where topicIds.Contains(topicBoard.TopicId) select new { topicBoard.BoardId, topicBoard.TopicId }; var topicBoards = await topicBoardsQuery.ToListAsync(); var users = await AccountRepository.Records(); var topicPreviews = new List <ViewModels.TopicPreview>(); var today = DateTime.Now.Date; var boards = await BoardRepository.Records(); foreach (var topicId in topicIds) { var topic = topics.First(item => item.Id == topicId); var firstMessagePostedBy = users.First(r => r.Id == topic.FirstMessagePostedById); var lastMessagePostedBy = users.FirstOrDefault(r => r.Id == topic.LastMessagePostedById); var topicPreview = new ViewModels.TopicPreview { Id = topic.Id, Pinned = topic.Pinned, ViewCount = topic.ViewCount, ReplyCount = topic.ReplyCount, Popular = topic.ReplyCount > UserContext.ApplicationUser.PopularityLimit, Pages = Convert.ToInt32(Math.Ceiling(1.0 * topic.ReplyCount / UserContext.ApplicationUser.MessagesPerPage)), FirstMessageId = topic.FirstMessageId, FirstMessageTimePosted = topic.FirstMessageTimePosted, FirstMessagePostedById = topic.FirstMessagePostedById, FirstMessagePostedByName = firstMessagePostedBy?.DecoratedName ?? "User", FirstMessagePostedByBirthday = today == new DateTime(today.Year, firstMessagePostedBy.Birthday.Month, firstMessagePostedBy.Birthday.Day).Date, FirstMessageShortPreview = string.IsNullOrEmpty(topic.FirstMessageShortPreview.Trim()) ? "No subject" : topic.FirstMessageShortPreview, LastMessageId = topic.Id, LastMessageTimePosted = topic.LastMessageTimePosted, LastMessagePostedById = topic.LastMessagePostedById, LastMessagePostedByName = lastMessagePostedBy?.DecoratedName ?? "User", LastMessagePostedByBirthday = today == new DateTime(today.Year, firstMessagePostedBy.Birthday.Month, firstMessagePostedBy.Birthday.Day).Date, }; topicPreviews.Add(topicPreview); var historyTimeLimit = DateTime.Now.AddDays(-14); if (topic.LastMessageTimePosted > historyTimeLimit) { topicPreview.Unread = GetUnreadLevel(topic.Id, topic.LastMessageTimePosted); } var topicPreviewBoardsQuery = from topicBoard in topicBoards where topicBoard.TopicId == topic.Id join board in boards on topicBoard.BoardId equals board.Id orderby board.DisplayOrder select new Models.ViewModels.Boards.IndexBoard { Id = board.Id, Name = board.Name, Description = board.Description, DisplayOrder = board.DisplayOrder, }; topicPreview.Boards = topicPreviewBoardsQuery.ToList(); var topicEventQuery = from topicEvent in DbContext.Events where topicEvent.TopicId == topic.Id select topicEvent; topicPreview.Event = await topicEventQuery.AnyAsync(); } return(topicPreviews); }
public async Task <List <ItemModels.MessagePreview> > GetPreviews(List <int> messageIds) { var messageQuery = from message in DbContext.Messages where messageIds.Contains(message.Id) select new { message.Id, message.ShortPreview, message.ViewCount, message.ReplyCount, message.TimePosted, message.PostedById, message.LastReplyId, message.LastReplyById, message.LastReplyPosted, message.Pinned }; var messages = await messageQuery.ToListAsync(); var users = await AccountRepository.Records(); var messagePreviews = new List <ItemModels.MessagePreview>(); var today = DateTime.Now.Date; var boards = await BoardRepository.Records(); foreach (var messageId in messageIds) { var message = messages.First(item => item.Id == messageId); var postedBy = users.First(r => r.Id == message.PostedById); var messagePreview = new ItemModels.MessagePreview { Id = message.Id, ShortPreview = string.IsNullOrEmpty(message.ShortPreview.Trim()) ? "No subject" : message.ShortPreview, Views = message.ViewCount, Replies = message.ReplyCount, Pages = Convert.ToInt32(Math.Ceiling(1.0 * message.ReplyCount / UserContext.ApplicationUser.MessagesPerPage)), LastReplyId = message.Id, Popular = message.ReplyCount > UserContext.ApplicationUser.PopularityLimit, Pinned = message.Pinned, TimePosted = message.TimePosted, PostedById = message.PostedById, PostedByName = postedBy.DecoratedName, PostedByBirthday = today == new DateTime(today.Year, postedBy.Birthday.Month, postedBy.Birthday.Day).Date }; messagePreviews.Add(messagePreview); var lastMessageTime = message.TimePosted; if (message.LastReplyId != 0) { var lastReply = (from item in DbContext.Messages where item.Id == message.LastReplyId select new { item.ShortPreview }).FirstOrDefault(); if (lastReply != null) { var lastReplyBy = users.FirstOrDefault(r => r.Id == message.LastReplyById); messagePreview.LastReplyId = message.LastReplyId; messagePreview.LastReplyPreview = lastReply.ShortPreview; messagePreview.LastReplyById = message.LastReplyById; messagePreview.LastReplyPosted = message.LastReplyPosted; lastMessageTime = message.LastReplyPosted; messagePreview.LastReplyByName = lastReplyBy?.DecoratedName ?? "User"; if (!(lastReplyBy is null)) { messagePreview.LastReplyByBirthday = today.Date == new DateTime(today.Year, lastReplyBy.Birthday.Month, lastReplyBy.Birthday.Day).Date; } } } var historyTimeLimit = DateTime.Now.AddDays(-14); if (lastMessageTime > historyTimeLimit) { messagePreview.Unread = GetUnreadLevel(message.Id, lastMessageTime); } var boardIdQuery = from messageBoard in DbContext.MessageBoards where messageBoard.MessageId == message.Id select messageBoard.BoardId; var messageBoards = new List <Models.ViewModels.Boards.Items.IndexBoard>(); foreach (var boardId in boardIdQuery) { var boardRecord = boards.Single(r => r.Id == boardId); messageBoards.Add(new Models.ViewModels.Boards.Items.IndexBoard { Id = boardRecord.Id.ToString(), Name = boardRecord.Name, Description = boardRecord.Description, DisplayOrder = boardRecord.DisplayOrder, }); } messagePreview.Boards = messageBoards.OrderBy(r => r.DisplayOrder).ToList(); } return(messagePreviews); }