public async Task <int> UpdateFootballer(int playerId, FootballerDto footballerDto)
{
await using var connection = new NpgsqlConnection(_connectionString);
connection.Open();
var parameters = new
{
PersonId = playerId,
FirstName = footballerDto.FirstName,
MiddleName = footballerDto.MiddleName,
Nationality = footballerDto.Nationality,
DataOfBirth = footballerDto.DataOfBirth,
PlaceOfBirth = footballerDto.PlaceOfBirth,
Height = footballerDto.Height,
Weight = footballerDto.Weight,
RoleId = footballerDto.RoleId,
};
var sql = @"UPDATE public.footballers SET first_name = @FirstName,
middle_name = @MiddleName,
nationality = @Nationality,
data_of_birth = @DataOfBirth,
place_of_birth =@PlaceOfBirth,
height =@Height,
weight = @Weight,
role_id =@RoleId
WHERE person_id = @PersonId";
return(await connection.ExecuteAsync(
sql,
parameters
));
}
public async Task <int> AddFootballer(FootballerDto footballerDto)
{
await using var connection = new NpgsqlConnection(_connectionString);
connection.Open();
var parameters = new
{
FirstName = footballerDto.FirstName,
MiddleName = footballerDto.MiddleName,
Nationality = footballerDto.Nationality,
DataOfBirth = footballerDto.DataOfBirth,
PlaceOfBirth = footballerDto.PlaceOfBirth,
Height = footballerDto.Height,
Weight = footballerDto.Weight,
RoleId = footballerDto.RoleId,
};
var sql = @"INSERT INTO public.footballers (first_name,
middle_name,
nationality,
data_of_birth,
place_of_birth,
height,
weight,
role_id)
VALUES (@FirstName, @MiddleName,
@Nationality, @DataOfBirth,
@PlaceOfBirth, @Height, @Weight, @RoleId);
";
return(await connection.ExecuteAsync(sql, parameters));
}
public async Task <int> UpdateFootballer([FromRoute] int playerId, FootballerDto footballerDto)
{
return(await _footballerRepository.UpdateFootballer(playerId, footballerDto));
}
public async Task <int> AddFootballer(FootballerDto footballerDto)
{
return(await _footballerRepository.AddFootballer(footballerDto));
}
