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++; } } }