public IActionResult Put(int FormacaoId, [FromBody] FormacaoRequest request)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("UPDATE Formacao SET Instituicao = @instituicao, Curso = @curso, Periodo = @periodo, EspecialistaId = @especialista ", conn))
{
cmd.Parameters.AddWithValue("@instituicao", request.Instituicao);
cmd.Parameters.AddWithValue("@curso", request.Curso);
cmd.Parameters.AddWithValue("@periodo", request.Periodo);
cmd.Parameters.AddWithValue("@especialista", request.EspecialistaId);
cmd.ExecuteNonQuery();
}
return(new OkObjectResult(new FormacaoResult {
FormacaoId = FormacaoId, Instituicao = request.Instituicao, Curso = request.Curso, EspecialistaId = request.EspecialistaId
}));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
public IActionResult Post([FromBody] FormacaoRequest request)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
int formacaoId = 0;
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Formacao (Instituicao, Curso, Periodo, EspecialistaId) VALUES(@instituicao, @curso, @periodo, @especialista);", conn))
{
cmd.Parameters.AddWithValue("@instituicao", request.Instituicao);
cmd.Parameters.AddWithValue("@curso", request.Curso);
cmd.Parameters.AddWithValue("@periodo", request.Periodo);
cmd.Parameters.AddWithValue("@especialista", request.EspecialistaId);
cmd.ExecuteNonQuery();
using (MySqlCommand cmd2 = new MySqlCommand("SELECT last_insert_id()", conn))
{
formacaoId = (int)(ulong)cmd2.ExecuteScalar();
}
}
return(new OkObjectResult(new FormacaoResult {
FormacaoId = formacaoId, Instituicao = request.Instituicao, Curso = request.Curso, EspecialistaId = request.EspecialistaId
}));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
