private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { try { db.cnn.Open(); SqlCommand counter = new SqlCommand("select count(ID) From NewUsers", db.cnn); reader = counter.ExecuteReader(); reader.Read(); count = Int32.Parse(reader[0].ToString().Trim()); reader.Close(); db.cnn.Close(); lecturer = new Lecturer[count]; reader = db.Select("*", "NewUsers"); for (int i = 0; i < count; i++) { reader.Read(); lecturer[i] = new Lecturer(); lecturer[i].FirstName = reader["FirstName"].ToString().Trim(); lecturer[i].LastName = reader["LastName"].ToString().Trim(); lecturer[i].Password = reader["Password"].ToString().Trim(); lecturer[i].Email = reader["Email"].ToString().Trim(); lecturer[i].Role = reader["Role"].ToString().Trim(); lecturer[i].Department = reader["Department"].ToString().Trim(); lecturer[i].Unit = reader["Unit"].ToString().Trim(); } reader.Close(); } catch (Exception exp) { MessageBox.Show("Could not connect to sql"); } finally { db.CloseConnection(); } }
private void ClassDepartment_Load(object sender, EventArgs e) { try { CenterToScreen(); int i = 0, j = 0; read = db.Select("*", "Classrooms"); while (read.Read()) { Button btn = new Button(); btn.Dock = DockStyle.Fill; btn.FlatStyle = FlatStyle.Flat; btn.Text = read["Name"].ToString().Trim(); btn.Click += new EventHandler(button_click); buttons.Add(btn); tableLayoutPanel2.Controls.Add(btn, j, i); j++; if (j % 11 == 0) { i++; } } read.Close(); } catch (Exception exp) { MessageBox.Show("Could not connect to sql"); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }
private void pictureBox1_Click(object sender, EventArgs e) { try { string filter1 = comboBox2.Text; string search = textBox1.Text; listView1.Items.Clear(); if (GlobalVariables.User_Permission != "Secretary") { reader = db.Select("*", "Courses"); while (reader.Read()) { if (reader[filter1].ToString().Trim().Contains(search.Trim())) { ListViewItem row = new ListViewItem(reader["Name"].ToString().Trim()); row.SubItems.Add(reader["ID"].ToString().Trim()); row.SubItems.Add(reader["Credits"].ToString().Trim()); row.SubItems.Add(reader["LectureHour"].ToString().Trim()); row.SubItems.Add(reader["PracticeHour"].ToString().Trim()); row.SubItems.Add(reader["ReceptionHour"].ToString().Trim()); row.SubItems.Add(reader["Semester"].ToString().Trim()); row.SubItems.Add(reader["Year"].ToString().Trim()); row.SubItems.Add(reader["Department"].ToString().Trim()); listView1.Items.Add(row); } } reader.Close(); if (listView1.Items.Count == 0) { MessageBox.Show("Could Not Found " + search + " in " + filter1, "Failed!", MessageBoxButtons.OK); } } else { string comboboxValue = combobox3.Text; reader = db.Select("*", "Courses", "Department", comboboxValue); while (reader.Read()) { ListViewItem row = new ListViewItem(reader["Name"].ToString().Trim()); row.SubItems.Add(reader["ID"].ToString().Trim()); row.SubItems.Add(reader["Credits"].ToString().Trim()); row.SubItems.Add(reader["LectureHour"].ToString().Trim()); row.SubItems.Add(reader["PracticeHour"].ToString().Trim()); row.SubItems.Add(reader["ReceptionHour"].ToString().Trim()); row.SubItems.Add(reader["Semester"].ToString().Trim()); row.SubItems.Add(reader["Year"].ToString().Trim()); row.SubItems.Add(reader["Department"].ToString().Trim()); listView1.Items.Add(row); } reader.Close(); } } catch (Exception exp) { MessageBox.Show("Colud not connect to sql"); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }
private void button1_Click_1(object sender, EventArgs e) { listView2.Items.Clear(); List <string> check_department = new List <string>(); if (listView1.SelectedItems.Count > 0) { button1.Text = listView1.SelectedItems[0].Text; read = db.Select("Department", "NewCourses"); while (read.Read()) { if (!check_department.Contains(read[0].ToString().Trim())) { check_department.Add(read[0].ToString().Trim()); listView2.Items.Add(new ListViewItem(read[0].ToString().Trim())); } } read.Close(); listView2.Enabled = true; listView1.Enabled = false; button1.Enabled = false; button2.Enabled = true; } else { MessageBox.Show("You didn't choose semester"); } }
private void button6_Click(object sender, EventArgs e) { listView7.Items.Clear(); bool check_class = false; if (addToSce.getClass() != null && listView6.SelectedItems.Count > 0) { listView8.Items.Add(new ListViewItem(addToSce.getClass())); listView8.Visible = true; button8.Enabled = true; button6.Enabled = false; listView6.Enabled = false; listView6.SelectedItems.Clear(); return; } SqlDataReader reader2; DataBase db2 = new DataBase(); if (listView6.SelectedItems.Count > 0) { button6.Text = listView6.SelectedItems[0].Text; if (button6.Text.Equals("Practice")) { listView6.Enabled = false; button6.Enabled = false; listView7.Enabled = true; button7.Enabled = true; read = db.Select("*", "NewUsers"); while (read.Read()) { if (read["Role"].ToString().Trim().Equals("Lecturer") || read["Role"].ToString().Trim().Equals("Head Of Department")) { if (read["Unit"].ToString().Trim().Equals(button3.Text)) { listView7.Items.Add(new ListViewItem(read["FirstName"].ToString().Trim() + " " + read["LastName"].ToString().Trim())); } } } read.Close(); } else if (button6.Text.Equals("Meeting")) { Description d = new Description(this); d.Show(); } if (button6.Text.Equals("Exam")) { button1.Text = button1.Text.Substring(button1.Text.Length - 1, 1); } listView6.Enabled = false; button6.Enabled = false; listView8.Enabled = true; button8.Enabled = true; read = db.Select("*", "NewSchedule"); reader2 = db2.Select("Name", "Classrooms"); while (reader2.Read()) { while (read.Read()) { if (reader2[0].ToString().Trim().Equals(read["Classroom"].ToString().Trim())) { if (read["Date"].ToString().Trim().Equals(addToSce.date)) { if (CalcHours(read["StartHour"].ToString().Trim(), read["EndHour"].ToString().Trim(), addToSce.Start.Text.Substring(0, 2), addToSce.End.Text.Substring(0, 2))) { check_class = true; break; } } } } if (!check_class) { listView8.Items.Add(new ListViewItem(reader2[0].ToString().Trim())); } check_class = false; } reader2.Close(); read.Close(); } else { listView6.Enabled = false; button6.Enabled = false; listView5.Enabled = true; button5.Enabled = true; listView6.Items.Clear(); } listView6.SelectedItems.Clear(); }
private void button4_Click(object sender, EventArgs e) { listView5.Items.Clear(); if (listView4.SelectedItems.Count >= 1) { button4.Text = listView4.SelectedItems[0].Text; read = db.Select("*", "NewCourses", "Name", button4.Text); while (read.Read()) { if (read["Unit"].ToString().Trim().Equals(button3.Text) && read["Department"].ToString().Trim().Equals(button2.Text)) { Course_ID = read["ID"].ToString().Trim(); break; } } read.Close(); listView4.Enabled = false; button4.Enabled = false; listView5.Enabled = true; button5.Enabled = true; bool check_if_lect_exist = false; DataBase db2 = new DataBase(); read = db.Select("*", "NewUsers", "Unit", button3.Text); SqlDataReader reader2; while (read.Read()) { if (read["Role"].ToString().Trim() == "Lecturer" || read["Role"].ToString().Trim().Equals("Practitioner") || read["Role"].ToString().Trim().Equals("Head Of Department")) { if (read["Department"].ToString().Trim().Equals(button2.Text) && read["Unit"].ToString().Trim().Equals(button3.Text)) { reader2 = db2.Select("*", "NewSchedule", "Unit", button3.Text); while (reader2.Read()) { if ((read["FirstName"].ToString().Trim() + " " + read["LastName"].ToString().Trim()).Equals(reader2["LecturerName"].ToString().Trim())) { if (reader2["Day"].ToString().Trim().Equals(addToSce.day)) { if (CalcHours(reader2["StartHour"].ToString().Trim(), reader2["EndHour"].ToString().Trim(), addToSce.Start.Text.Substring(0, 2), addToSce.End.Text.Substring(0, 2))) { check_if_lect_exist = true; break; } } } } reader2.Close(); if (!check_if_lect_exist) { listView5.Items.Add(new ListViewItem(read["FirstName"].ToString().Trim() + " " + read["LastName"].ToString().Trim())); } check_if_lect_exist = false; } } } read.Close(); if (listView5.Items.Count == 0 && listView4.SelectedItems.Count > 0) { MessageBox.Show("there are no currently lecturers in this course"); listView4.Enabled = true; button4.Enabled = true; listView5.Enabled = false; button5.Enabled = false; return; } } else { listView4.Enabled = false; button4.Enabled = false; listView3.Enabled = true; button3.Enabled = true; listView4.Items.Clear(); } listView4.SelectedItems.Clear(); }
private void Show_Exams_Load(object sender, EventArgs e) { try { string name; if (GlobalVariables.User_Permission != "Secretary") { toolStripComboBox1.Visible = false; label1.Text = Calc_Dates(); this.CenterToScreen(); reader = db.Select("*", "NewSchedule"); while (reader.Read()) { if (reader["LecturerName"].ToString().Trim().Equals(GlobalVariables.Full_Name)) { if (reader["Type"].ToString().Trim().Equals("Exam")) { Button button1 = new Button(); button1.Size = new Size(panel1.Width, 70); button1.Font = new Font("Georgia", 14, FontStyle.Bold); button1.TextAlign = ContentAlignment.MiddleLeft; button1.Text = reader["Name"].ToString().Trim() + " - " + reader["NumOfExam"].ToString().Trim(); button1.Image = Resources.Actions_go_next_icon; button1.ForeColor = Color.White; button1.ImageAlign = ContentAlignment.MiddleRight; //button1.BackColor = Color.White; button1.BackgroundImage = Resources.blue_surface_with_creases_1160_191; button1.BackgroundImageLayout = ImageLayout.Stretch; button1.Click += new EventHandler(button1_Click); button1.Location = new Point(0, button_height); button_height += 70; button1.Name = reader["LecturerName"].ToString().Trim(); button1.Cursor = Cursors.Hand; panel1.Controls.Add(button1); } } } reader.Close(); } else { this.CenterToScreen(); toolStripComboBox1.Visible = true; label1.Text = Calc_Dates(); reader = db.Select("*", "NewUsers"); while (reader.Read()) { if (reader["Role"].ToString().Trim() != "Secretary") { name = reader["FirstName"].ToString().Trim() + " " + reader["LastName"].ToString().Trim(); toolStripComboBox1.Items.Add(name); } } reader.Close(); } } catch (Exception) { MessageBox.Show("Could not connect to sql"); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }
private void button1_Click(object sender, EventArgs e) { DateTime end_of_exams_semester_a = new DateTime(DateTime.Today.Year, 3, 5); DateTime end_of_semester_b = new DateTime(DateTime.Today.Year, 6, 15); DateTime end_of_exams_semester_b = new DateTime(DateTime.Today.Year, 7, 15); SqlDataReader read = db.Select("*", "NewUsers"); try { if (textBox1.Text == "") { MessageBox.Show("Logon Failure: unknown ID or invalid password"); return; } if (SQLFunctions.checkExistsEmail(textBox1.Text)) { if (SQLFunctions.checkLogIn(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text)), textBox2.Text)) { this.Hide(); if (SQLFunctions.checkRole(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString()))) == "Student") { FormMenuStudent mainForm = new FormMenuStudent(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString())), textBox2.Text); mainForm.Show(); } else if (SQLFunctions.checkRole(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString()))) == "SecretaryA") { FormMenuSecretary mainForm = new FormMenuSecretary(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString())), textBox2.Text); mainForm.Show(); } else if (SQLFunctions.checkRole(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString()))) == "Exam Department") { FormMenuExamDepartment mainForm = new FormMenuExamDepartment(); mainForm.Show(); } else if (SQLFunctions.checkRole(Convert.ToInt32(SQLFunctions.getIDbyEmail(textBox1.Text.ToString()))) == "Admin") { FormMenuAdmin mainForm = new FormMenuAdmin(); mainForm.Show(); } else { while (read.Read()) { if (textBox1.Text == read["Email"].ToString().Trim() && textBox2.Text == read["Password"].ToString().Trim()) { ID = read["ID"].ToString(); // GlobalVariables h;.ID = read["ID"].ToString().Trim(); GlobalVariables.User_ID = read["ID"].ToString().Trim(); GlobalVariables.Full_Name = read["FirstName"].ToString().Trim() + " " + read["LastName"].ToString().Trim(); GlobalVariables.User_Permission = read["Role"].ToString().Trim(); GlobalVariables.User_Department = read["Department"].ToString().Trim(); GlobalVariables.User_Email = read["Email"].ToString().Trim(); if (monthCalendar1.MaxDate >= DateTime.Today && monthCalendar1.MinDate <= DateTime.Today) { GlobalVariables.Semester = "A"; } else if (monthCalendar1.MaxDate < DateTime.Today && DateTime.Today <= end_of_exams_semester_a) { GlobalVariables.Semester = "Exam Period semester A"; } else if (end_of_exams_semester_a < DateTime.Today && DateTime.Today <= end_of_semester_b) { GlobalVariables.Semester = "B"; } else if (end_of_exams_semester_b >= DateTime.Today && DateTime.Today > end_of_semester_b) { GlobalVariables.Semester = "Exam Period semester B"; } else { GlobalVariables.Semester = "Summer Semester"; } IsFound = true; GlobalVariables.maxDate = monthCalendar1.MaxDate; GlobalVariables.minDate = monthCalendar1.MinDate; break; } GlobalVariables.maxDate = monthCalendar1.MaxDate; GlobalVariables.minDate = monthCalendar1.MinDate; } read.Close(); if (!IsFound) { MessageBox.Show("You have to sign up before"); textBox1.Text = ""; textBox2.Text = ""; return; } this.Hide(); main m = new main(); m.Show(); } } else { MessageBox.Show("Logon Failure: unknown ID or invalid password"); } } else { MessageBox.Show("Logon Failure: unknown ID or invalid password"); } } catch (SqlException exception) { MessageBox.Show(exception.ToString()); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }
private void button1_Click(object sender, EventArgs e) { try { first = textBox1.Text; last = textBox2.Text; ////username = first + last[0] + last[1]; reader = db.Select("*", "NewUsers", "Email", textBox6.Text); int count = 0, count_id = 0; while (reader.Read()) { if (reader["Email"].ToString().Trim().Equals(textBox6.Text)) { count++; } } reader.Close(); reader = db.Select("*", "NewUsers", "ID", textBox3.Text); while (reader.Read()) { if (reader["ID"].ToString().Trim().Equals(textBox3.Text)) { count_id++; } } reader.Close(); if (count == 0 && count_id == 0) { reader.Close(); id = textBox3.Text; password = textBox4.Text; password_again = textBox5.Text; email = textBox6.Text; Role = role.Text; department = Department_comboBox.Text; unit = comboBox1.Text; if (password == password_again) { db.InsertUser(first, last, id, email, password, Role, department, unit); this.Hide(); main ss = new main(); ss.Show(); } else { MessageBox.Show("Wrong input!\n The passwords are Different"); } } else if (count != 0) { MessageBox.Show("Wrong input!\n Email already exist in the system"); } else if (count_id != 0) { MessageBox.Show("Wrong input!\n ID already exist in the system"); } } catch (Exception) { MessageBox.Show("Could not connect to sql"); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }
public Quat_date(Button btn) { try { string data, day, houer; b = new Button(); b = btn; this.Show(); CenterToScreen(); InitializeComponent(); comboBox2.Visible = false; label3.Text = "" + btn.Text + " is a: "; label6.Text = "Time of use in " + btn.Text; button1.Visible = false; // read = db.Select("Name", "Classrooms"); read = db.Select("*", "Classrooms"); while (read.Read()) { if (read["Name"].ToString().Trim().Equals(btn.Text)) { label5.Text = read["Type"].ToString().Trim(); } } read.Close(); read2 = db.Select("*", "NewSchedule", "Classroom", btn.Text); while (read2.Read()) { startH = Int32.Parse(read2["StartHour"].ToString().Trim()); endH = Int32.Parse(read2["EndHour"].ToString().Trim()); Shour = read2["StartHour"].ToString().Trim() + ":" + "00"; Ehour = read2["EndHour"].ToString().Trim() + ":" + "00"; if (read2["StartHour"].ToString().Length == 1) { Shour = "0" + Shour; } if (read2["EndHour"].ToString().Length == 1) { Ehour = "0" + Ehour; } if (read2["Classroom"].ToString().Trim().Equals(btn.Text)) { ListViewItem lv = new ListViewItem(read2["Date"].ToString()); lv.SubItems.Add(read2["Day"].ToString().Trim()); lv.SubItems.Add(Shour + "-" + Ehour); listView1.Items.Add(lv); counter++; } } read2.Close(); } catch (Exception) { MessageBox.Show("Could not connect to sql"); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }
private void AddToSce_Load(object sender, EventArgs e) { button2.Image = Resources.add_folder_normal; DateTime Summer_date = new DateTime(DateTime.Now.Year, 7, 15); chosen_day = Int32.Parse(date.Substring(0, 2)); chosen_year = Int32.Parse(date.Substring(6, 4)); chosen_month = Int32.Parse(date.Substring(3, 2)); chosen_date = new DateTime(chosen_year, chosen_month, chosen_day); if (chosen_date > Summer_date && chosen_date < new DateTime(DateTime.Now.Year, 10, 30)) { MessageBox.Show("You can't add or delete courses in summer semester"); this.Close(); return; } bool help = false; Start.Text = hour.Substring(0, 5); foreach (string item in Hours1) { if (Int32.Parse(item.Substring(0, 2)) > Int32.Parse(Start.Text.Substring(0, 2))) { End.Items.Add(item); } } SqlDataReader reader3 = db.Select("*", "NewSchedule"); while (reader3.Read()) { help = true; string start, end; start = reader3["StartHour"].ToString().Trim() + ":00"; end = reader3["EndHour"].ToString().Trim() + ":00"; if (day == reader3["Day"].ToString().Trim() && calc_hours(start, end, hour.Substring(0, 5)) && reader3["Semester"].ToString().Trim().Equals(GlobalVariables.Semester)) { if (reader3["Type"].ToString().Trim() == "Exam") { if (Check_exam_date(btn, reader3["Date"].ToString().Trim())) { group = new ListViewGroup(reader3["LecturerName"].ToString().Trim() + "-" + reader3["Type"].ToString().Trim() + "/" + reader3["NumOfExam"].ToString().Trim()); item = new ListViewItem(group); item.Text = reader3["Name"].ToString().Trim() + " , " + reader3["StartHour"].ToString().Trim() + ":00" + "-" + reader3["EndHour"].ToString().Trim() + ":00"; Course_list.Groups.Add(group); Course_list.Items.Add(item); help = true; group = null; item = null; continue; } help = false; } if (help) { group = new ListViewGroup(reader3["LecturerName"].ToString().Trim() + "-" + reader3["Type"].ToString().Trim()); item = new ListViewItem(group); item.Name = reader3["Classroom"].ToString().Trim(); item.Text = reader3["Name"].ToString().Trim() + " , " + reader3["StartHour"].ToString().Trim() + ":00" + "-" + reader3["EndHour"].ToString().Trim() + ":00"; Course_list.Groups.Add(group); Course_list.Items.Add(item); group = null; item = null; } } } reader3.Close(); }
private void permission() { try { bool flag = false; bool flag1 = true; if (GlobalVariables.User_Permission == "Secretary") { tableLayoutPanel4.Visible = true; Load_Buttons(); Init(0, "", a); SqlDataReader reader = db.Select("*", "NewSchedule"); while (reader.Read()) { if (reader["Semester"].ToString().Trim().Equals(GlobalVariables.Semester)) { if (reader["Type"].ToString().Trim().Equals("Exam") || reader["Type"].ToString().Trim().Equals("Meeting")) { string Sun_date = buttons[1].Text.Substring(6 + 1); DateTime tempDate = new DateTime(Int32.Parse(Sun_date.Substring(6)), Int32.Parse(Sun_date.Substring(3, 2)), Int32.Parse(Sun_date.Substring(0, 2))); string Exam_date = reader["Date"].ToString().Trim(); DateTime Week_from_now = tempDate.AddDays(6); DateTime ExamDate = new DateTime(Int32.Parse(Exam_date.Substring(6)), Int32.Parse(Exam_date.Substring(3, 2)), Int32.Parse(Exam_date.Substring(0, 2))); int diff = ExamDate.DayOfYear - tempDate.DayOfYear; int diff2 = ExamDate.DayOfYear - Week_from_now.DayOfYear; if (diff >= 0) { if (diff2 < 0) { flag = true; } } } if (flag == true || (reader["Type"].ToString().Trim() != "Exam" && reader["Type"].ToString().Trim() != "Meeting")) { button_indexes = get_button_index(reader["StartHour"].ToString().Trim() + ":00" + "-" + reader["EndHour"].ToString().Trim() + ":00", reader["Day"].ToString().Trim()); for (int i = 0; i < button_indexes.Length; i++) { buttons[button_indexes[i]].BackgroundImage = Resources.blue_surface_with_creases_1160_191; buttons[button_indexes[i]].BackgroundImageLayout = ImageLayout.Stretch; buttons[button_indexes[i]].FlatStyle = FlatStyle.Flat; buttons[button_indexes[i]].FlatAppearance.BorderSize = 1; buttons[button_indexes[i]].Text = "..."; buttons[button_indexes[i]].ForeColor = Color.Green; buttons[button_indexes[i]].Image = Resources.User_Group_icon; buttons[button_indexes[i]].ImageAlign = ContentAlignment.MiddleLeft; flag = false; } } } } reader.Close(); } if (GlobalVariables.User_Permission == "Lecturer" || GlobalVariables.User_Permission == "Head Of Department") { Build(0);//id == 0 for lec or head of dep } if (GlobalVariables.User_Permission == "Practitioner") { Build(1); } if (Spec_date != new DateTime(1111, 11, 11)) { double d = (this.Spec_date - today).TotalDays; Init(Convert.ToInt32(d), this.Spec_date.DayOfWeek.ToString(), this.Spec_date); } } catch (Exception e) { MessageBox.Show(e.Message); MessageBox.Show("Could not connect to sql"); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }
private void Build(int id) { try { tableLayoutPanel4.Visible = false; string temp1 = ""; if (id == 0) { temp1 = "Lecture"; } else { temp1 = "Practice"; } Load_Buttons(); Init(0, "", a); SqlDataReader reader = db.Select("*", "NewSchedule"); DataBase db2 = new DataBase(); string hour = " "; while (reader.Read()) { bool flag1 = true; if ((reader["LecturerName"].ToString().Trim().Equals(GlobalVariables.Full_Name) && (reader["Type"].ToString().Trim().Equals(temp1)) || (reader["Type"].ToString().Trim().Equals("ReceptionHours")) || reader["Type"].ToString().Trim().Equals("Meeting") || reader["Type"].ToString().Trim().Equals("Exam"))) { if (GlobalVariables.Semester.Equals(reader["Semester"].ToString().Trim()) || reader["Type"].ToString().Trim().Equals("Meeting")) { // reader2 = db2.Select("*", "Constraints"); while (reader2.Read()) { string Sche_hour = reader["StartHour"].ToString().Trim() + ":00" + "-" + reader["EndHour"].ToString().Trim() + ":00"; if ((reader["LecturerName"].ToString().Trim() == reader2["FullName"].ToString().Trim() && reader["Day"].ToString().Trim() == reader2["Days"].ToString().Trim() && (reader2["StartHours"].ToString().Trim() + "-" + reader2["EndHours"].ToString().Trim()) == Sche_hour && reader2["Approved"].ToString().Trim() == "true" && Spec_date.ToShortDateString() == reader2["Date"].ToString().Trim()) || check_spec_date(Spec_date, reader2["Date"].ToString().Trim())) { hour = reader2["StartHours"].ToString().Trim() + "-" + reader2["EndHours"].ToString().Trim(); flag1 = false; break; } } } reader2.Close(); if (flag1 == true) { reader2 = db2.Select("*", "Constraints"); while (reader2.Read()) { // if (reader["Type"].ToString().Trim().Equals("Exam") || reader["Type"].ToString().Trim().Equals("Meeting")) { if (ExamFilter(reader) != "Exam" && ExamFilter(reader) != "Meeting") { flag1 = false; } } if (flag1 == true) { button_indexes = get_button_index(reader["StartHour"].ToString().Trim() + ":00" + "-" + reader["EndHour"].ToString().Trim() + ":00", reader["Day"].ToString().Trim()); for (int i = 0; i < button_indexes.Length; i++) { buttons[button_indexes[i]].BackColor = Color.Green; if (reader["Type"].ToString().Trim() == "Meeting") { buttons[button_indexes[i]].Text = reader["Type"].ToString().Trim(); buttons[button_indexes[i]].Name = reader["LectureID"].ToString().Trim(); } else { buttons[button_indexes[i]].Text = reader["Name"].ToString().Trim(); } buttons[button_indexes[i]].Enabled = true; buttons[button_indexes[i]].FlatStyle = FlatStyle.Flat; buttons[button_indexes[i]].FlatAppearance.BorderSize = 1; buttons[button_indexes[i]].Click += new EventHandler(showClassDate); buttons[button_indexes[i]].Name = reader["LectureID"].ToString().Trim(); } } } reader2.Close(); } } } reader.Close(); } catch (Exception) { MessageBox.Show("Could not connect to sql"); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }