public List <QueueItem> GetNextQueueItem()
{
using (var db = new ClientDbContext())
{
List <QueueItem> l = db.Database.SqlQuery <QueueItem>("GetNextQueueItem").ToList();
return(l);
}
}
public void DeleteQueueItem(int queueItemId)
{
using (var db = new ClientDbContext())
{
var qi = new QueueItem {
Id = queueItemId, SuccessfullySent = true
};
db.QueueItems.Attach(qi);
db.Entry(qi).Property(x => x.SuccessfullySent).IsModified = true;
db.SaveChanges();
}
}
public int InsertQueueItem(string message)
{
using (var db = new ClientDbContext())
{
QueueItem qi = db.QueueItems.Add(new QueueItem {
Message = message, CreatedDate = DateTime.Now
});
db.SaveChanges();
return(qi.Id);
}
}