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.
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?
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 !
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.
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.
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 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.
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
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 ???
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?
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
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.
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.
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.
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.
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
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?
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.
Повторно пересматриваю, вопрос, зачем делать сортировку строк, если первым наименованием идет иконка, текстовая... сортируется то, все равно по ней, а она не несет никакого смысла и сортировка не работает )
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
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.
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
И кстати, сейчас проект лучше всего сразу загружать из VS, там не надо париться с лицензией, так как используешь на смежных правах с учеткой, привязанной к студии, иначе, издатели фреймворка, блокируют твою учетную запись и все лицензии ))
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.
Severity Code Description Project File Line Suppression State Error TS2792 (TS) Cannot find module 'csstype'. Did you mean to set the 'moduleResolution' option to 'node', or to add aliases to the 'paths' option? how can i fix this error
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
how can i contact you or can i just ask you out in comments , I have a doubt regarding this code i am facing many errors and issues please help me out with that,
Hello I did not yet watch the full video But on the home page after entering amounts in the income and expenses in transactions are we supposed to see the amount and net amount? Cuz there us nothing Is there another source code?
hello as far as i know i beileve that step was a the very beginning of the video lesson? i belive i did so, and yes i can create incoen and expnese transcations but i dont see the update on the main dashboard; ok today i will check my project and do the migration again if i didnt and then update here Lisa
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.
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😅
Profile Picture + Logout + Tracker + Tab + ..... Awesome Thanks Sir
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 😊
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
The material is very practical, thank's for share this project.
Is there any way you can show how to do this for multiple profiles. Keeping the same categories, just showing different expense tracking
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?
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?
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 !
Dark reader! Thankyou for using it!
This looks awesome.
Will go thru it completely.
Thanks for the comment.
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.
Thank you so much this gives me a great place to start to learn from x
Glad you think so!
SIR, very eagerly awaiting you wonderful expenses tracker program in Angular
Thank you for such an informative tutorial!
Hi, what server can I use to deploy it? Do you have recommendations?
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.
Very precise tutorial. Thanks you :)
Thank you.
Woww SuperCool! Can you add a login page at the starting to add more security..can you assist me in this?
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
Awesome Yaar . Can not Believe on my eyes. this kind of thing can be made.
Thank you ❤ can i ask is that possible that this can connect to json file data?
what coding languages are you using in this project
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 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.
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
SIR, I have been eagerly awaiting for your post in Angular for the same application.
hey im not able to clone its says that invalid index packerror
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 ???
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.
this is the jackal blogger, all things he made behind, it is not asp.net, it is just html and css
This is just awesome! thank you sir
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 database platform did you use in this video???
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
Hi bro actually I am doing your project and I am getting some errors can u please help me
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
This is a monthly or yearly expenses tracker?
Can you say the requirements of this project ?
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 😢
How to get the syncfusuon community license as a student?🙂
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.
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?
At 40:56 when I add a new one it doesn't appear The Title field is required.
can this be built on .net 5.0 and visual studio 2019 ?
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.
Thank you for the great tutorial
Glad you found it helpful.
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.
can we convert it into an android app ?
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.
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.
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
Which font style and theme are you using in vs code?
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.
Hey Sir Delete Button not working, its show's HTTP ERROR 405 , Please Help
@CodeAffection any Update?
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?
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.
Повторно пересматриваю, вопрос, зачем делать сортировку строк, если первым наименованием идет иконка, текстовая... сортируется то, все равно по ней, а она не несет никакого смысла и сортировка не работает )
Mine wasn't able to generate the database with the supplied connection string I had to do it manually
Can I get the ER diagram for the same?
nice work
Glad you liked it.
Beutiful amazing design
Great channel!
Do you have plan to create other version using WebApi & Angular or React?
Not yet decided :)
@@CodAffection WebApi & Angular, please!
AMAZING
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
Tengo problemas al crear la migracion
a pesar que tengo instalado el Microsft....Tool
Do we need to add tables in database?
Is this sorted out bro ?
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?
How we add login log out & sign up
Invalid value for key 'Multiple Active Result Sets'.
PM>
Make sure there is no typo.
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
How to run ur proj taken from github
Just clone the repository or download the project as zip.
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.
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
Bravo!!!
И кстати, сейчас проект лучше всего сразу загружать из VS, там не надо париться с лицензией, так как используешь на смежных правах с учеткой, привязанной к студии, иначе, издатели фреймворка, блокируют твою учетную запись и все лицензии ))
Great !!
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.
Severity Code Description Project File Line Suppression State
Error TS2792 (TS) Cannot find module 'csstype'. Did you mean to set the 'moduleResolution' option to 'node', or to add aliases to the 'paths' option?
how can i fix this error
Is this error from an asp.net core mvc project ?
i want more examples with Blazor
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
Hi CodeAffection please make video on Razor pay integration with DB using latest asp.net core please
MVC Product & Category entity relationship project
Creat one video in this topic
how can i contact you or can i just ask you out in comments , I have a doubt regarding this code i am facing many errors and issues please help me out with that,
the title is not showing??
Boom!
Boom that's it 😭😭
Nice explain, code base is not accessible 😕😕
Please code affection do a version in blazor wasm
If i want to filtering or search , how i can do it when type is an icon in database
It's better to have a separate table and controller for icons. and then you use a dropdown to list them other forms.
Hope this helps.
@@CodAffection i have another question, what tools do you use to change code but must not reload the project
hello only entering transactions works nothing elese Lisa
did you figure it out?
is there any error message?
Hello
I did not yet watch the full video
But on the home page after entering amounts in the income and expenses in transactions are we supposed to see the amount and net amount? Cuz there us nothing
Is there another source code?
There is no actually error on the default dashboard page but it doesn't display the amount from transactions
@@pjmclenon Did you create the physical db through migration?
are you able to create any transaction ?
hello as far as i know i beileve that step was a the very beginning of the video lesson? i belive i did so, and yes i can create incoen and expnese transcations but i dont see the update on the main dashboard; ok today i will check my project and do the migration again if i didnt and then update here Lisa
Sir Please Add UserImage upload functionality in This Project Please??
💥 boomb
"CodAffection" so this page is not about romance towards fish?...