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; }
public ActionResult UpdateStickers(FormCollection form) { JavaScriptSerializer serializer = new JavaScriptSerializer(); if (!string.IsNullOrEmpty(form["enablities"])) { Dictionary<string, string> enables = serializer.Deserialize<Dictionary<string, string>>(form["enablities"]); using (StickersStorage context = new StickersStorage()) { Album album = (from a in context.Album where a.Id == 1 select a).FirstOrDefault(); if (album == null) return RedirectToAction("EditStickerInfo"); foreach (string key in enables.Keys) { int value = int.Parse(enables[key]); int number = int.Parse(key); Stickers sticker = (from s in context.Stickers where s.Number == number && s.UserId == SystemSettings.CurrentUserId select s).FirstOrDefault(); if (sticker != null) { if (value == 0) context.DeleteObject(sticker); else { sticker.NeedOrFree = Convert.ToByte(value); context.SaveChanges(true); } } else if (sticker == null) { sticker = new Stickers(); sticker.NeedOrFree = Convert.ToByte(value); sticker.Number = (short)number; sticker.UserId = (Guid)SystemSettings.CurrentUserId; sticker.Album = album; context.AddToStickers(sticker); } } context.SaveChanges(true); } } return RedirectToAction("EditStickerInfo"); }
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; }