Okay, so let's now start for creating a simple table full stop. So that we can create a surface so it has now created a table to the database, our BPM I will create a new table I will call it stock and it can has like item could maybe invite him to scription and to quantity This is just a symbol. The primary key is this just assembly symbol table which has the item code and quantity it's which is available in the system. Okay, so please Okay. In this talk let's add some items. Okay.

So we can add item is your one or and is this we have to to mauers And we have only one for example this is talk have two keyboards and one mouse. Okay, so this is our a table. Let's go to for our roof surface. This is our roof surface which we use so let's just create a check and update because here in our process we need to make the check if this item is exists or not or available in stock or not. So we will create web surface to check the stock. We can see okay, so I have just create this function just to save the time.

This is chicken it Availability it will take us on item code and the quantity and it will check is the quantity from A to B we'll get the quantity from the stock where item could equal what the user will send and it will compare if the quantity is greater than or equal to the quantity or return true otherwise it will return false. We just can close our result set as well. So here Okay, so this is our new web surface to mix, check. The second web surface we need to do is update the stock. Actually both of them will update this to one will add an item and one will remove one item. Some items will well here we will add Once we receive it from As a supplier and once we take it to the user we will will throw the quantity from the stock.

So, here we will create another two web surface want to add one to take or you can create one which surface to all update the stock with the quantity, but I want it with a flag it will add or subtract or remove, so we can get another one okay. So, this is the second web surface which I have created is updates a stock it will take the item code and the quantity which we need to update the stock and the operation if it is at or will be will draw. So I will check the operation. If it is a it means we need to add this quantity to the item code quantity, so I will update the stock and I will set a quantity equal to quantity plus with a quantity will it include the equal item code. If the operation is not a, I will update the stock quantity called quantity minus a quantity we're writing code.

So now we have this to web surface. Let's just we'll update this. We'll go for web service properties. We have here the methods we should select posts and press OK. So here, we had here, the tech the chick a lighting over the ability here I can write it could end here. Same here we will write byte code quantity.

British. Okay. So it's stop and Ronnie. Okay, so if we take now this and post it here as wisdom We should have the cert and we should have as well check item availability and updated stock. So, hold operation now is exist we can take this and we will back to the our process and as I told you in first BPM application to create with surface so, we need to go to to the composite first which is have all Tosca flows This is the input and this is what the surface will be used. Okay, this is for notification.

So here I need to add So as a surface code soup, so I will go to the components you will find here so okay so we can say stuck surface and we will write our wisdom okay and press OK. Press OK this is the first step you should do to call a web surface in the composite you should add this surface here after that is annotation you will go into this web surface so, now I will back again to the the supply chain process for this CIC stock. Now I should be able to implement it and the same absorb surface. Let us finish this web surface invitation in next video. So see you next activity