public void Remove(params T[] items)
{
using (var context = new CardProcessingEntities())
{
foreach (T item in items)
{
context.Entry(item).State = System.Data.EntityState.Deleted;
}
context.SaveChanges();
}
}
public T Update(params T[] items)
{
using (var context = new CardProcessingEntities())
{
T rs = null;
foreach (T item in items)
{
context.Entry(item).State = System.Data.EntityState.Modified;
rs = item;
}
context.SaveChanges();
return(rs);
}
}
public Agent Add(params Agent[] items)
{
using (var context = new CardProcessingEntities()) {
Agent rs = null;
foreach (Agent item in items)
{
context.Entry(item).State = System.Data.EntityState.Added;
context.Entry(item.Account.Privilege).State = System.Data.EntityState.Unchanged;
rs = item;
}
context.SaveChanges();
return(rs);
}
}
public T GetSingle(Func <T, bool> where, params Expression <Func <T, object> >[] navigationproperties)
{
T item;
using (var context = new CardProcessingEntities())
{
context.Configuration.LazyLoadingEnabled = false;
context.Configuration.ProxyCreationEnabled = false;
IQueryable <T> dbquery = context.Set <T>();
// eager loading
foreach (Expression <Func <T, object> > navigationProperty in navigationproperties)
{
dbquery = dbquery.Include(navigationProperty);
}
item = dbquery.AsNoTracking().SingleOrDefault(where);
}
return(item);
}
public IList <T> GetList(Func <T, bool> where, params Expression <Func <T, object> >[] navigationproperties)
{
List <T> list;
using (var context = new CardProcessingEntities())
{
context.Configuration.LazyLoadingEnabled = false;
context.Configuration.ProxyCreationEnabled = false;
IQueryable <T> dbquery = context.Set <T>();
// eager loading
foreach (Expression <Func <T, object> > navigationProperty in navigationproperties)
{
dbquery = dbquery.Include(navigationProperty);
}
list = dbquery.AsNoTracking().Where(where).ToList();
}
return(list);
}
public IList <T> GetAllWithPaging(int limit, int upset, params Expression <Func <T, object> >[] navigationproperties)
{
List <T> list;
using (var context = new CardProcessingEntities())
{
context.Configuration.LazyLoadingEnabled = false;
context.Configuration.ProxyCreationEnabled = false;
IQueryable <T> dbquery = context.Set <T>();
// eager loading
foreach (Expression <Func <T, object> > navigationProperty in navigationproperties)
{
dbquery = dbquery.Include(navigationProperty);
}
list = dbquery.AsNoTracking().ToList().Skip(limit * upset).Take(limit).ToList();
}
return(list);
}
