public LoginPermission GetById(int id)
{
using (var context = new FuelManagementEntities())
{
return(context.LoginPermissions.FirstOrDefault(x => x.Id == id));
}
}
public LoginPermission GetByUserID(int userId)
{
using (var context = new FuelManagementEntities())
{
return(context.LoginPermissions.FirstOrDefault(x => x.UserID == userId));
}
}
public virtual T GetByKey(object key)
{
using (var context = new FuelManagementEntities())
{
return((T)context.Set(GetEntityType()).Find(key));
}
}
public PartnerServiceIntegration GetByClientID(int clientId, int AdminID)
{
using (var context = new FuelManagementEntities())
{
return(context.PartnerServiceIntegrations.FirstOrDefault(x => x.ClientID == clientId && x.AdminClientID == AdminID));
}
}
public PartnerServiceIntegration GetByAccountID(Guid accountId)
{
using (var context = new FuelManagementEntities())
{
return(context.PartnerServiceIntegrations.FirstOrDefault(x => x.AccountNumber == accountId));
}
}
public virtual T GetByKeySerializable(object key)
{
using (var context = new FuelManagementEntities())
{
context.Configuration.LazyLoadingEnabled = false;
return((T)context.Set(GetEntityType()).Find(key));
}
}
public virtual T Insert(T entity)
{
using (var context = new FuelManagementEntities())
{
context.Set(GetEntityType()).Add(entity);
context.SaveChanges();
return(entity);
}
}
protected virtual void DeleteByKey(object key)
{
using (var context = new FuelManagementEntities())
{
T entityToUpdate = (T)context.Set(GetEntityType()).Find(key);
if (entityToUpdate == null)
{
return;
}
context.Entry(entityToUpdate).State = EntityState.Deleted;
context.SaveChanges();
}
}
protected virtual T UpdateByKey(T entity, object key)
{
using (var context = new FuelManagementEntities())
{
if (key == null || ((int)key) == 0)
{
return(Insert(entity));
}
context.Set(GetEntityType()).Attach(entity);
context.Entry(entity).State = EntityState.Modified;
context.SaveChanges();
return(entity);
}
}
public virtual List <T> GetList(System.Linq.Expressions.Expression <System.Func <T, bool> > predicate, string include = "")
{
using (var context = new FuelManagementEntities())
{
if (string.IsNullOrEmpty(include))
{
return(context.Set(GetEntityType()).AsQueryable().Cast <T>().Where(predicate).ToList());
}
else
{
return(context.Set(GetEntityType()).AsQueryable().Include(include).Cast <T>().Where(predicate).ToList());
}
}
}
public virtual List <T> GetListSerializable(System.Linq.Expressions.Expression <Func <T, bool> > predicate, string include = "")
{
using (var context = new FuelManagementEntities())
{
context.Configuration.LazyLoadingEnabled = false;
if (string.IsNullOrEmpty(include))
{
return(context.Set(GetEntityType()).AsQueryable().Cast <T>().Where(predicate).ToList());
}
else
{
return(context.Set(GetEntityType()).AsQueryable().Include(include).Cast <T>().Where(predicate).ToList());
}
}
}