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 RUclips
@@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
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 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 !
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.
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.
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.
И кстати, сейчас проект лучше всего сразу загружать из VS, там не надо париться с лицензией, так как используешь на смежных правах с учеткой, привязанной к студии, иначе, издатели фреймворка, блокируют твою учетную запись и все лицензии ))
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.
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.
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 ???
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?
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.
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.
Повторно пересматриваю, вопрос, зачем делать сортировку строк, если первым наименованием идет иконка, текстовая... сортируется то, все равно по ней, а она не несет никакого смысла и сортировка не работает )
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.
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 RUclips. Awaiting your response Thanks
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
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
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
Format of initialisation string does not match when I tried to update - database and when I tried to add migration I got service provider error for that I had to add on configuring method and a parameterless constructor inside db context
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 RUclips
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 😊
Dark reader! Thankyou for using it!
The material is very practical, thank's for share this project.
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 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!
Is there any way you can show how to do this for multiple profiles. Keeping the same categories, just showing different expense tracking
SIR, very eagerly awaiting you wonderful expenses tracker program in Angular
Awesome Yaar . Can not Believe on my eyes. this kind of thing can be made.
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 such an informative tutorial!
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?
SIR, I have been eagerly awaiting for your post in Angular for the same application.
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
This is just awesome! thank you sir
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 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 !
AMAZING
Great channel!
Thank you for the great tutorial
Glad you found it helpful.
Hi, what server can I use to deploy it? Do you have recommendations?
nice work
Glad you liked it.
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
Thank you ❤ can i ask is that possible that this can connect to json file data?
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.
Beutiful amazing design
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.
hey im not able to clone its says that invalid index packerror
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
this is the jackal blogger, all things he made behind, it is not asp.net, it is just html and css
Bravo!!!
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.
At 40:56 when I add a new one it doesn't appear The Title field is required.
Great !!
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
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.
Which database platform did you use in this video???
Woww SuperCool! Can you add a login page at the starting to add more security..can you assist me in this?
This is a monthly or yearly expenses tracker?
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.
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?
can this be built on .net 5.0 and visual studio 2019 ?
Mine wasn't able to generate the database with the supplied connection string I had to do it manually
Which font style and theme are you using in vs code?
И кстати, сейчас проект лучше всего сразу загружать из VS, там не надо париться с лицензией, так как используешь на смежных правах с учеткой, привязанной к студии, иначе, издатели фреймворка, блокируют твою учетную запись и все лицензии ))
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 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 we add login log out & sign up
Invalid value for key 'Multiple Active Result Sets'.
PM>
Make sure there is no typo.
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.
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.
Can you say the requirements of this project ?
Tengo problemas al crear la migracion
a pesar que tengo instalado el Microsft....Tool
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 ???
Can I get the ER diagram for the same?
can we convert it into an android app ?
How to get the syncfusuon community license as a student?🙂
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?
Do we need to add tables in database?
Is this sorted out bro ?
i want more examples with Blazor
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
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.
Hi bro actually I am doing your project and I am getting some errors can u please help me
How to run ur proj taken from github
Just clone the repository or download the project as zip.
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.
Do you have plan to create other version using WebApi & Angular or React?
Not yet decided :)
@@CodAffection WebApi & Angular, please!
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
Hey Sir Delete Button not working, its show's HTTP ERROR 405 , Please Help
@CodeAffection any Update?
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?
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.
Boom!
Повторно пересматриваю, вопрос, зачем делать сортировку строк, если первым наименованием идет иконка, текстовая... сортируется то, все равно по ней, а она не несет никакого смысла и сортировка не работает )
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
Hi CodeAffection please make video on Razor pay integration with DB using latest asp.net core please
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.
the title is not showing??
Boom that's it 😭😭
Please code affection do a version in blazor wasm
💥 boomb
Nice explain, code base is not accessible 😕😕
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 RUclips.
Awaiting your response
Thanks
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
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 ?
MVC Product & Category entity relationship project
Creat one video in this topic
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
59:32
2:17:50
2:23:43
Sir Please Add UserImage upload functionality in This Project Please??
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
I faced issue in migration
Is there any specific error message?
Format of initialisation string does not match when I tried to update - database and when I tried to add migration I got service provider error for that I had to add on configuring method and a parameterless constructor inside db context
@@simranbansal5644 did you try this : stackoverflow.com/a/8243370/4133590