Build an Expense Tracker with Asp.Net Core MVC

[@CodAffection]

goo.gl/RFY5C2 : Subscribe to CodAffection goo.gl/bPcyXW : Buy me a Coffee bit.ly/36IA1cH : Asp.Net Core MVC CRUD Operations bit.ly/2z3P6RQ : Restaurant App in Asp.Net Core bit.ly/2yEPlpB : MVC Single Page Application with jQuery Ajax bit.ly/3NyeMLj : User Registration & Login in MVC

[@moustnk]

Dear can i have your mail to contact you

[@moustnk]

your

[@BESTFOURU]

Provided the best without any ads in between. Thanks a lot.

[@brandonkobeshchak]

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!

[@CodAffection]

Thanks for your wonderfull feedback. Glad you found it helpful.

[@sayatraveltheworld]

Hey! I'm also watched this video for my final project. Can you please share with your project for me, if you dont mind😅

[@codingislife6387]

Profile Picture + Logout + Tracker + Tab + ..... Awesome Thanks Sir

[@_c0derJ]

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!

[@mohdali-yq8gq]

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 KZbin

[@CodAffection]

Really appreciate your time for writing this comment. We will find a way to make it happen.

[@mohdali-yq8gq]

@@CodAffection thanks for your answer and great support.

[@josephbenz698]

@@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

[@CodAffection]

@@josephbenz698 no angular video has been created using the syncfusion library. If everything goes accordingly that's also a good idea.

[@chrisogonas]

Tremendously useful! Thanks for putting this together 👏👏👏

[@chapin9606]

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?

[@TheRaz911]

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.

[@CodAffection]

Thanks for the understanding 😊

[@cesarsoftnica5126]

The material is very practical, thank's for share this project.

[@StarsManny]

Dark reader! Thankyou for using it!

[@mohdali-yq8gq]

SIR, very eagerly awaiting you wonderful expenses tracker program in Angular

[@user-no6dl3iv4t]

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.

[@ebonyieliasizuchukwu1999]

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

[@wissamfawzy6543]

nice work

[@CodAffection]

Glad you liked it.

[@codingislife6387]

Awesome Yaar . Can not Believe on my eyes. this kind of thing can be made.

[@phillismable6303]

Thank you so much this gives me a great place to start to learn from x

[@CodAffection]

Glad you think so!

[@anurag3487]

This looks awesome. Will go thru it completely.

[@CodAffection]

Thanks for the comment.

[@deepinuniverseblore]

Very precise tutorial. Thanks you :)

[@CodAffection]

Thank you.

[@mohdali-yq8gq]

SIR, I have been eagerly awaiting for your post in Angular for the same application.

[@Asisvenia]

Thank you for such an informative tutorial!

[@lukehenry6537]

Is there any way you can show how to do this for multiple profiles. Keeping the same categories, just showing different expense tracking

[@2005Azm]

This is just awesome! thank you sir

[@RafaVeraDataEng]

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?

[@kangjiawei7526]

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

[@phillismable6303]

Great video such a shame that you never finished off with the reports side of things, as that would ahve rounded the project off.

[@CodAffection]

Thanks for your constructive criticism. Could be done accordingly in similar future lessons.

[@user-od5lm1ne4y]

this is the jackal blogger, all things he made behind, it is not asp.net, it is just html and css

[@tauraigombera]

Thank you for the great tutorial

[@CodAffection]

Glad you found it helpful.

[@Big_Dai]

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.

[@JohnSunda]

there are just lambda expressions, go check the documentation

[@sravenkande]

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.

[@igorfilit713]

Great channel!

[@yomyrodriguez1516]

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 !

[@fajarariev9184]

AMAZING

[@mohitsingh-jy8er]

Woww SuperCool! Can you add a login page at the starting to add more security..can you assist me in this?

[@Cursix]

Beutiful amazing design

[@TheArtVoid]

hey im not able to clone its says that invalid index packerror

[@anhtuanppoi8448]

Great !!

[@leandrovazquez9159]

Hi, what server can I use to deploy it? Do you have recommendations?

[@samjoshua9456]

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.

[@MusicalGeniusBar]

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?

[@CodAffection]

I will consider your suggestion.

[@jimmydavila7196]

I had the same problem.

[@FurqanaFathuzzaman]

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

[@jimmydavila7196]

@@FurqanaFathuzzaman Thanks. I was able to create one for $5.00 a month

[@lodiyt9892]

Thank you ❤ can i ask is that possible that this can connect to json file data?

[@shabanelmogy7912]

i want more examples with Blazor

[@minhluu7886]

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

[@codebuster2716]

Bravo!!!

[@silveralcid]

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.

[@houseofevengaming1629]

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

[@JevLogin]

И кстати, сейчас проект лучше всего сразу загружать из VS, там не надо париться с лицензией, так как используешь на смежных правах с учеткой, привязанной к студии, иначе, издатели фреймворка, блокируют твою учетную запись и все лицензии ))

[@gregoryallen1122]

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.

[@jonathansmith7285]

Mine wasn't able to generate the database with the supplied connection string I had to do it manually

[@sapphirefang]

Which database platform did you use in this video???

[@TranKhanhpom-pom]

At 40:56 when I add a new one it doesn't appear The Title field is required.

[@gamerfromkudla6584]

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?

[@AbdullahMubeenA.M]

This is a monthly or yearly expenses tracker?

[@harsimran0198]

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 😢

[@boobalakrishnan2384]

Single application can use 2 methods? Like With EF database creation and few functions and also use store procedures for some complicated operation?

[@CodAffection]

IDK, Seems like a feasible approach.

[@farveshRahim]

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.

[@adarshchouhan5712]

Invalid value for key 'Multiple Active Result Sets'. PM>

