I'm not gonna lie, this is incredible and couldn't have come at a better time :D. I am actually doing a Budget Tracking app(that can import various local bank transactions) for my Finals and this alleviated a huge part of the Frontend work. I am a backend developer not a frontend developer so I would've struggled a ton with doing this from scratch!
Great tutorial! I decided to try and create a budget expense tracker for my own use as well as practice. I implemented some tweaks in my own version where the user has a date range picker and that would be used in the charts and added validations and search functions in the tables I am planning to add a Log In and Register function as well as create a multi tenancy structure for people to use in the future. Your Tutorial really helped me understand syncfusion and got some ideas that helped me understand more about the LINQ. Thanks! Keep up the good work!
Very, very humble request to you to write this app in Angular also as it is really a very practical example of expenses tracker and most importantly you have applied a very clean approach of code optimization especially you have designed the backend very beautifully incorporating the code first approach and same time one to many relation in code first approach which provide the sql queries in a great fashion. Your videos are very good addition to the masses who aspire to learn more and more but unfortunately you videos come after a huge interval. At last but not the least, please post the same video using Angular as a front end and same syncfussion. Thanks for posting such a professional video on TH-cam
@@CodAffection Thanks for your video, if angular as front end with MVC core video if posted can u pls share me the link , I could not find in ur videos list
Great App, mostly easy to follow learned a few new tricks. Would've been nice for it to be in Angular but I guess beggars can't be choosers lol. As a dev, you take what you have and build on it. From this, I think it is possible to create an Angular front end.
Thank you, it's very helpful tutorial. In addition, I would be happy if you could add pdf file uploads with uploader information and open in browsers, delete, send and add to the database.
Very nice and well explained tutorial. Thanks for this great contribution. Could be possible to add entries loading a .csv directly in addition of this manual input functionality?
Notice that , when you add a controller, VS will generate the DBtext and relative, you do not have to manully do it like in the video around 10:00, but it is good to know how it works, thanks
Wow excellent app. Great work. To enhance more can we have an uploader to read the bills and inject transactions instead of manual entries. Also any statements.
The content and tutorial itself is great, but the editing/pacing needs love. Cutting to another view or step before completing a line has been very frustrating for me as a beginner.
Hi a great app, I´m learning a lot with the tutorial. a question, can this app be used in phones, or it needs to be configured to that purpose, if yes how to do so ? Thanks !
Shamseer, @1:49:44 What exactly are x (for x.Category), y (used with y.Date), i (for i.Category) and j (used for amount)? Are these just variables defined at that point of the code to store that information? I'm a little lost as to where they came from.
Hi , I tried to implement it , but after removing header and footer , i am getting blank space in top and bottom , just the table is rendered , is there anything i can do about it ? pls help. Thank you.
И кстати, сейчас проект лучше всего сразу загружать из VS, там не надо париться с лицензией, так как используешь на смежных правах с учеткой, привязанной к студии, иначе, издатели фреймворка, блокируют твою учетную запись и все лицензии ))
How do I hide formattedamount of some categories in doughnut chart if they are too small? My chart has a lot of categories and the datalabels are all over the place. I already tried settling formattedamount null if it’s
hello i added my local vs2022 db path the appsettings and after running the 2 Pm commands i have the db in vs2022 but not in sql server 2019 but the project runs; how do i get it to populate in sql server?
Hi Sir, Should we need to install the syncfusion web installer exe to use in the web app? I have request for the community license. its still in the approve process. Please help.
get { return Category == null ? "" : Category.Icon + " " + Category.Title; } this code is not working .....i debug and found that category is getting null value but they have all the property like category id and all things .... is anyone have any solution ???
18:35 I have the following error when loading the Category/Index page: SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) There are no errors in SQLServer & I can't see it from the MMC either.
Hi! I was trying to add Scaffolded Identity to the project in which i already had a usual ApplicationDbContext and already created tables in this db. I was trying to create IdentityDbContext and inherit my ApplicationDbContext from it etc. In the end, I still did not understand how to do this, and whether it is possible. Maybe someone knows how to deal with it?
For implementing the edit operation we need the corresponding entity id. Then only we can update the respective entity from the EF or Database. Without the hidden field, post action method doesn't receive the id details. You could better understand this if you submit the form with and without the hidden field
SIR, request you to spare some time to post same app using Angular as a front-end as it is very great app you have post on TH-cam. Awaiting your response Thanks
Повторно пересматриваю, вопрос, зачем делать сортировку строк, если первым наименованием идет иконка, текстовая... сортируется то, все равно по ней, а она не несет никакого смысла и сортировка не работает )
Is the VS Enterprise one or the usual community one ? U had installed entityframeworkcore package but its not showing in the nuget manager Whats the solution ?
Community Version. not showing in nuget manager? nuget manager search inside browse tab it should be there if you there is an internet access. let me know if you still have the same problem.
I tried to host a small Mvc project m azure, it started charging me hundreds of dollars before anyone used it. Can you make a video on how to host databases and projects?
Azure SQL v-core model is an expensive service. Depending on how "small" your project is, you can also consider v-core serverless, DTU model, or even put the "DB" in file storage
Hello. I study the material, I try to repeat it. No syncfusion component is displayed. I'm from Russia, could it be related to this? My website only works through VPN...
@@CodAffection completed all the steps. These are all fucking sanctions. The software is blocked on the developer's side. When will this political war end?..
@@CodAffection I found a way to launch the project. I'm going to bed now. I'll finish the code in the morning. I installed (VERY QUICKLY, until they blocked) the software, and then just updated the NPM package. Everything worked. I will continue on video. It is a pity that political bad people cannot come to peace. Because of this, the opportunity to gain new knowledge and apply it in practice disappears.
error: There is already an object named 'Categories' in the database. giving this error when im trying to update database after migration. help and thanku for this tutorial
There is a free community license for organizations with fewer than 5 users and less than $1 million USD in gross revenue are eligible for the Community License. Apply for the license as shown in the video and they will contact you to confirm whether you are eligible for the same or not. that's it.
Teacher Shamseer! I'm working on an Inventory app, and I would like to add the functionality of adding / reducing Stock! Is it possible to use an editable EJS-Grid object (to which you can add and remove Rows on the fly) with Row Cells that are pre-populated like your dropdown-list example for categories? The idea would be for users to add Products to the grid (new Rows), and on that Row's Product column : select from a list of pre-existing Products! Which would filling-in other (non-editable) row cells, like "available Stock/Quantity". Thanks in advance! And for the excellent tutorials.
![[LIVE] : ONE ลุมพินี 88 | คู่เอก "ป้อมเพชร vs อัสลามจอน"](http://i.ytimg.com/vi/1ZqTVVbMgbo/mqdefault.jpg)
goo.gl/bPcyXW : Buy me a Coffee
bit.ly/36IA1cH : AspNet Core MVC CRUD Operations
bit.ly/2yEPlpB : Convert MVC App to Single Page(jQuery Ajax)
bit.ly/403lUVC : MVC Login & User Registration
bit.ly/39B6xdh : Image Upload in AspNet Core MVC
bit.ly/30fPDMg : More MVC Tutorials
Dear can i have your mail to contact you
your
Provided the best without any ads in between. Thanks a lot.
Profile Picture + Logout + Tracker + Tab + ..... Awesome Thanks Sir
I'm not gonna lie, this is incredible and couldn't have come at a better time :D. I am actually doing a Budget Tracking app(that can import various local bank transactions) for my Finals and this alleviated a huge part of the Frontend work. I am a backend developer not a frontend developer so I would've struggled a ton with doing this from scratch!
Thanks for your wonderfull feedback.
Glad you found it helpful.
Hey! I'm also watched this video for my final project. Can you please share with your project for me, if you dont mind😅
Great tutorial! I decided to try and create a budget expense tracker for my own use as well as practice. I implemented some tweaks in my own version where the user has a date range picker and that would be used in the charts and added validations and search functions in the tables I am planning to add a Log In and Register function as well as create a multi tenancy structure for people to use in the future. Your Tutorial really helped me understand syncfusion and got some ideas that helped me understand more about the LINQ. Thanks! Keep up the good work!
Tremendously useful! Thanks for putting this together 👏👏👏
Very, very humble request to you to write this app in Angular also as it is really a very practical example of expenses tracker and most importantly you have applied a very clean approach of code optimization especially you have designed the backend very beautifully incorporating the code first approach and same time one to many relation in code first approach which provide the sql queries in a great fashion. Your videos are very good addition to the masses who aspire to learn more and more but unfortunately you videos come after a huge interval.
At last but not the least, please post the same video using Angular as a front end and same syncfussion.
Thanks for posting such a professional video on TH-cam
Really appreciate your time for writing this comment.
We will find a way to make it happen.
@@CodAffection thanks for your answer and great support.
@@CodAffection Thanks for your video, if angular as front end with MVC core video if posted can u pls share me the link , I could not find in ur videos list
Great App, mostly easy to follow learned a few new tricks. Would've been nice for it to be in Angular but I guess beggars can't be choosers lol. As a dev, you take what you have and build on it. From this, I think it is possible to create an Angular front end.
Thanks for the understanding 😊
The material is very practical, thank's for share this project.
Thank you, it's very helpful tutorial. In addition, I would be happy if you could add pdf file uploads with uploader information and open in browsers, delete, send and add to the database.
Dark reader! Thankyou for using it!
SIR, very eagerly awaiting you wonderful expenses tracker program in Angular
In the front view of the app we have settings, report at the left side and bell for notification, and messages do i write the code for all
this is the jackal blogger, all things he made behind, it is not asp.net, it is just html and css
SIR, I have been eagerly awaiting for your post in Angular for the same application.
Awesome Yaar . Can not Believe on my eyes. this kind of thing can be made.
Thank you so much this gives me a great place to start to learn from x
Glad you think so!
This looks awesome.
Will go thru it completely.
Thanks for the comment.
Thank you for such an informative tutorial!
Great channel!
nice work
Glad you liked it.
Very precise tutorial. Thanks you :)
Thank you.
Very nice and well explained tutorial. Thanks for this great contribution.
Could be possible to add entries loading a .csv directly in addition of this manual input functionality?
Is there any way you can show how to do this for multiple profiles. Keeping the same categories, just showing different expense tracking
AMAZING
This is just awesome! thank you sir
Notice that , when you add a controller, VS will generate the DBtext and relative, you do not have to manully do it like in the video around 10:00, but it is good to know how it works, thanks
Beutiful amazing design
Sorry but at 11:50 he connects his studio how? where's the connection /link from his code in vs to the studio? Where was that?
how did you resolve the issue?
Thank you for the great tutorial
Glad you found it helpful.
Great video such a shame that you never finished off with the reports side of things, as that would ahve rounded the project off.
Thanks for your constructive criticism.
Could be done accordingly in similar future lessons.
Great !!
Wow excellent app. Great work. To enhance more can we have an uploader to read the bills and inject transactions instead of manual entries. Also any statements.
Bravo!!!
Thank you ❤ can i ask is that possible that this can connect to json file data?
Hi, what server can I use to deploy it? Do you have recommendations?
Woww SuperCool! Can you add a login page at the starting to add more security..can you assist me in this?
The content and tutorial itself is great, but the editing/pacing needs love. Cutting to another view or step before completing a line has been very frustrating for me as a beginner.
Hi a great app, I´m learning a lot with the tutorial. a question, can this app be used in phones, or it needs to be configured to that purpose, if yes how to do so ? Thanks !
Please I’m stuck at 12:16, whenever I click on package manager console. It brings up cannot bind “isolevel” and 3 other cannot bind
Shamseer,
@1:49:44 What exactly are x (for x.Category), y (used with y.Date), i (for i.Category) and j (used for amount)? Are these just variables defined at that point of the code to store that information? I'm a little lost as to where they came from.
there are just lambda expressions, go check the documentation
Hi , I tried to implement it , but after removing header and footer , i am getting blank space in top and bottom , just the table is rendered , is there anything i can do about it ? pls help. Thank you.
И кстати, сейчас проект лучше всего сразу загружать из VS, там не надо париться с лицензией, так как используешь на смежных правах с учеткой, привязанной к студии, иначе, издатели фреймворка, блокируют твою учетную запись и все лицензии ))
hey im not able to clone its says that invalid index packerror
i want more examples with Blazor
can this be built on .net 5.0 and visual studio 2019 ?
Which database platform did you use in this video???
Can I get the ER diagram for the same?
How do I hide formattedamount of some categories in doughnut chart if they are too small? My chart has a lot of categories and the datalabels are all over the place. I already tried settling formattedamount null if it’s
what coding languages are you using in this project
hello i added my local vs2022 db path the appsettings and after running the 2 Pm commands i have the db in vs2022 but not in sql server 2019 but the project runs; how do i get it to populate in sql server?
Which font style and theme are you using in vs code?
At 40:56 when I add a new one it doesn't appear The Title field is required.
How we add login log out & sign up
Mine wasn't able to generate the database with the supplied connection string I had to do it manually
Not sure why it's only letting me create an Expense and Income one at a time, I can't create multiples. Any help will be greatly appreciated.
MVC Product & Category entity relationship project
Creat one video in this topic
Good application, any alternate website to copy and paste the icon symbol.
www.coralnodes.com/font-awesome-alternatives/.
I didn't find any other bigger library than fa icons.
well can't we build in a web program and use container such as electron to get a windows application?
it would be more cost effective won't it be?
Hi CodeAffection please make video on Razor pay integration with DB using latest asp.net core please
I m not able to retrieve database information of income and expense on the dashboard....why is the so...i followed all thr steps according 😢
Hi Sir,
Should we need to install the syncfusion web installer exe to use in the web app? I have request for the community license. its still in the approve process. Please help.
get
{
return Category == null ? "" : Category.Icon + " " + Category.Title;
}
this code is not working .....i debug and found that category is getting null value but they have all the property like category id and all things .... is anyone have any solution ???
Do we need to add tables in database?
Is this sorted out bro ?
18:35
I have the following error when loading the Category/Index page:
SqlException: A connection was successfully established with the server, but then an error occurred during the login process.
(provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
There are no errors in SQLServer & I can't see it from the MMC either.
It should be related to connection string. do you still have the error?
@@CodAffection I still do.
How do you suggest to correct it?
@@12-OneTwo I'm providing one-to-one support. ping me at support@codaffection.com.
@@12-OneTwo add Encrypt=false; to your connection string
@@badrelrhazi I'll try it.
Hi! I was trying to add Scaffolded Identity to the project in which i already had a usual ApplicationDbContext and already created tables in this db. I was trying to create IdentityDbContext and inherit my ApplicationDbContext from it etc. In the end, I still did not understand how to do this, and whether it is possible.
Maybe someone knows how to deal with it?
Tengo problemas al crear la migracion
a pesar que tengo instalado el Microsft....Tool
This is a monthly or yearly expenses tracker?
How to get the syncfusuon community license as a student?🙂
After update-database, am getting an error of "the connectionstring property has not been initialized, how do I correct it?
please verify the connection string you've given in C# code. it should be the exact name given in appsetttings.json
can someone please explain what his doing at 43:52 till 44:45? Thank you.
For implementing the edit operation we need the corresponding entity id. Then only we can update the respective entity from the EF or Database.
Without the hidden field, post action method doesn't receive the id details. You could better understand this if you submit the form with and without the hidden field
@@CodAffection Thank you
can we convert it into an android app ?
Can you say the requirements of this project ?
SIR, request you to spare some time to post same app using Angular as a front-end as it is very great app you have post on TH-cam.
Awaiting your response
Thanks
Boom that's it 😭😭
Boom!
Повторно пересматриваю, вопрос, зачем делать сортировку строк, если первым наименованием идет иконка, текстовая... сортируется то, все равно по ней, а она не несет никакого смысла и сортировка не работает )
Please code affection do a version in blazor wasm
Do you have plan to create other version using WebApi & Angular or React?
Not yet decided :)
@@CodAffection WebApi & Angular, please!
Can we do it using visual studio 2019???
Yes. doesn't depend on the IDE.
And also .net 5.0
sure but there might few changes required.
try it without hesitation, let me know what goes wrong.
@@CodAffection okay sure
Hey Sir Delete Button not working, its show's HTTP ERROR 405 , Please Help
@CodeAffection any Update?
Nice explain, code base is not accessible 😕😕
Is the VS Enterprise one or the usual community one ?
U had installed entityframeworkcore package but its not showing in the nuget manager
Whats the solution ?
Community Version.
not showing in nuget manager? nuget manager search inside browse tab it should be there if you there is an internet access. let me know if you still have the same problem.
Hi bro actually I am doing your project and I am getting some errors can u please help me
Invalid value for key 'Multiple Active Result Sets'.
PM>
Make sure there is no typo.
I am getting this error
a namespace cannot directly contain members such as fileds, methods or statements 9:11
what did you name your project?
I tried to host a small Mvc project m azure, it started charging me hundreds of dollars before anyone used it. Can you make a video on how to host databases and projects?
I will consider your suggestion.
I had the same problem.
Azure SQL v-core model is an expensive service. Depending on how "small" your project is, you can also consider v-core serverless, DTU model, or even put the "DB" in file storage
@@FurqanaFathuzzaman Thanks. I was able to create one for $5.00 a month
How to run ur proj taken from github
Just clone the repository or download the project as zip.
how did it go?
Hello. I study the material, I try to repeat it. No syncfusion component is displayed. I'm from Russia, could it be related to this? My website only works through VPN...
Did you follow all the steps shown in this video ?
Is there any error message ?
@@CodAffection completed all the steps. These are all fucking sanctions. The software is blocked on the developer's side. When will this political war end?..
@@CodAffection I even downloaded this software, but it only works if you use CDN - Assets form. And in the video you show NPM
@@CodAffection is there any other software in which you can output such cool graphics? that he was not sanctioned?
@@CodAffection I found a way to launch the project. I'm going to bed now. I'll finish the code in the morning. I installed (VERY QUICKLY, until they blocked) the software, and then just updated the NPM package. Everything worked. I will continue on video. It is a pity that political bad people cannot come to peace. Because of this, the opportunity to gain new knowledge and apply it in practice disappears.
the title is not showing??
hi im unable to add any transaction in my project?can someone help me how to resolve it
Is there any error message? if not seen, try to run in debug mode with breakpoint in respective action method.
@@CodAffection yes it is showing failed to load resource error 404
error: There is already an object named 'Categories' in the database.
giving this error when im trying to update database after migration. help
and thanku for this tutorial
Do you still have the problem?
If you are just getting started the project.
reset all migrations as mentioned here. stackoverflow.com/a/11679386
@@CodAffection thankyou sir , i have reinstalled the server instance and now it's working. Thank you for your reply sir
Sir Please Add UserImage upload functionality in This Project Please??
59:32
2:17:50
2:23:43
Is the syncfusion free to use? I check their website, it said it is trial version only
There is a free community license for organizations with fewer than 5 users and less than $1 million USD in gross revenue are eligible for the Community License.
Apply for the license as shown in the video and they will contact you to confirm whether you are eligible for the same or not. that's it.
💥 boomb
"CodAffection" so this page is not about romance towards fish?...
16:08
Teacher Shamseer!
I'm working on an Inventory app, and I would like to add the functionality of adding / reducing Stock!
Is it possible to use an editable EJS-Grid object (to which you can add and remove Rows on the fly) with Row Cells that are pre-populated like your dropdown-list example for categories?
The idea would be for users to add Products to the grid (new Rows), and on that Row's Product column : select from a list of pre-existing Products! Which would filling-in other (non-editable) row cells, like "available Stock/Quantity".
Thanks in advance! And for the excellent tutorials.
2:06