public async Task <Maybe <MasterGameRequest> > GetMasterGameRequest(Guid requestID) { var sql = "select * from tbl_mastergame_request where RequestID = @requestID"; using (var connection = new MySqlConnection(_connectionString)) { MasterGameRequestEntity entity = await connection.QuerySingleOrDefaultAsync <MasterGameRequestEntity>(sql, new { requestID }); if (entity == null) { return(Maybe <MasterGameRequest> .None); } var eligibilityLevel = await GetEligibilityLevel(entity.EligibilityLevel); Maybe <MasterGame> masterGame = Maybe <MasterGame> .None; if (entity.MasterGameID.HasValue) { masterGame = await GetMasterGame(entity.MasterGameID.Value); } var user = await _userStore.FindByIdAsync(entity.UserID.ToString(), CancellationToken.None); return(entity.ToDomain(user, eligibilityLevel, masterGame)); } }
public async Task <MasterGameRequest?> GetMasterGameRequest(Guid requestID) { var sql = "select * from tbl_mastergame_request where RequestID = @requestID"; await using var connection = new MySqlConnection(_connectionString); MasterGameRequestEntity entity = await connection.QuerySingleOrDefaultAsync <MasterGameRequestEntity>(sql, new { requestID }); if (entity == null) { return(null); } MasterGame?masterGame = null; if (entity.MasterGameID.HasValue) { masterGame = await GetMasterGame(entity.MasterGameID.Value); } var user = await _userStore.FindByIdAsync(entity.UserID.ToString(), CancellationToken.None); return(entity.ToDomain(user, masterGame)); }