public void ImportGeoIPCitiesList(List <IBulkCopyItem> geopIpBlocks, List <IBulkCopyItem> geoIpCities, List <ColumnDefinition> geoIpBlockDefinitions, List <ColumnDefinition> geoIpCityDefinitions, Action <double> setProgress)
{
using (var db = ApiDataContext.Create())
{
db.ExecuteCommand("Delete FROM GeoIPCityBlock");
db.ExecuteCommand("Delete FROM GeoIPCity");
}
//Import geo ip city Blocks
setProgress.Invoke(0);
BulkCopyCollection bulkCopyCollection = BulkCopyCollection.Create("GeoIPCityBlock", geopIpBlocks.Count, geoIpBlockDefinitions);
bulkCopyCollection.BulkCopyItems.AddRange(geopIpBlocks);
BulkUploadToSql bulkUploadToSql = BulkUploadToSql.Load(bulkCopyCollection, setProgress);
bulkUploadToSql.Flush();
setProgress.Invoke(0);
//Import geo ip city items
bulkCopyCollection = BulkCopyCollection.Create("GeoIPCity", geoIpCities.Count, geoIpCityDefinitions);
bulkCopyCollection.BulkCopyItems.AddRange(geoIpCities);
bulkUploadToSql = BulkUploadToSql.Load(bulkCopyCollection, setProgress);
bulkUploadToSql.Flush();
setProgress.Invoke(1);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="jwtOptions"></param>
/// <param name="loggerFactory"></param>
/// <param name="cloutApiDataContext"></param>
public JwtController(IOptions <JwtIssuerOptions> jwtOptions, ILoggerFactory loggerFactory, ApiDataContext cloutApiDataContext)
{
_jwtOptions = jwtOptions.Value;
ThrowIfInvalidOptions(_jwtOptions);
_logger = loggerFactory.CreateLogger <JwtController>();
_serializerSettings = new JsonSerializerSettings
{
Formatting = Formatting.Indented
};
_dbContext = cloutApiDataContext;
_dbContext.Database.EnsureCreated();
var jwtCount = _dbContext.JwtUsers.Count();
if (jwtCount == 0)
{
_dbContext.JwtUsers.Add(new JwtUser {
UserName = "******",
Password = _tokenizer.GetSHA1HashData("DefaultApplicationPassword")
});
_dbContext.SaveChanges();
}
}
/// <summary>
/// Constructor for Controller
/// </summary>
/// <param name="apiDataContext">API Data Context</param>
/// <param name="logger">ILoggerFactory</param>
public ContributorBaseApiController(ApiDataContext apiDataContext, ILoggerFactory logger)
{
_logger = logger.CreateLogger <ContributorBaseApiController>();
_dbContext = apiDataContext;
_dbContext.Database.EnsureCreated();
var count = _dbContext.Contributors.Count();
if (count == 0)
{
// Add default administrator
_dbContext.Contributors.Add(
new Contributor
{
Name = "Default Administrator",
Description = "Default system administrator",
Email = "*****@*****.**",
Password = _tokenizer.GetSHA1HashData("Default#Admin#Password777"),
Comments = "This account should be disabled or deleted (in favor of a better admin account) in production"
}
);
// Add default unit tester
_dbContext.Contributors.Add(
new Contributor
{
Name = "Default Unit Tester",
Description = "Default unit test run account",
Email = "*****@*****.**",
Password = _tokenizer.GetSHA1HashData("Unit#Test#Password2018"),
Comments = "This account should be disabled or deleted in production"
}
);
_dbContext.SaveChanges();
}
}
public GeoIPCountryBo GetGeoIpCountry(long ipNumber)
{
using (var db = ApiDataContext.Create())
{
GeoIPCountry ipLookup = db.GeoIPCountries.FirstOrDefault(x => ipNumber >= x.IPFrom && ipNumber <= x.IPTo);
return(ObjectMapper.Map <GeoIPCountry, GeoIPCountryBo>(ipLookup));
}
}
public RefreshGeneratedTokenCommandHandler(UserManager <UserEntity> manager, ApiDataContext context, IMediator mediator, TokenValidationParameters tokenValidationParameters, IMapper mapper)
{
_manager = manager;
_context = context;
_mediator = mediator;
_tokenValidationParameters = tokenValidationParameters;
_mapper = mapper;
}
public TimeSeriesController(ApiDataContext context, ITimeSeriesRepository timeSeriesRepository, IUserEventRepository userEventRepository, IGenerate<TimeSeries> generateTimeSeries, IFeatureRepository featureRepository, IBackgroundJobClient backgroundJobClient)
{
this.context = context;
this.timeSeriesRepository = timeSeriesRepository;
this.userEventRepository = userEventRepository;
this.generateTimeSeries = generateTimeSeries;
this.featureRepository = featureRepository;
this.backgroundJobClient = backgroundJobClient;
}
public DbAccess()
{
// TODO use secrets
var conString = "Server=localhost,1433\\Catalog=sql1;Database=sql1;User=SA;Password=<YourStrong@Passw0rd>;";
var optionsBuilder = new DbContextOptionsBuilder <ApiDataContext>();
optionsBuilder.UseSqlServer(conString);
DbContext = new ApiDataContext(optionsBuilder.Options);
}
public static void SetupUnitTest(TestContext myContext)
{
var dataConfiguration = new DataConfiguration();
_contextOptions = new DbContextOptionsBuilder <ApiDataContext>()
.UseSqlServer(@dataConfiguration.ConnectionString).Options;
_dbContext = new ApiDataContext(_contextOptions);
_logger = new Mock <ILoggerFactory>().Object;
using (var userApi = new ContributorApiController(_dbContext, _logger))
{
var userResponse = userApi.LoginUser(dataConfiguration.LoginEmail, dataConfiguration.LoginPassword) as OkObjectResult;
loginToken = userResponse.Value.ToString();
}
}
public static bool CanConnectToDatabase()
{
try
{
using (var db = ApiDataContext.Create())
{
return(db.DatabaseExists());
}
}
catch (Exception ex)
{
return(false);
}
}
public void ImportGeoIPCountryList(List <IBulkCopyItem> geopIpCountries, List <ColumnDefinition> columnDefinitions, Action <double> setProgress)
{
setProgress.Invoke(0);
using (var db = ApiDataContext.Create())
{
db.ExecuteCommand("TRUNCATE TABLE GeoIPCountry");
}
BulkCopyCollection bulkCopyCollection = BulkCopyCollection.Create("GeoIPCountry", geopIpCountries.Count, columnDefinitions);
bulkCopyCollection.BulkCopyItems.AddRange(geopIpCountries);
BulkUploadToSql bulkUploadToSql = BulkUploadToSql.Load(bulkCopyCollection, setProgress);
bulkUploadToSql.Flush();
setProgress.Invoke(1);
}
public GeoIPCityBo GetGeoIpCity(long ipNumber)
{
GeoIPCity gerIpCity = null;
using (var db = ApiDataContext.Create())
{
var lo = new DataLoadOptions();
lo.LoadWith <GeoIPCityBlock>(c => c.GeoIPCity);
db.LoadOptions = lo;
GeoIPCityBlock geoBlock = db.GeoIPCityBlocks.Where(x => x.IPFrom <= ipNumber && x.IPTo >= ipNumber).Take(1).SingleOrDefault();
if (geoBlock == null)
{
return(null);
}
gerIpCity = geoBlock.GeoIPCity;
}
var geoIpCityBo = ObjectMapper.Map <GeoIPCity, GeoIPCityBo>(gerIpCity);
return(geoIpCityBo);
}
public GetProgressesByCurrentUserQueryHandler(ApiDataContext context, IMapper mapper, ICurrentUserService currentUser)
{
_context = context;
_mapper = mapper;
_currentUser = currentUser;
}
public HistogramController(ApiDataContext context)
: this(context, new FeatureRepository(context), new BackgroundJobClient())
{
}
public HistogramController(ApiDataContext context, IFeatureRepository featureRepository, IBackgroundJobClient backgroundJobClient)
: this(new HistogramRepository(context), new UserEventRepository(context), new GenerateFeatureDecorator<Histogram>(new GenerateHistogram(), featureRepository), featureRepository, backgroundJobClient)
{
}
/// <summary>
/// Message API Controller
/// </summary>
/// <param name="apiDataContext">DbContext for EntityFramework</param>
/// <param name="logger">Injected ILoggerFactory</param>
/// <param name="_sendGridOptions"></param>
public MessageApiController(ApiDataContext apiDataContext, ILoggerFactory logger, IOptions <SendGridOptions> _sendGridOptions) : base(apiDataContext, logger)
{
this._sendGridOptions = _sendGridOptions.Value;
}
/// <summary>
/// TestField API Controller
/// </summary>
/// <param name="apiDataContext">DbContext for EntityFramework</param>
/// <param name="logger">Injected ILoggerFactory</param>
public TestFieldApiController(ApiDataContext apiDataContext, ILoggerFactory logger) : base(apiDataContext, logger)
{
}
public BooksRepository(ApiDataContext context)
{
_context = context;
}
public GetLessonWithoutAnswersQueryHandler(ApiDataContext context, IMapper mapper, ICurrentUserService currentUser)
{
_context = context;
_mapper = mapper;
_currentUser = currentUser;
}
public LogoutUserCommandHandler(ApiDataContext context, ICurrentUserService currentUser)
{
_context = context;
_currentUser = currentUser;
}
public LoginDomainService(ApiDataContext dc)
{
this.dc = dc;
}
public TimeSeriesController(ApiDataContext context, IFeatureRepository featureRepository)
: this(context, new TimeSeriesRepository(context), new UserEventRepository(context), new GenerateFeatureDecorator<TimeSeries>(new GenerateTimeSeries(),featureRepository), featureRepository, new BackgroundJobClient())
{
}
public TimeSeriesController(ApiDataContext context)
: this(context, new FeatureRepository(context))
{
}
public TimeSeriesRepository(ApiDataContext context)
{
this.context = context;
}
public LikeLessonCommandHandler(ApiDataContext context, ICurrentUserService currentUser)
{
_context = context;
_currentUser = currentUser;
}
public GetCommentsQueryHandler(ApiDataContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public ValidateQuizCommandHandler(ApiDataContext context, IMapper mapper, ICurrentUserService currentUser)
{
_context = context;
_mapper = mapper;
_currentUser = currentUser;
}
public UserEventRepository(ApiDataContext context)
{
this.context = context;
}
/// <summary>
/// Contributor API Controller
/// </summary>
/// <param name="apiDataContext">DbContext for EntityFramework</param>
/// <param name="logger">Injected ILoggerFactory</param>
public ContributorApiController(ApiDataContext apiDataContext, ILoggerFactory logger) : base(apiDataContext, logger)
{
}
public FeatureRepository(ApiDataContext context)
{
this.context = context;
}
public UserApplication(ApiDataContext dc, IDomainUnitOfWork uow)
{
this.uow = uow;
this.dc = dc;
}
public CategoryDomainService(ApiDataContext dc)
{
this.dc = dc;
}
public PackageDomainService(ApiDataContext dc)
{
this.dc = dc;
}
public HistogramRepository(ApiDataContext context)
{
this.context = context;
}
public BookingDomainService(ApiDataContext dc)
{
this.dc = dc;
}
public UpdateCourseScheduleCommandHandler(ApiDataContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public RegisterDomainService(ApiDataContext dc)
{
this.dc = dc;
}
public ActivityApplication(ApiDataContext dc, IDomainUnitOfWork uow, IMapper mapper)
{
this.uow = uow;
this.mapper = mapper;
this.dc = dc;
}
public ActivityDomainService(ApiDataContext dc, IWebHostEnvironment environment)
{
this.dc = dc;
this.environment = environment;
}
/// <summary>
/// Constructor for Controller
/// </summary>
/// <param name="apiDataContext">API Data Context</param>
/// <param name="logger">ILoggerFactory</param>
public ReviewBaseApiController(ApiDataContext apiDataContext, ILoggerFactory logger)
{
_logger = logger.CreateLogger <ReviewBaseApiController>();
_dbContext = apiDataContext;
_dbContext.Database.EnsureCreated();
}
