Personal Accounting  free asp.net project with source codes

This web application allows users to store details regarding expenses, income, fixed deposits, mutual funds and insurace. Apart from provides required reports and searching facility, it also reminds user about maturity of fixed deposits and insurance premium policy dues.

Technologies and Products used

• ASP.NET 2.0
• C# language
• Visual Web Developer 2005 Express Edition
• SQL Server 2000
• SMTP Server - CMaliServer

File Structure

The following is the directory structure of this application.

exam
 |- App_Code
 |    |-Database.cs
 |- App_Themes
 |    |-all
 |        |-all.css
 |- all
 |    |- forgotpassword.aspx
 !- default.aspx
 |- login.aspx
 |- changepwd.aspx
 |- allusers.master
 |- main.master
 |- addincomehead.aspx
 |- addincome.aspx
 |- adddeposit.aspx
 |- editdeposits.aspx
 |- depositsreport.aspx
 |- incomereport.aspx
 |- logout.aspx
 |- mfreport.aspx
 !- searchexp.aspx
 !- searchincome.aspx
 |- tables.sql
 |- Web.config
 !- web.sitemap
 !- unregister.aspx
 !- unregisteruser.sql

Operations and related files

The following table lists operations and associated objects and files.

Operation	Files
Login	login.aspx
Master page of all	all.master
Master page of logged in users	main.master
Home Page	default.aspx
Change password	changepwd.aspx
Add income head	addincomehead.aspx
Add income entry	addincome.aspx
Add deposit	adddeposit.aspx
Search income entries	searchincome.aspx
Search exp entries	searchexp.aspx
Editing Deposits	editdeposits.aspx
Income Report	incomereport.aspx
Mutual Funds Report	mfreport.aspx
Logout	logout.aspx
Unregister user	unregister.aspx
Register User	all\register.aspx
Forgot Password	all\forgotpassword.aspx

The following are the steps to related to be taken to run the existing part of the application :

1. Download personalaccouting.zip and unzip it into any directory in your system. (For example if you extract to d:\ then it will create a directory personalaccounting in d:\ .
2. Connect to SQL Server and create pa database as follows:
   CREATE DATABASE PA
3. Make pa the current database by giving the following command
   USE pa
4. Create required tables using TABLES.TXT file and also insert appropriate data into tables.
5. Open Visual Web Developer 2005 Express Edition.
6. Open the project from the directory into which you extracted project.For example, d:\personalaccounting
7. Goto Solution Explorer and make login.aspx the startup page.
8. Run project from VWD 2005 Express Edition.
9. You should see login.aspx page.

Admin Project

This application is used by Adminstrator of Personal Accounting application to send mails and news letters to users. Follow the steps below to extract and run this application.

1. Download paadmin.zip and unzip it into any directory in your system. (For example if you extract to d:\ then it will create a directory paadmin in d:\ .
2. Open Visual Web Developer 2005 Express Edition.
3. Open the project from the directory into which you extracted project.For example, d:\paadmin
4. Goto Solution Explorer and make default.aspx the startup page.
5. Run project from VWD 2005 Express Edition.
6. You should see default.aspx page with menu and select required option in the menu.