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();
}
