Exemplo n.º 1
0
        public void insertSolutionOnSystem(string path)
        {
            //clean timetable_temp
            string currentSemester = getCurrentSemester();

            DBConnection.Delete("timetable_" + currentSemester);

            // Open document
            List <string> myValues = new List <string>();
            string        line;
            // Read the file and display it line by line.
            StreamReader file = new StreamReader("Output/" + path);

            while ((line = file.ReadLine()) != null)
            {
                myValues.Add(line);
            }

            foreach (string item in myValues)
            {
                string   row   = string.Join(" ", item.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries));
                string[] items = row.Split(' ');

                if ((items.Count() != 4) || !items[0].StartsWith("c") || !items[1].StartsWith("r"))
                {
                    throw new Exception("Selected file is not on the correct format!");
                }

                string values = "'" + items[0] + "', '" + items[1] + "', '" + items[2] + "', '" + items[3] + "'";

                int res = DBConnection.Create("timetable_" + currentSemester, "course_code, room_code, day, start_period", values);
            }
        }
Exemplo n.º 2
0
        private void saveTeacher_MouseUp(object sender, EventArgs e)
        {
            if (txtName.Text.Length == 0)
            {
                MessageBox.Show("Teacher name is required!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                return;
            }
            if (txtSurname.Text.Length == 0)
            {
                MessageBox.Show("Teacher surname is required!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                return;
            }

            if(txtEmail.Text.Length > 0 && !Regex.IsMatch(txtEmail.Text, @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"))
            {
                MessageBox.Show("Please enter a valid email!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                return;
            }

            if (txtId.Text.Length == 0)
            {
                string code = null;
                for (int i = 1; i < 1000; i++)
                {
                    code = "t" + i.ToString("000");
                    DataView data = DBConnection.Select("teachers", "'*'", " code = '" + code + "'").DefaultView;
                    if (data.Count == 0) break;
                }

                string values = "'" + txtName.Text +
                                "', '" + txtSurname.Text +
                                "', '" + txtTitle.Text +
                                "', '" + txtEmail.Text +
                                "', '" + txtPhone.Text +
                                "', '" + code.ToString() +
                                "', '" + txtNote.Text + "'";

                int result = DBConnection.Create("teachers", "name, surname, title, email, phone, code, note", values);
                if (result > 0)
                {
                    MessageBox.Show("Successfully created new Teacher!", "Information", MessageBoxButton.OK);
                    txtId.Text = result.ToString();
                }
            }
            else if (Convert.ToInt32(txtId.Text) > 0)
            {
                string values = "name='" + txtName.Text +
                                "', surname='" + txtSurname.Text +
                                "', title='" + txtTitle.Text +
                                "', email='" + txtEmail.Text +
                                "', phone='" + txtPhone.Text +
                                "', code='" + txtCode.Text +
                                "', note='" + txtNote.Text + "'";

                int result = DBConnection.Update("teachers", values, Convert.ToInt32(txtId.Text));
                if (result > 0)
                    MessageBox.Show("Successfully updated Teacher!", "Information", MessageBoxButton.OK);
            }
        }
Exemplo n.º 3
0
        public void main()
        {
            try
            {
                Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();

                // Set filter for file extension and default file extension
                dlg.DefaultExt = ".txt";
                dlg.Filter     = "TXT Files (*.txt)|*.txt";

                // Display OpenFileDialog by calling ShowDialog method
                Nullable <bool> result = dlg.ShowDialog();

                // Get the selected file name and display in a TextBox
                if (result == true)
                {
                    //clean timetable_temp
                    DBConnection.Delete("timetable_temp");

                    // Open document
                    string        filename = dlg.FileName;
                    List <string> myValues = new List <string>();
                    string        line;
                    // Read the file and display it line by line.
                    StreamReader file = new StreamReader(filename);
                    while ((line = file.ReadLine()) != null)
                    {
                        myValues.Add(line);
                    }

                    foreach (string item in myValues)
                    {
                        string   row   = string.Join(" ", item.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries));
                        string[] items = row.Split(' ');

                        if ((items.Count() != 4) || !items[0].StartsWith("c") || !items[1].StartsWith("r"))
                        {
                            throw new Exception("Selected file is not on the correct format!");
                        }

                        string values = "'" + items[0] + "', '" + items[1] + "', '" + items[2] + "', '" + items[3] + "'";

                        int res = DBConnection.Create("timetable_temp", "course_code, room_code, day, start_period", values);
                    }

                    TimetablingResultDisplay display = new TimetablingResultDisplay();
                    display.Show();
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
        }
 private void insertCoursePreferences(int courseId, int teacherId = 0)
 {
     if (teacherId > 0)
     {
         DataTable preferences = DBConnection.Select("teacher_periods_preferences", "day, period", "teacher_id=" + teacherId);
         if (preferences.Rows.Count != 0)
         {
             foreach (DataRow preference in preferences.Rows)
             {
                 string values = "'" + courseId + "', '" + preference.ItemArray[0] + "', '" + preference.ItemArray[1] + "'";
                 int    result = DBConnection.Create("course_periods_preferences", "course_id, day, period", values);
             }
         }
     }
 }
Exemplo n.º 5
0
        private void saveDepartment_MouseUp(object sender, EventArgs e)
        {
            try
            {
                if (txtName.Text == null || txtName.Text == "")
                {
                    MessageBox.Show("Study program name is required!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    return;
                }
                if (int.Parse(comboBox.SelectedIndex.ToString()) < 0)
                {
                    MessageBox.Show("Please select study program's faculty!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    return;
                }

                if (txtId.Text == "")
                {
                    string values = "'" + txtName.Text +
                                    "', '" + comboBox.SelectedValue + "'";

                    int result = DBConnection.Create("departments", "name, faculty_id", values);

                    if (result > 0)
                    {
                        MessageBox.Show("Successfully created new study program!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    }
                }
                else if (Convert.ToInt32(txtId.Text) > 0)
                {
                    string values = " name='" + txtName.Text +
                                    "', faculty_id='" + comboBox.SelectedValue + "'";

                    int result = DBConnection.Update("departments", values, Convert.ToInt32(txtId.Text));
                    if (result > 0)
                    {
                        MessageBox.Show("Successfully updated study program!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    }
                }

                Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }
Exemplo n.º 6
0
        private void saveCoursePeriodPreferences_MouseUp(object sender, MouseButtonEventArgs e)
        {
            var course_id = comboBoxCourse.SelectedValue;
            var day       = comboBoxDay.SelectedValue;
            var period    = comboBoxPeriod.SelectedValue;

            string values = "'" + course_id + "', '" + day + "', '" + period + "'";

            int result = DBConnection.Create("course_periods_preferences", "course_id, day, period", values);

            if (result > 0)
            {
                MessageBox.Show("Successfully created new Course Period Preferences!", "Information", MessageBoxButton.OK);
            }

            Close();
        }
Exemplo n.º 7
0
        private void saveCourseDepartmentRel_MouseUp(object sender, EventArgs e)
        {
            try
            {
                if (int.Parse(comboBoxCourse.SelectedIndex.ToString()) < 0)
                {
                    MessageBox.Show("Please select course!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    return;
                }
                if (int.Parse(comboBoxDepartment.SelectedIndex.ToString()) < 0)
                {
                    MessageBox.Show("Please select department!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    return;
                }

                var course_id     = comboBoxCourse.SelectedValue;
                var department_id = comboBoxDepartment.SelectedValue;

                DataView data = DBConnection.Select("course_department_rel", "'*'", " course_id = '" + course_id + "' AND department_id='" + department_id + "'").DefaultView;
                if (data.Count != 0)
                {
                    MessageBox.Show("This course is already assigned to the selected department!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    return;
                }

                string values = "'" + course_id + "', '" + department_id + "'";

                int result = DBConnection.Create("course_department_rel", "course_id, department_id", values);
                if (result > 0)
                {
                    MessageBox.Show("Successfully created new course department assignment!", "Information", MessageBoxButton.OK);
                }

                Close();
            } catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
            }
        }
Exemplo n.º 8
0
        private void OnDoubleClick(object sender, MouseButtonEventArgs e)
        {
            if (e.LeftButton == MouseButtonState.Pressed && e.ClickCount == 2)
            {
                foreach (UControl child in childs)
                {
                    if (child.Clicked == "true")
                    {
                        if (comboBoxRooms.SelectedIndex != -1)
                        {
                            if (child.ControlAssigned == "false" && child.BlockedAssigned != "true")
                            {
                                //check if clicked period is a red position
                                string cCode       = txtCode.Text;
                                int    day         = int.Parse(child.Column) - 1;
                                int    startPeriod = int.Parse(child.Row) - 1;
                                string rCode       = "";

                                string    query = " SELECT code FROM rooms WHERE id=" + comboBoxRooms.SelectedValue;
                                DataTable res   = DBConnection.RAW_Select(query);

                                ArrayList result = new ArrayList();
                                foreach (DataRow r in res.Rows)
                                {
                                    rCode = r.ItemArray[0].ToString();
                                }

                                string values = "'" + cCode + "', '" + rCode + "', '" + day + "', '" + startPeriod + "'";

                                string table = "timetable_" + getCurrentSemester();

                                DataView data = DBConnection.Select(table, "'*'", " course_code = '" + cCode + "'").DefaultView;
                                if (data.Count == 0)
                                {
                                    int createdId = DBConnection.Create(table, "course_code, room_code, day, start_period", values);
                                }
                                else
                                {
                                    string vals      = "room_code='" + rCode + "', day='" + day + "', start_period='" + startPeriod + "'";
                                    int    createdId = DBConnection.Update(table, vals, 0, " course_code='" + cCode + "'");
                                }
                                MessageBox.Show("Class was placed successfully!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                                Close();
                                break;
                            }
                            else
                            {
                                MessageBox.Show("Class can not be placed at this position!", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
                                child.Clicked = "false";
                                break;
                            }
                        }
                        else
                        {
                            MessageBox.Show("Please select a room first!", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
                            child.Clicked = "false";
                            break;
                        }
                    }
                }
            }
        }
Exemplo n.º 9
0
        /*  private void preferences()
         * {
         *    DataTable data = DBConnection.Select(" courses c " +
         *                            " LEFT JOIN course_department_rel cdr ON c.id = cdr.course_id ", " c.id ", "c.detail='laboratory'");//AND c.detail='lecture'
         *    ArrayList courseIds = new ArrayList();
         *
         *    foreach (DataRow courseRow in data.Rows)
         *        courseIds.Add(courseRow.ItemArray[0]);
         *
         *    ArrayList days = new ArrayList() {1,2,3,4,5,6};
         *    ArrayList periods = new ArrayList() {1,2,3 };
         *    int res;
         *    foreach (int id in courseIds)
         *    {
         *        foreach(int day in days)
         *        {
         *            foreach(int period in periods)
         *            {
         *                DataView dt = DBConnection.Select("course_periods_preferences", "'*'", " course_id = " + id + " AND day=" + day + " AND period=" + period ).DefaultView;
         *                if (dt.Count == 0)
         *                    res = DBConnection.Create("course_periods_preferences", " course_id, day, period", "'" + id + "','" + day + "','" + period + "'");
         *            }
         *        }
         *    }
         * }*/

        private void roomPreferences(string code, ArrayList lecRooms, ArrayList numRooms, ArrayList labRooms)
        {
            //Lecture
            DataTable lecData      = DBConnection.Select(" courses ", " id ", " base_parent_code='" + code + "' AND detail='lecture'");//AND c.detail='lecture'
            ArrayList lecCourseIds = new ArrayList();

            foreach (DataRow courseRow in lecData.Rows)
            {
                lecCourseIds.Add(courseRow.ItemArray[0]);
            }

            int res;

            foreach (int id in lecCourseIds)
            {
                foreach (int lecRoom in lecRooms)
                {
                    DataView dt = DBConnection.Select("courses_rooms_rel", "'*'", " course_id = " + id + " AND room_id=" + lecRoom).DefaultView;
                    if (dt.Count == 0)
                    {
                        res = DBConnection.Create("courses_rooms_rel", " course_id, room_id", "'" + id + "','" + lecRoom + "'");
                    }
                }
            }

            //Numeric
            if (numRooms.Count > 0)
            {
                DataTable numData      = DBConnection.Select(" courses ", " id ", " base_parent_code='" + code + "' AND detail='numeric'");//AND c.detail='lecture'
                ArrayList numCourseIds = new ArrayList();

                foreach (DataRow courseRow in numData.Rows)
                {
                    numCourseIds.Add(courseRow.ItemArray[0]);
                }

                int res1;
                foreach (int id in numCourseIds)
                {
                    foreach (int numRoom in numRooms)
                    {
                        DataView dt = DBConnection.Select("courses_rooms_rel", "'*'", " course_id = " + id + " AND room_id=" + numRoom).DefaultView;
                        if (dt.Count == 0)
                        {
                            res1 = DBConnection.Create("courses_rooms_rel", " course_id, room_id", "'" + id + "','" + numRoom + "'");
                        }
                    }
                }
            }

            //Laboratory
            if (labRooms.Count > 0)
            {
                DataTable labData      = DBConnection.Select(" courses ", " id ", " base_parent_code='" + code + "' AND detail='laboratory'");//AND c.detail='lecture'
                ArrayList labCourseIds = new ArrayList();

                foreach (DataRow courseRow in labData.Rows)
                {
                    labCourseIds.Add(courseRow.ItemArray[0]);
                }

                int res2;
                foreach (int id in labCourseIds)
                {
                    foreach (int labRoom in labRooms)
                    {
                        DataView dt = DBConnection.Select("courses_rooms_rel", "'*'", " course_id = " + id + " AND room_id=" + labRoom).DefaultView;
                        if (dt.Count == 0)
                        {
                            res2 = DBConnection.Create("courses_rooms_rel", " course_id, room_id", "'" + id + "','" + labRoom + "'");
                        }
                    }
                }
            }
        }
        private void saveRoom_MouseUp(object sender, EventArgs e)
        {
            try
            {
                if (txtName.Text == null || txtName.Text == "")
                {
                    MessageBox.Show("Room name is required!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    return;
                }
                if (txtSize.Text == null || txtSize.Text == "")
                {
                    MessageBox.Show("Room size is required!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    return;
                }
                if (int.Parse(comboBox.SelectedIndex.ToString()) < 0)
                {
                    MessageBox.Show("Please select building!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    return;
                }

                if (txtId.Text == "")
                {
                    string code = null;
                    for (int i = 1; i < 1000; i++)
                    {
                        code = "r" + i.ToString("000");
                        DataView data = DBConnection.Select("rooms", "'*'", " code = '" + code + "'").DefaultView;
                        if (data.Count == 0)
                        {
                            break;
                        }
                    }

                    string values = "'" + txtName.Text +
                                    "', '" + Convert.ToInt32(txtSize.Text) +
                                    "', '" + code.ToString() +
                                    "', '" + comboBox.SelectedValue +
                                    "', '" + txtNote.Text + "'";

                    int result = DBConnection.Create("rooms", "name, size, code, building_id, note", values);

                    if (result > 0)
                    {
                        MessageBox.Show("New room has been successfully created!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    }
                }
                else if (Convert.ToInt32(txtId.Text) > 0)
                {
                    string values = " name='" + txtName.Text +
                                    "', size='" + Convert.ToInt32(txtSize.Text) +
                                    "', code='" + txtCode.Text +
                                    "', building_id='" + comboBox.SelectedValue +
                                    "', note='" + txtNote.Text + "'";

                    int result = DBConnection.Update("rooms", values, Convert.ToInt32(txtId.Text));
                    if (result > 0)
                    {
                        MessageBox.Show("Room has been successfully updated!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                    }
                }

                Close();
            } catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }
Exemplo n.º 11
0
        private void pnlBackground_MouseDown(object sender, MouseButtonEventArgs e)
        {
            if (e.LeftButton == MouseButtonState.Pressed)
            {
                var day    = int.Parse(lblColumn.Text);
                var period = int.Parse(lblRow.Text);

                if (lblClicked.Text == "false")
                {
                    if ((Parent.GetType() == typeof(Grid)) && ((Parent as Grid).Parent.GetType() == typeof(Grid)) && (((Parent as Grid).Parent as Grid).Parent.GetType() == typeof(PreferencesWindow)))
                    {
                        if (!(((Parent as Grid).Parent as Grid).Parent as PreferencesWindow).validatePreference())
                        {
                            MessageBox.Show("Teacher should be available at least half of the week! In order to add other constraints, please remove some existing constraints!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                            return;
                        }
                    }

                    lblClicked.Text = "true";
                    PanelBackground = "#5E716A";

                    if (TeacherId > 0)
                    {
                        DataTable preferences = DBConnection.Select("teacher_periods_preferences", "day, period", "teacher_id=" + TeacherId + " AND day=" + day + " AND period=" + period);
                        if (preferences.Rows.Count == 0)
                        {
                            string values = "'" + TeacherId + "', '" + day + "', '" + period + "'";
                            int    result = DBConnection.Create("teacher_periods_preferences", "teacher_id, day, period", values);
                        }
                    }

                    if (CourseIds.Count > 0)
                    {
                        foreach (int cId in CourseIds)
                        {
                            DataView data = DBConnection.Select("course_periods_preferences", "'*'", " course_id = " + cId + " AND day=" + day + " AND period=" + period).DefaultView;
                            if (data.Count == 0)
                            {
                                string values = "'" + cId + "', '" + day + "', '" + period + "'";
                                int    result = DBConnection.Create("course_periods_preferences", "course_id, day, period", values);
                            }
                        }
                    }
                }
                else
                {
                    lblClicked.Text = "false";
                    PanelBackground = "#EEEEEE";

                    if (TeacherId > 0)
                    {
                        int result = DBConnection.Delete("teacher_periods_preferences", 0, " teacher_id=" + TeacherId + " AND day=" + day + " AND period=" + period);
                    }

                    if (CourseIds.Count > 0)
                    {
                        foreach (int cId in CourseIds)
                        {
                            int result = DBConnection.Delete("course_periods_preferences", 0, " course_id=" + cId + " AND day=" + day + " AND period=" + period);
                        }
                    }
                }
            }
        }
        private void insertCourse(Thread newWindowThread, bool hideMessage = false)
        {
            try
            {
                string code = null;
                for (int i = 1; i < 1000; i++)
                {
                    code = "p" + i.ToString("000");
                    DataView data = DBConnection.Select("courses", "'*'", " code = '" + code + "'").DefaultView;
                    if (data.Count == 0)
                    {
                        break;
                    }
                }

                validateFields(newWindowThread);
                int departmentRes;
                List <ComboDepartments> departments = courseDepartmentsGrid.Items.OfType <ComboDepartments>().ToList();
                if (departments.Count() == 0)
                {
                    throw new Exception("No department selected!");
                }

                List <CourseTeachers> teachersGroups = courseTeacherRelationGrid.Items.OfType <CourseTeachers>().ToList();
                int nrGroups           = int.Parse(comboBoxGroups.SelectedIndex.ToString()) >= 0 ? int.Parse(comboBoxGroups.SelectedValue.ToString()) : 0;
                int nrExerciseGroups   = int.Parse(comboBoxNrExerciseGroups.SelectedIndex.ToString()) >= 0 ? int.Parse(comboBoxNrExerciseGroups.SelectedValue.ToString()) : 0;
                int nrLaboratoryGroups = int.Parse(comboBoxLabExercisesGroups.SelectedIndex.ToString()) >= 0 ? int.Parse(comboBoxLabExercisesGroups.SelectedValue.ToString()) : 0;

                string lectures           = comboBoxNrLectures.SelectedIndex >= 0 ? comboBoxNrLectures.SelectedValue.ToString() : "0";
                string numLectures        = comboBoxNrNumExercLectures.SelectedIndex >= 0 ? comboBoxNrNumExercLectures.SelectedValue.ToString() : "0";
                string labLectures        = comboBoxNrLabExercLectures.SelectedIndex >= 0 ? comboBoxNrLabExercLectures.SelectedValue.ToString() : "0";
                string number_of_lectures = lectures + "+" + numLectures + "+" + labLectures;
                string ects            = comboBoxEcts.SelectedValue.ToString();
                int    min_days        = int.Parse(comboBoxMinDays.SelectedValue.ToString());
                var    type            = comboBoxType.SelectedValue;
                var    degree          = comboBoxDegree.SelectedValue;
                var    semester_id     = comboBoxSemester.SelectedValue;
                var    double_lectures = int.Parse(comboBoxDoubleLectures.SelectedValue.ToString()) == 1 ? true : false;

                string values = "'" + txtName.Text +
                                "', '" + code.ToString() +
                                "', '" + ects +
                                "', '" + type +
                                "', '" + degree +
                                "', '" + semester_id +
                                "', '" + number_of_lectures +
                                "', '" + min_days +
                                "', '" + double_lectures +
                                "', '" + int.Parse(txtNrStudents.Text) +
                                "', '" + int.Parse(comboBoxGroups.SelectedValue.ToString()) +
                                "', 'base', null, null, null, null";

                string columns = "name, code, ects, type, degree, semester_id, number_of_lectures, min_days, double_lectures, number_of_students, groups, detail, lecture_group, numeric_group, laboratory_group, base_parent_code";

                int result = DBConnection.Create("courses", columns, values);                    //Returns last inserted id

                //Insert Groups of Course
                if (result > 0)
                {
                    int   gr = 0, ex = 0, lab = 0;
                    int[] groupIds        = new int[nrGroups];
                    int[] numExercisesIds = new int[nrExerciseGroups];
                    int[] labExercisesIds = new int[nrLaboratoryGroups];
                    if (nrGroups > 0)
                    {
                        int studentsPerGroup = Convert.ToInt32(txtNrStudents.Text) / nrGroups;
                        for (int i = 1; i <= nrGroups; i++)
                        {
                            int    exercisePerGroup = nrExerciseGroups / nrGroups;
                            int    exDiff           = nrExerciseGroups - (nrGroups * exercisePerGroup);
                            string groupsCode       = null;
                            for (int j = 1; j < 1000; j++)
                            {
                                groupsCode = "c" + j.ToString("000");
                                DataView data = DBConnection.Select("courses", "'*'", " code = '" + groupsCode + "'").DefaultView;
                                if (data.Count == 0)
                                {
                                    break;
                                }
                            }

                            string groupValues = "'" + txtName.Text + ((nrGroups > 1) ? (" Gr. " + i.ToString()) : " ") +
                                                 "', '" + groupsCode.ToString() +
                                                 "', '" + ects +
                                                 "', '" + type +
                                                 "', '" + degree +
                                                 "', '" + semester_id +
                                                 "', '" + number_of_lectures +
                                                 "', '" + min_days +
                                                 "', '" + double_lectures +
                                                 "', '" + studentsPerGroup +
                                                 "', '" + result +
                                                 "', 'lecture', 'Gr" + i.ToString() + "', null, null, '" + code.ToString() + "'";


                            string grColumns = "name, code, ects, type, degree, semester_id, number_of_lectures, min_days, double_lectures, number_of_students, parent_id, detail, lecture_group, numeric_group, laboratory_group, base_parent_code";

                            int grResult = DBConnection.Create("courses", grColumns, groupValues);
                            groupIds[gr] = grResult;
                            gr++;
                            //Insert Exercises per Group
                            if (exercisePerGroup > 0)
                            {
                                if (i == 1 && exDiff > 0)
                                {
                                    exercisePerGroup += exDiff;
                                }
                                int studentsPerExercises = studentsPerGroup / exercisePerGroup;
                                for (int a = 1; a <= exercisePerGroup; a++)
                                {
                                    int    laboratoryPerGroup = nrLaboratoryGroups / nrExerciseGroups;
                                    int    labDiff            = nrLaboratoryGroups - (nrExerciseGroups * laboratoryPerGroup);
                                    string exerciseCode       = null;

                                    for (int j = 1; j < 1000; j++)
                                    {
                                        exerciseCode = groupsCode + j;
                                        DataView data = DBConnection.Select("courses", "'*'", " code = '" + exerciseCode + "'").DefaultView;
                                        if (data.Count == 0)
                                        {
                                            break;
                                        }
                                    }

                                    string exGroup        = i.ToString() + alphabet[a - 1];
                                    string exerciseValues = "'" + txtName.Text + ((nrGroups > 1) ? (" Gr. ") : " ") + (nrGroups > 1 || exercisePerGroup > 1 ? (i.ToString() + exGroup.Replace(i.ToString(), "")) : "") +
                                                            "', '" + exerciseCode.ToString() +
                                                            "', '" + ects +
                                                            "', '" + type +
                                                            "', '" + degree +
                                                            "', '" + semester_id +
                                                            "', '" + number_of_lectures +
                                                            "', '" + min_days +
                                                            "', '" + double_lectures +
                                                            "', '" + studentsPerExercises +
                                                            "', '" + grResult +
                                                            "', 'numeric', 'Gr" + i.ToString() + "', '" + exGroup + "', null, '" + code.ToString() + "'";


                                    int exResult = DBConnection.Create("courses", grColumns, exerciseValues);
                                    numExercisesIds[ex] = exResult;
                                    ex++;
                                    //Insert Laboratory Exercises
                                    if (laboratoryPerGroup > 0)
                                    {
                                        if (a == 1 & labDiff > 0)
                                        {
                                            laboratoryPerGroup += labDiff;
                                        }
                                        int studentsPerLaboratory = studentsPerExercises / laboratoryPerGroup;
                                        for (int b = 0; b < laboratoryPerGroup; b++)
                                        {
                                            string labCode = null;
                                            for (int j = 1; j < 1000; j++)
                                            {
                                                labCode = exerciseCode + j;
                                                DataView data = DBConnection.Select("courses", "'*'", " code = '" + labCode + "'").DefaultView;
                                                if (data.Count == 0)
                                                {
                                                    break;
                                                }
                                            }

                                            string labValues = "'" + txtName.Text + ((nrGroups > 1) ? (" Gr. ") : " ") + (nrGroups > 1 || (exercisePerGroup > 1 && laboratoryPerGroup >= 1) ? (i.ToString() + exGroup.Replace(i.ToString(), "") + primes[b]) : "") +
                                                               "', '" + labCode.ToString() +
                                                               "', '" + ects +
                                                               "', '" + type +
                                                               "', '" + degree +
                                                               "', '" + semester_id +
                                                               "', '" + number_of_lectures +
                                                               "', '" + min_days +
                                                               "', '" + double_lectures +
                                                               "', '" + studentsPerLaboratory +
                                                               "', '" + exResult +
                                                               "', 'laboratory', 'Gr" + i.ToString() + "', '" + exGroup + "', '" + exGroup + primes[b] + "', '" + code.ToString() + "'";


                                            int labResult = DBConnection.Create("courses", grColumns, labValues);
                                            labExercisesIds[lab] = labResult;
                                            lab++;
                                        }
                                    }
                                }
                            }
                            //Insert Laboratory if no exercise groups
                            else if (nrLaboratoryGroups / nrGroups > 0)
                            {
                                int laboratoryPerGroup    = nrLaboratoryGroups / nrGroups;
                                int studentsPerLaboratory = studentsPerGroup / laboratoryPerGroup;
                                int labDiff = nrLaboratoryGroups - (nrGroups * laboratoryPerGroup);
                                if (i == 1 && labDiff > 0)
                                {
                                    laboratoryPerGroup += labDiff;
                                }
                                for (int b = 1; b <= laboratoryPerGroup; b++)
                                {
                                    string labCode = null;
                                    for (int j = 1; j < 1000; j++)
                                    {
                                        labCode = groupsCode + j;
                                        DataView data = DBConnection.Select("courses", "'*'", " code = '" + labCode + "'").DefaultView;
                                        if (data.Count == 0)
                                        {
                                            break;
                                        }
                                    }

                                    double des       = Convert.ToDouble(b / 2.0);
                                    double devideRes = Math.Ceiling(Convert.ToDouble(b / 2.0));
                                    int    remain    = b % 2;
                                    string labName   = i.ToString() + alphabet[Convert.ToInt32(devideRes) - 1] + primes[remain];

                                    string labValues = "'" + txtName.Text + ((nrGroups > 1) ? (" Gr. ") : " ") + (laboratoryPerGroup > 1 ? (labName) : "") +
                                                       "', '" + labCode.ToString() +
                                                       "', '" + ects +
                                                       "', '" + type +
                                                       "', '" + degree +
                                                       "', '" + semester_id +
                                                       "', '" + number_of_lectures +
                                                       "', '" + min_days +
                                                       "', '" + double_lectures +
                                                       "', '" + studentsPerLaboratory +
                                                       "', '" + grResult +
                                                       "', 'laboratory', 'Gr" + i.ToString() + "', null, '" + labName + "', '" + code.ToString() + "'";


                                    int labResult = DBConnection.Create("courses", grColumns, labValues);
                                    labExercisesIds[lab] = labResult;
                                    lab++;
                                }
                            }
                        }

                        //Get teacher and their number of groups
                        List <CourseTeachers> teachers = courseTeacherRelationGrid.Items.OfType <CourseTeachers>().ToList();
                        int lecture = 0, exercise = 0, laboratory = 0;
                        foreach (CourseTeachers row in teachers)
                        {
                            while (row.Lectures > 0)
                            {
                                if (lecture >= groupIds.Count())
                                {
                                    break;
                                }
                                string vals = "'" + groupIds[lecture] + "', '" + row.TeacherID + "'";

                                int res = DBConnection.Create("course_teacher_rel", "course_id, teacher_id", vals);

                                //Insert course preferences
                                insertCoursePreferences(groupIds[lecture], row.TeacherID);
                                lecture++;
                                row.Lectures--;
                            }

                            while (row.NumericExercises > 0)
                            {
                                if (exercise >= numExercisesIds.Count())
                                {
                                    break;
                                }
                                string vals = "'" + numExercisesIds[exercise] + "', '" + row.TeacherID + "'";

                                int res = DBConnection.Create("course_teacher_rel", "course_id, teacher_id", vals);

                                //Innsert course preferences
                                insertCoursePreferences(numExercisesIds[exercise], row.TeacherID);
                                exercise++;
                                row.NumericExercises--;
                            }

                            while (row.LaboratoryExercises > 0)
                            {
                                if (laboratory >= labExercisesIds.Count())
                                {
                                    break;
                                }
                                string vals = "'" + labExercisesIds[laboratory] + "', '" + row.TeacherID + "'";

                                int res = DBConnection.Create("course_teacher_rel", "course_id, teacher_id", vals);

                                //Insert course preferences
                                insertCoursePreferences(labExercisesIds[laboratory], row.TeacherID);
                                laboratory++;
                                row.LaboratoryExercises--;
                            }
                        }

                        // Get all registered rooms
                        DataTable          rooms    = DBConnection.Select("rooms", "id, name");
                        List <CourseRooms> allRooms = new List <CourseRooms>();
                        if (rooms.Rows.Count != 0)
                        {
                            foreach (DataRow room in rooms.Rows)
                            {
                                //First column is ID
                                allRooms.Add(new CourseRooms()
                                {
                                    RoomID = int.Parse(room.ItemArray[0].ToString()), RoomName = room.ItemArray[1].ToString()
                                });
                            }
                        }

                        //Get rooms and their number of groups
                        int roomRes;
                        List <CourseRooms> lectureRooms      = courseRoomRelationLecturesGrid.Items.OfType <CourseRooms>().ToList();
                        List <CourseRooms> numericExRooms    = courseRoomRelationNumExGrid.Items.OfType <CourseRooms>().ToList();
                        List <CourseRooms> laboratoryExRooms = courseRoomRelationLabExGrid.Items.OfType <CourseRooms>().ToList();

                        foreach (CourseRooms row in allRooms)
                        {
                            if (lectureRooms.Count > 0 && !lectureRooms.Where(x => x.RoomID == row.RoomID).Any())
                            {
                                foreach (int m in groupIds)
                                {
                                    roomRes = DBConnection.Create("courses_rooms_rel", "course_id, room_id", "'" + m + "', '" + row.RoomID + "'");
                                }
                            }

                            if (numericExRooms.Count > 0 && !numericExRooms.Where(x => x.RoomID == row.RoomID).Any())
                            {
                                foreach (int n in numExercisesIds)
                                {
                                    roomRes = DBConnection.Create("courses_rooms_rel", "course_id, room_id", "'" + n + "', '" + row.RoomID + "'");
                                }
                            }

                            if (laboratoryExRooms.Count > 0 && !laboratoryExRooms.Where(x => x.RoomID == row.RoomID).Any())
                            {
                                foreach (int o in labExercisesIds)
                                {
                                    roomRes = DBConnection.Create("courses_rooms_rel", "course_id, room_id", "'" + o + "', '" + row.RoomID + "'");
                                }
                            }
                        }

                        foreach (ComboDepartments row in departments)
                        {
                            departmentRes = DBConnection.Create("course_department_rel", "course_id, department_id", "'" + result + "', '" + row.DepartmentID + "'");

                            if (groupIds.Length > 0)
                            {
                                foreach (int m in groupIds)
                                {
                                    departmentRes = DBConnection.Create("course_department_rel", "course_id, department_id", "'" + m + "', '" + row.DepartmentID + "'");
                                }
                            }

                            if (numExercisesIds.Length > 0)
                            {
                                foreach (int n in numExercisesIds)
                                {
                                    departmentRes = DBConnection.Create("course_department_rel", "course_id, department_id", "'" + n + "', '" + row.DepartmentID + "'");
                                }
                            }

                            if (labExercisesIds.Length > 0)
                            {
                                foreach (int o in labExercisesIds)
                                {
                                    departmentRes = DBConnection.Create("course_department_rel", "course_id, department_id", "'" + o + "', '" + row.DepartmentID + "'");
                                }
                            }
                        }
                    }
                }
                newWindowThread.Abort();
                if (!hideMessage)
                {
                    MessageBox.Show("Successfully generated new Courses!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                }
                else
                {
                    MessageBox.Show("Courses were successfully updated!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
                }
                Close();
                if (parentGrid.IsVisible)
                {
                    parentGrid.filterCourse();
                }
            } catch (Exception e)
            {
                newWindowThread.Abort();
                MessageBox.Show(e.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
            }
        }