public void SaveEarnedBadges(IQueryable<BadgeAwardDTO> badges)
{
using (var ctx = new Entities())
{
ctx.Database.Connection.Open();
var badgeAwards = new List<BadgeAward>();
foreach (var badge in badges)
{
var saveBadge = LoadData(badge);
ctx.BadgeAwards.Add(saveBadge);
badgeAwards.Add(saveBadge);
}
ctx.SaveChanges();
foreach (var badgeAward in badgeAwards)
{
var queueItem = new QueueItem
{
BadgeAwardId = badgeAward.BadgeAwardId,
QueueItemCreated = badgeAward.AwardDate
};
ctx.QueueItems.Add(queueItem);
}
ctx.SaveChanges();
}
}
public QueueItemDTO Update(QueueItemDTO item)
{
using (Entities context = new Entities())
{
QueueItem itemToUpdate = new QueueItem
{
QueueItemId = item.QueueItemId,
BadgeAwardId = item.BadgeAwardId,
QueueItemCreated = item.QueueItemCreated
};
context.QueueItems.Attach(itemToUpdate);
context.Entry(itemToUpdate).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return Get(item.QueueItemId);
}
}