public IActionResult Put(int EspecialistaId, [FromBody] EspecialistaRequest request)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("UPDATE Especialista SET Especialidade = @especialidade, Descricao = @descricao, Registro = @registro, UsuarioId = @usuarioId, Consultorio = @consultorioId WHERE EspecialistaId = @especialistaId", conn))
{
cmd.Parameters.AddWithValue("@especialidade", request.Especialidade);
cmd.Parameters.AddWithValue("@descricao", request.Descricao);
cmd.Parameters.AddWithValue("@registro", request.Registro);
cmd.Parameters.AddWithValue("@usuarioId", request.UsuarioId);
cmd.Parameters.AddWithValue("@consultorioId", request.ConsultorioId);
cmd.Parameters.AddWithValue("@especialistaId", EspecialistaId);
cmd.ExecuteNonQuery();
}
return(new OkObjectResult(new EspecialistaResult {
EspecialistaId = EspecialistaId, Especialidade = request.Especialidade, Descricao = request.Descricao, Registro = request.Registro, UsuarioId = request.UsuarioId, ConsultorioId = request.ConsultorioId
}));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
public IActionResult Post([FromBody] EspecialistaRequest request)
{
MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString);
int especialistaId = 0;
try
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Especialista (Especialidade, Descricao, Registro, UsuarioId, ConsultorioId) VALUES(@especialidade, @descricao, @registro, @usuario, @consultorio)", conn))
{
cmd.Parameters.AddWithValue("@especialidade", request.Especialidade);
cmd.Parameters.AddWithValue("@Descricao", request.Descricao);
cmd.Parameters.AddWithValue("@Registro", request.Registro);
cmd.Parameters.AddWithValue("@usuario", request.UsuarioId);
cmd.Parameters.AddWithValue("@consultorio", request.ConsultorioId);
cmd.ExecuteNonQuery();
using (MySqlCommand cmd2 = new MySqlCommand("SELECT last_insert_id()", conn))
{
especialistaId = (int)(ulong)cmd2.ExecuteScalar();
}
}
return(new OkObjectResult(new EspecialistaResult {
EspecialistaId = especialistaId, Especialidade = request.Especialidade, Descricao = request.Descricao, Registro = request.Registro, UsuarioId = request.UsuarioId, ConsultorioId = request.ConsultorioId
}));
}
catch (Exception ex)
{
return(BadRequest(ex));
}
finally
{
conn.Dispose();
conn.Close();
}
}
