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