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