public IActionResult Put(int AuthorID, [FromBody] AuthorRequest request) { MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString); AuthorResult result = new AuthorResult(); try { conn.Open(); using (MySqlCommand cmd = new MySqlCommand("update Author set name = @name where AuthorID = @AuthorId", conn)) { cmd.Parameters.AddWithValue("@name", request.Name); cmd.Parameters.AddWithValue("@AuthorId", AuthorID); cmd.ExecuteNonQuery(); } result.AuthorID = AuthorID; result.Name = request.Name; return(new OkObjectResult(result)); } catch (Exception ex) { return(BadRequest(ex)); } finally { conn.Dispose(); conn.Close(); } }
public IActionResult Delete(int AuthorID) { MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString); AuthorResult result = new AuthorResult(); try { conn.Open(); using (MySqlCommand cmd = new MySqlCommand("delete from Author where AuthorID = @AuthorId", conn)) { cmd.Parameters.AddWithValue("@AuthorId", AuthorID); cmd.ExecuteNonQuery(); } return(new OkResult()); } catch (Exception ex) { return(BadRequest(ex)); } finally { conn.Dispose(); conn.Close(); } }
public IActionResult Post([FromBody] AuthorRequest request) { MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString); AuthorResult result = new AuthorResult(); try { conn.Open(); using (MySqlCommand cmd = new MySqlCommand("insert into Author (Name) Values (@name)", conn)) { cmd.Parameters.AddWithValue("@name", request.Name); cmd.ExecuteNonQuery(); using (MySqlCommand cmd2 = new MySqlCommand("SELECT last_insert_id()", conn)) { result.AuthorID = (int)(ulong)cmd2.ExecuteScalar(); } } result.Name = request.Name; return(new OkObjectResult(result)); } catch (Exception ex) { return(BadRequest(ex)); } finally { conn.Dispose(); conn.Close(); } }
public IActionResult Get(int AuthorID) { MySqlConnection conn = new MySqlConnection(_appSettings.ConnectionString); AuthorResult result = new AuthorResult(); try { conn.Open(); using (MySqlCommand cmd = new MySqlCommand("SELECT AuthorID, Name FROM Author WHERE AuthorID=" + AuthorID, conn)) { MySqlDataReader dataReader = cmd.ExecuteReader(); if (dataReader.Read()) { result = new AuthorResult { AuthorID = dataReader.GetInt32(0), Name = dataReader.GetString(1) }; } } return(new OkObjectResult(result)); } catch (Exception ex) { return(BadRequest(ex)); } finally { conn.Dispose(); conn.Close(); } }
public IActionResult Put(int AuthorID, [FromBody] AuthorRequest request) { AuthorResult result = new AuthorResult(); //rotina de gravar dados no banco e selecionar Autor gravado para retornar (neste exemplo mokado) result.AuthorID = 6; result.Name = request.Name; //rotina de gravar dados no banco e selecionar Autor gravado para retornar (neste exemplo mokado) return(new OkObjectResult(result)); }
public IActionResult Get(int AuthorID) { AuthorResult result = new AuthorResult(); //aqui iremos mokar a informção do banco result.AuthorID = AuthorID; result.Name = "Teste 1"; //aqui iremos mokar a informção do banco return(new OkObjectResult(result)); }
public IActionResult Post([FromBody] AuthorRequest request)//em um verbo POST ou PUT você pode passar os parametros da chamada pelo Body usando a notation [FromBody] isso permite passar objeto JSON complexos { AuthorResult result = new AuthorResult(); //rotina de gravar dados no banco e selecionar Autor gravado para retornar (neste exemplo mokado) result.AuthorID = 1; result.Name = request.Name; //rotina de gravar dados no banco e selecionar Autor gravado para retornar (neste exemplo mokado) return(new OkObjectResult(result)); }