public IVmListItemsData <IVmListItem> GetMunicipalities(string searchedCode, bool onlyValid = true)//TODO ADD LANGUAGE PARAM, MUNICIPALITY NAME { IReadOnlyList <VmListItem> result = new List <VmListItem>(); contextManager.ExecuteReader(unitOfWork => { var searchCode = searchedCode.ToLower(); var municipalityRep = unitOfWork.CreateRepository <IMunicipalityRepository>(); var qry = municipalityRep.All(); if (onlyValid) { qry = qry.Where(m => m.IsValid); } var resultTemp = unitOfWork.ApplyIncludes(qry, i => i.Include(j => j.MunicipalityNames)); if (!string.IsNullOrEmpty(searchCode)) { resultTemp = resultTemp .Where(x => x.Code.ToLower().Contains(searchedCode) || x.MunicipalityNames.Any(y => y.Name.ToLower().Contains(searchedCode) // && y.LocalizationId == languageCache.Get(LanguageCode.fi.ToString()) )) .OrderBy(x => x.Code) .Take(CoreConstants.MaximumNumberOfAllItems); result = translationEntToVm.TranslateAll <Municipality, VmListItem>(resultTemp); } }); return(new VmListItemsData <IVmListItem>(result)); }
public List<ImportStatutoryServiceGeneralDescription> DownloadGeneralDescriptions() { return contextManager.ExecuteWriter(unitOfWork => { var gds = unitOfWork.CreateRepository<IStatutoryServiceGeneralDescriptionVersionedRepository>().All(); gds = unitOfWork.ApplyIncludes(gds, i => i .Include(j => j.Names) .Include(x => x.ServiceClasses).ThenInclude(x => x.ServiceClass).ThenInclude(x => x.Names) .Include(x => x.OntologyTerms).ThenInclude(x => x.OntologyTerm).ThenInclude(x => x.Names) .Include(x => x.LifeEvents).ThenInclude(x => x.LifeEvent).ThenInclude(x => x.Names) .Include(x => x.IndustrialClasses).ThenInclude(x => x.IndustrialClass).ThenInclude(x => x.Names) .Include(x => x.TargetGroups).ThenInclude(x => x.TargetGroup) .Include(j => j.Descriptions) .Include(x => x.LanguageAvailabilities) .Include(x => x.Versioning) .Include(j => j.StatutoryServiceRequirements) .Include(j => j.StatutoryServiceLaws).ThenInclude(j => j.Law).ThenInclude(j => j.Names) .Include(j => j.StatutoryServiceLaws).ThenInclude(j => j.Law).ThenInclude(j => j.WebPages).ThenInclude(j => j.WebPage) .Include(j => j.UnificRoot).ThenInclude(j => j.StatutoryServiceGeneralDescriptionServiceChannels).ThenInclude(j => j.ServiceChannel).ThenInclude(j => j.Versions).ThenInclude(j => j.ServiceChannelNames) .Include(j => j.UnificRoot).ThenInclude(j => j.StatutoryServiceGeneralDescriptionServiceChannels).ThenInclude(j => j.ServiceChannel).ThenInclude(j => j.Versions).ThenInclude(j => j.LanguageAvailabilities) .Include(j => j.UnificRoot).ThenInclude(j => j.StatutoryServiceGeneralDescriptionServiceChannels).ThenInclude(j => j.GeneralDescriptionServiceChannelDescriptions) .Include(j => j.UnificRoot).ThenInclude(j => j.StatutoryServiceGeneralDescriptionServiceChannels).ThenInclude(j => j.GeneralDescriptionServiceChannelDigitalAuthorizations).ThenInclude(j => j.DigitalAuthorization) ); return transaltionManager .TranslateAll<StatutoryServiceGeneralDescriptionVersioned, ImportStatutoryServiceGeneralDescription >(gds).ToList(); }); }
public IReadOnlyList <VmListItem> GetOrganizationNamesForIds(IUnitOfWork unitOfWork, IList <Guid> organizationIds) { var organizationRepository = unitOfWork.CreateRepository <IOrganizationVersionedRepository>(); var psPublished = typesCache.Get <PublishingStatusType>(PublishingStatus.Published.ToString()); var resultTemp = organizationRepository.All().Where(x => x.PublishingStatusId == psPublished && organizationIds.Contains(x.UnificRootId)); resultTemp = unitOfWork.ApplyIncludes(resultTemp, q => q.Include(i => i.OrganizationNames).ThenInclude(i => i.Localization).Include(i => i.OrganizationDisplayNameTypes).Include(i => i.LanguageAvailabilities)); return(translationManagerToVm.TranslateAll <OrganizationVersioned, VmListItem>(resultTemp)); }
public IVmListItemsData <IVmCountry> GetCountries(string searchedCode) { IReadOnlyList <IVmCountry> result = new List <IVmCountry>(); contextManager.ExecuteReader(unitOfWork => { var searchCode = searchedCode.ToLower(); var countryRep = unitOfWork.CreateRepository <ICountryRepository>(); var resultTemp = unitOfWork.ApplyIncludes(countryRep.All(), i => i.Include(j => j.CountryNames)); if (!string.IsNullOrEmpty(searchCode)) { resultTemp = resultTemp .Where(x => x.Code.ToLower().Contains(searchedCode) || x.CountryNames.Any(y => y.Name.ToLower().Contains(searchCode))) .OrderBy(x => x.Code) .Take(CoreConstants.MaximumNumberOfAllItems); result = translationEntToVm.TranslateAll <Country, VmCountry>(resultTemp); } }); return(new VmListItemsData <IVmCountry> (result)); }
public IList <VmOpenApiCodeListItem> GetLanguageCodeList() { IReadOnlyList <VmOpenApiCodeListItem> result = new List <VmOpenApiCodeListItem>(); contextManager.ExecuteReader(unitOfWork => { var languageRep = unitOfWork.CreateRepository <ILanguageRepository>(); var resultTemp = unitOfWork.ApplyIncludes(languageRep.All(), i => i.Include(j => j.Names)); resultTemp = resultTemp.OrderBy(x => x.Code); result = translationEntToVm.TranslateAll <Language, VmOpenApiCodeListItem>(resultTemp); }); return(new List <VmOpenApiCodeListItem>(result)); }
public List <VmBugReport> GetAllBugReports() { var result = new List <VmBugReport>(); contextManager.ExecuteWriter(unitOfWork => { var bugReportRepository = unitOfWork.CreateRepository <IBugReportRepository>(); var resultTemp = bugReportRepository.All() .Select(x => new BugReport() { Id = x.Id, Created = x.Created, Description = x.Description, CreatedBy = x.CreatedBy, Modified = x.Modified, ModifiedBy = x.ModifiedBy, Name = x.Name, Version = x.Version }); result = translationManager.TranslateAll <BugReport, VmBugReport>(resultTemp).ToList(); }); return(result); }