//public static async Task<ICollection<ContentModel>> Content_GetUserSystemcontents(string userId)
//{
// var query = await _contentDataCollection.FindAsync(x => x.UserId == userId && x.IsSystem == true);
// var contents = await query.ToListAsync();
// return contents.Where(x => x.UserId == userId).OrderBy(x => !x.IsSystem).ThenBy(x => x.Name).ToList();
//}
//public static async Task<ICollection<ContentModel>> Content_GetAllCurrentUsercontents()
//{
// var userId = HttpContextAccessor.HttpContext.User.GetUserId();
// var query = await _contentDataCollection.FindAsync(x => x.UserId == userId);
// var contents = await query.ToListAsync();
// return contents.Where(x => x.UserId == userId).OrderBy(x => !x.IsSystem).ThenBy(x => x.Name).ToList();
//}
public static async Task <ContentModel> Content_Get(ObjectId id)
{
var content = await _contentDataCollectionQueryable.FirstOrDefaultAsync(x => x.Id == id);
content.CreationDate = content.CreationDate.ToUniversalTime();
return(content);
}
public async Task <T> GetFirstByConditionsAsync <TKey>(
Expression <Func <T, bool> > expression,
Sort <T, TKey> sort,
CancellationToken cancellationToken = default)
{
IMongoQueryable <T> entities = this.GetQueryableByConditionsAndSort(expression, sort);
T entity = await entities.FirstOrDefaultAsync(cancellationToken);
return(entity);
}
public Task <TEntity> GetFirstAsync(Expression <Func <TEntity, bool> > filter, params ISorting[] sortingColumns)
{
IMongoQueryable <TEntity> query = GetSet();
if (filter != null)
{
query = query.Where(filter);
}
if (sortingColumns != null && sortingColumns.Length > 0)
{
query = (IOrderedMongoQueryable <TEntity>)query.OrderBy(sortingColumns);
}
return(query.FirstOrDefaultAsync());
}
public async Task<UserDTO> AuthUser(LoginViewModel loginViewModel)
{
return _mapper.Map<UserDTO>(
await _users.FirstOrDefaultAsync(u => u.UserName == loginViewModel.UserName && _passwordHasher.CheckMatch(u.HashedPassword,loginViewModel.Password)));
}
public async Task <PlayerModel> GetPlayer(string playerName)
{
return(await playersCollection.FirstOrDefaultAsync(e => e.LastName == playerName));
}
public async Task <TEntity> FirstOrDefaultAsync(Expression <Func <TEntity, bool> > predicate)
{
return(await _queryable.FirstOrDefaultAsync <TEntity>(predicate));
}
public override async Task <T> FirstOrDefaultAsync()
{
return(await queryable.FirstOrDefaultAsync());
}
public async Task <UserViewModel> GetUserByEmail(string email)
{
return(_mapper.Map <UserViewModel>(
await _users.FirstOrDefaultAsync(u => u.Email == email)));
}
public async Task <TeamModel> GetTeam(string teamName)
{
return(await teamsCollection.FirstOrDefaultAsync(e => e.Name == teamName));
}
public Task <TEntity> FirstOrDefaultAsync(Expression <Func <TEntity, bool> > predicate = null)
{
return(_queryable.FirstOrDefaultAsync(predicate));
}
public Task <TType> FirsteOrDefaultAsync()
{
return(_query.FirstOrDefaultAsync());
}