public override string ToString()
{
string teacherString = string.Empty;
teacherString += $"{nameof(Teacher_ID)} = {Teacher_ID.ToString()}/n";
teacherString += $"{nameof(Username)} = {Username ?? "NULL"}/n";
teacherString += $"{nameof(Password)} = {Password ?? "NULL"}/n";
teacherString += $"{nameof(Name)} = {Name ?? "NULL"}/n";
teacherString += $"{nameof(Address)} = {Address ?? "NULL"}/n";
teacherString += $"{nameof(PhoneNumber)} = {PhoneNumber ?? "NULL"}/n";
teacherString += $"{nameof(Permission)} = {Permission ?? "NULL"}/n";
teacherString += $"{nameof(Status)} = {Status ?? "NULL"}/n";
teacherString += $"{nameof(DateIn)} = {((DateIn == null) ? DateIn.ToLongDateString() : "NULL")}/n";
teacherString += $"{nameof(DateOut)} = {((DateOut == null) ? DateOut.Value.ToLongDateString() : "NULL")}/n";
return(teacherString);
}
private void Lecture_CheckedChanged(object sender, EventArgs e)
{
//the function checks if the checkbox that was checked is lecture
//if it does, the function will load the lectures info into the listboxes accordingly
int Count = 0, val = 0;
if (Lecture.Checked && Practice.Checked)
{
Practice.Checked = false;
}
if (!Lecture.Checked)
{
Lecture_Select.Enabled = false;
Lecture_Select.Enabled = false;
ID.ResetText();
ID.Items.Clear();
Start_Time.ResetText();
Start_Time.Items.Clear();
End_Time.ResetText();
End_Time.Items.Clear();
Courses.ResetText();
Courses.Items.Clear();
Days.ResetText();
Days.Items.Clear();
Day.Text = "";
Teacher_ID.ResetText();
Teacher_ID.Items.Clear();
Lecture_Select.Enabled = true;
Lecture_Select.Items.Clear();
Lecture_Select.ResetText();
Search.Enabled = false;
StartTime.ResetText();
StartTime.Items.Clear();
EndTime.ResetText();
EndTime.Items.Clear();
Teacher.ResetText();
Teacher.Items.Clear();
ClassCombobox.ResetText();
ClassCombobox.Items.Clear();
ClassCombobox.Enabled = false;
Teacher.Enabled = false;
StartTime.Enabled = false;
EndTime.Enabled = false;
Day.Enabled = false;
}
else
{
ID.ResetText();
ID.Items.Clear();
Start_Time.ResetText();
Start_Time.Items.Clear();
End_Time.ResetText();
End_Time.Items.Clear();
Courses.ResetText();
Courses.Items.Clear();
Days.ResetText();
Days.Items.Clear();
Day.Text = "";
Teacher_ID.ResetText();
Teacher_ID.Items.Clear();
Lecture_Select.Enabled = true;
Lecture_Select.Items.Clear();
Lecture_Select.ResetText();
Search.Enabled = false;
StartTime.ResetText();
StartTime.Items.Clear();
EndTime.ResetText();
EndTime.Items.Clear();
Teacher.ResetText();
Teacher.Items.Clear();
ClassCombobox.ResetText();
ClassCombobox.Items.Clear();
ClassCombobox.Enabled = false;
Teacher.Enabled = false;
StartTime.Enabled = false;
EndTime.Enabled = false;
Day.Enabled = false;
if (StartTime.Items.Count == 0)
{
for (int i = 8; i < 21; i++)
{
StartTime.Items.Add(i + ":00");
}
}
Lesson = "Lecture";
if (!SqlWorker.CheckForInternetConnection())
{
MessageBox.Show("There is no internet connection.\nPlease try again later.", "Error"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet TableShow = SqlWorker.GetDataSet("SELECT CourseName , StartTime , Day ,EndTime , Lecturer, ID From Lecture");
val = TableShow.Tables[0].Rows.Count;
while (val > Count)
{
Lecture_Select.Items.Add(TableShow.Tables[0].Rows[Count]["ID"].ToString());
ID.Items.Add(TableShow.Tables[0].Rows[Count]["ID"].ToString());
Courses.Items.Add(TableShow.Tables[0].Rows[Count]["CourseName"].ToString());
Start_Time.Items.Add(TableShow.Tables[0].Rows[Count]["StartTime"].ToString());
End_Time.Items.Add(TableShow.Tables[0].Rows[Count]["EndTime"].ToString());
Days.Items.Add(TableShow.Tables[0].Rows[Count]["Day"].ToString());
Teacher_ID.Items.Add(TableShow.Tables[0].Rows[Count]["Lecturer"].ToString());
Count++;
}
}
}
