WEBVTT 00:00.530 --> 00:01.690 Welcome back to a new lecture. 00:01.700 --> 00:08.180 Now in this lecture let us fix some issues and also modify some of our code to make it in proper format. 00:08.420 --> 00:12.710 So currently if I run my application I just need to do a few things. 00:12.710 --> 00:16.390 So I just need to modify the subject NAME AND MAKE IT refresh. 00:16.400 --> 00:19.170 I also need to add a total paid amount here. 00:19.610 --> 00:25.890 I also need to showcase my portfolio I.T. so that would be useful in future dorms. 00:25.940 --> 00:32.890 So if I have 10 or 20 points I have a portfolio I.T. so I can look at that I know there would be quite 00:32.890 --> 00:34.380 some head and changes. 00:34.420 --> 00:36.110 So let does focus on that. 00:36.120 --> 00:41.110 So firstly I just want to take this function and put it inside that system. 00:41.130 --> 00:43.770 I also need to do one important thing. 00:43.840 --> 00:50.830 Let me add our new function have qualified as application her that and just move this code inside that. 00:51.520 --> 00:55.450 So it would be more convenient for us if we need to change anything inside that. 00:55.800 --> 01:01.720 Because in for other lectures we are going to do a lot of changes with that application and also let 01:01.720 --> 01:08.550 me change this one to refresh and there will be few more changes regarding our calculation. 01:08.570 --> 01:10.290 So this is not the problem I know. 01:10.320 --> 01:16.400 Earlier I was doing just to make you understand our calculation that is an addition and I would recommend 01:16.400 --> 01:18.470 you remove that and use this. 01:18.470 --> 01:20.780 This is the bowl format actually. 01:20.870 --> 01:23.990 And I would really recommend you to do these small changes 01:28.250 --> 01:29.210 once that is done. 01:29.210 --> 01:32.780 I also need to add our total calculation for total amount paid. 01:33.170 --> 01:34.940 So we have total current value. 01:34.940 --> 01:36.800 I also need to add to that I'm on paid 01:49.090 --> 01:50.390 so that should be easy. 01:50.390 --> 01:52.590 We just need to use our total payroll on 01:55.580 --> 01:57.500 and we just need before this quantum 02:00.260 --> 02:03.250 all I need to do is use this column. 02:04.490 --> 02:06.200 I need to use total amount paid 02:15.210 --> 02:16.440 this looks fine to me. 02:16.440 --> 02:18.230 Don't forget to change your column number 02:21.570 --> 02:26.680 let me close this on and on the song in yeah. 02:26.690 --> 02:27.300 That's fine. 02:27.300 --> 02:29.290 So this is the amount we have paid. 02:29.300 --> 02:32.640 This is our current value and this is our profit. 02:32.660 --> 02:34.970 We have changed our update to refresh. 02:35.120 --> 02:43.530 And also we need to add one more column add a new column have I would call it as portfolio i.e. 02:54.620 --> 02:59.990 one thing you need to do is you also need to update all the column number because you are adding a new 02:59.990 --> 03:00.530 column. 03:00.590 --> 03:02.870 So just replace this quickly. 03:03.530 --> 03:05.280 So we have added to our header. 03:05.390 --> 03:07.970 We now need to add with our values column 03:21.320 --> 03:24.120 so if you remember as I said earlier it would be queen. 03:24.160 --> 03:27.660 And then the position number that is in next number 0. 03:27.880 --> 03:30.310 You also need to change the value of this column 03:43.980 --> 03:44.290 now. 03:44.350 --> 03:53.930 It looks fine to me if I run my application again so these are the juniors and we have a portfolio I.D. 03:53.930 --> 03:59.540 for now if I need to talk about Neal it would be at a position number that is portfolio 80 number three 03:59.780 --> 04:02.180 if I talk about eczema it would be four. 04:02.360 --> 04:06.680 So these are not in sequence but they have no idea which we can define. 04:07.040 --> 04:12.840 So if I need to delete anything I can therefore do this particular I.T. because this is sync with database 04:12.970 --> 04:19.340 we are taking this idea from database if I need to edit this one that means if I need to update anything 04:19.340 --> 04:25.160 in my portfolio I can refer to this particular I.T. and this is going to solve a lot of problem for 04:25.160 --> 04:33.050 us in future I hope now understand why I done these basic changes because it is going to make our application 04:33.140 --> 04:40.100 easy to use and also it is going to make us easy to code our application we need to do a lot more thing 04:40.190 --> 04:45.550 inside our application in the next lecture let us focus on insert update and delete. 04:45.800 --> 04:51.700 So I would be adding three fields in my application at that particular position so we can just enter 04:51.710 --> 04:57.240 data and click on Add button and we can add data in our database that would be quite interesting. 04:57.320 --> 04:58.610 So see you in the next one.