Students Tracker
This web application allows a training institute to keep track of Subjects, Courses and Students
The overall architecure is ASP.NET MVC 4.0 (with C# and Razor)
-> Entity Framework -> SQL Server Database.
This website uses the following tools and technologies.
- Asp.Net MVC 4.0
- Razor engine for presentation
- C# Language
- SQL Server LocalDB
- Visual Studio.NET 2013 Express for Web
- Data Validation Attributes for validation using JQuery
- Ajax
- Entity Framework
- Forms Authentication
- Layout and Stylesheets
The following are the major operations in this application.
- User Login
- Add, list, update, add and delete Subject
- Add, update and delete Course
- List running courses
- List upcoming courses
- List courses history
- List students of a course
- Add student to course
- Edit and delete student
- Search Students
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 tables, is bundled
along with this application.
- Download students.rar and unzip it into any directory in your system.
For example, if you extract to c:\ then it will create a directory c:\students.
- Start Visual Studio.NET 2012 Express for Web
- Open the project from the directory into which you extracted the .rar file. For example, c:\students
- Database (students.mdf) is placed in App_Data and it contains required tables. Tables contain some sample data for testing.
- I also provided tables.sql, which contains commands to create tables. Though not required now, it could be useful in some cases.
- In order to keep download small, i have removed .dll files from BIN folder. So, project may not run after you open it in Visual Studio. Add libraries to this project or create another project
and copy source code into that new project.
Run project from Visual Studio.NET after you are done with the above procedure.
- You should see login page
- Login with password that you find in the source code and test other options also.