public void AddDirection(DirectionClient directionClient)
{
DBconn.Open();
var sqlAddDirection = new NpgsqlCommand(
"INSERT INTO directions_clients (direction, client_email) " +
"VALUES (@p1, @p2)", DBconn
);
sqlAddDirection.Parameters.AddWithValue("p1", directionClient.direction);
sqlAddDirection.Parameters.AddWithValue("p2", directionClient.client_email);
sqlAddDirection.ExecuteNonQuery();
DBconn.Close();
}
public ActionResult <ClientDto> CreateClient(ClientDto clientDto)
{
var clientModel = _mapper.Map <Client>(clientDto);
_repository.AddClient(clientModel);
var directionClientModel = new DirectionClient();
directionClientModel.client_email = clientDto.email;
directionClientModel.direction = clientDto.direction;
_repository.AddDirection(directionClientModel);
var newClientDto = _mapper.Map <ClientDto>(clientModel);
return(CreatedAtRoute(nameof(GetClientByEmail), new { email = newClientDto.email },
newClientDto));
}