Enquiries and Intimations Tracker
This web application is used to keep track of enquiries of a typical training institutue such as Srikanth Technologies. It allows
counsellors to store details of Enquiries, Courses, Batches and Intimations sent through mails to enquirers.
- Asp.Net 4.0
- C# Language
- SQL Server 2005 Express Edition
- Visual Studio.NET 2010
- Layered Architecture with Presentation Layer and Data Access Layer
- Some database operations are done with stored procedures.
- ObjectDataSource is used in presentation layer to talk to DAL.
- GridView is mainly used to display details.
- ADO.NET is used to access database
The following are the major operations in this application.
- Login
- Change password
- Home page
- Add Enquiry
- Search Enquiries
- Showing details of enquirer
- List of most recently handled enquiries
- Add Batch
- List of Batches
- List of Course
- Updation and deletion of enquiry
- Sending intimation to selected enquiries
- Getting history of intimations
- Logout
Steps to download, deploy and run this project
The following are the steps to be taken to run the existing part of the application. Sql Server database, which contains all required table and stored procedures, is boundled along with this application.
- Download enquiries.rar and unzip it into any directory in your system.
For example, if you extract to c:\ then it will create a directory c:\enquiries.
- Open Visual Studio.NET 2010
- Open the website from the directory into which you extracted the .rar file. For example, c:\enquiries
- Database (Database.dbf) is placed in App_Data and it contains required tables and stored procedures
- Go to Solution Explorer and make login.aspx the startup page.
- Run project from Visual Studio.NET 2010
- You should see login.aspx page.
- Login using loginname - joe, and password - j. You can add more counsellors by adding rows to COUNSELLORS table
- Test the rest of the options.