How trgchinhh/quanlysinhvien-sqlserver works
A Vietnamese console application for instructors to register or sign in, then manage students in their assigned class. The workflow is driven by Program.cs: instructor authentication opens the student-management menu, whose services handle CRUD, filtering, sorting, and statistics against SQL Server. Registration also manages classes; models and helpers support validation, password hashing, and console presentation. Source excerpts establish the main calls and database operations; SQL schema details and some service behavior are not fully shown.
Main entry points: QuanLyGiangVien.cs Instructor accounts · Program.cs Menu and routing · QuanLySinhVien.cs Student operations · Ketnoidulieu.cs SQL data access
Components 14
Console workflow
- Menu and routing
Program.cs - Menu helpers
Utils/HamPhuProgram.cs
Instructor and class
- Instructor accounts
Services/QuanLyGiangVien.cs - Instructor prompts
Utils/HamPhuQuanLyGiangVien.cs
Student management
- Student operations
Services/QuanLySinhVien.cs - Student helpers
Utils/HamPhuQuanLySinhVien.cs
SQL persistence
- SQL data access
Data/Ketnoidulieu.cs - SQL Server
Models and presentation
- Instructor model
Models/GiangVien.cs - Class model
Models/Lop.cs - Student model
Models/SinhVien.cs - Password hashing
Sha256/Sha256.cs - Console colors
Color/Mau.cs
Other components
- Instructor
Connections 26
- Instructor → Menu and routing: uses
Program.cs - Menu and routing → Instructor accounts: routes login
Program.cs - Menu and routing → Instructor accounts: routes registration
Program.cs - Menu and routing → Instructor accounts: lists accounts
Program.cs - Instructor accounts → Student operations: opens student menu
Program.cs - Menu and routing → Student operations: dispatches menu actions
Program.cs - Menu and routing → Menu helpers: selects menu color
Program.cs - Menu and routing → Instructor prompts: renders instructor header
Program.cs - Instructor accounts → Instructor prompts: prompts credentials
Services/QuanLyGiangVien.cs - Instructor accounts → SQL data access: queries and writes
Services/QuanLyGiangVien.cs - Instructor accounts → Password hashing: hashes login password
Services/QuanLyGiangVien.cs - Instructor accounts → Instructor model: creates accounts
Services/QuanLyGiangVien.cs - Instructor accounts → Class model: creates classes
Services/QuanLyGiangVien.cs - Instructor model → Password hashing: hashes assigned password
Models/GiangVien.cs - Student operations → SQL data access: loads and changes students
Services/QuanLySinhVien.cs - Student operations → Student model: collects student input
Services/QuanLySinhVien.cs - Student operations → Student helpers: filters and sorts
Services/QuanLySinhVien.cs - SQL data access → Student model: constructs student records
Data/Ketnoidulieu.cs - SQL data access → Instructor model: constructs instructor records
Data/Ketnoidulieu.cs - SQL data access → Class model: constructs class records
Data/Ketnoidulieu.cs - SQL data access → SQL Server: executes SQL
Data/Ketnoidulieu.cs - Student model → Console colors: formats warnings
Models/SinhVien.cs - Instructor model → Console colors: formats instructor display
Models/GiangVien.cs - Instructor accounts → Console colors: reports outcomes
Services/QuanLyGiangVien.cs - Student operations → Console colors: reports outcomes
Services/QuanLySinhVien.cs - Menu helpers → Console colors: uses color choices
Utils/HamPhuProgram.cs