This project is initiated to streamline the current process of leasing automobiles and to keep track of income and expenses. The current process involves printing documents and manually entering information into these documents.
This project foresees two systems, a production system and a test system.
The production system will consist of a Web Server, a Database Server running in a Windows Server environment on an existing Dell Poweredge SC430 server and a number of Workstations and Printers. The test system will consist of a Web Server, a Database Server and one or two Workstations and Printers. Initially, the Web and Database Servers shall be physically located on the premises and used through the intranet. There shall be a connection between the place where the servers are installed and offsite locations where access to the servers is required. This can be accomplished over the internet through a Virtual Private Network (VPN).
The Web Server and Database Server shall run Microsoft IIS and SQLServer Express software. The web applications shall be written using ASP.net. The user will use a User Name and Password to check into the system. The system shall verify the validity of the originating workstation or modem by means of an IP and/or MAC address.
This will be the software that
. populates the tables Automobiles, Lessees, Locations and Users;
. generates Leases;
. records Payments and Expenses;
. records Tickets;
. records Accidents and stores Accident pictures;
. generates cost reports by vehicles;
. generates cost reports by lessees;
. generates lease payments received;
. generates schedule of lessees due to come in;
. generates outstanding lease payment reports;
. generates outstanding traffic ticket reports.