public override void Up() { RegisterDbContext db = new RegisterDbContext(); var queryResultsRegister = from r in db.RegisterItems where r.statusId == "NotAccepted" || r.statusId == "Accepted" || r.statusId == "Experimental" || r.statusId == "Deprecated" || r.statusId == "Candidate" || r.statusId == "InProgress" || r.statusId == "Proposal" select r; List <RegisterItem> registers = queryResultsRegister.ToList(); foreach (RegisterItem item in registers) { if (item.statusId == "NotAccepted" || item.statusId == "Proposal" || item.statusId == "InProgress" || item.statusId == "Candidate" || item.statusId == "Experimental" || item.statusId == "Deprecated") { item.statusId = "Submitted"; } if (item.statusId == "Accepted") { item.statusId = "Valid"; } Sql("UPDATE RegisterItems SET statusId = '" + item.statusId + "' WHERE (systemId = '" + item.statusId.ToString() + "')"); } }
public AccessControlService(RegisterDbContext db) { _registerItemService = new RegisterItemService(db); _registerService = new RegisterService(db); _organizationService = new OrganizationsService(db); _userAuthorization = new UserAuthorization(); }
private OrganizationsService CreateService(IEnumerable <Organization> listOfOrganizations) { RegisterDbContext dbContextMock = CreateTestDbContext(listOfOrganizations); var service = new OrganizationsService(dbContextMock); return(service); }
public AlertsController(RegisterDbContext dbContext, IRegisterItemService registerItemServive, IRegisterService registerService, IAccessControlService accessControlService) { _dbContext = dbContext; _registerItemService = registerItemServive; _registerService = registerService; _accessControlService = accessControlService; }
public SubregisterController(ITranslationService translationService, RegisterDbContext dbContex, IRegisterItemService registerItemService, IRegisterService registerService, IAccessControlService accessControlService) { _db = dbContex; _registerService = registerService; _registerItemService = registerItemService; _accessControlService = accessControlService; _translationService = translationService; }
public CodelistValuesController(IRegisterItemService registerItemService, IRegisterService registerService, IAccessControlService accessControlService, ITranslationService translationService, RegisterDbContext dbContext) { _registerItemService = registerItemService; _registerService = registerService; _accessControlService = accessControlService; _translationService = translationService; _db = dbContext; }
public OrganizationsController(RegisterDbContext dbContext, IRegisterService registerService, IRegisterItemService registerItemService, IAccessControlService accessControlService, ITranslationService translationService) { _dbContext = dbContext; _registerService = registerService; _registerItemService = registerItemService; _accessControlService = accessControlService; _translationService = translationService; }
public EPSGsController(ITranslationService translationService, RegisterDbContext dbContext, IRegisterItemService registerItemService, IRegisterService registerService, IAccessControlService accessControlService) { db = dbContext; _registerItemService = registerItemService; _registerService = registerService; _accessControlService = accessControlService; _translationService = translationService; }
public MareanoDatasetService(RegisterDbContext dbContext) { _dbContext = dbContext; _registerService = new RegisterService(_dbContext); _datasetDeliveryService = new DatasetDeliveryService(_dbContext); _registerItemService = new RegisterItemService(_dbContext); _metadataService = new MetadataService(_dbContext); }
public DatasetService(RegisterDbContext context) { _context = context; _versioningService = new VersioningService(_context); _registerService = new RegisterService(_context); _registerItemService = new RegisterItemService(_context); _datasetDeliveryService = new DatasetDeliveryService(_context); _coverageService = new CoverageService(_context); }
// *** HJELPEMETODER private DatasetsController CreateController(RegisterDbContext dbContext, IRegisterService registerService, IRegisterItemService registerItemService, IAccessControlService accessControlService, IDatasetDeliveryService datasetDeliveryService, ITranslationService translationService, IDatasetService datasetService) { var controller = new DatasetsController(dbContext, registerItemService, registerService, accessControlService, datasetDeliveryService, translationService, datasetService, null); return(controller); }
public InspireDatasetService(RegisterDbContext dbContext) { _dbContext = dbContext; _registerService = new RegisterService(_dbContext); _registerItemService = new RegisterItemService(_dbContext); _datasetDeliveryService = new DatasetDeliveryService(_dbContext); _metadataService = new MetadataService(_dbContext); _synchronizationService = new SynchronizationService(_dbContext); }
public GeodatalovDatasetsController(RegisterDbContext dbContext, IGeodatalovDatasetService geodatalovDatasetService, IAccessControlService accessControllService, IRegisterService registerService, IRegisterItemService registerItemService, IDatasetDeliveryService datasetDeliveryService) { _db = dbContext; _geodatalovDatasetService = geodatalovDatasetService; _accessControlService = accessControllService; _metadataService = new MetadataService(_db); _registerService = registerService; _registerItemService = registerItemService; _datasetDeliveryService = datasetDeliveryService; }
public DocumentsController(RegisterDbContext dbContext, INotificationService notificationService, ITranslationService translationService, IRegisterService registerService, IRegisterItemService registerItemService, IAccessControlService accessControlService, IDocumentService documentService) { db = dbContext; _registerItemService = registerItemService; _registerService = registerService; _accessControlService = accessControlService; _notificationService = notificationService; _translationService = translationService; _documentService = documentService; }
public DatasetsController(RegisterDbContext dbContext, IRegisterItemService registerItemService, IRegisterService registerService, IAccessControlService accessControllService, IDatasetDeliveryService datasetDeliveryService, ITranslationService translationService, IDatasetService datasetService, IStatusReportService statusReportService) { db = dbContext; _registerItemService = registerItemService; _registerService = registerService; _accessControlService = accessControllService; _datasetDeliveryService = datasetDeliveryService; _translationService = translationService; _datasetService = datasetService; _statusReportService = statusReportService; }
public ApiRootController(RegisterDbContext dbContext, ISearchService searchService, IRegisterService registerService, IRegisterItemService registerItemService, IInspireDatasetService inspireDatasetService, IInspireMonitoringService inspireMonitoringService, IAccessControlService accessControlService, ISynchronizationService synchronizationService, IStatusReportService statusReportService) { _registerItemService = registerItemService; _inspireDatasetService = inspireDatasetService; _searchService = searchService; _registerService = registerService; _inspireMonitoringService = inspireMonitoringService; _accessControlService = accessControlService; _synchronizationService = synchronizationService; _statusReportService = statusReportService; db = dbContext; }
public static IServiceCollection UseMigrations(this IServiceCollection serviceCollection, string connectionString) { serviceCollection.AddScoped <IMigrationContext>((serviceProvider) => { var ctxOptions = new DbContextOptionsBuilder <RegisterDbContext>() .UseSqlServer(connectionString) .Options; var context = new RegisterDbContext(ctxOptions); return(context); }); return(serviceCollection); }
public RegistersController(ITranslationService translationService, RegisterDbContext dbContext, IRegisterItemService registerItemService, ISearchService searchService, IVersioningService versioningService, IRegisterService registerService, IAccessControlService accessControlService, IInspireDatasetService inspireDatasetService, IGeodatalovDatasetService geodatalovService, IInspireMonitoringService inspireMonitoringService, ISynchronizationService synchronizationService, IStatusReportService statusReportService) { _db = dbContext; _registerItemService = registerItemService; _searchService = searchService; _versioningService = versioningService; _registerService = registerService; _accessControlService = accessControlService; _translationService = translationService; _inspireDatasetService = inspireDatasetService; _geodatalovDatasetService = geodatalovService; _inspireMonitoringService = inspireMonitoringService; _synchronizationService = synchronizationService; _statusReportService = statusReportService; }
public static IWebHost UpgradeRegisterDb(this IWebHost webHost) { var connectionString = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build().GetConnectionString("RegisterDb"); var options = new DbContextOptionsBuilder <RegisterDbContext>() .UseSqlServer(connectionString) .Options; var dbContext = new RegisterDbContext(options); dbContext.Database.Migrate(); return(webHost); }
public void InitializeDb() { var connectionString = ConfigurationManager.AppSettings["DbConnectionString"]; var apiUrl = ConfigurationManager.AppSettings["ApiUrl"]; var productsRepository = new ProductsRepository(connectionString); var barcodesRepository = new BarcodesRepository(connectionString); var productsApiService = new ProductsApiService(apiUrl); var allProducts = productsApiService.GetAllProducts(); var context = new RegisterDbContext(connectionString); context.Database.EnsureDeleted(); context.Database.EnsureCreated(); var barcodes = allProducts.Data.SelectMany(s => s.BarCodes); productsRepository.Add(allProducts.Data); barcodesRepository.Add(barcodes); }
private string mapOrganizationSeoName(string seoName) { RegisterDbContext db = new RegisterDbContext(); string organizationName = seoName; var queryResultsRegisterItem = from o in db.RegisterItems where o.seoname == seoName select o.name; var name = queryResultsRegisterItem.FirstOrDefault(); organizationName = name.ToString(); db.Dispose(); return(organizationName); }
public static IServiceCollection UseRegisterDbContext(this IServiceCollection serviceCollection, string connectionString, IsolationLevel level = IsolationLevel.ReadUncommitted) { //First, configure the SqlConnection and open it //This is done for every request/response serviceCollection.AddScoped <DbConnection>((serviceProvider) => { var dbConnection = new SqlConnection(connectionString); dbConnection.Open(); return(dbConnection); }); //Start a new transaction based on the SqlConnection //This is done for every request/response serviceCollection.AddScoped <DbTransaction>((serviceProvider) => { var dbConnection = serviceProvider .GetService <DbConnection>(); return(dbConnection.BeginTransaction(level)); }); //Create DbOptions for the DbContext, use the DbConnection //This is done for every request/response serviceCollection.AddScoped <DbContextOptions>((serviceProvider) => { var dbConnection = serviceProvider.GetService <DbConnection>(); return(new DbContextOptionsBuilder <RegisterDbContext>() .UseSqlServer(dbConnection) .Options); }); //Finally, create the DbContext, using the transaction //This is done for every request/response serviceCollection.AddScoped <RegisterDbContext>((serviceProvider) => { var transaction = serviceProvider.GetService <DbTransaction>(); var options = serviceProvider.GetService <DbContextOptions>(); var context = new RegisterDbContext(options); context.Database.UseTransaction(transaction); return(context); }); return(serviceCollection); }
public static string StatusBeskrivelse(Models.Register register) { RegisterDbContext db = new RegisterDbContext(); var queryResults = from s in db.Statuses select s; string forslag = translation.Registers.Proposal + ":
"; string gyldig = translation.Registers.Valid + ":
"; string historiske = translation.Registers.Historical + ":
"; foreach (Status s in queryResults) { if (s.group == "suggested") { forslag += "- " + s.DescriptionTranslated() + "
"; } if (s.group == "historical") { historiske += "- " + s.DescriptionTranslated() + "
"; } if (s.group == "current") { if (register.name != "Produktspesifikasjoner") { if (s.value != "Sosi-valid") { gyldig += "- " + s.DescriptionTranslated() + "
"; } } else { gyldig += "- " + s.DescriptionTranslated() + "
"; } } } string beskrivelse = translation.Registers.StatusAvailable + ":

" + forslag + "
" + gyldig + "
" + historiske; return(beskrivelse); }
public bool AddtoTestRegister(TestRegister test) { try { using (regDb = new RegisterDbContext()) { regDb.TestRegisters.Add(test); int status = regDb.SaveChanges(); if (status > 0) { Success = true; } else { } } return(Success); } catch (Exception e) { throw e; } }
public StatusReportService(RegisterDbContext dbContext) { _dbContext = dbContext; }
public ShipmentService(RegisterDbContext context) { this.context = context; }
public GenericRepository(RegisterDbContext registerDbContext) { _dbContext = registerDbContext; }
public AlertApiController(RegisterDbContext dbContext, IRegisterItemService registerItemServive, IRegisterService registerService) { _dbContext = dbContext; _registerItemService = registerItemServive; _registerService = registerService; }
public SynchronizationService(RegisterDbContext dbContext) { _dbContext = dbContext; }
public UsersModel(RegisterDbContext registerDbContext) { _registerDbContext = registerDbContext; Users = _registerDbContext.Users.ToList(); }