public void SetUp()
{
var serverOpt = new MsSqlConnectionSettings()
{
ConnectionString = TestContextUtils.GetParameterOrDefault("sqlserver",
"Data Source=.;Initial Catalog=AuctionhouseDatabase;Integrated Security=False;User ID=sa;PWD=Qwerty1234;")
};
userRepository = new MsSqlUserRepository(serverOpt);
user = new User();
user.Register("test");
}
public void SetUp()
{
var serverOpt = new MsSqlConnectionSettings()
{
ConnectionString = TestContextUtils.GetParameterOrDefault("sqlserver",
"Data Source=.;Initial Catalog=AuctionhouseDatabase;Integrated Security=False;User ID=sa;PWD=Qwerty1234;")
};
auctionRepository = new MsSqlAuctionRepository(serverOpt);
user = new User();
user.Register("Test username");
user.AddCredits(1000);
user.MarkPendingEventsAsHandled();
}
private static void ConfigureServiceSettings(
IServiceCollection serviceCollection, MsSqlConnectionSettings sqlServerConnectionSettings,
RabbitMqSettings rabbitMqSettings, TimeTaskServiceSettings timeTaskServiceSettings,
ImageDbSettings imageDbSettings,
UserAuthDbContextOptions userAuthDbContextOptions,
CategoryNameServiceSettings categoryNameServiceSettings)
{
serviceCollection.AddSingleton(sqlServerConnectionSettings);
serviceCollection.AddSingleton(rabbitMqSettings);
serviceCollection.AddSingleton(categoryNameServiceSettings);
serviceCollection.AddSingleton(timeTaskServiceSettings);
serviceCollection.AddSingleton(imageDbSettings);
serviceCollection.AddSingleton(userAuthDbContextOptions);
}
public static void Configure <UserIdentityServiceImplT, AuctionCreateSessionServiceImplT, ResetLinkSenderServiceImplT>(
IServiceCollection serviceCollection,
MsSqlConnectionSettings eventStoreConnectionSettings,
RabbitMqSettings rabbitMqSettings,
TimeTaskServiceSettings timeTaskServiceSettings,
ImageDbSettings imageDbSettings,
UserAuthDbContextOptions userAuthDbContextOptions,
CategoryNameServiceSettings categoryNameServiceSettings
)
where UserIdentityServiceImplT : class, IUserIdentityService
where AuctionCreateSessionServiceImplT : class, IAuctionCreateSessionService
where ResetLinkSenderServiceImplT : class, IResetLinkSenderService
{
ConfigureServiceSettings(serviceCollection, eventStoreConnectionSettings, rabbitMqSettings,
timeTaskServiceSettings, imageDbSettings, userAuthDbContextOptions, categoryNameServiceSettings);
ConfigureAuthDbServices(serviceCollection);
ConfigureUserIdentitySessionService <UserIdentityServiceImplT>(serviceCollection);
ConfigureAuctionCreateSessionService <AuctionCreateSessionServiceImplT>(serviceCollection);
ConfigureImageServices(serviceCollection);
ConfigureDomainRepositories(serviceCollection);
ConfigureAuctionShedulerService(serviceCollection, timeTaskServiceSettings);
ConfigureDecoratedCommandHandlers(serviceCollection);
ConfigureResetLinkSenderService <ResetLinkSenderServiceImplT>(serviceCollection);
serviceCollection.AddScoped <CreateAuctionCommandHandlerDepedencies>();
serviceCollection.AddSingleton <IHTTPQueuedCommandStatusStorage, HTTPMemQueuedCommandStatusStorage>();
serviceCollection.AddScoped <WSQueuedCommandHandler>();
serviceCollection.AddScoped <HTTPQueuedCommandHandler>();
serviceCollection.AddScoped <MediatRCommandHandlerMediator>();
serviceCollection.AddScoped <EventBusCommandHandlerMediator>();
serviceCollection.AddScoped <HTTPQueuedCommandHandlerMediator>();
serviceCollection.AddScoped <ImmediateCommandMediator>();
serviceCollection.AddScoped <WSQueuedCommandMediator>();
serviceCollection.AddScoped <HTTPQueuedCommandMediator>();
serviceCollection.AddScoped <HTTPQueuedCommandStatusService>();
}
// IDisposable
protected virtual void Dispose(bool disposing)
{
if (!this.disposedValue) {
if (disposing) {
if (this.dbConnectionSettings != null)
this.dbConnectionSettings = null;
if (this.dbConnection != null) {
this.dbConnection.Dispose();
this.dbConnection = null;
}
if (this.dbCommand != null) {
this.dbCommand.Dispose();
this.dbCommand = null;
}
}
}
this.disposedValue = true;
}
private static void RemoveProcessedNotificationRecords(ReportNotification reportNotification)
{
try
{
MsSqlConnectionSettings staticDbConnectionSettings = new MsSqlConnectionSettings();
staticDbConnectionSettings.DataSource = AppVars.dbSettings.DataSource;
staticDbConnectionSettings.Catalog = AppVars.dbSettings.DatabaseName;
staticDbConnectionSettings.User = AppVars.dbSettings.UserLogin;
staticDbConnectionSettings.Password = AppVars.dbSettings.Password;
using (MsSqlPersistence staticConnection = new MsSqlPersistence(staticDbConnectionSettings, true))
{
if (staticConnection.IsConnected())
{
using (SqlCommand staticCommand = new SqlCommand())
{
staticCommand.CommandText = @"
DELETE
FROM report_notifications
WHERE report_notifications.id = @Id
";
staticCommand.Parameters.Add("@Id", System.Data.SqlDbType.UniqueIdentifier).Value = reportNotification.Id;
staticConnection.ExecuteCommand(staticCommand);
}
}
else
{
throw new Exception("Unable to Connect");
}
}
}
catch
{
throw;
}
}
