Personal Accounting

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

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.