public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
//SE ATUALIZAÇÃO FUNCIONAR, RETORNA 204 NO CONTENT
//SE DADOS ENTRADA ESTIVEREM INCORRETOS, RETORNA 400 BAD REQUEST
//SE NÃO EXISTIR, RETORNA NOT FOUND 404
if (model.Price <= 0)
{
return(BadRequest("Valor do veiculo não pode ser menor ou igual 0."));
}
var car = _dbContext.Cars.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(NotFound());
}
car.Update(model.Color, model.Price);
using (var sqlConnection = new SqlConnection(_connectionString))
{
var query = "UPDATE Cars SET Color = @color, Price = @price WHERE Id = @id";
sqlConnection.Execute(query, new { color = car.Color, price = car.Price, car.Id });
}
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
//SE A ATUALIZAÇÃO FUNCIONAR, RETORNAR 204 NO CONTENT
//SE DADOS DE ENTRADA ESTIVEREM INCORRETOS, RETORNA 400 BAD REQUEST
//SE NAO EXISTIR, RETORNA NOT FOUND 404
var car = _dbContext.Cars.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(NotFound());
}
car.Update(model.Collor, model.Price);
//using (var sqlConnection = new SqlConnection(_connectionString))
//{
// var query = "UPDATE Cars SET Collor = @collor, Price = @price, WHERE Id = @id";
// sqlConnection.Execute(query, new { collor = car.Collor, price = car.Price, car.Id });
//}
_dbContext.SaveChanges();
return(NoContent());
}
public IActionResult Put(int Id, [FromBody] UpdateCarInputModel model)
{
if (model.Price < 0)
{
return(BadRequest("Preço não pode ser menor que 0"));
}
var car = _dbContext.Cars.SingleOrDefault(c => c.Id == Id);
if (car == null)
{
return(NotFound());
}
//car.Update(model.Color, model.Price);
using (var sqlConnection = new SqlConnection(_connectionString))
{
var query = "UPDATE Cars SET Color = @color, Price = @price WHERE Id = @id";
sqlConnection.Execute(query, new { car.Color, car.Price, car.Id });
}
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
var update = _carServices.UpdateCar(id, model);
if (!update)
{
return(NotFound());
}
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
var car = _dbContext.Cars.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(NotFound());
}
car.Update(model.Color, model.Price);
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
// SE A ATUALIZAÇÃO FUNCIONAR, RETORNA 204 NO CONTENT
// SE DADOS DE ENTRADA ESTIVEREM INCORRETOS, RETORNA 400 BAD REQUEST
// SE NAO EXISTIR, RETORNA NOT FOUND 404
var car = _dbContext.Cars.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(NotFound());
}
car.Update(model.Color, model.Price);
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
//SE ATUALIZACAO FUNCIONAR, RETORNA 204
//SE OBJETO TIVER INCORRETO, RETORNA 400 BAD REQUEST
//SE NAO EXISTIR RETORNA NOT FOUND 404
var car = _dbContext.Cars.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(NotFound());
}
car.UpdateCar(model.Color, model.Price);
_dbContext.SaveChanges();
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
var carro = _dbContext.Carros.SingleOrDefault(c => c.Id == id);
if (carro == null)
{
return(NotFound());
}
carro.Atualizar(model.Color, model.Preco);
//_dbContext.SaveChanges();
using (var sqlConnection = new SqlConnection(_connectionstring))
{
var query = "UPDATE CARROS SET Cor = @color, Preco = @preco WHERE id = @id";
sqlConnection.Execute(query, new { color = carro.Cor, preco = carro.Preco, id = carro.Id });
}
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
var car = _dbContext.Cars.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(NotFound());
}
car.Update(model.Color, model.Price);
using (var sqlConnection = new SqlConnection(_connectionString))
{
var query = "UPDATE Cars SET Color = @color, Price = @price Where Id = @id";
sqlConnection.Execute(query, new { color = car.Color, price = car.Price, car.Id });
}
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
//Se a atualizacao funcionar, retorna 204 No Content
//Se dados de estiverem incorretos, retorna 400
//se nao estiver existir o id retornar 404
var car = _dbcontext.Cars.SingleOrDefault(c => id == c.Id);
if (car == null)
{
return(NotFound());
}
car.Update(model.Color, model.Price);
_dbcontext.SaveChanges();
return(Ok());
}
public ActionResult Put([FromBody] UpdateCarInputModel carInputModel, int id)
{
var car = Context.Cars.SingleOrDefault(x => x.Id.Equals(id));
if (car == null)
{
return(NotFound());
}
car.Update(carInputModel.Color, carInputModel.Price);
Context.SaveChanges();
/* Command with Dapper
* using (var sqlConnection = new SqlConnection(ConnectionString))
* {
* var command = "UPDATE Cars SET Color = @Color, Price = @price WHERE Id = @id";
* sqlConnection.Execute(command, new { color = car.Color, price = car.Price, id = car.Id });
* } */
return(NoContent());
}
public bool UpdateCar(int id, UpdateCarInputModel model)
{
var car = _dbContext.Cars
.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(false);
}
car.Update(model.Color, model.Price);
//_dbContext.SaveChanges(); // using Entity Framework Core
// using dapper
using (var sqlConnection = new SqlConnection(_connectionString))
{
var query = "UPDATE Cars SET Color = @color, Price = @price WHERE Id = @id";
sqlConnection.Execute(query, new { color = car.Color, price = car.Price, id = car.Id });
}
return(true);
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
var car = _dbContext.Cars
.SingleOrDefault(c => c.Id == id);
if (car == null)
{
return(NotFound(0));
}
car.Update(model.Color, model.Price);
//com Dapper
using (var sqlConnection = new SqlConnection(_connectionString))
{
var query = "UPDATE tb_car set Color = @color, Price = @price WHERE Id = @id";
sqlConnection.Execute(query, new { color = car.Color, price = car.Price, id = car.Id });
}
_dbContext.SaveChanges();
return(NoContent());
}
public IActionResult Put(int id, [FromBody] UpdateCarInputModel model)
{
return(Ok());
}
