Hello guys, welcome to the SU one tutorial so the US we don't have VBA In this lesson we will establish the put request to update the our database record in the IRS for minor. For this we need to switch to Visual Studio and create a new method or axon port which take the ID from the parameter a new product detail from a body click the try catch block. First of all we need to retrieve the original item from the database for that given ID. For this we need to write the same code that we are using the get parameter ID Method started with the using statement product entities dt equal to new product entity rotor axis thing for call to action and duties toward production or for strategy for x such that x dot product ID quality cool near you and it Via parameter and update the existing product.

Name with the new product. Name Sam quarter for the auto properties true is equal to a new product dot price for the chart quantity Korto new product dot quantity, existing product or box size or to a new product walk sighs And we need to save the changes. And it is dot Save Changes. And we need to run it let's copy the URL switch to postman plugin. Here's the URL right the API slash or controller name. That is a product and click on the SN to the to all of the exit data.

You can see that the product ID eight that is a marker, which block size is 10 and the price is 30. I'm going to sanebox I should find one price to the 24 that we need to Copy the JSON format. Choose the output method, specify the ID in the parameter. Click on the body and specify the AIDS content. Remove the ID upgrade to the file and 20 click on the send button. You can see that it it status is a 204 that is no content that's red or the our database.

You can see that the box sizes a file as well as the prices change to the 20. We have successfully updated the our database. But India certain situation it throws the exception when the product does not exist in the database. For that, we need to handle it. And we also need to send the proper shaders that is a 404 product not found. And when the product is updated, we need to send the orchestrators.

Let's do it. First of all we need to check that the product is accessing the our database or not. Or that we need to check whether the product is null then we need to return a request dot could you add a response with the HTTP status code? Not found that is 404. And with the proper message, product with the UN ID does not exist we also want to chain the Overton type to the TTP response message. If the product does not exist then it will written this message with the not found status code empty it exists, it will update the database and and we also need to send the proper status code that is okay for that to any good idea return request door could you response with the HTTP status code?

Okay. A product that is existing product, not the new product. And when they accept Sonico, we need to put it on the request or create error response with the TTP status code. Bad request and your idea and pass the our exception object. Right click on the run button. Let's switch to postman plugin and this time we are going to update the box size to then click on the send button.

You can see that it written status code 200 that is okay and the new product object details that is product IDs eight and the details. Let's quick check to SQL Server, we can see that the box sizes 10 to 10. Less shy to update the product that does not exist. For example, we are assuming that the product with the egg you and it does not exist messes with the status quo for zero for this is the code for the put request. First of all we need to showing the exit product detail and check whether the product is exists or not if not exist, then we need to return the 404 status. Otherwise, update the product detail and DSL changes and return the keys to the score otherwise Return the Barefoot Crash Course.

Thanks for watching. If you have any doubt, feel free to contact me