public async Task SeedTrigger(IDbQueryRunner dbQueryRunner)
{
await dbQueryRunner.RunQueryAsync(
"CREATE TRIGGER InsertMandatoryGroups" +
"ON dbo.Businesses" +
"AFTER INSERT" +
"AS" +
"BEGIN" +
"DECLARE @BusinessId NVARCHAR(450)" +
"SELECT @BusinessId = ID from inserted" +
"DECLARE @OwnerId NVARCHAR(450)" +
"DECLARE @OwnerId = OwnerId from inserted" +
"DECLARE @AdminGroupId NVARCHAR(450) = NEWID()" +
"DECLARE @HRGroupId NVARCHAR(450) = NEWID()" +
"DECLARE @SheduleManagerGroupId NVARCHAR(450) = NEWID()" +
"INSERT INTO Groups(Id, CreatedOn, Name, StandardSalary, BusinessId, IsDeleted)" +
"VALUES" +
"(@AdminGroupId, GETDATE(), 'Admins', 0, @BusinessId, 0)," +
"(@HRGroupId, GETDATE(), 'HR Managers', 0, @BusinessId, 0)," +
"(@SheduleManagerGroupId, GETDATE(), 'Schedule Managers', 0, @BusinessId, 0)" +
"INSERT INTO EmployeeGroups(Id, CreatedOn, UserId, GroupId, Position, Salary, IsDeleted)" +
"VALUES" +
"(NEWID(), GETDATE(), @OwnerId, @AdminGroupId, 'Owner', 0, 0)," +
"(NEWID(), GETDATE(), @OwnerId, @HRGroupId, 'Owner', 0, 0)," +
"(NEWID(), GETDATE(), @OwnerId, @SheduleManagerGroupId, 'Owner', 0, 0)");
}
public DashboardController(
IDeletableEntityRepository <News> newsRepository,
IDeletableEntityRepository <ApplicationUser> usersRepository,
IDbQueryRunner queryRunner)
{
this.newsRepository = newsRepository;
this.usersRepository = usersRepository;
this.queryRunner = queryRunner;
}
/// <summary>
/// Initializes a new instance of the <see cref="DbConnectionPool"/> class.
/// </summary>
/// <param name="connectionString">ConnectionString used for the connections made in this DbConnectionPool.</param>
protected DbConnectionPool(string connectionString)
{
_connectionString = connectionString;
_pool = new ObjectPool<PooledDbConnection>(CreateNewObj, InitializePooledConnection, DeinitializePooledConnection,
true);
// Create our DbQueryRunner using a connection NOT in the pool (since the connection will remain opened)
var conn = CreateConnection(ConnectionString);
_queryRunner = new DbQueryRunner(this, conn);
}
/// <summary>
/// Initializes a new instance of the <see cref="DbConnectionPool"/> class.
/// </summary>
/// <param name="connectionString">ConnectionString used for the connections made in this DbConnectionPool.</param>
protected DbConnectionPool(string connectionString)
{
_connectionString = connectionString;
_pool = new ObjectPool <PooledDbConnection>(CreateNewObj, InitializePooledConnection, DeinitializePooledConnection,
true);
// Create our DbQueryRunner using a connection NOT in the pool (since the connection will remain opened)
var conn = CreateConnection(ConnectionString);
_queryRunner = new DbQueryRunner(this, conn);
}
public DbCleanupTaskJob(IDbQueryRunner dbQueryRunner)
{
this.dbQueryRunner = dbQueryRunner;
}
public ChangeShiftStatusJob(IDbQueryRunner dbQueryRunner)
{
this.dbQueryRunner = dbQueryRunner;
}
public DbCleanupTask(IDbQueryRunner queryRunner, ILoggerFactory loggerFactory)
{
this.queryRunner = queryRunner;
this.logger = loggerFactory.CreateLogger <DbCleanupTask>();
}
public DbCleanupJob(IDbQueryRunner queryRunner)
{
this.queryRunner = queryRunner;
}
