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;
}
