public async Task <PlayerRecordDto> CreateNewPlayerRecordAsync(CreatePlayerRecordDto newRecord) { var newRecordId = await _recordsRepository.CreateNewPlayerRecord(newRecord); var newPlayer = await GetPlayerRecordByIdAsync(newRecordId); return(newPlayer); }
//create new record public async Task <int> CreateNewPlayerRecord(CreatePlayerRecordDto newRecord) { string query = @"INSERT INTO public.player_records(player_id, start_date, score, time_spent) VALUES (@PlayerId, @StartDate, @Score, @TimeSpent);; SELECT currval(pg_get_serial_sequence('player_records','id'));"; using (var conn = CreateConnection()) { var newPlayerRecordId = await conn.QueryFirstAsync <int>(query, newRecord); return(newPlayerRecordId); } }
public async Task <PlayerRecordDto> CreateNewPlayerRecord(CreatePlayerRecordDto newPlayerRecord) { var newRecord = await _service.CreateNewPlayerRecordAsync(newPlayerRecord); return(newRecord); }