예제 #1
0
        public async Task <IReadOnlyCollection <GiftReceivedFeedViewModel> > GetGiftTransactionsForUserFeedAsync(string userId)
        {
            var giftTransactions = from gifts in db.GiftTransactions
                                   where (gifts.FromUserId == userId || gifts.ToUserId == userId)
                                   where gifts.FromUser.IsActive
                                   where gifts.ToUser.IsActive
                                   select new GiftReceivedFeedViewModel()
            {
                DateSent                 = gifts.DateTransactionOccurred,
                ReceiverUserName         = gifts.ToUser.UserName,
                ReceiverProfileImagePath = gifts.ToUser.Profile.UserImage.FileName,
                ReceiverProfileId        = gifts.ToUser.Profile.Id,
                SenderProfileId          = gifts.FromUser.Profile.Id,
                SenderProfileImagePath   = gifts.FromUser.Profile.UserImage.FileName,
                SenderUserId             = gifts.FromUser.Id,
                SenderUserName           = gifts.FromUser.UserName,
                StoreItemId              = gifts.StoreItemId,
                ItemCount                = gifts.ItemCount,
                StoreItemIconPath        = gifts.StoreItem.IconFileName
            };

            var results = await giftTransactions.ToListAsync();

            foreach (var result in results)
            {
                result.ReceiverProfileImagePath = ProfileExtensions.GetThumbnailImagePath(result.ReceiverProfileImagePath);
                result.SenderProfileImagePath   = ProfileExtensions.GetThumbnailImagePath(result.SenderProfileImagePath);
                result.StoreItemIconPath        = StoreItemExtensions.GetImagePath(result.StoreItemIconPath);
                result.Gifts = new Dictionary <int, GiftReceivedFeedItemViewModel>();
            }

            return(results.AsReadOnly());
        }
예제 #2
0
        /// <summary>
        /// Returns all store items in descending order by the date at which they were added.
        /// </summary>
        /// <returns></returns>
        public async Task <IReadOnlyList <StoreItemViewModel> > GetNewStoreItemsAsync()
        {
            DateTime now = DateTime.Now;

            var query = from storeItems in db.StoreItems
                        join sales in db.StoreSales on storeItems.Id equals sales.StoreItemId into lj
                        from sales in lj.DefaultIfEmpty()
                        where (now >= sales.DateStart && now <= sales.DateEnd) || sales.Discount == null // sales for today or items without sales
                        orderby storeItems.DateAdded descending
                        select new StoreItemViewModel()
            {
                ItemId          = storeItems.Id,
                Discount        = sales.Discount,
                ItemDescription = storeItems.Description,
                ItemName        = storeItems.Name,
                ItemTypeId      = storeItems.ItemTypeId,
                PointsCost      = storeItems.PointPrice,
                ItemImagePath   = storeItems.IconFileName,
                DateSaleEnds    = sales.DateEnd
            };

            var results = await query.ToListAsync();

            // we couldn't execute these custom formatting functions in the LINQ query, so we loop and do it here
            foreach (var item in results)
            {
                item.ItemImagePath = StoreItemExtensions.GetImagePath(item.ItemImagePath);
            }

            return(results);
        }
예제 #3
0
        public async Task <IReadOnlyCollection <GiftReceivedFeedViewModel> > GetFollowerGiftTransactionsAsync(string userId, FeedItemQueryType queryType)
        {
            List <GiftReceivedFeedViewModel> results = new List <GiftReceivedFeedViewModel>();

            if (queryType == FeedItemQueryType.All)
            {
                var giftsSent = (from gifts in db.GiftTransactions
                                 from favoritedProfiles in db.FavoriteProfiles
                                 where gifts.FromUser.Profile.Id == favoritedProfiles.ProfileId ||
                                 gifts.ToUser.Profile.Id == favoritedProfiles.ProfileId
                                 where favoritedProfiles.UserId == userId
                                 where gifts.FromUser.IsActive
                                 where gifts.ToUser.IsActive
                                 select new GiftReceivedFeedViewModel()
                {
                    DateSent = gifts.DateTransactionOccurred,
                    ReceiverUserName = gifts.ToUser.UserName,
                    ReceiverProfileImagePath = gifts.ToUser.Profile.UserImage.FileName,
                    ReceiverProfileId = gifts.ToUser.Profile.Id,
                    SenderProfileId = gifts.FromUser.Profile.Id,
                    SenderProfileImagePath = gifts.FromUser.Profile.UserImage.FileName,
                    SenderUserId = gifts.FromUser.Id,
                    SenderUserName = gifts.FromUser.UserName,
                    StoreItemId = gifts.StoreItemId,
                    ItemCount = gifts.ItemCount,
                    StoreItemIconPath = gifts.StoreItem.IconFileName
                })
                                .Distinct();

                results = await giftsSent.ToListAsync();
            }
            else
            {
                var giftsToSelf = from gifts in db.GiftTransactions
                                  .Include(g => g.StoreItem)
                                  .Include(g => g.FromUser)
                                  where gifts.ToUserId == userId
                                  where gifts.FromUser.IsActive
                                  where gifts.ToUser.IsActive
                                  select new GiftReceivedFeedViewModel()
                {
                    DateSent                 = gifts.DateTransactionOccurred,
                    ReceiverUserName         = gifts.ToUser.UserName,
                    ReceiverProfileImagePath = gifts.ToUser.Profile.UserImage.FileName,
                    ReceiverProfileId        = gifts.ToUser.Profile.Id,
                    SenderProfileId          = gifts.FromUser.Profile.Id,
                    SenderProfileImagePath   = gifts.FromUser.Profile.UserImage.FileName,
                    SenderUserId             = gifts.FromUser.Id,
                    SenderUserName           = gifts.FromUser.UserName,
                    StoreItemId              = gifts.StoreItemId,
                    ItemCount                = gifts.ItemCount,
                    StoreItemIconPath        = gifts.StoreItem.IconFileName
                };

                results = await giftsToSelf.ToListAsync();
            }

            foreach (var result in results)
            {
                result.ReceiverProfileImagePath = ProfileExtensions.GetThumbnailImagePath(result.ReceiverProfileImagePath);
                result.SenderProfileImagePath   = ProfileExtensions.GetThumbnailImagePath(result.SenderProfileImagePath);
                result.StoreItemIconPath        = StoreItemExtensions.GetImagePath(result.StoreItemIconPath);
                result.Gifts = new Dictionary <int, GiftReceivedFeedItemViewModel>();
            }

            return(results.AsReadOnly());
        }