ASPMonitor Dashboard is a web-based application designed for monitoring and visualizing data collected from test result files (.RES). This system retrieves parsed data from a SQL Server database processed by a separate Windows Form application (Monitor Interface). The dashboard presents real-time data visualization organized by Room → Section, along with recent activities, summary counts, and user management.
- 🔐 Secure user login and authentication
- 📊 Dashboard displays data organized by Room → Section
- 🔄 Real-time data updates synchronized from the database
- 🕒 Recent activities timeline to track incoming data
- 📈 Summary of total test counts and sections
- ⚙️ Manage rooms and sections dynamically
- 🌐 Fully deployable on IIS (Internet Information Services) for local or network access
- Backend: ASP.NET Core MVC (C#)
- Frontend: Razor Pages, Bootstrap 5, HTML/CSS, JavaScript
- Database: SQL Server
- ORM: Entity Framework Core
- Hosting: IIS (Internet Information Services)
- Open SQL Server Management Studio (SSMS).
- Run the SQL script located in
/Database/aspdashboard.sql. - This will create the database, tables, sample data, and stored procedures automatically.
⚙️ Configure appsettings.json
"ConnectionStrings": {
"DefaultConnection": "Server=localhost;Database=ASPMonitorDB;Trusted_Connection=True;"
}
🌐 IIS Deployment Open IIS Manager.
Add a new Website or Application pointing to the project’s publish folder.
Configure the Application Pool to use .NET CLR Version No Managed Code and Managed Pipeline Mode: Integrated.
Ensure ASP.NET Core Hosting Bundle is installed on the server.
Bind the website to a port or domain as needed (e.g., http://localhost:8080 or internal network IP).
Apply permissions to allow IIS to access the project files.
- เปิดไฟล์
README.mdใน Visual Studio - วางเนื้อหานี้ทั้งหมดลงไป
- Save
- ใช้คำสั่ง:
git add README.md
git commit -m "Add professional README.md for ASPMonitor Dashboard"
git push
---
## 💡 Notes
- This project depends on a Windows Form application (**Monitor Interface**) which parses `.RES` files and inserts the data into SQL Server for the dashboard to consume.
- Make sure the database is synchronized correctly for real-time data to display.
---
### 📥 Clone the repository
```bash
git clone https://github.com/yourusername/ASPMonitor-Dashboard.git