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