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