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();
}
}
}
