public Classroom(string _name)
{
DataRow row = SQLFunctions.getClassroomProperties(_name);
name = _name;
capacity = Convert.ToInt32(row["Capacity"]);
}
public FormAdmin_ChangePermission()
{
InitializeComponent();
AcceptButton = button_Accept;
textBox_UserID.MaxLength = 9;
comboBox_Permission.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox_users.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox_Department.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox_Year.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox_Semester.DropDownStyle = ComboBoxStyle.DropDownList;
DataTable users = new DataTable();
users = SQLFunctions.getUsers();
allUsers = users;
for (int i = 0; i < users.Rows.Count; i++)
{
if (users.Rows[i]["Role"].ToString() == "SecretaryA")
{
comboBox_users.Items.Add(users.Rows[i]["LastName"].ToString() + " " + users.Rows[i]["FirstName"].ToString() + " - Students Secretary");
}
else if (users.Rows[i]["Role"].ToString() == "Secretary")
{
comboBox_users.Items.Add(users.Rows[i]["LastName"].ToString() + " " + users.Rows[i]["FirstName"].ToString() + " - Department Secretary");
}
else
{
comboBox_users.Items.Add(users.Rows[i]["LastName"].ToString() + " " + users.Rows[i]["FirstName"].ToString() + " - " + users.Rows[i]["Role"].ToString());
}
}
}
public FormExamDepartment_ShowCourse(int course_ID)
{
InitializeComponent();
courseID = course_ID;
LecturesID = SQLFunctions.getLectureIDByCourseID(courseID);
courseName = SQLFunctions.covertCourseIDtoCourseName(courseID);
if (LecturesID != null && StudentsID != null)
{
for (int i = 0; i < LecturesID.Count; i++)
{
if (SQLFunctions.getStudentsIDfromLectureID(LecturesID[i]) != null)
{
if (StudentsID.Count == 0)
{
StudentsID = (SQLFunctions.getStudentsIDfromLectureID(LecturesID[i]));
}
else
{
StudentsID.Union(SQLFunctions.getStudentsIDfromLectureID(LecturesID[i])).ToList();
}
}
}
for (int i = 0; i < StudentsID.Count; i++)
{
dataGridView1.Rows.Add(courseID, courseName, StudentsID[i], SQLFunctions.covertStudentIDtoStudentLastName(Convert.ToInt32(StudentsID[i])) + " " + SQLFunctions.covertStudentIDtoStudentFirstName(Convert.ToInt32(StudentsID[i])));
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox_ID.Text)) == false)
{
SQLFunctions.insertUser(Convert.ToInt32(textBox_ID.Text), textBox_Password.Text, textBox_FirstName.Text, textBox_LastName.Text, comboBox_Permission.Text, comboBox_Department.Text);
if (comboBox_Permission.SelectedIndex == 0 || comboBox_Permission.SelectedIndex == 1)
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as a " + comboBox_Permission.Text + " in " + comboBox_Department.Text + " department.");
}
else if (comboBox_Permission.SelectedIndex == 3)
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as an " + comboBox_Permission.Text);
}
else
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as an " + comboBox_Permission.Text + " employee");
}
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("Student " + textBox_FirstName.Text + " is already registered in the system");
}
}
public FormMenuAdmin()
{
InitializeComponent();
int newNotificationCount = 0;
DataTable notifications = SQLFunctions.getErrors();
if (notifications != null)
{
for (int i = 0; i < notifications.Rows.Count; i++)
{
if (notifications.Rows[i]["Viewed"].ToString() == "False")
{
newNotificationCount++;
}
}
if (newNotificationCount > 0)
{
labelNotificationCount.Text = newNotificationCount.ToString();
labelNotificationCount.Visible = true;
}
}
}
private void buttonLogin_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkLogIn(Convert.ToInt32(textBoxID.Text), textBoxPassword.Text))
{
this.Hide();
if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Student")
{
FormMenuStudent mainForm = new FormMenuStudent();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Secretary")
{
FormMenuSecretary mainForm = new FormMenuSecretary();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Exam Department")
{
FormMenuExamDepratment mainForm = new FormMenuExamDepratment();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Admin")
{
}
else
{
MessageBox.Show("Unknown Error");
}
}
else
{
MessageBox.Show("Logon Failure: unknown ID or bad password");
}
}
private void buttonSaveChanges_Click(object sender, EventArgs e)
{
if (checkTimeTable())
{
SQLFunctions.addLecturesToStudent(userStudnet.getUserID(), userStudnet.getRegisteredCoursesIDs(), userStudnet.getSemeterPoints(), userStudnet.getWeaklyHours());
MessageBox.Show("Timetable was saved");
}
}
private void button_Submit_Click(object sender, EventArgs e)
{
SQLFunctions.addError(userID, textBox_title.Text, textBox_description.Text);
MessageBox.Show("Your error has been submitted");
textBox_title.Text = "";
button_Submit.Enabled = false;
textBox_description.Text = "";
this.Close();
}
public FormMenuSecretary(int _id, string _password)
{
InitializeComponent();
id = _id;
password = _password;
userSecretary = new Users(_id, _password, SQLFunctions.covertStudentIDtoStudentFirstName(_id), SQLFunctions.covertStudentIDtoStudentLastName(_id), SQLFunctions.getStudentDepartment(_id));
combobox_Year.DropDownStyle = ComboBoxStyle.DropDownList;
combobox_Semester.DropDownStyle = ComboBoxStyle.DropDownList;
}
public Student(int _id, string _password) : base(_id, _password, SQLFunctions.covertStudentIDtoStudentFirstName(_id), SQLFunctions.covertStudentIDtoStudentLastName(_id), SQLFunctions.getStudentDepartment(_id))
{
year = SQLFunctions.getStudentYear(_id);
semester = SQLFunctions.getStudentSemester(_id);
failedCoursesID = SQLFunctions.getStudentFailedCoursesIDs(_id);
semesterPoints = SQLFunctions.getStudentSemesterPoints(_id);
notification = SQLFunctions.getStudentNotificationsState(_id);
weeklyHours = SQLFunctions.getStudentWeeklyHours(_id);
registeredLessonsIDs = SQLFunctions.findStudentLecturesIDs(_id);
}
public Users(int _id)
{
DataRow row = SQLFunctions.getUserProperties(_id);
id = _id;
password = row["Password"].ToString();
firstName = row["FirstName"].ToString();
lastName = row["LastName"].ToString();
department = row["Department"].ToString();
}
public Lesson(int _id)
{
DataRow row = SQLFunctions.getLessonProperties(_id);
lessonID = _id;
day = row["Day"].ToString();
starts = Convert.ToInt32(row["StartHour"]);
ends = Convert.ToInt32(row["EndHour"]);
type = row["Type"].ToString();
classroom = new Classroom(row["Classroom"].ToString());
}
private void listView1_DoubleClick(object sender, EventArgs e)
{
textBox1.Text = listView1.SelectedItems[0].SubItems[1].Text;
textBox1.Visible = false;
List <string> coursesNames = new List <string>();
List <int> coursesID = new List <int>();
int flag = 0;
if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox1.Text)) == true)
{
int j = 0;
comboBox_CourseList.Visible = true;
label_Course.Visible = true;
textBox1.Visible = false;
button_Accept.Visible = true;
AcceptButton = button_Accept;
List <int> lecturesList = SQLFunctions.findStudentLecturesIDs(Convert.ToInt32(textBox1.Text));
if (lecturesList != null)
{
for (int i = 0; i < lecturesList.Count; i++)
{
flag = 0;
for (j = 0; j < coursesID.Count; j++)
{
if (Convert.ToInt32(SQLFunctions.findLectureProperties(lecturesList[i])[2]) == coursesID[j])
{
flag = 1;
}
}
if (flag == 0)
{
coursesID.Add(Convert.ToInt32(SQLFunctions.findLectureProperties(lecturesList[i])[2]));
coursesNames.Add(SQLFunctions.findCourseProperties(coursesID[j])[0]);
}
}
comboBox_CourseList.Items.Clear();
comboBox_CourseList.ResetText();
for (int i = 0; i < coursesNames.Count; i++)
{
comboBox_CourseList.Items.Add(coursesNames[i]);
}
}
else
{
MessageBox.Show("The student is not registered to courses");
}
}
else
{
MessageBox.Show("This student isnt registered");
}
}
public Student(int _id) : base(_id)
{
DataRow row = SQLFunctions.getStudentProperties(_id);
year = Convert.ToInt32(row["Year"]);
semester = (row["Semester"]).ToString();
failedCoursesID = SQLFunctions.getStudentFailedCoursesIDs(_id);
semesterPoints = (float)Convert.ToDouble(row["SemesterPoint"]);
notification = Convert.ToBoolean(row["Notification"]);
weeklyHours = Convert.ToInt32(row["WeeklyHours"]);
registeredLessonsIDs = SQLFunctions.findStudentLecturesIDs(_id);
}
private void buttonChanges_Click(object sender, EventArgs e)
{
//change window + notiication
FormStudent_ViewChanges viewChange = new FormStudent_ViewChanges(userStudnet.getUserID());
viewChange.Show();
userStudnet.setNotification(false);
pictureBox1.Visible = false;
SQLFunctions.ChangeStudentNotificationState(new List <int> {
userStudnet.getUserID()
}, "False");
}
private void button1_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox_ID.Text)) == false)
{
if (!SQLFunctions.checkExistsEmail(textBox_email.Text))
{
if (textBox_email.Text.Contains("@"))
{
if (comboBox_Permission.Text == "Student Secretary")
{
SQLFunctions.insertUser(textBox_email.Text, Convert.ToInt32(textBox_ID.Text), textBox_Password.Text, textBox_FirstName.Text, textBox_LastName.Text, "SecretaryA", comboBox_Department.Text);
}
else if (comboBox_Permission.Text == "Department Secretary")
{
SQLFunctions.insertUser(textBox_email.Text, Convert.ToInt32(textBox_ID.Text), textBox_Password.Text, textBox_FirstName.Text, textBox_LastName.Text, "Secretary", comboBox_Department.Text);
}
else
{
SQLFunctions.insertUser(textBox_email.Text, Convert.ToInt32(textBox_ID.Text), textBox_Password.Text, textBox_FirstName.Text, textBox_LastName.Text, comboBox_Permission.Text, comboBox_Department.Text);
}
if (comboBox_Permission.SelectedIndex == 3)
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as an " + comboBox_Permission.Text);
}
else if (comboBox_Permission.SelectedIndex == 2)
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as an " + comboBox_Permission.Text + " employee");
}
else
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as a " + comboBox_Permission.Text + " in " + comboBox_Department.Text + " department.");
}
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("Invalid Email address");
}
}
else
{
MessageBox.Show("Email " + textBox_email.Text + " is already registered in the system");
}
}
else
{
MessageBox.Show("Student " + textBox_FirstName.Text + " is already registered in the system");
}
}
private void buttonLogin_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkLogIn(Convert.ToInt32(textBoxID.Text), textBoxPassword.Text))
{
this.Hide();
MenuStudentForm mainForm = new MenuStudentForm();
mainForm.Show();
}
else
{
MessageBox.Show("Logon Failure: unknown ID or bad password");
}
}
private bool checkTimeTableAtAdding(int _courseIndex, int _lessonIndex)
{
Lesson lessonToAdd = allowedCoursesProperties[_courseIndex].getLessons()[_lessonIndex];
for (int i = 0; i < allowedCoursesProperties.Count; i++)
{
if (allowedCoursesProperties[i].getCourseID() == allowedCoursesProperties[_courseIndex].getCourseID())
{
for (int j = 0; j < allowedCoursesProperties[i].getLessons().Count; j++)
{
if (allowedCoursesProperties[i].getLessons()[j].getType() == lessonToAdd.getType() &&
userStudnet.getRegisteredLessonsIDs().Contains(allowedCoursesProperties[i].getLessons()[j].getLessonID()))
{
MessageBox.Show("You already added " + allowedCoursesProperties[_courseIndex].getCourseName() + " " + lessonToAdd.getType());
return(false);
}
}
}
}
for (int i = 0; i < allowedCoursesProperties.Count; i++)
{
for (int j = 0; j < allowedCoursesProperties[i].getLessons().Count; j++)
{
if (userStudnet.getRegisteredLessonsIDs().Contains(allowedCoursesProperties[i].getLessons()[j].getLessonID()) &&
allowedCoursesProperties[i].getLessons()[j].getDay() == lessonToAdd.getDay())
{
if ((lessonToAdd.getStartTime() >= allowedCoursesProperties[i].getLessons()[j].getStartTime() && lessonToAdd.getStartTime() < allowedCoursesProperties[i].getLessons()[j].getEndTime()) ||
(lessonToAdd.getEndTime() > allowedCoursesProperties[i].getLessons()[j].getStartTime() && lessonToAdd.getEndTime() <= allowedCoursesProperties[i].getLessons()[j].getEndTime()))
{
MessageBox.Show("You already have lesson on these hours");
return(false);
}
}
}
}
if (lessonToAdd.getType() == "Lecture" && userStudnet.getSemeterPoints() + allowedCoursesProperties[_courseIndex].getCredits() > 30)
{
MessageBox.Show("Semester points is over");
return(false);
}
if (SQLFunctions.getNumberOfRegisteredStudentsAtLesson(lessonToAdd.getLessonID()) >= new Lesson(lessonToAdd.getLessonID()).getClassroom().getCapacity())
{
MessageBox.Show("This class is full");
return(false);
}
return(true);
}
private void comboBox_Department_SelectedIndexChanged(object sender, EventArgs e)
{
//filter courses by department
dataGridView_courses.Rows.Clear();
List <string> row = new List <string>(8);
int i = 0, countRows = 0;
List <string> courseList = SQLFunctions.findCoursePropertiesByDepartment(comboBox_Department.Text);
countRows = courseList.Count / 8;
for (i = 0; i < courseList.Count; i += 9)
{
dataGridView_courses.Rows.Add(courseList[i], courseList[i + 1], courseList[i + 2], courseList[i + 3], courseList[i + 4], courseList[i + 5], courseList[i + 6], (int)Convert.ToDouble(courseList[i + 7]) / 1, Convert.ToString((Convert.ToDouble(courseList[i + 7]) % 1) * 10));
}
}
private void buttonSaveChanges_Click(object sender, EventArgs e)
{
if (checkTimeTableAtSaving())
{
buttonSaveChanges.Visible = false;
buttonAddCourses.Visible = false;
listView1.Visible = false;
buttonRemoveCourses.Visible = false;
comboBox_courses.Visible = false;
buttonEditTimeTable.Visible = true;
SQLFunctions.addLecturesToStudent(userStudnet.getUserID(), userStudnet.getRegisteredLessonsIDs(), userStudnet.getSemeterPoints(), userStudnet.getWeaklyHours());
MessageBox.Show("Timetable was saved");
}
}
private void button_Accept_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsUsers(Convert.ToInt32(listView1.SelectedItems[0].SubItems[0].Text)) == true)
{
SQLFunctions.deleteUser(Convert.ToInt32(listView1.SelectedItems[0].SubItems[0].Text));
MessageBox.Show("User with ID: " + listView1.SelectedItems[0].SubItems[0].Text + " was deleted!");
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("User ID could not be located in the database");
}
}
private void button_Accept_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsClassroom(listView1.SelectedItems[0].SubItems[0].Text) == true)
{
SQLFunctions.deleteClassroom(listView1.SelectedItems[0].SubItems[0].Text);
MessageBox.Show("Class " + listView1.SelectedItems[0].SubItems[0].Text + " was deleted!");
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("Classroom was not found");
}
}
private void button_Accept_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsClassroom(textBox_ClassName.Text) == true)
{
SQLFunctions.deleteClassroom(textBox_ClassName.Text);
MessageBox.Show("Class " + textBox_ClassName.Text + " was deleted!");
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("Classroom could not be located in the database");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsClassroom(textBox_ClassName.Text) == false)
{
SQLFunctions.addClassroom(textBox_ClassName.Text, Convert.ToInt32(textBox_Capacity.Text));
MessageBox.Show("class " + textBox_ClassName.Text + " was added with " + textBox_Capacity.Text + " seats.");
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("class " + textBox_ClassName.Text + " is already exists.");
}
}
private void comboBox_Department_SelectedIndexChanged(object sender, EventArgs e)
{
//filter courses by department
dataGridView_courses.Rows.Clear();
List <string> row = new List <string>(8);
int i = 0;
DataTable courseList_dt = SQLFunctions.findCoursePropertiesByDepartment(comboBox_Department.Text);
if (courseList_dt != null)
{
for (i = 0; i < courseList_dt.Rows.Count; i++)
{
dataGridView_courses.Rows.Add(courseList_dt.Rows[i]["Name"].ToString(), Convert.ToInt32(courseList_dt.Rows[i]["ID"]), (courseList_dt.Rows[i]["PreReqID"]).ToString(), Convert.ToInt32(courseList_dt.Rows[i]["Credits"]), Convert.ToInt32(courseList_dt.Rows[i]["LectureHour"]), Convert.ToInt32(courseList_dt.Rows[i]["PracticeHour"]), Convert.ToInt32(courseList_dt.Rows[i]["ReceptionHour"]), Convert.ToInt32(courseList_dt.Rows[i]["Year"]), Convert.ToChar(courseList_dt.Rows[i]["Semester"]));
}
}
}
public FormAdmin_RemoveClassroom()
{
InitializeComponent();
this.AcceptButton = button_Accept;
DataTable classes = SQLFunctions.getClassrooms();
if (classes != null)
{
for (int i = 0; i < classes.Rows.Count; i++)
{
string[] row = { classes.Rows[i]["Name"].ToString(), classes.Rows[i]["Capacity"].ToString(), classes.Rows[i]["Type"].ToString() };
ListViewItem item = new ListViewItem(row);
listView1.Items.Add(item);
}
}
}
private void login1()
{
if (!link)
{
DataRow dataRow = SQLFunctions.checkFbLogIn(fbMail);
if (dataRow == null)
{
MessageBox.Show("This facebook account is not linked to any system user\nPlease link your Facebook account and try again");
B_8.login login = new B_8.login();
login.Show();
}
else if (SQLFunctions.checkLogIn(Convert.ToInt32(dataRow[0]), dataRow[1].ToString()))
{
if (SQLFunctions.checkRole(Convert.ToInt32(dataRow[0])) == "Student")
{
FormMenuStudent mainForm = new FormMenuStudent(Convert.ToInt32(dataRow[0]), dataRow[1].ToString());
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(dataRow[0])) == "SecretaryA")
{
FormMenuSecretary mainForm = new FormMenuSecretary(Convert.ToInt32(dataRow[0]), dataRow[1].ToString());
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(dataRow[0])) == "Exam Department")
{
FormMenuExamDepartment mainForm = new FormMenuExamDepartment();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(dataRow[0])) == "Admin")
{
FormMenuAdmin mainForm = new FormMenuAdmin();
mainForm.Show();
}
else
{
B_8.login login = new B_8.login(true, SQLFunctions.convertFbMailToMail(fbMail), dataRow[1].ToString());
}
}
}
else
{
SQLFunctions.linkFbAccount(mail, fbMail);
MessageBox.Show("Your facebook account was succesfuly linked");
this.Hide();
}
}
private void button_accept_Click(object sender, EventArgs e)
{
int lectureID;
if ((2000 + Convert.ToInt32(textBox_year.Text) < 2100) && (2000 + Convert.ToInt32(textBox_year.Text) > 2000) && (Convert.ToInt32(textBox_month.Text) < 13) && (Convert.ToInt32(textBox_month.Text) > 0))
{
if (!(Convert.ToInt32(textBox_day.Text) > DateTime.DaysInMonth(2000 + Convert.ToInt32(textBox_year.Text), Convert.ToInt32(textBox_month.Text)) || Convert.ToInt32(textBox_day.Text) < 0))
{
if ((Convert.ToInt32(textBox_StartTime.Text) >= 8 && Convert.ToInt32(textBox_StartTime.Text) <= 21) && (Convert.ToInt32(textBox_EndTime.Text) >= 8 && Convert.ToInt32(textBox_EndTime.Text) <= 21) && (Convert.ToInt32(textBox_StartTime.Text) < Convert.ToInt32(textBox_EndTime.Text)))
{
if (comboBox_AddRemove.SelectedIndex == 0)
{
if (comboBox_Lectures.SelectedItem.ToString() != "All")
{
lectureID = lectureIDS[comboBox_Lectures.SelectedIndex];
SQLFunctions.addChange(textBox_description.Text, Convert.ToInt32(textBox_StartTime.Text), Convert.ToInt32(textBox_EndTime.Text), Convert.ToInt32(textBox_day.Text), Convert.ToInt32(textBox_month.Text), 2000 + Convert.ToInt32(textBox_year.Text), lectureID);
}
else
{
SQLFunctions.addChange(textBox_description.Text, Convert.ToInt32(textBox_StartTime.Text), Convert.ToInt32(textBox_EndTime.Text), Convert.ToInt32(textBox_day.Text), Convert.ToInt32(textBox_month.Text), 2000 + Convert.ToInt32(textBox_year.Text), 0);
}
}
else
{
lectureID = lectureIDS[comboBox_Lectures.SelectedIndex];
SQLFunctions.addChange("Canceled", Convert.ToInt32(textBox_StartTime.Text), Convert.ToInt32(textBox_EndTime.Text), Convert.ToInt32(textBox_day.Text), Convert.ToInt32(textBox_month.Text), 2000 + Convert.ToInt32(textBox_year.Text), lectureID);
}
FormMenuSecretary secForm = new FormMenuSecretary(id, password);
this.Hide();
secForm.Show();
}
else
{
MessageBox.Show("Incorrect values");
}
}
else
{
MessageBox.Show("Incorrect values");
}
}
else
{
MessageBox.Show("Incorrect values");
}
}
public FormStudent_ViewChanges(int id)
{
InitializeComponent();
int index = 0;
userStudent = new Student(id);
DataTable datatable = SQLFunctions.getTimeTableChanges();
if (datatable != null && userStudent.getRegisteredLessonsIDs() != null)
{
for (int i = 0; i < userStudent.getRegisteredLessonsIDs().Count; i++)
{
for (int j = 0; j < datatable.Rows.Count; j++)
{
if (userStudent.getRegisteredLessonsIDs()[i] == Convert.ToInt32(datatable.Rows[j]["LectureID"]))
{
List <string> change = new List <string>();
change.Add(datatable.Rows[j]["Title"].ToString());
change.Add(datatable.Rows[j]["Description"].ToString());
change.Add(datatable.Rows[j]["Starts"].ToString());
change.Add(datatable.Rows[j]["Ends"].ToString());
change.Add(datatable.Rows[j]["day"].ToString());
change.Add(datatable.Rows[j]["month"].ToString());
change.Add(datatable.Rows[j]["year"].ToString());
changes.Add(change);
listViewTitle.Items.Add(changes[index++][0]);
}
}
}
for (int i = 0; i < datatable.Rows.Count; i++)
{
if (Convert.ToInt32(datatable.Rows[i]["LectureID"]) == 0)
{
List <string> change = new List <string>();
change.Add(datatable.Rows[i]["Title"].ToString());
change.Add(datatable.Rows[i]["Description"].ToString());
change.Add(datatable.Rows[i]["Starts"].ToString());
change.Add(datatable.Rows[i]["Ends"].ToString());
change.Add(datatable.Rows[i]["day"].ToString());
change.Add(datatable.Rows[i]["month"].ToString());
change.Add(datatable.Rows[i]["year"].ToString());
changes.Add(change);
listViewTitle.Items.Add(changes[index++][0]);
}
}
}
}
private void button_ClearList_Click(object sender, EventArgs e)
{
if (listViewTitle.Items.Count > 0)
{
if (MessageBox.Show("Are you sure you want to delete all the errors?", "Clear Errors", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
listViewTitle.Clear();
SQLFunctions.ClearErrors();
textBoxFrom.Clear();
textBoxDescription.Clear();
}
}
else
{
MessageBox.Show("There were no errors to delete");
}
}
