Academic Advising System

A comprehensive web-based academic advising system designed to streamline the interaction between students, academic advisors, and administrative staff in educational institutions. The system facilitates course management, graduation planning, and academic request handling through a user-friendly web interface.

🎓 Overview

The Academic Advising System is built to address the complex needs of academic institutions by providing a centralized platform for:

• Student academic progress tracking
• Course prerequisite management
• Graduation plan creation and monitoring
• Academic request processing
• Financial status tracking
• Makeup exam registration

✨ Features

👨‍🎓 Student Portal

• Course Management
  • View available courses and their details
  • Check course prerequisites
  • View assigned instructors
• Academic Planning
  • Access graduation plans
  • Track academic progress
• Exam Services
  • Register for makeup exams
  • View exam schedules
• Financial Services
  • Check installment plans
  • View financial status
• Communication
  • Send requests to advisors
  • Access contact information

👨‍🏫 Advisor Portal

• Student Management
  • View assigned students
  • Monitor student progress
• Academic Planning
  • Create and update graduation plans
  • Add courses to student plans
• Request Handling
  • Process student requests
  • Approve/deny academic petitions
• Course Management
  • Add new courses to the system

👨‍💼 Administrator Portal

• System Management
  • Add new users and courses
  • Update system configurations
  • Delete outdated records
• Data Management
  • View comprehensive system reports
  • Link related academic records
• Certificate Services
  • Issue academic certificates
  • Manage certificate requests

🛠️ Technology Stack

• Frontend: ASP.NET Web Forms
• Backend: C# (.NET Framework 4.8)
• Database: SQL Server
• Development Environment: Visual Studio
• Web Server: IIS Express

📋 Prerequisites

Before running this application, ensure you have the following installed:

• Visual Studio 2019/2022 with ASP.NET and web development workload
• .NET Framework 4.8
• SQL Server (Express, Developer, or Standard edition)
• SQL Server Management Studio (SSMS) (optional but recommended)

🚀 Installation & Setup

1. Clone the Repository

git clone https://github.com/ahmedhussein107/Advising_System.git
cd Advising_System

2. Database Setup

1. Open SQL Server Management Studio
2. Connect to your SQL Server instance
3. Open the source/DB_M2_Solution --Upload.sql file
4. Execute the script to create the database and tables
5. Verify that the Advising_System database has been created successfully

3. Configure Connection String

1. Open the project in Visual Studio
2. Create or edit the source/web.config file
3. Add the connection string configuration to match your SQL Server setup:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <connectionStrings>
        <add name="Advising_System" 
             connectionString="Server=YOUR_SERVER_NAME;Database=Advising_System;Integrated Security=true;" 
             providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.web>
        <compilation targetFramework="4.8" />
        <httpRuntime targetFramework="4.8" />
    </system.web>
</configuration>

Note: Replace YOUR_SERVER_NAME with your actual SQL Server instance name (e.g., localhost, .\SQLEXPRESS, or your server name).

4. Build and Run

1. Open source/source.sln in Visual Studio
2. Build the solution (Build → Build Solution)
3. Press F5 or click "Start" to run the application
4. The application will open in your default browser at https://localhost:44324/

📁 Project Structure

Advising_System/
├── source/
│   ├── Admin_SRC/              # Administrator functionality
│   │   ├── Add.aspx            # Add new records
│   │   ├── Delete.aspx         # Delete records
│   │   ├── Update.aspx         # Update existing records
│   │   ├── View.aspx           # View system data
│   │   ├── Issue.aspx          # Issue certificates
│   │   └── Link.aspx           # Link records
│   ├── Advisor_SRC/            # Advisor functionality
│   │   ├── Actions/            # Advisor actions
│   │   ├── Requests/           # Handle student requests
│   │   └── Students/           # Student management
│   ├── Student_SRC/            # Student functionality
│   │   ├── Courses/            # Course-related pages
│   │   ├── Financial/          # Financial information
│   │   ├── Grad_Plan/          # Graduation planning
│   │   ├── Main/               # General student pages
│   │   ├── Makeup_Exams/       # Makeup exam services
│   │   └── Requests/           # Student requests
│   ├── Properties/             # Project properties
│   ├── Login_Page.aspx         # Main login page
│   ├── Registration_Page.aspx  # User registration
│   ├── Error_Page.aspx         # Error handling
│   ├── web.config              # Application configuration
│   ├── source.csproj           # Project file
│   └── DB_M2_Solution --Upload.sql  # Database schema
└── README.md

🔐 Default Access

The system includes a default administrator account for initial setup:

• Admin ID: 123456
• Admin Password: 1234

After setting up the database, you can:

1. Use the default admin credentials to access the administrator portal
2. Create additional user accounts through the registration page
3. Manage user accounts through the admin interface

The system supports three user types:

• Students: Access academic planning, course information, and request services
• Advisors: Manage assigned students and handle academic requests
• Administrators: Full system management and configuration access

🎯 Usage

1. Login: Navigate to the login page and enter your credentials
2. Registration: New users can register through the registration page
3. Navigation: Use the role-specific dashboard to access available features
4. Academic Planning: Students and advisors can collaborate on graduation plans
5. Request Management: Students can submit requests for advisor review

🤝 Contributing

We welcome contributions to improve the Academic Advising System! Please follow these steps:

1. Fork the repository
2. Create a feature branch (git checkout -b feature/YourFeatureName)
3. Commit your changes (git commit -m 'Add some feature')
4. Push to the branch (git push origin feature/YourFeatureName)
5. Open a Pull Request

Development Guidelines

• Follow C# coding conventions
• Ensure proper error handling
• Add comments for complex logic
• Test thoroughly before submitting

📝 License

This project is open source and available under the MIT License.

🐛 Issues & Support

If you encounter any issues or have questions:

1. Check the Issues page
2. Create a new issue if your problem isn't already documented
3. Provide detailed information about the problem and your environment

📞 Contact

For additional support or questions about the Academic Advising System, please contact the development team through the GitHub repository.

---

Note: This system is designed for educational purposes and may require additional security measures and testing before deployment in a production environment.