public virtual async Task <bool> AuthorizeSessionAsync(UserInfo userInfo)
{
databaseConnection.GetNewConnection();
await using (databaseConnection.DbConnection)
{
try
{
var sql = $"DELETE FROM Sessions WHERE Expires < GETDATE();";
await databaseConnection.DbConnection.ExecuteAsync(sql);
var guid = userInfo.Guid.ToString();
var email = userInfo.Email;
var now = DateTimeOffset.Now.AddHours(2).ToString("yyyy'-'MM'-'dd HH':'mm':'ss'.'ff");
sql = $"INSERT INTO Sessions (Guid, Email, Expires) " +
$"VALUES (@guid, @email, @now);";
await databaseConnection.DbConnection.ExecuteAsync(sql, new { guid, email, now });
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public async Task InsertDeveloperAsync(string developerName)
{
var sql = @"IF NOT EXISTS(SELECT * FROM Developers WHERE Name = @developerName)
INSERT INTO Developers (Name)
VALUES (@developerName)";
databaseConnection.GetNewConnection();
await databaseConnection.DbConnection.ExecuteAsync(sql, new { developerName });
}
public async Task RemoveHistoryItemByIdAsync(int id)
{
databaseConnection.GetNewConnection();
await using (databaseConnection.DbConnection)
{
var sql = $"DELETE FROM HistoryEvents WHERE Id = @id";
await databaseConnection.DbConnection.ExecuteAsync(sql,
new { id });
}
}
public async Task RemoveReleaseEnvironmentById(int releaseEnvironmentId)
{
databaseConnection.GetNewConnection();
await using (databaseConnection.DbConnection)
{
var sql = $"DELETE FROM ReleaseEnvironments WHERE Id = @releaseEnvironmentId";
await databaseConnection.DbConnection.ExecuteAsync(sql, new { releaseEnvironmentId });
}
}
public TaskItemType[] GetTaskItemTypes()
{
databaseConnection.GetNewConnection();
using (databaseConnection.DbConnection)
{
var sql = $"SELECT Id FROM TaskItemTypes";
var taskItemTypes = databaseConnection.DbConnection
.Query <TaskItemType>(sql);
return(taskItemTypes.ToArray());
}
}
public async Task InsertReleaseListAsync(IEnumerable <Release> releases)
{
databaseConnection.GetNewConnection();
await using (databaseConnection.DbConnection)
{
if (releases == null)
{
return;
}
foreach (var release in releases)
{
await InsertReleaseAsync(release);
}
}
}