[@CodAffection]

Make sure there is no typo.

[@majk1383]

what coding languages ​​are you using in this project

[@pjmclenon]

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?

[@blockchaindevelopment120]

Which font style and theme are you using in vs code?

[@rdanisatria1546]

can this be built on .net 5.0 and visual studio 2019 ?

[@12-OneTwo]

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.

[@CodAffection]

It should be related to connection string. do you still have the error?

[@12-OneTwo]

@@CodAffection I still do. How do you suggest to correct it?

[@CodAffection]

​@@12-OneTwo I'm providing one-to-one support. ping me at [e-mail].

[@badrelrhazi]

@@12-OneTwo add Encrypt=false; to your connection string

[@12-OneTwo]

@@badrelrhazi I'll try it.

[@vishnupyda]

Can you say the requirements of this project ?

[@AngelaMariaEspitiaGomez]

Tengo problemas al crear la migracion a pesar que tengo instalado el Microsft....Tool

[@illia1732]

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?

[@addybeez3277]

Hey Sir Delete Button not working, its show's HTTP ERROR 405 , Please Help

[@addybeez3277]

@CodeAffection any Update?

[@743Dora]

Good application, any alternate website to copy and paste the icon symbol.

[@CodAffection]

www.coralnodes.com/font-awesome-alternatives/. I didn't find any other bigger library than fa icons.

[@JaspPankaj]

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 ???

[@MrBroYT007]

Hi bro actually I am doing your project and I am getting some errors can u please help me

[@user-mg1vg3mp5f]

can we convert it into an android app ?

[@DHARAGANATRA-ik4ri]

Can I get the ER diagram for the same?

[@yasin8447]

can someone please explain what his doing at 43:52 till 44:45? Thank you.

[@CodAffection]

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

[@yasin8447]

@@CodAffection Thank you

[@JevLogin]

Повторно пересматриваю, вопрос, зачем делать сортировку строк, если первым наименованием идет иконка, текстовая... сортируется то, все равно по ней, а она не несет никакого смысла и сортировка не работает )

[@viral_plays1081]

How to get the syncfusuon community license as a student?🙂

[@Zenbotx]

How we add login log out & sign up

[@vishnuravva7992]

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 ?

[@CodAffection]

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.

[@JigarTapkirwala]

Do you have plan to create other version using WebApi & Angular or React?

[@CodAffection]

Not yet decided :)

[@BolsaCast365]

@@CodAffection WebApi & Angular, please!

[@mrtrader3661]

the title is not showing??

[@JevLogin]

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]

Did you follow all the steps shown in this video ? Is there any error message ?

[@JevLogin]

@@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?..

[@JevLogin]

@@CodAffection I even downloaded this software, but it only works if you use CDN - Assets form. And in the video you show NPM

[@JevLogin]

@@CodAffection is there any other software in which you can output such cool graphics? that he was not sanctioned?

[@JevLogin]

@@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.

[@keshav_Pandit-]

I am getting this error a namespace cannot directly contain members such as fileds, methods or statements 9:11

[@CodAffection]

what did you name your project?

[@mohdali-yq8gq]

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 KZbin. Awaiting your response Thanks

[@ankitmaurya8109]

MVC Product & Category entity relationship project Creat one video in this topic

[@davidcordoba6424]

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.

[@MTSightseeing]

Hi CodeAffection please make video on Razor pay integration with DB using latest asp.net core please

[@hardikmasalawala254]

Nice explain, code base is not accessible 😕😕

[@domi_nator]

Boom that's it 😭😭

[@doodlex6399]

Do we need to add tables in database?

[@vishnupyda]

Is this sorted out bro ?

[@ahmadsalim1726]

Please code affection do a version in blazor wasm

[@jantheman5741]

Boom!

[@cafedecausette2182]

Is the syncfusion free to use? I check their website, it said it is trial version only

[@CodAffection]

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.

[@Tentoumushi69]

"CodAffection" so this page is not about romance towards fish?...

[@bitaha3964]

59:32

[@bitaha3964]

2:17:50

[@bitaha3964]

2:23:43

[@manavbangotra4356]

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

[@CodAffection]

Do you still have the problem? If you are just getting started the project. reset all migrations as mentioned here. stackoverflow.com/a/11679386

[@manavbangotra4356]

@@CodAffection thankyou sir , i have reinstalled the server instance and now it's working. Thank you for your reply sir

[@aishwaryakg2411]

Can we do it using visual studio 2019???

[@CodAffection]

Yes. doesn't depend on the IDE.

[@aishwaryakg2411]

And also .net 5.0

[@CodAffection]

sure but there might few changes required. try it without hesitation, let me know what goes wrong.

[@aishwaryakg2411]

@@CodAffection okay sure

[@codingislife6387]

Sir Please Add UserImage upload functionality in This Project Please??

[@faizanhamza7807]

💥 boomb

[@adarshchouhan5712]

Edit is not deleting

[@CodAffection]

Is there any error message?

[@pjmclenon]

hello only entering transactions works nothing elese Lisa

[@CodAffection]

did you figure it out? is there any error message?

[@pjmclenon]

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?

[@pjmclenon]

There is no actually error on the default dashboard page but it doesn't display the amount from transactions

[@CodAffection]

@@pjmclenon Did you create the physical db through migration? are you able to create any transaction ?

[@pjmclenon]

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

[@hansodolce9943]

that's cool but a user can't log in and out

[@CodAffection]

It's explained in a seperate video here : kzbin.info/www/bejne/ravEoISfiMRsmqs

[@simranbansal5644]

I faced issue in migration

[@CodAffection]

Is there any specific error message?

[@simranbansal5644]

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

[@CodAffection]

@@simranbansal5644 did you try this : stackoverflow.com/a/8243370/4133590