public TrackerRepository(IDatabaseConnectionProvider databaseConnectionProvider
, IExternalConnectionProvider otherConnectionStringProvider
)
{
_databaseConnectionProvider = databaseConnectionProvider;
_otherConnectionStringProvider = otherConnectionStringProvider;
}
/// <summary>
/// SQL Database Context constructor
/// </summary>
/// <param name="connectionStringProvider">Connection String Provider</param>
/// <param name="databaseConnectionProvider">Database Connection Provider</param>
/// <param name="databaseTransactionProvider">Database Transaction Provider</param>
protected DatabaseContextBase(IConnectionStringProvider connectionStringProvider,
IDatabaseConnectionProvider databaseConnectionProvider,
IDatabaseTransactionProvider databaseTransactionProvider)
{
_connectionStringProvider = connectionStringProvider ?? throw new ArgumentNullException(nameof(connectionStringProvider));
_databaseConnectionProvider = databaseConnectionProvider ?? throw new ArgumentNullException(nameof(databaseConnectionProvider));
DatabaseTransactionProvider = databaseTransactionProvider ?? throw new ArgumentNullException(nameof(databaseTransactionProvider));
}
public RegisterOdsInstanceCommand(IOdsInstanceFirstTimeSetupService odsInstanceFirstTimeSetupService
, IDatabaseConnectionProvider connectionProvider
, AdminAppIdentityDbContext identity)
{
_odsInstanceFirstTimeSetupService = odsInstanceFirstTimeSetupService;
_connectionProvider = connectionProvider;
_identity = identity;
}
public FakeSqlDatabaseContext(IConnectionStringProvider connectionStringProvider,
IDatabaseConnectionProvider databaseConnectionProvider,
IDatabaseTransactionProvider databaseTransactionProvider,
IStatementBuildProvider sqlStatementBuildProvider,
IDataModelPopulateProvider dataModelPopulateProvider)
: base(connectionStringProvider, databaseConnectionProvider, databaseTransactionProvider, sqlStatementBuildProvider, dataModelPopulateProvider)
{
}
/// <summary>
/// Initialization conctructor.
/// </summary>
public CourseSchedulesController(IDatabaseConnectionProvider databaseConnectionProvider, ISchedulingBusinessLogicComponent schedulingBusinessLogicComponent)
{
// Initialize the database connection provider.
this.databaseConnectionProvider = databaseConnectionProvider;
// Initialize the business logic components.
this.schedulingBusinessLogicComponent = schedulingBusinessLogicComponent;
}
/// <summary>
/// Initialization conctructor.
/// </summary>
public SessionsController(IDatabaseConnectionProvider databaseConnectionProvider, ISchedulingBusinessLogicComponent schedulingBusinessLogicComponent)
{
// Initialize the database connection provider.
this.databaseConnectionProvider = databaseConnectionProvider;
// Initialize the business logic components.
this.schedulingBusinessLogicComponent = schedulingBusinessLogicComponent;
}
public RegisterOdsInstanceModelValidator(AdminAppDbContext database
, ICloudOdsAdminAppSettingsApiModeProvider apiModeProvider
, IDatabaseValidationService databaseValidationService
, IDatabaseConnectionProvider databaseConnectionProvider
, bool validationMessageWithDetails = false)
{
_database = database;
_databaseValidationService = databaseValidationService;
_databaseConnectionProvider = databaseConnectionProvider;
var requiredNumericSuffixMessage = "'ODS Instance District / EdOrg Id' must not be empty.";
var inRangeMessage = "'ODS Instance District / EdOrg Id' must be a valid positive integer.";
var maxValue = int.MaxValue;
var minValue = 1;
var beUniqueValidationMsg = "Education Organization / District Id";
_mode = apiModeProvider.GetApiMode();
if (_mode == ApiMode.YearSpecific)
{
requiredNumericSuffixMessage = "'ODS Instance School Year' must not be empty.";
maxValue = 2099;
inRangeMessage = "'ODS Instance School Year' must be between 1900 and 2099.";
beUniqueValidationMsg = "school year";
minValue = 1900;
}
RuleFor(m => m.NumericSuffix).NotEmpty().WithMessage(requiredNumericSuffixMessage);
RuleFor(m => m.NumericSuffix)
.Must(BeWithinApplicationNameMaxLength)
.When(x => x.NumericSuffix != null);
RuleFor(m => m.NumericSuffix)
.Must(x => x <= maxValue && x >= minValue)
.When(x => x.NumericSuffix != null)
.WithMessage(inRangeMessage);
RuleFor(m => m.NumericSuffix)
.Must(BeAUniqueInstanceName)
.When(x => x.NumericSuffix != null)
.WithMessage(
x => $"An instance for this {beUniqueValidationMsg}{(validationMessageWithDetails ? $"({x.NumericSuffix})":"")} already exists.");
RuleFor(m => m.NumericSuffix)
.Must(BeValidOdsInstanceDatabase)
.When(x => x.NumericSuffix != null)
.WithMessage(
x => $"Could not connect to an ODS instance database for this {beUniqueValidationMsg}{(validationMessageWithDetails ? $"({x.NumericSuffix})":"")}.");
RuleFor(m => m.Description).NotEmpty();
RuleFor(m => m.Description)
.Must(BeAUniqueInstanceDescription)
.When(x => x.Description != null)
.WithMessage(
x => $"An instance with this description{(validationMessageWithDetails ? $"({beUniqueValidationMsg}: {x.NumericSuffix}, Description: {x.Description})":"")} already exists.");
}
public PoorMansDIFetchBookProcess(
IDatabaseConnectionProvider connProvider,
IFetchBookProvider bookProvider
)
{
_connProvider = connProvider;
_bookProvider = bookProvider;
_bookDataManager = new BookDataManager(_connProvider, _bookProvider);
}
/// <inheritdoc />
public IDatabaseContextBuilder WithDatabaseConnectionProvider(IDatabaseConnectionProvider databaseConnectionProvider)
{
if (databaseConnectionProvider == null)
{
throw new ArgumentNullException(nameof(databaseConnectionProvider));
}
DatabaseConnectionProvider = databaseConnectionProvider;
return(this);
}
public DatabaseViewsProvider(
IDatabaseConnectionProvider databaseConnectionProvider,
IDatabaseConnectionStringProvider connectionStringProvider)
{
_databaseConnectionProvider = Preconditions.ThrowIfNull(
databaseConnectionProvider, nameof(databaseConnectionProvider));
Preconditions.ThrowIfNull(connectionStringProvider, nameof(connectionStringProvider));
_connectionString = connectionStringProvider.GetConnectionString();
}
/// <summary>
/// Sql Database Context
/// </summary>
/// <param name="connectionStringProvider">Connection String Provider</param>
/// <param name="databaseConnectionProvider">Database Connection Provider</param>
/// <param name="databaseTransactionProvider">Database Transaction Provider</param>
/// <param name="sqlStatementBuildProvider">SQL Statement Build Provider</param>
/// <param name="dataModelPopulateProvider">Data Model Populate Provider</param>
public SqlDatabaseContext(IConnectionStringProvider connectionStringProvider,
IDatabaseConnectionProvider databaseConnectionProvider,
IDatabaseTransactionProvider databaseTransactionProvider,
IStatementBuildProvider sqlStatementBuildProvider,
IDataModelPopulateProvider dataModelPopulateProvider)
: base(connectionStringProvider, databaseConnectionProvider, databaseTransactionProvider)
{
_sqlStatementBuildProvider = sqlStatementBuildProvider ?? throw new ArgumentNullException(nameof(sqlStatementBuildProvider));
_dataModelPopulateProvider = dataModelPopulateProvider ?? throw new ArgumentNullException(nameof(dataModelPopulateProvider));
}
public BulkRegisterOdsInstancesModelValidator(AdminAppDbContext database
, ICloudOdsAdminAppSettingsApiModeProvider apiModeProvider
, IDatabaseValidationService databaseValidationService
, IDatabaseConnectionProvider databaseConnectionProvider
, IBulkRegisterOdsInstancesFiltrationService dataFilterService)
{
var mode = apiModeProvider.GetApiMode();
RuleFor(m => m.OdsInstancesFile)
.NotEmpty();
RuleFor(m => m.OdsInstancesFile.FileName).NotNull().Must(x => x.ToLower().EndsWith(".csv"))
.WithMessage("Please select a file with .csv format.");
When(m => m.OdsInstancesFile != null, () =>
{
RuleFor(m => m).SafeCustom(HaveValidHeaders);
});
When(m => m.OdsInstancesFile != null && !ValidHeadersRuleFailed, () =>
{
RuleFor(m => m).SafeCustom(HaveUniqueRecords);
});
When(
m => m.OdsInstancesFile != null && !UniquenessRuleFailed && !ValidHeadersRuleFailed, () =>
{
RuleFor(x => x)
.SafeCustom(
(model, context) =>
{
var validator = new RegisterOdsInstanceModelValidator(
database, apiModeProvider, databaseValidationService,
databaseConnectionProvider, true);
var newOdsInstancesToRegister = dataFilterService.FilteredRecords(model.DataRecords(), mode).ToList();
model.FilteredDataRecords = newOdsInstancesToRegister;
foreach (var record in newOdsInstancesToRegister)
{
var data = (RegisterOdsInstanceModel)record;
var results = validator.Validate(data);
if (!results.IsValid)
{
foreach (var failure in results.Errors)
{
_logger.Error($"Property: {failure.PropertyName} failed validation. Error: {failure.ErrorMessage}");
}
}
context.AddFailures(results);
}
});
});
}
public UserProfileDeletionManager(
IDatabaseConnectionProvider databaseConnectionProvider,
IUserProfileWriter userProfileWriter,
IListWriter listWriter,
ITodoItemsWriter todoItemsWriter)
{
_databaseConnectionProvider = databaseConnectionProvider;
_userProfileWriter = userProfileWriter;
_listWriter = listWriter;
_todoItemsWriter = todoItemsWriter;
}
public OrderRepository(IDatabaseConnectionProvider databaseConnectionProvider
,IExternalConnectionProvider otherConnectionStringProvider,
IProductMicroService productMicroService,
ICustomerMicroService customerMicroService
)
{
_databaseConnectionProvider = databaseConnectionProvider;
_otherConnectionStringProvider = otherConnectionStringProvider;
_productMicroService = productMicroService;
_customerMicroService = customerMicroService;
}
private IDatabaseContext CreateDatabaseContext(IConnectionStringProvider connectionStringProvider = null,
IDatabaseConnectionProvider databaseConnectionProvider = null,
IDatabaseTransactionProvider databaseTransactionProvider = null,
IStatementBuildProvider sqlStatementBuildProvider = null,
IDataModelPopulateProvider dataModelPopulateProvider = null,
bool useFalseContext = false)
{
connectionStringProvider ??= Substitute.For <IConnectionStringProvider>();
databaseConnectionProvider ??= Substitute.For <IDatabaseConnectionProvider>();
databaseTransactionProvider ??= Substitute.For <IDatabaseTransactionProvider>();
sqlStatementBuildProvider ??= Substitute.For <IStatementBuildProvider>();
dataModelPopulateProvider ??= new SqlDataModelPopulateProvider();
return(useFalseContext
? new FakeSqlDatabaseContext(connectionStringProvider, databaseConnectionProvider, databaseTransactionProvider, sqlStatementBuildProvider, dataModelPopulateProvider)
: new SqlDatabaseContext(connectionStringProvider, databaseConnectionProvider, databaseTransactionProvider, sqlStatementBuildProvider, dataModelPopulateProvider));
}
public BulkRegisterOdsInstancesModelValidator(AdminAppDbContext database
, ICloudOdsAdminAppSettingsApiModeProvider apiModeProvider
, IDatabaseValidationService databaseValidationService
, IDatabaseConnectionProvider databaseConnectionProvider)
{
RuleFor(m => m.OdsInstancesFile)
.NotEmpty();
RuleFor(m => m.OdsInstancesFile)
.Must(HaveUniqueRecords)
.When(m => m.OdsInstancesFile != null);
When(
m => m.OdsInstancesFile != null && !UniquenessRuleFailed, () =>
{
RuleFor(x => x.OdsInstancesFile)
.SafeCustom(
(model, context) =>
{
var validator = new RegisterOdsInstanceModelValidator(
database, apiModeProvider, databaseValidationService,
databaseConnectionProvider, true);
foreach (var record in model.DataRecords())
{
var results = validator.Validate(record);
if (!results.IsValid)
{
foreach (var failure in results.Errors)
{
_logger.Error($"Property: {failure.PropertyName} failed validation. Error: {failure.ErrorMessage}");
}
}
context.AddFailures(results);
}
});
});
}
public StudentEnrollmentByEthnicityQuery(IDatabaseConnectionProvider connectionProvider)
{
_connectionProvider = connectionProvider;
}
public RegisterOdsInstanceCommand(IOdsInstanceFirstTimeSetupService odsInstanceFirstTimeSetupService
, IDatabaseConnectionProvider connectionProvider)
{
_odsInstanceFirstTimeSetupService = odsInstanceFirstTimeSetupService;
_connectionProvider = connectionProvider;
}
protected override void OnAwake()
{
base.OnAwake();
databaseConnectionProvider = Components.GetComponent <IDatabaseConnectionProvider>().AssertNotNull();
}
public BulkRegisterOdsInstancesFiltrationService(AdminAppDbContext database,
IDatabaseConnectionProvider databaseConnectionProvider)
{
_database = database;
_databaseConnectionProvider = databaseConnectionProvider;
}
public PoorMansDIFetchBookProcess()
{
_connProvider = new DatabaseConnectionProvider();
_bookProvider = new FetchBookProvider(new SqlResourceLoader());
_bookDataManager = new BookDataManager(_connProvider, _bookProvider);
}
public TransactionManager(IDatabaseConnectionProvider databaseConnectionProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
}
public DatabaseSessionFactory(IDatabaseConnectionProvider connectionProvider)
{
_connectionProvider = connectionProvider;
}
public ListWriter(ListContext context, IDatabaseConnectionProvider databaseConnectionProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
}
/// <summary>
/// Initializes a new instance of the <see cref="BookDataManager"/> class.
/// </summary>
/// <param name="databaseConnectionProvider">The database connection provider.</param>
/// <param name="fetchBookProvider">The fetch book provider.</param>
public BookDataManager(IDatabaseConnectionProvider databaseConnectionProvider,
IFetchBookProvider fetchBookProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
_fetchBookProvider = fetchBookProvider;
}
public GetAllLocalEducationAgenciesQuery(IDatabaseConnectionProvider connectionProvider)
{
_databaseConnectionProvider = connectionProvider;
}
public GetSchoolYearsQuery(IDatabaseConnectionProvider databaseConnectionProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
}
public DatabaseRepository(IDatabaseConnectionProvider databaseConnectionProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
}
public TodoItemsReader(IDatabaseConnectionProvider databaseConnectionProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
}
public TotalEnrollmentQuery(IDatabaseConnectionProvider databaseConnectionProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
}
public StudentEnrollmentByRaceQuery(IDatabaseConnectionProvider connectionProvider)
{
_connectionProvider = connectionProvider;
}
public DatabaseValidationService(IDatabaseConnectionProvider connectionProvider)
{
_connectionProvider = connectionProvider;
}
public DatabaseCommandProvider(IDatabaseConnectionProvider databaseConnectionProvider, ITransactionWrapper transactionWrapper)
{
_databaseConnectionProvider = databaseConnectionProvider;
_transactionWrapper = transactionWrapper;
}
public SqlComparator(IDatabaseConnectionProvider connectionProviderProvider, ISqlCommandFactory commandFactory)
{
_commandFactory = commandFactory;
_connectionProvider = connectionProviderProvider;
}
public TransactionWrapper(IDatabaseConnectionProvider databaseConnectionProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
}
public StudentEconomicSituationReportQuery(IDatabaseConnectionProvider connectionProvider)
{
_connectionProvider = connectionProvider;
}
public UserProfileReader(ListContext context, IDatabaseConnectionProvider databaseConnectionProvider)
{
_databaseConnectionProvider = databaseConnectionProvider;
}
public InferInstanceService(IDatabaseConnectionProvider connectionProvider)
{
_connectionProvider = connectionProvider;
}
