public PreviewImagesViewModel PreviewTopImagesLasтThirtyDays(int category) { var images = imageDbSet.All().Where(i => (int)i.ImageCategory == category) .Where(t => t.UploadedDate > DateTime.Now.AddDays(-30)).OrderByDescending(d => d.Scores) .Select(u => new PreviewImageViewModel { Title = u.Title, Id = u.Id, PhotographyAddictedUser = u.PhotographyAddictedUser, PhotographyAddictedUserId = u.PhotographyAddictedUserId, Description = u.Description, ImageCategory = u.ImageCategory, ImageComments = u.ImageComments, Picture = u.Picture, Scores = u.Scores, UploadedDate = u.UploadedDate, Equipment = u.Equipment, Settings = u.Settings, VotedUsers = u.VotedUsers, }).ToList(); var imagesByCategory = new PreviewImagesViewModel() { PreviewImages = images, }; return(imagesByCategory); }
public PreviewImagesViewModel PreviewImages(string input) { PreviewImagesViewModel images = new PreviewImagesViewModel(); if (input == null) { images.PreviewImages = imageDbSet.All().Select(u => new PreviewImageViewModel { Title = u.Title, Id = u.Id, PhotographyAddictedUser = u.PhotographyAddictedUser, PhotographyAddictedUserId = u.PhotographyAddictedUserId, Description = u.Description, ImageCategory = u.ImageCategory, ImageComments = u.ImageComments, Picture = u.Picture, Scores = u.Scores, UploadedDate = u.UploadedDate, Equipment = u.Equipment, Settings = u.Settings, VotedUsers = u.VotedUsers, }).OrderByDescending(d => d.UploadedDate); } else { images.PreviewImages = imageDbSet.All().Where(n => n.Title.Contains(input)).Select(u => new PreviewImageViewModel { Title = u.Title, Id = u.Id, PhotographyAddictedUser = u.PhotographyAddictedUser, PhotographyAddictedUserId = u.PhotographyAddictedUserId, Description = u.Description, ImageCategory = u.ImageCategory, ImageComments = u.ImageComments, Picture = u.Picture, Scores = u.Scores, UploadedDate = u.UploadedDate, Equipment = u.Equipment, Settings = u.Settings, VotedUsers = u.VotedUsers, }).OrderByDescending(d => d.UploadedDate); images.Input = input; } return(images); }
public PreviewImagesViewModel PreviewUserFavoriteImages(string userId) { var images = userDbSet.All().Where(i => i.Id == userId).FirstOrDefault().Favourite.FavouriteImages .Select(p => new PreviewImageViewModel { Id = p.ImageId, Title = p.Image.Title, Picture = p.Image.Picture, Scores = p.Image.Scores, PhotographyAddictedUserId = p.Image.PhotographyAddictedUserId, UploadedDate = p.Image.UploadedDate, }) .ToList(); var userImages = new PreviewImagesViewModel() { PreviewImages = images, }; return(userImages); }
public PreviewImagesViewModel PreviewUserImages(string userId) { var images = imageDbSet.All().Where(i => i.PhotographyAddictedUserId == userId) .Select(p => new PreviewImageViewModel { Id = p.Id, Title = p.Title, Picture = p.Picture, Scores = p.Scores, PhotographyAddictedUserId = p.PhotographyAddictedUserId, UploadedDate = p.UploadedDate, VotedUsers = p.VotedUsers, }) .ToList(); var userImages = new PreviewImagesViewModel() { PreviewImages = images, }; return(userImages); }
public PreviewImagesViewModel PreviewTopImagesLasтThirtyDaysByCategory() { var images = new List <PreviewImageViewModel>(); for (int i = 1; i < 13; i++) { var checkCategory = imageDbSet.All().Where(p => (int)p.ImageCategory == i).Where(t => t.UploadedDate > DateTime.Now.AddDays(-30)); if (checkCategory.Count() != 0) { var currentImage = imageDbSet.All().Where(p => (int)p.ImageCategory == i) .Where(t => t.UploadedDate > DateTime.Now.AddDays(-30)).OrderByDescending(s => s.Scores).Select(u => new PreviewImageViewModel { Title = u.Title, Id = u.Id, PhotographyAddictedUser = u.PhotographyAddictedUser, PhotographyAddictedUserId = u.PhotographyAddictedUserId, Description = u.Description, ImageCategory = u.ImageCategory, ImageComments = u.ImageComments, Picture = u.Picture, Scores = u.Scores, UploadedDate = u.UploadedDate, Equipment = u.Equipment, Settings = u.Settings, VotedUsers = u.VotedUsers, }).First(); images.Add(currentImage); } } var imagesByCategory = new PreviewImagesViewModel() { PreviewImages = images, }; return(imagesByCategory); }