public async Task <Registration> FindForUserAsync(int id, int userId) { return(RegistrationMapper.MapFromDomain(await RepositoryDbSet .Include(a => a.Title) .ThenInclude(a => a.Translations) .Include(a => a.Comment) .ThenInclude(a => a.Translations) .Include(a => a.Dog) .ThenInclude(a => a.Sex) .ThenInclude(a => a.Translations) .Include(a => a.Participant) .Include(a => a.Schooling) .ThenInclude(a => a.SchoolingName) .ThenInclude(a => a.Translations) .Include(a => a.Show) .ThenInclude(a => a.Title) .ThenInclude(a => a.Translations) .Include(a => a.Show) .ThenInclude(a => a.Comment) .ThenInclude(a => a.Translations) .Include(a => a.Competition) .ThenInclude(a => a.Title) .ThenInclude(a => a.Translations) .Include(a => a.Competition) .ThenInclude(a => a.Comment) .ThenInclude(a => a.Translations) .Include(a => a.Schooling) .ThenInclude(a => a.SchoolingName) .ThenInclude(a => a.Translations) .FirstOrDefaultAsync(a => a.Dog.AppUserId == userId))); }
public override async Task <List <DAL.App.DTO.Registration> > AllAsync() { return(await RepositoryDbSet .Include(a => a.Dog) .ThenInclude(dog => dog.Sex) .ThenInclude(sex => sex.Translations) .Include(a => a.Dog) .ThenInclude(a => a.AppUser) .Include(m => m.Title) .ThenInclude(t => t.Translations) .Include(n => n.Comment) .ThenInclude(t => t.Translations) .Include(a => a.Schooling) .ThenInclude(a => a.SchoolingName) .ThenInclude(a => a.Translations) .Include(a => a.Show) .ThenInclude(a => a.Title) .ThenInclude(a => a.Translations) .Include(a => a.Show) .ThenInclude(a => a.Comment) .ThenInclude(a => a.Translations) .Include(a => a.Participant) .Include(a => a.Competition) .ThenInclude(comp => comp.Comment) .ThenInclude(comment => comment.Translations) .Include(a => a.Competition) .ThenInclude(comp => comp.Title) .ThenInclude(title => title.Translations) .Select(e => RegistrationMapper.MapFromDomain(e)).ToListAsync()); }
public async Task <List <Registration> > AllForDogRegisAsync(int dogId) { return(await RepositoryDbSet .Include(a => a.Dog) .Include(a => a.Comment) .ThenInclude(a => a.Translations) .Include(a => a.Title) .ThenInclude(e => e.Translations) .Where(a => a.DogId == dogId) .Select(e => RegistrationMapper.MapFromDomain(e)) .ToListAsync()); }
public async Task <List <DAL.App.DTO.Registration> > AllForUserAsync(int userId) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var res = await RepositoryDbSet .Include(a => a.Title) .ThenInclude(a => a.Translations) .Include(a => a.Comment) .ThenInclude(a => a.Translations) .Include(a => a.Dog) .ThenInclude(a => a.Sex) .ThenInclude(a => a.Translations) .Include(a => a.Participant) .Include(a => a.Schooling) .ThenInclude(a => a.SchoolingName) .ThenInclude(a => a.Translations) .Include(a => a.Show) .ThenInclude(a => a.Title) .ThenInclude(a => a.Translations) .Include(a => a.Show) .ThenInclude(a => a.Comment) .ThenInclude(a => a.Translations) .Include(a => a.Competition) .ThenInclude(a => a.Title) .ThenInclude(a => a.Translations) .Include(a => a.Competition) .ThenInclude(a => a.Comment) .ThenInclude(a => a.Translations) .Include(a => a.Schooling) .ThenInclude(a => a.SchoolingName) .ThenInclude(a => a.Translations) .Where(a => a.Dog.AppUserId == userId) .Select(e => RegistrationMapper.MapFromDomain(e)) .ToListAsync(); // .Select(c => new // { // Id = c.Id, // title = c.Title, // comment = c.Comment, // // // //Dog = c.Dog, // Translations = c.Comment.Translations, // Translations2 = c.Title.Translations, // Participant = c.Participant // // }) // .ToListAsync(); // // var resultList = res.Select(c => new DTO.Registration() // { // Id = c.Id, // //Dog = c.Dog, // Title = c.title.Translate(), // Comment = c.comment.Translate(), // // Participant = c.Participant // // //// Participant = c.Participant, //// Dog = c.Dog // // // }).ToList(); //return resultList; return(res); }
public override async Task <DTO.Registration> FindAsync(params object[] id) { var culture = Thread.CurrentThread.CurrentUICulture.Name.Substring(0, 2).ToLower(); var registration = await RepositoryDbSet.FindAsync(id); if (registration != null) { await RepositoryDbContext.Entry(registration) .Reference(c => c.Schooling) .LoadAsync(); await RepositoryDbContext.Entry(registration.Schooling) .Reference(c => c.SchoolingName) .LoadAsync(); await RepositoryDbContext.Entry(registration.Schooling.SchoolingName) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(registration) .Reference(c => c.Competition) .LoadAsync(); await RepositoryDbContext.Entry(registration.Competition) .Reference(c => c.Title) .LoadAsync(); await RepositoryDbContext.Entry(registration.Competition.Title) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(registration) .Reference(c => c.Competition) .LoadAsync(); await RepositoryDbContext.Entry(registration.Competition) .Reference(c => c.Comment) .LoadAsync(); await RepositoryDbContext.Entry(registration.Competition.Comment) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(registration) .Reference(c => c.Title) .LoadAsync(); await RepositoryDbContext.Entry(registration.Title) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(registration) .Reference(c => c.Comment) .LoadAsync(); await RepositoryDbContext.Entry(registration.Comment) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(registration) .Reference(c => c.Dog) .LoadAsync(); await RepositoryDbContext.Entry(registration.Dog) .Reference(c => c.Sex) .LoadAsync(); await RepositoryDbContext.Entry(registration.Dog.Sex) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(registration) .Reference(c => c.Participant) .LoadAsync(); await RepositoryDbContext.Entry(registration) .Reference(c => c.Show) .LoadAsync(); await RepositoryDbContext.Entry(registration.Show) .Reference(c => c.Title) .LoadAsync(); await RepositoryDbContext.Entry(registration.Show.Title) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); await RepositoryDbContext.Entry(registration) .Reference(c => c.Show) .LoadAsync(); await RepositoryDbContext.Entry(registration.Show) .Reference(c => c.Comment) .LoadAsync(); await RepositoryDbContext.Entry(registration.Show.Comment) .Collection(b => b.Translations) .Query() .Where(t => t.Culture == culture) .LoadAsync(); // } return(RegistrationMapper.MapFromDomain(registration)); }