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); } } }