public OutboundMessage GetMessageByPostmarkId(Guid id)
{
using (var ctx = new MailboxContext())
{
return(ctx.Messages.SingleOrDefault(m => m.PostmarkMessageId == id));
}
}
public IQueryable <TEntity> Get <TEntity>(Expression <Func <TEntity, bool> > filter = null) where TEntity : class
{
using (var context = new MailboxContext())
{
IQueryable <TEntity> query = context.Set <TEntity>();
query = filter != null?query.Where(filter) : query;
return(query);
}
}
public TEntity Add <TEntity>(TEntity entity) where TEntity : class
{
if (entity == null)
{
return(null);
}
using (var context = new MailboxContext())
{
var addedEntity = context.Set <TEntity>().Add(entity);
context.SaveChanges();
return(addedEntity);
}
}
public TEntity Delete <TEntity>(TEntity entity) where TEntity : class
{
if (entity == null)
{
return(null);
}
using (var context = new MailboxContext())
{
// Make sure DbContext is tracking this entry
var entry = context.Entry(entity);
if (entry.State == EntityState.Detached)
{
context.Set <TEntity>().Attach(entity);
}
var deletedEntity = context.Set <TEntity>().Remove(entity);
return(deletedEntity);
}
}
public TEntity Update <TEntity>(TEntity entity) where TEntity : class
{
if (entity == null)
{
return(null);
}
using (var context = new MailboxContext())
{
// Make sure DbContext is tracking this entry
var entry = context.Entry(entity);
if (entry.State == EntityState.Detached)
{
context.Set <TEntity>().Attach(entity);
}
entry.State = EntityState.Modified;
context.SaveChanges();
return(entity);
}
}
