Пример #1
0
        public static List<StickerPresentation> GetStickerListNeed(Guid userId)
        {
            List<StickerPresentation> stickerList = new List<StickerPresentation>();
            using (StickersStorage context = new StickersStorage())
            {
                var stickersCollection = (from stikers in context.Stickers.Include("Album")
                                          where stikers.UserId == userId && stikers.NeedOrFree == 1
                                          select new
                                          {
                                              number = stikers.Number,
                                              isNeed = stikers.NeedOrFree == 1 ? true : false,
                                              isFree = stikers.NeedOrFree == 2 ? true : false
                                          }).ToList();

                foreach (var item in stickersCollection)
                {
                    StickerPresentation sticker = new StickerPresentation();
                    sticker.Number = item.number;
                    sticker.isNeed = item.isNeed;
                    sticker.isFree = item.isFree;
                    stickerList.Add(sticker);
                }
            }
            stickerList.Sort(new CollectStickers.Helpers.Helpers.SortStickers());
            return stickerList;
        }
Пример #2
0
        public static List<StickerPresentation> GetStickerList()
        {
            Hashtable htuser = new Hashtable();

            using (MembershipStorage usercontext = new MembershipStorage())
            {
                var usersList = (from user in usercontext.aspnet_Users where user.UserName.ToLower() != "admin" select user).ToList();
                foreach (var item in usersList)
                {
                    htuser.Add(item.UserId, item.UserName);
                }
            }

            List<StickerPresentation> stickerList = new List<StickerPresentation>();
            using (StickersStorage context = new StickersStorage())
            {
                var stickersCollection = (from stikers in context.Stickers.Include("Album")
                                          where stikers.UserId != SystemSettings.CurrentUserId
                                          select new
                                          {
                                              number = stikers.Number,
                                              isNeed = stikers.NeedOrFree == 1 ? true : false,
                                              isFree = stikers.NeedOrFree == 2 ? true : false,
                                              userId = stikers.UserId
                                          }).ToList();

                foreach (var item in stickersCollection)
                {
                    StickerPresentation sticker = new StickerPresentation();
                    sticker.Number = item.number;
                    sticker.isNeed = item.isNeed;
                    sticker.isFree = item.isFree;
                    sticker.UserId = item.userId;
                    sticker.UserName = (string)htuser[item.userId];
                    stickerList.Add(sticker);
                }
            }
            stickerList.Sort(new CollectStickers.Helpers.Helpers.SortStickersByUser());
            return stickerList;
        }