HI guys, I'm just about to build a small, simple expenses application. Basically I'd like to keep track of how much money I'll make by selling some stuff, and therefore I have to input the income and have a total of it, the expenses (fee, refunds) and total it and then the effective total (income - expenses), so pretty simple stuff. I'd like to store everything in the database as I'd like to have a record of everything (income per item, total income, total expenses and effective total), but I'm not sure where the calculations should occur (database or on the fly in the application). So for example: say I sell a camera, I'd like to store the price paid and the item on the database. But where do I calculate the total income, expenses and effective total? The thing is so far I've only stored and retrieved stuff from the EF database, not sure what I have to do to make calculations and store the values back in the database.
In terms of data visualization, I'd like to have a good summary of everything, so again I'd like to be able to see what I sold, for how much and keep track of income, expenses and effective total.
Needless to say, if somebody have any suggestions, or think that the way I want to implement the application is wrong, please do let me know. Once we establish the way to proceed I'll think about the classes needed