Interactive Course Flowsheet Windows App

Get Started

1. Download the ZIP and Extract it to your own Windows machine.

2. Open the .sln file.

3. Open App.Config then add and name your connectionString and enter the file path for the MSAccess Database as the Data Source.
   

I.e. :

add name="NameThis" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=YourFilePathHere" providerName="System.Data.OleDb"

E.g. :

add name="CourseFlow" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\User\Documents\CourseFlowApp\CourseFlow\MSAccessDatabase\CourseFlow.accdb" providerName="System.Data.OleDb"

This is the .accb File where I store the Data I’ve worked on. You can use this or copy this.

4. Open RepositoryBase.cs from the Repositories Folder then replace the defined string inside ConnectionStrings[] with your own defined string of the connection string from the previous step.
   

I.e. :

_connectionString = ConfigurationManager.ConnectionStrings["YourDefinedName"].ConnectionString;

E.g. :

_connectionString = ConfigurationManager.ConnectionStrings["CourseFlow"].ConnectionString;

5. Build and Run the Program.
   

a. You can use the existing Users:
Username: admin | Password: admin | Role: Admin
Username: user | Password: user | Role: Student
b. Or you can create your own User by Clicking Sign-up.

c. Clicking Sign up will redirect you to a separate window.

6. Login using the pre-existing accounts or your created account.

7. Upon successful login, you will be redirected to the Dashboard.
   a. To test the Primary Feature of the app, click the Course Flowsheet from the left panel.

8. Load the Data from the Selected Course and Effective Academic Year by clicking the Load Flowsheet Button
   

Note:

• Edit Mode is only available for Users with Admin roles.
  
• Only Course: BS Computer Engineering and Academic Year: 2022-2023 have pre-existing data. If you wish to create data for a separate course with its effective academic year, you may do so by using the Edit Mode which I’ll cover in the later part.
  

9. And there you go, you can now fully enjoy the Interactive Course Flowsheet Windows App. Whether you just want to check the subject in your Bachelor’s Program or just wanted to know in a quick mouse hover how subjects relate to each other (Pre-requisite, Co-requisite, Post-requisite) in your Bachelor’s Program, I got you covered in my app.

Entity Relationship Diagram (ERD)

Create, Read, Update, and Delete (CRUD) to the Database

1. Here’s the pre-existing database schema that involves a Bachelor’s Program.

2. The app Reads from the database after the Load Flowsheet Button is pressed.

3. The app only allows Create Update and Delete for the Subjects and SubjectRelationships Table. The rest will require manual modifications in the database.

4. To Create Subjects and their Relationships, click the Edit Mode (Admin Only) then click the Add Subjects Button.

5. A separate window will pop up and will require the necessary fields to be filled.

6. After filling out the fields, you can now save it to the database by clicking the Save Button.
   

Note:

• You may define here the related subjects of this subject from the existing data or you may edit it later using the Edit button.
  

With no relationships

With relationships

7. After saving, you may continue to add subjects as it will still remain open or you may want to close it to check the newly added subject in the app.

8. Editing a subject will allow you to modify all of its data. You can also add and remove its related subjects.

9. The remove button will erase the Subject and its associated Related Subjects.

10. Congratulations, you can now use the app’s functionalities to accommodate your preferred Bachelor’s Program with its respective Effective Academic Year.

Bugs?

• create an issue

Thank you.