public void Delete(string accessToken)
{
var entityToDelete = _dbContext.Query <Entities.Master.AccessToken>()
.FirstOrDefault(e => e.Token == accessToken);
// non-expiring token rule
if (entityToDelete?.ValidUntilValue.Year < DateTime.Today.Year + 5)
{
_dbContext.Remove(entityToDelete);
}
}
public IEnumerable <User> GetByIds(List <int> ids)
{
ids = ids.Distinct().ToList();
var result = new List <User>();
for (int i = 0, page = 0; i < ids.Count; i += MaxClauseCount, page++)
{
var batch = ids.Skip(MaxClauseCount * page).Take(MaxClauseCount).ToArray();
result.AddRange(_dbContext.Query <Entities.Master.User>()
.Where(u => batch.Contains(u.Id)).ProjectTo <User>(_mapper.ConfigurationProvider).ToArray());
}
return(result);
}
public IEnumerable <IFeatureSetting> GetForTenant(int tenantId)
{
return(_dbContext.Query <TenantProductFeature>()
.Include(x => x.ParentFeatures)
.Where(f => f.TenantId == tenantId)
.AsNoTracking()
.AsEnumerable());
}
public void Add(TaskInstance taskInstance)
{
var taskInstanceId = (taskInstance ?? throw new ArgumentNullException(nameof(taskInstance))).Id;
var entity = _dbContext.Query <Entities.Master.TaskInstance>()
.Include(e => e.Parameters).FirstOrDefault(x => x.Id == taskInstanceId);
if (entity == null)
{
_dbContext.Add(_mapper.Map <Entities.Master.TaskInstance>(taskInstance),
post =>
{
post.MapTo(taskInstance);
}, _mapper);
}
else
{
_mapper.Map(taskInstance, entity);
_dbContext.Update(_mapper.Map <Entities.Master.TaskInstance>(entity),
post => post.MapTo(taskInstance), _mapper);
}
}
public int Count() => _dbContext.Query <MasterEntities.TaskInstance>().Count();
public string GetUserSetting(int userId, string key) => _dbContext.Query <UserSetting>() .SingleOrDefault(e => e.UserId == userId && e.Name == key)?.Value;
public int Count() => _dbContext.Query <MasterEntities.User>().Count();
public int Count() => _dbContext.Query <MasterEntities.ProductSettings>().Count();
public List <UpdateDetails> GetAll() => _dbContext.Query <Entities.Master.UpdateDetails>() .ProjectTo <UpdateDetails>(_mapper.ConfigurationProvider) .ToList();
public int Count() => _dbContext.Query <MasterEntities.Tenant>().Count();
public List <Tenant> GetAll() => _dbContext.Query <Entities.Master.Tenant>() .ProjectTo <Tenant>(_mapper.ConfigurationProvider) .ToList();
public int Count() => _dbContext.Query <MasterEntities.AccessToken>().Count();
