public IActionResult Put(int PatologiaId, [FromBody] PatologiaRequest request)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("UPDATE Patologia SET NomePatologia = @nome, Descricao = @desc, PacienteId = @paciente ", conn))
{
cmd.Parameters.AddWithValue("@nome", request.NomePatologia);
cmd.Parameters.AddWithValue("@desc", request.Descricao);
cmd.Parameters.AddWithValue("@paciente", request.PacienteId);
cmd.ExecuteNonQuery();
}
return(new OkObjectResult(new PatologiaResult {
PatologiaId = PatologiaId, NomePatologia = request.NomePatologia, Descricao = request.Descricao, PacienteId = request.PacienteId
}));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
public IActionResult Post([FromBody] PatologiaRequest request)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
int patologiaId = 0;
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Patologia (NomePatologia, Descricao, PacienteId) VALUES(@nome, @desc, @paciente);", conn))
{
cmd.Parameters.AddWithValue("@nome", request.NomePatologia);
cmd.Parameters.AddWithValue("@desc", request.Descricao);
cmd.Parameters.AddWithValue("@paciente", request.PacienteId);
cmd.ExecuteNonQuery();
using (MySqlCommand cmd2 = new MySqlCommand("SELECT last_insert_id()", conn))
{
patologiaId = (int)(ulong)cmd2.ExecuteScalar();
}
}
return(new OkObjectResult(new PatologiaResult {
PatologiaId = patologiaId, NomePatologia = request.NomePatologia, Descricao = request.Descricao, PacienteId = request.PacienteId
}));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
