Before you begin, ensure you have the following prerequisites installed:
- Visual Studio: The project is developed using C# with the .NET Framework.
- Microsoft SQL Server: Required for the database component. -.Net Framework
git clone https://github.com/BorisPaunovic/School-Managment-System-Desktop-Application.git- Open the project in Visual Studio.
- Build the solution by pressing Ctrl + Shift + B or navigating to Build > Build Solution in the menu.
cd ../School-ZavrsniFinal/School/Program.cs
# Build the solution
dotnet build
# Run the application
dotnet run
- Open the project in Visual Studio.
- Navigate to the App.config file in the project.
- Locate the connection string in Settings1.settings file and modify it according to your SQL Server configuration.
<?xml version='1.0' encoding='utf-8'?>
<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="SchoolDAL" GeneratedClassName="Settings1">
<Profiles />
<Settings>
<Setting Name="ConnectionString" Type="(Connection string)" Scope="Application">
<DesignTimeValue Profile="(Default)"><?xml version="1.0" encoding="utf-16"?>
<SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ConnectionString>Data Source= *********YOUR SERVER*********;Initial Catalog=SchoolDB;Integrated Security=True</ConnectionString>
<ProviderName>System.Data.SqlClient</ProviderName>
</SerializableConnectionString></DesignTimeValue>
<Value Profile="(Default)">Data Source= *********YOUR SERVER********* ;Initial Catalog=SchoolDB;Integrated Security=True</Value>
</Setting>
</Settings>
</SettingsFile>
Use your preferred text editor to edit the Settings1.settings file.
notepad ../School-ZavrsniFinal/School/Settings1.settings
- Set the startup project to the main application.
- Press F5 or select Debug > Start Debugging from the menu.
Navigate to the project's executable directory and run the application.
cd ../School-ZavrsniFinal/School/obj/Debug
School.exe
///////////////
OR
//////////////
cd ../School-ZavrsniFinal/School
# Build the solution
dotnet build
# Run the application
dotnet run
Once the application is running, log in with your credentials and start using the School Management System directly within the application.
The School Management System is a comprehensive application designed to streamline school data management. This repository contains the source code for a desktop application developed in C# using the .NET Framework. The system consists of two main components: the database (Microsoft SQL) and the desktop application itself.
To access the School Management System, launch the application and enter your username and password on the login page.
Figure 1 - Logging in to the application
Upon successful login, you will be redirected to the main page, known as "Main/Dashboard."
New users can create an account by clicking the "Sign in" button on the login page.
Figure 2 - New User Creation Page
Fill in the required information to create an account, and choose the option to be an administrator if needed. Afterward, log in to the application.
The main page provides a quick menu on the left side, displaying commands such as Dashboard, Courses, Students, Teachers, Countries, Subjects, and Users (visible only for administrators). The Dashboard page serves the same purpose.
Figure 3 - Main Page
Data related to specific topics is presented in tables at the bottom of the page. Controls for entering, deleting, and updating data are available at the top. A search bar with filters enhances the data viewing experience.
Figure 4 - Data Management and Viewing Page
To add new data, click the "Add" button for the respective data type. Fill in all required fields on the data entry page and click "Save." Confirmation or error messages will guide you.
Figure 5 - New Data Entry Page
Select the item to delete from the list and click the "Delete" button for the respective data type. Confirm the deletion when prompted.
Figure 6 -Delete entry prompt
Updating data involves selecting the item from the table, clicking the "Update" button, and modifying the fields on the update page. Save the changes, and error notifications will guide you if needed.
Figure 7 - Data Updating Page
The School Management System utilizes Microsoft SQL as its relational database, comprising nine tables for efficient data organization. SMS Database Diagram
Figure 8 - SMS Database Diagram For more information, refer to the detailed Database Documentation.
If you encounter any issues or would like to contribute, please open an issue or fork the repository and submit a pull request.