LYLAcademy

Academy Management System Project in Agular

Let's start to develop c#.net project for student management system. We'll use this project as base.
This base project just has admin role to manage the system. Our project will include two more roles: student and teacher. They manage some processes within the limits of their authorization.

You can check the completed project here : Angular project azure link
with these login parameters ;
username: admin , password : admin
username: student , password : student
username: teacher , password : teacher

Project Title :	Academy Management System
Abstract :	Academy management system project is used to maintain and monitor students' and teacher's course data and financial figures for education institution..
Project Type :	Web / Windows Application
Technology :	Visual Studio 2019 with C#, HTML, CSS, JS, Typscript Language (ASP.NET CORE MVC Web API + EntityFramework + Angular 10 + SQL Server 2019)
Database :	SQL-Server 2019 Database

---

Project Abstract :

In this .net article we will discuss academy management system software which is used in classes for maintaining scheduled course detail. Our main focus in this software to keep student, teacher, course and schedule records. In this management software administrator can operate base records of the system. Admin has to first add detail of course with course name, duration and fees which are run in organization. The next work is to create teacher profile with suitable course. After adding course detail and teacher detail we can add student detail in our system. We provide search facility by course wise, student wise, teacher wise in our project. This student management software help us to find student fees status, paid or remaining. Also, teacher or student can login the system. Teacher can add course to calendar with content, can display detail and participant list.Student can reach the list of scheduled courses and join any. Admin can update all records and add fees.

---

The first step to develop dynamic software system we need to use database server to store the records permanently. Here, we use SQL Server database to keep the data.

Database detail – LYL Academy

SQL server database table detail

Here, database script for this academy software to create tables in sql server.

Table Name	Description
Courses	This table contain course detail Name, Duration and standard price detail.
Teachers	Table contain user name, teacher detail Name, Qualification detail
Students	Table contain user name, student detail Name, contact detail
Users	Table Store username and password detail for login purpose.
Calendars	Table store all the detail of scheduled course, content, price, course, participants and Fees Detail.
Participants	Table store the participant and scheduled course relation.

---

ADD Course Form

Above image shows how to add course detail with course name, standart price, time duration detail.

---

ADD Teacher Form

Above image shows how to add teacher detail with name, branch, username ...

---

ADD Student Form

Above image shows how to add student detail with name, contact information, username ...

---

ADD Fees & Scheduled course detail Form

This scheduled course detail form used to maintain student fees detail. Admin makes fees entry when student paid fees to institute. This form very useful to maintain fess status by paid fees and remaining fees.

---

Student Search Form

Here, we provide search facility by each student information

---

Scheduled Course Student Form

Here, we provide search facility by scheduled course information,can display course detail. Student can display own course list. Also student can display other scheduled courses and can join any of them.

---

Scheduled Course Admin-Teacher Form

Here, we provide search facility by scheduled course information. Admin can delete if there is not any participant, can edit-create-display detail and change fees data.
Teacher can create own scheduled course on calendar, can edit content and display detail.

---

This academy management software system has some more forms like :

• Add, List User Form
  Admin can crud user, set user as teacher, student or admin role. Also when admin create or update student/teacher can set the related username.
• Add, List Teacher Form

Related API Model,Controller & Angular Companent,Model,Services

Here, related source link for this academy software to have detail information .

Table Name	Related Links
Courses	Related API Model, Controller & Angular Component, Model, Services
Teachers	Related API Model, Controller & Angular Component, Model, Services
Students	Related API Model, Controller & Angular Component, Model, Services
Users	Related API Model, Controller , IRepository , Repository & Angular Component, Model, Services
Calendars	Related API Model, Controller & Angular Component, Model, Services
Participants	Related API Model, Controller & Angular Component, Model, Services

for the better solution :
-user and role must be improved with Microsoft.AspNet.Identity.EntityFramework.
-password must be managed with salting and hashing methods.
-API access functions must be provided by IApprepository&AppRepository. I used repository pattern as an instance : for user with IAuthRepository - AuthRepository on AuthController.
same structure must be applied to IAppRepository - AppRepository
-I applied AutoMapperProfiles to map DTO's to models for some instances.It would be better if automapper solution applied to other models too.

Bootswatch Sketchy & Angle Theme Forms

Form	Sketchy Theme Azure Link	Angle Theme Azure Link
Login
User Add
User List
Student Add
Student List
Teacher Add
Teacher List
Course Add
Course List
Scheduled Course List
Scheduled Course Detail
Student My Course List
Student to Join Course List