charbelsako / doctorsschedule Goto Github PK

Could keep track of your data.
We'll be able to use inheritance.
Also very helpful for the database project.

The database is highly needed for this project to work.
We should finish it first.

Visual Studio Problems

Connecting to the database
The problem turned out to be the version of the .NET framework. Had to download a newer version.

Couldn't figure out how to display the result of the query to the user.
Made a MySqlDataAdapter and filled a DataSet with the data.
MySqlDataAdapter adapter = new MySqlDataAdapter(query, connection);
adapter.Fill(ds, "data");
Then I return the data from the dataset. return ds.Tables["data"] and store that in a DataTable object
DataTable table
and now you can modify the DataSource of a DataGridView and display the data.
dataGridView1.DataSource = table

When a window other than the main window closes the program keeps running.
To solve this I had to add the line
Application.Exit()
in the FormClosed event on the other forms

Database problems

• Because I was stupid enough to make one table for all users. Professor availability is hard to implement.
  So I'm gonna add a new table for professors
• Because of the latter complication, we have two unforeseen constraints.
  1. the user has to be of type 'b' (Professor) to exist in the professor absence table and to teach a course.
  2. the user has to be of type 'a' (Student) to register in a course.

Questions

1. If I have an intermediary table are both foreign keys primary? If so how do I determine that?

A signup page for no reason.
Or a register new user page that only the registrar sees. That sounds better

Better way to switch windows.
I don't have to hide the first form.

Better way to logout.
Same idea as above. I pass the main window to a static property of a class to manipulate

Better design for the register form.

Now that the database class has been made we can use it in Form1.cs

Should include the following

• a function to connect to the database
• a function to run queries. Preferably, 4 to run each type of query. SELECT, DELETE, UPDATE, INSERT.