University Management System

Overview

This University Management System is a robust and user-friendly web application developed using ASP.NET MVC 5 and Entity Framework 6, leveraging the Database First approach. The system provides a seamless interface for managing university-related data, including Courses, Departments, Instructors, and Students. It also incorporates image handling capabilities for user profiles and other relevant records.

Features

• Course Management: Create, update, delete, and view courses. Assign courses to instructors and manage course details efficiently.
• Department Management: Manage departments, assign instructors as department heads, and link courses to departments.
• Instructor Management: Add, update, delete, and view instructor profiles. Assign office locations and courses to instructors, and manage instructor-specific details.
• Student Management: Enroll students, manage student profiles, and handle student-specific data including images.
• Image Handling: Upload and manage images for instructors and students to enhance user profiles and other records.
• Sorting and Filtering: Implement sorting and filtering functionalities across various tables for improved data navigation.
• Validation and Error Handling: Comprehensive validation and error handling to ensure data integrity and a smooth user experience.

Technologies Used

• ASP.NET MVC 5: For creating a scalable and maintainable web application.
• Entity Framework 6: For data access and management using the Database First approach.
• Bootstrap: For responsive and modern UI design.
• jQuery and DataTables: For enhanced user interactions and data handling.
• SQL Server: As the database solution to store and manage application data.

System Overview in Images

Below are some screenshots of the system:

Home Page

Course Management

Department Management

Instructor Management

Student Management

Master-Detail CRUD Application

Using Entity Framework Code First for managing Courses, Departments, Instructors, and Students with image support.

How to Use This Application

• Initial Setup:
  • Open Microsoft SQL Server Management Studio.
  • Copy the server name.
  • Navigate to the root folder of the IdbUniversity application.
  • Open Web.config.
  • Update the data source with your server name (other settings remain unchanged).
• Database Setup:
  • Open Visual Studio.
  • Navigate to Tools -> NuGet Package Manager -> Package Manager Console.
  • Run the command:

    update-database

  • The database will be created, and data will be seeded.
  • If update-database does not work, delete the Migrations folder and run the following commands:

    Enable-Migrations
    Add-Migration initIsdbUniversityData
    Update-Database

  • If issues persist, ensure the database catalog name in Web.config is correct.
  • Note: The update-database command should work fine Insha Allah.
  • ***Note: After updateing database and seed, open sql server management, right click on table CourseInstructor table in edit mode the insert CourseID 1254 and InstructorID 1
• Rebuild the project
• Run the Application:
  • Open HomeController and run the project.
• Features:
  • Search functionality works by LastName and FirstMidName.
  • Data/Row sorting works by LastName, FirstName, and Email.
  • Pagination is implemented with 3 rows per table.

This setup and features ensure a smooth and user-friendly experience for managing university-related data.

Request:

If you face any problem you can mail me to : [email protected]

To hire me as freelancer feel free to contact me