Claims Management System

Project Overview

This project is a Claims Management System for Helping Hands Software Solution, developed using ASP.NET Core MVC and SQL Server. It allows lecturers to submit claims for hours worked, which can be reviewed by a program coordinator for approval or rejection. The system also supports file uploads (limited to .txt files) and ensures that claims are submitted with the correct date.

Features

• Lecturer Login: Allows lecturers to log in and submit claims.
• Coordinator Login: Enables coordinators to log in and review submitted claims, approving or rejecting them.
• File Upload: Lecturers can upload .txt files as supporting documents for their claims (up to 1 MB).
• Claims Tracking: Lecturers can track the status of their submitted claims.
• Role-based Navigation: Lecturers and coordinators have different dashboards tailored to their roles.

Technologies Used

• ASP.NET Core MVC: For the web application and routing.
• Entity Framework Core: For database interaction with SQL Server.
• SQL Server: As the relational database for storing claims data.
• Razor Pages: Used for handling the views for Lecturer and Coordinator dashboards.
• Bootstrap: For responsive and user-friendly UI design.
• Session Management: To handle user roles and login states.

How to Use

Lecturer

1. Login: Lecturers can log in using the following hardcoded credentials:

   • Email: lecturer@example.com
   • Password: lecturer123

2. Submit a Claim: Lecturers can submit claims by entering the required information such as hours worked, hourly rate, and optionally uploading a .txt file as a supporting document.

3. Track Claim: After submission, lecturers can track the status of their claim on the dashboard (either Pending, Approved, or Rejected).

Coordinator

1. Login: Coordinators can log in using the following hardcoded credentials:

   • Email: coordinator@example.com
   • Password: coordinator123

2. Review Claims: Coordinators can view all pending claims submitted by lecturers.

3. Approve/Reject Claims: Coordinators can approve or reject claims from their dashboard. The decision is updated in real-time and the lecturer is notified.

Claim Submission

• Only .txt files are allowed for uploads.
• The file size must not exceed 1 MB.
• The date has to be the day of submitting the claim
• If the file does not meet these criteria, an error message is displayed to the lecturer.
• If a lecturer doesnt submit a document the words "No Document" are shown

Automation Features

• Added feature to automatically calculate Hours Worked x Hourly Rate.
• Added feature to allow Programme Coordinators to edit the claim after it has been submitted if a lecturer mistakening inputed the wrong details for Hours Worked and Hourly Rate.
• Added feature to allow Lecturers to filter their tracked claims. For example filter the tracked claims to see only an HourlyRate of 5,00, HoursWorked 5 hour and finally TotalClaim amount. Also made it so you can clear the filter criteria.
• Added feature to allow Lecturers to see an invoice of their claim.

Done by Jordan Mosselson ST10270629