Beispiel #1
0
        private void Courses_Box_SelectedIndexChanged(object sender, EventArgs e)
        {
            Courses_Lable.Show();
            //Filling the ****LECTURE BOX*****
            int curItem = Convert.ToInt32(Courses_Box.SelectedItem.ToString().Substring(0, Courses_Box.SelectedItem.ToString().IndexOf('-')));

            //if course is pre condition
            check_pre_courses(curItem);


            //MessageBox.Show(curItem.ToString());
            //Uplode data
            add_course.SetCourseID(curItem);
            int CourseToRemove = curItem;

            Lectures_Box.Items.Clear();
            string course_name = "";

            for (int i = 0; i < Courses_ID_Name.Count; i++)
            {
                if (curItem == Courses_ID_Name[i].GetCourseID())
                {
                    course_name = Courses_ID_Name[i].getCourseName();
                }
            }

            //Uplode data
            add_course.setCourseName(course_name);

            string        LecID;
            string        Query       = "select * from schedualing where courseName = '" + course_name + "' and lecturer IS NOT NULL";
            SqlConnection conDatabase = new SqlConnection(Connecting_String);
            SqlCommand    cmdDatabase = new SqlCommand(Query, conDatabase);
            SqlDataReader myReader;

            try
            {
                conDatabase.Open();
                myReader = cmdDatabase.ExecuteReader();
                while (myReader.Read())
                {
                    LecID = Convert.ToString(myReader.GetInt32(7)) + "-" + Convert.ToString(myReader.GetInt32(8) + "Day." + Convert.ToString(myReader["day"].ToString()));
                    //MessageBox.Show(Convert.ToString(myReader.GetString(4)));

                    if (!overlap_hours_Lec(sd.getID(), Convert.ToInt32(myReader.GetInt32(7)), Convert.ToInt32(myReader.GetInt32(8)), Convert.ToString(myReader.GetString(4))))
                    {
                        Lectures_Box.Items.Add(LecID);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            Lectures_Box.Show();
        }
Beispiel #2
0
        public void POPUP_Messege()
        {
            // Put Out Messege that there are more courses or no more courses - need to be fixed!!!!!
            string display_placement = "";

            regiCourses.Add(add_course);
            regicourseint.Add(add_course.GetCourseID());

            for (int i = 0; i < regiCourses.Count; i++)
            {
                display_placement = Convert.ToString(regiCourses[i].GetCourseID()) + "\n  " +
                                    "Course Name: " +
                                    Convert.ToString(regiCourses[i].getCourseName()) + "\n  " +
                                    "Lecture: " +
                                    Convert.ToString(regiCourses[i].GetLecBegin()) + " - " +
                                    Convert.ToString(regiCourses[i].GetLecEnd()) + "\n  " +
                                    Convert.ToString(regiCourses[i].GetLectureDay()) + "\n  " +
                                    "Practice:" +
                                    Convert.ToString(regiCourses[i].GetPracticeBegin()) + " - " +
                                    Convert.ToString(regiCourses[i].GetPracticeEnd()) + "\n  " +
                                    Convert.ToString(regiCourses[i].GetPracticeDay()) + "\n  " +
                                    "Lab: " +
                                    Convert.ToString(regiCourses[i].GetLabBegin()) + " - " +
                                    Convert.ToString(regiCourses[i].GetLabEnd()) + "\n  " +
                                    Convert.ToString(regiCourses[i].GetLabDay()) + "\n  "
                                    + "Placement Succesfull";

                /*
                 * display_placement = Convert.ToString(regiCourses[i].GetCourseID()) + "\n" +
                 *  "Course Name: " +
                 *  Convert.ToString(regiCourses[i].getCourseName()) + "\n" +
                 *  "Lecture: " +
                 *   Convert.ToString(regiCourses[i].GetLecBegin()) + " - " +
                 *    Convert.ToString(regiCourses[i].GetLecEnd()) + "\n" +
                 *    "Practice:"+
                 *     Convert.ToString(regiCourses[i].GetPracticeBegin()) + " - " +
                 *      Convert.ToString(regiCourses[i].GetPracticeEnd()) + "\n" +
                 *      "Lab: "+
                 *       Convert.ToString(regiCourses[i].GetLabBegin()) + " - " +
                 *        Convert.ToString(regiCourses[i].GetLabEnd()) + "\n"
                 + "Placement Succesfull";
                 */
                MessageBox.Show(display_placement);
                //Regi_Courses.Items.Add(display_placement);
            }

            Lectures_Box.Hide();
            Practices_Box.Hide();
            Labs_Box.Hide();
            Courses_Box.Hide();
            Courses_Box.Items.Clear();
            start();
        }
Beispiel #3
0
        public void start()
        {
            int i;

            add_course = new Course();
            Fill_Courses_Box();
            for (i = 0; i < courses.Count; i++)
            {
                Courses_Name_ID(courses[i]);
            }

            for (i = 0; i < Courses_ID_Name.Count; i++)
            {
                display += Convert.ToString(Courses_ID_Name[i].GetCourseID()) + "  " + Courses_ID_Name[i].getCourseName() + "\n";
            }
            button1.Hide();
            Courses_Box.Show();
            Lectures_Box.Hide();
            Practices_Box.Hide();
            Labs_Box.Hide();
        }