public async Task <OrganizationUserOrganizationDetails> GetDetailsByUserAsync(Guid userId, Guid organizationId, OrganizationUserStatusType?status = null) { using (var scope = ServiceScopeFactory.CreateScope()) { var dbContext = GetDatabaseContext(scope); var view = new OrganizationUserOrganizationDetailsViewQuery(); var t = await(view.Run(dbContext)).ToArrayAsync(); var entity = await view.Run(dbContext) .FirstOrDefaultAsync(o => o.UserId == userId && o.OrganizationId == organizationId && (status == null || o.Status == status)); return(entity); } }
public async Task <ICollection <OrganizationUserOrganizationDetails> > GetManyDetailsByUserAsync(Guid userId, OrganizationUserStatusType?status = null) { using (var scope = ServiceScopeFactory.CreateScope()) { var dbContext = GetDatabaseContext(scope); var view = new OrganizationUserOrganizationDetailsViewQuery(); var query = from ou in view.Run(dbContext) where ou.UserId == userId && (status == null || ou.Status == status) select ou; var organizationUsers = await query.ToListAsync(); return(organizationUsers); } }