public override async Task <List <AppUser> > AllAsync()
{
return(await RepositoryDbSet
.Include(s => s.Shop).ThenInclude(a => a.ShopName).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopAddress).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact2).ThenInclude(t => t.Translations)
.Select(e => AppUserMapper.MapFromDomain(e)).ToListAsync());
}
public async Task <List <DAL.App.DTO.DomainLikeDTO.Identity.AppUser> > GetUserById(int userId)
{
return(await RepositoryDbSet
.Include(s => s.Shop).ThenInclude(a => a.ShopName).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopAddress).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact2).ThenInclude(t => t.Translations)
.Where(a => a.Id == userId)
.Select(e => AppUserMapper.MapFromDomain(e)).ToListAsync());
}
public override async Task <List <DAL.App.DTO.Identity.AppUser> > AllAsync()
{
return(await RepositoryDbSet
// .Include(c =>c.AppUserOnObjects)
.Include(d => d.AppUserInPositions)
.ThenInclude(d => d.AppUserPosition)
.ThenInclude(d => d.AppUserPositionValue)
.ThenInclude(d => d.Translations)
.Select(e => AppUserMapper.MapFromDomain(e))
.ToListAsync());
}
public override async Task <AppUser> FindAsync(params object[] id)
{
var appUser = await base.FindAsync(id);
return(AppUserMapper.MapFromDomain(await RepositoryDbSet.Where(a => a.Id == appUser.Id)
.Include(s => s.Shop).ThenInclude(a => a.ShopName).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopAddress).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact2).ThenInclude(t => t.Translations)
.FirstOrDefaultAsync()));
}
public async Task <List <AppUser> > AllForUserAsync(int userId)
{
return(await RepositoryDbSet
.Include(c => c.AppUserOnObjects)
.Include(d => d.AppUserInPositions)
.ThenInclude(f => f.AppUserPosition)
.ThenInclude(d => d.AppUserPositionValue)
.ThenInclude(d => d.Translations)
.Where(c => c.Id == userId)
.Select(e => AppUserMapper.MapFromDomain(e))
.ToListAsync());
}
public async Task <List <AppUser> > AllAsync(string order, string searchFor)
{
var query = RepositoryDbSet
.Include(s => s.Shop).ThenInclude(a => a.ShopName).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopAddress).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact2).ThenInclude(t => t.Translations)
.AsQueryable();
query = Search(query, searchFor);
var res = await query.Select(e => AppUserMapper.MapFromDomain(e)).ToListAsync();
return(Order(res, order));
}
public async Task <List <DAL.App.DTO.DomainLikeDTO.Identity.AppUser> > AllAsyncByShop(int?shopId, string order, string searchFor)
{
var query = RepositoryDbSet
.Include(s => s.Shop).ThenInclude(a => a.ShopName).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopAddress).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact).ThenInclude(t => t.Translations)
.Include(s => s.Shop).ThenInclude(a => a.ShopContact2).ThenInclude(t => t.Translations)
.Where(a => a.ShopId == shopId || a.ShopId == null)
.AsQueryable();
query = Search(query, searchFor);
var res = await query.Select(e => AppUserMapper.MapFromDomain(e)).ToListAsync();
return(Order(res, order));
}
public override async Task <DAL.App.DTO.Identity.AppUser> FindAsync(params object[] id)
{
// return await RepositoryDbSet
// .Include(d => d.AppUserInPositions)
// .ThenInclude(d => d.AppUserPosition)
// .ThenInclude(d => d.AppUserPositionValue)
// .ThenInclude(d => d.Translations)
// .Select(p => AppUserMapper.MapFromDomain(p))
// .FirstOrDefaultAsync(p => p.Id == (int) id[0]);
var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower();
var appUser = await RepositoryDbSet.FindAsync(id);
if (appUser != null)
{
await RepositoryDbContext.Entry(appUser)
.Collection(c => c.AppUserInPositions)
.LoadAsync();
foreach (var appUserInPosition in appUser.AppUserInPositions)
{
await RepositoryDbContext.Entry(appUserInPosition)
.Reference(c => c.AppUserPosition)
.LoadAsync();
await RepositoryDbContext.Entry(appUserInPosition.AppUserPosition)
.Reference(c => c.AppUserPositionValue)
.LoadAsync();
await RepositoryDbContext.Entry(appUserInPosition.AppUserPosition.AppUserPositionValue)
.Collection(c => c.Translations)
.Query()
.Where(t => t.Culture == culture)
.LoadAsync();
}
}
return(AppUserMapper.MapFromDomain(appUser));
}
