public async Task <List <Schooling> > AllForMaterialAsync(int materialId)
{
return(await RepositoryDbSet
.Include(a => a.Material)
.Include(a => a.SchoolingName)
.ThenInclude(a => a.Translations)
.Where(a => a.MaterialId == materialId)
.Select(e => SchoolingMapper.MapFromDomain(e))
.ToListAsync());
}
public override async Task <List <DAL.App.DTO.Schooling> > AllAsync()
{
return(await RepositoryDbSet
.Include(m => m.SchoolingName)
.ThenInclude(t => t.Translations)
.Include(m => m.Material)
.ThenInclude(a => a.MaterialName)
.ThenInclude(t => t.Translations)
.Include(a => a.Location)
.ThenInclude(a => a.Locations)
.ThenInclude(a => a.Translations)
.Select(e => SchoolingMapper.MapFromDomain(e)).ToListAsync());
}
public override async Task <DTO.Schooling> FindAsync(params object[] id)
{
var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower();
var schooling = await RepositoryDbSet.FindAsync(id);
if (schooling != null)
{
await RepositoryDbContext.Entry(schooling)
.Reference(c => c.SchoolingName)
.LoadAsync();
await RepositoryDbContext.Entry(schooling.SchoolingName)
.Collection(b => b.Translations)
.Query()
.Where(t => t.Culture == culture)
.LoadAsync();
await RepositoryDbContext.Entry(schooling)
.Reference(c => c.Material)
.LoadAsync();
await RepositoryDbContext.Entry(schooling.Material)
.Reference(c => c.MaterialName)
.LoadAsync();
await RepositoryDbContext.Entry(schooling.Material.MaterialName)
.Collection(b => b.Translations)
.Query()
.Where(t => t.Culture == culture)
.LoadAsync();
await RepositoryDbContext.Entry(schooling)
.Reference(c => c.Location)
.LoadAsync();
await RepositoryDbContext.Entry(schooling.Location)
.Reference(c => c.Locations)
.LoadAsync();
await RepositoryDbContext.Entry(schooling.Location.Locations)
.Collection(b => b.Translations)
.Query()
.Where(t => t.Culture == culture)
.LoadAsync();
}
return(SchoolingMapper.MapFromDomain(schooling));
}
