public AuthorsService(IDatabaseConnectionService con)
{
_con = con.GetDatebaseConnection();
_con.CreateTable <Author>();
//_con.Insert(new Author("James", "Braun"));
//_con.Insert(new Author("Fedor", "Dostoevskiy"));
}
public MigrationManager(IDatabaseConnectionService databaseConnectionService, IMigrationScriptConverter migrationScriptConverter, string initMigrationScriptFullPath, MigrationStrategy migrationStrategy)
{
this._databaseConnectionService = databaseConnectionService;
this._migrationScriptConverter = migrationScriptConverter;
this._initMigrationScriptFullPath = initMigrationScriptFullPath;
this._migrationStrategy = migrationStrategy;
}
private void FileValidated(IDatabaseConnectionService databaseConnection, FilePayload filePayload)
{
DbParameter downloadId = CreateDownloadIdParameter(databaseConnection, filePayload.DownloadId);
DbParameter fileUtcDateTime =
databaseConnection.CreateParameter("@FileUtcDateTime", DbType.DateTime, ParameterDirection.Input);
fileUtcDateTime.Value = filePayload.FileUtcDateTime;
DbParameter filePath = databaseConnection.CreateParameter("@FilePath", DbType.String,
ParameterDirection.Input);
filePath.Value = filePayload.UploadPath;
DbParameter fileName = databaseConnection.CreateParameter("@FileName", DbType.String,
ParameterDirection.Input);
fileName.Value = filePayload.DownloadFileName;
DbParameter fileExtension = databaseConnection.CreateParameter("@FileExtension", DbType.String,
ParameterDirection.Input);
fileExtension.Value = filePayload.DownloadFileExtension;
databaseConnection.ExecuteStoredProcedure(Constants.FileDownloadDatabase.FileValidatedProcedureName,
new List <DbParameter>
{
downloadId,
fileUtcDateTime,
filePath,
fileName,
fileExtension
});
}
public IdentityRepository(IDatabaseConnectionService databaseConnection,
IDatabaseActions databaseActions,
IDatabaseConnectionService connectionService) : base(databaseActions, connectionService)
{
_sqlConnection = databaseConnection.Create();
_connectionService = connectionService;
}
private static void Init(string[] args)
{
string baseDirectory = AppDomain.CurrentDomain.BaseDirectory;
string initMigrationScriptPath = string.Format("{0}{1}", baseDirectory, "V0.0.0_InitMigrationTable.sql");
_artifactContentFolder = string.Format("{0}{1}", baseDirectory, "artifact");
Console.WriteLine("========== Row Settings ==========");
Console.WriteLine(args == null ? string.Empty : string.Join(" - ", args));
Console.WriteLine("========================================");
_settings = new Settings(args);
if (_settings == null)
{
throw new ArgumentException("Args empty or not valid");
}
Console.WriteLine("========== Settings ==========");
Console.WriteLine(JsonSerializer.Serialize(_settings, new JsonSerializerOptions()
{
WriteIndented = true, IgnoreNullValues = true
}));
Console.WriteLine("========================================");
WaitForKey(_settings.DebugMode);
ExtractArtifactTo(_settings.ArtifactPath, _artifactContentFolder);
_migrationScriptsFolder = GetScriptMigrationFolderPath(_artifactContentFolder, _settings.MigrationScriptsFolderName);
_databaseConnection = new DatabaseConnectionService(_settings.ConnectionString, DatabaseType.SqlServer2012, SqlClientFactory.Instance);
_migrationScriptConverter = new MigrationScriptConverter();
_migrationManager = new MigrationManager(_databaseConnection, _migrationScriptConverter, initMigrationScriptPath, _settings.MigrationStrategy);
}
public CountryRepository(IDatabaseConnectionService databaseConnection,
IDatabaseActions databaseActions,
IDatabaseConnectionService connectionService) : base(databaseActions, connectionService)
{
_sqlConnection = databaseConnection.Create();
_databaseActions = databaseActions;
}
private AddUserDataParameters CreateAddUserDataParameters(IDatabaseConnectionService databaseConnection)
{
return(new AddUserDataParameters
{
DownloadId = CreateDownloadIdParameter(databaseConnection),
LineNumber = CreateLineNumberParameter(databaseConnection),
FahUserName =
databaseConnection.CreateParameter("@FAHUserName", DbType.String, ParameterDirection.Input,
150),
TotalPoints =
databaseConnection.CreateParameter("@TotalPoints", DbType.Int64, ParameterDirection.Input),
WorkUnits =
databaseConnection.CreateParameter("@WorkUnits", DbType.Int64, ParameterDirection.Input),
TeamNumber =
databaseConnection.CreateParameter("@TeamNumber", DbType.Int64, ParameterDirection.Input),
FriendlyName =
databaseConnection.CreateParameter("@FriendlyName", DbType.String, ParameterDirection.Input,
125),
BitcoinAddress =
databaseConnection.CreateParameter("@BitcoinAddress", DbType.String,
ParameterDirection.Input, 50),
ReturnValue = databaseConnection.CreateParameter("@ReturnValue", DbType.Int32,
ParameterDirection.ReturnValue)
});
}
public DbParameter CreateDownloadIdParameter(IDatabaseConnectionService databaseConnection, int downloadId)
{
DbParameter downloadIdParameter = CreateDownloadIdParameter(databaseConnection);
downloadIdParameter.Value = downloadId;
return(downloadIdParameter);
}
public TypesService(IUnityContainer container, IDatabaseConnectionService connectionService, IEventAggregator eventAggragator)
{
dbConnection = connectionService;
eventAggragator.GetEvent <ClothesListRefreshRequestedEvent>().Subscribe(UpdateTypesList);
updating = false;
UpdateTypesList();
}
public DatabaseConnectionDetailsViewModelFactory(
ILoggerFactory loggerFactory,
IDatabaseConnectionService databaseConnectionService)
{
m_loggerFactory = loggerFactory;
m_databaseConnectionService = databaseConnectionService;
}
private void UpdateToLatest(IDatabaseConnectionService databaseConnection)
{
int numberOfRowsEffected =
databaseConnection.ExecuteStoredProcedure(Constants
.FileDownloadDatabase.UpdateToLatestStoredProcedureName);
LogVerbose($"'{numberOfRowsEffected}' rows were effected");
}
private void EnsureDatabaseConnectionOpened(IDatabaseConnectionService databaseConnection)
{
if (databaseConnection.ConnectionState == ConnectionState.Closed)
{
databaseConnection.Open();
LogVerbose(DatabaseConnectionSuccessfulLogMessage);
}
}
private DbParameter CreateErrorMessageParameter(IDatabaseConnectionService databaseConnection, string message)
{
DbParameter errorMessage = databaseConnection.CreateParameter("@ErrorMessage", DbType.String,
ParameterDirection.Input);
errorMessage.Value = message;
return(errorMessage);
}
public DbParameter CreateDownloadIdParameter(IDatabaseConnectionService databaseConnection,
ParameterDirection direction)
{
DbParameter downloadIdParameter = CreateDownloadIdParameter(databaseConnection);
downloadIdParameter.Direction = direction;
return(downloadIdParameter);
}
public DbParameter CreateErrorMessageParameter(IDatabaseConnectionService databaseConnection,
StatsUploadResult statsUploadResult)
{
string message =
errorMessageService.GetErrorMessage(statsUploadResult.FailedReason, StatsDownloadService.StatsUpload);
return(CreateErrorMessageParameter(databaseConnection, message));
}
public DbParameter CreateErrorMessageParameter(IDatabaseConnectionService databaseConnection,
FileDownloadResult fileDownloadResult)
{
FilePayload filePayload = fileDownloadResult.FilePayload;
string message = errorMessageService.GetErrorMessage(fileDownloadResult.FailedReason, filePayload,
StatsDownloadService.FileDownload);
return(CreateErrorMessageParameter(databaseConnection, message));
}
public AddressRepository(IDatabaseConnectionService databaseConnection,
IDatabaseActions databaseActions,
IDatabaseConnectionService connectionService) : base(databaseActions,
connectionService)
{
_sqlConnection = databaseConnection.Create();
_databaseActions = databaseActions;
_connectionService = connectionService;
}
public ClothesServices(ImageService imageService, IDatabaseConnectionService connectionService, IEventAggregator eventAggregator, IFilteringService filteringService)
{
this.eventAggregator = eventAggregator;
dbConnection = connectionService;
this.imageService = imageService;
this.filteringService = filteringService;
eventAggregator.GetEvent <ClothesListRefreshRequestedEvent>().Subscribe(RefreshClothesListAsync);
eventAggregator.GetEvent <RefreshClothesFilteringEvent>().Subscribe(RefreshFiltering);
}
public static void SetUpDatabaseConnectionServiceReturns(
IDatabaseConnectionService databaseConnectionServiceMock, ParameterDirection parameterDirection)
{
databaseConnectionServiceMock.CreateParameter(Arg.Any <string>(), Arg.Any <DbType>(), parameterDirection)
.Returns(CreateParameterMock);
databaseConnectionServiceMock.CreateParameter(Arg.Any <string>(), Arg.Any <DbType>(),
parameterDirection, Arg.Any <int>()).Returns(CreateParameterMockWithSize);
}
private void FileValidationStarted(IDatabaseConnectionService databaseConnection, FilePayload filePayload)
{
DbParameter downloadId = CreateDownloadIdParameter(databaseConnection, filePayload.DownloadId);
databaseConnection.ExecuteStoredProcedure(Constants.FileDownloadDatabase.FileValidationStartedProcedureName,
new List <DbParameter> {
downloadId
});
}
private void StatsUploadFinished(DbTransaction transaction, IDatabaseConnectionService databaseConnection,
int downloadId)
{
DbParameter download = CreateDownloadIdParameter(databaseConnection, downloadId);
databaseConnection.ExecuteStoredProcedure(transaction,
Constants.StatsUploadDatabase.StatsUploadFinishedProcedureName, new List <DbParameter> {
download
});
}
public UserStore(IDatabaseConnectionService databaseConnection)
{
SqlConnection sqlConnection = databaseConnection.CreateConnection();
_usersTable = new UsersTable(sqlConnection);
_usersRolesTable = new UsersRolesTable(sqlConnection);
_rolesTable = new RolesTable(sqlConnection);
_usersClaimsTable = new UsersClaimsTable(sqlConnection);
_usersLoginsTable = new UsersLoginsTable(sqlConnection);
}
public DatabaseConnectionDetailsBaseViewModel(
IDatabaseConnectionService databaseConnectionService,
int databaseConnectionId)
{
m_databaseConnectionService = databaseConnectionService;
m_databaseConnectionId = databaseConnectionId;
DatabaseConnectionTypes = Enum.GetValues(typeof(DatabaseConnectionType)).Cast <DatabaseConnectionType>();
}
protected override void RegisterTypes(IContainerRegistry containerRegistry)
{
containerRegistry.RegisterForNavigation <NavigationPage>("Navigation");
containerRegistry.RegisterForNavigation <MainPage, MainPageViewModel>("Index");
DBService = this.Container.Resolve <IDatabaseConnectionService>();
containerRegistry.RegisterInstance <IBookService>(new BookService(DBService));
containerRegistry.RegisterInstance <IAuthorService>(new AuthorsService(DBService));
containerRegistry.RegisterInstance <IPublisherService>(new PublisherService(DBService));
}
private AddUserRejectionParameters CreateAddUserRejectionParameters(
IDatabaseConnectionService databaseConnection)
{
return(new AddUserRejectionParameters
{
DownloadId = CreateDownloadIdParameter(databaseConnection),
LineNumber = CreateLineNumberParameter(databaseConnection),
RejectionReason =
statsDownloadDatabaseParameterService.CreateRejectionReasonParameter(databaseConnection)
});
}
public void CreateDatabaseConnectionAndExecuteAction(Action <IDatabaseConnectionService> action)
{
string connectionString = GetConnectionString();
int? commandTimeout = GetCommandTimeout();
EnsureValidConnectionString(connectionString);
IDatabaseConnectionService databaseConnection =
CreateDatabaseConnection(loggingService, connectionString, commandTimeout);
EnsureDatabaseConnectionOpened(databaseConnection);
action?.Invoke(databaseConnection);
}
public DatabaseConnectionCreateViewModel(
ILoggerFactory loggerFactory,
IDatabaseConnectionService databaseConnectionService) : base(databaseConnectionService, 0)
{
m_logger = loggerFactory.CreateLogger <DatabaseConnectionCreateViewModel>();
Name = "New Connection";
SelectedType = DatabaseConnectionType.SqlServerLocalDB;
Server = String.Empty;
Database = String.Empty;
UserId = String.Empty;
}
private int FileDownloadStarted(IDatabaseConnectionService databaseConnection)
{
DbParameter downloadId =
statsDownloadDatabaseParameterService.CreateDownloadIdParameter(databaseConnection,
ParameterDirection.Output);
databaseConnection.ExecuteStoredProcedure(Constants.FileDownloadDatabase.FileDownloadStartedProcedureName,
new List <DbParameter> {
downloadId
});
return((int)downloadId.Value);
}
private void StatsUploadError(IDatabaseConnectionService databaseConnection,
StatsUploadResult statsUploadResult)
{
DbParameter downloadId = CreateDownloadIdParameter(databaseConnection, statsUploadResult.DownloadId);
DbParameter errorMessage =
statsDownloadDatabaseParameterService.CreateErrorMessageParameter(databaseConnection,
statsUploadResult);
ExecuteStoredProcedure(databaseConnection, Constants.StatsUploadDatabase.StatsUploadErrorProcedureName,
new List <DbParameter> {
downloadId, errorMessage
});
}
public DatabaseConnectionEditViewModel(
ILoggerFactory loggerFactory,
IDatabaseConnectionService databaseConnectionService,
int databaseConnectionId) : base(databaseConnectionService, databaseConnectionId)
{
m_logger = loggerFactory.CreateLogger <DatabaseConnectionEditViewModel>();
DatabaseConnection databaseConnection = m_databaseConnectionService.Get(m_databaseConnectionId);
Name = databaseConnection.Name;
SelectedType = databaseConnection.Type;
Server = databaseConnection.Server;
Database = databaseConnection.Database;
UserId = databaseConnection.UserId;
}
