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(); }
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(); }
private void Practices_Box_SelectedIndexChanged(object sender, EventArgs e) { //FILLING ****LABS BOX**** //if there is no practices: if (Practices_Box.Items.Count == 0) { Practices_Box.Hide(); Labs_Box.Items.Clear(); int curItem = Convert.ToInt32(Courses_Box.SelectedItem.ToString()); string Query = "select * from Labs_B where CourseID = '" + curItem + "' "; SqlConnection conDatabase = new SqlConnection(Connecting_String); SqlCommand cmdDatabase = new SqlCommand(Query, conDatabase); SqlDataReader myReader; try { conDatabase.Open(); myReader = cmdDatabase.ExecuteReader(); while (myReader.Read()) { string Lab = Convert.ToString(myReader.GetInt32(2)) + " - " + Convert.ToString(myReader.GetInt32(3)); if (!overlap_hours_Lab(sd.getID(), Convert.ToInt32(myReader.GetInt32(7)), Convert.ToInt32(myReader.GetInt32(8)), Convert.ToString(myReader.GetString(4)))) { Labs_Box.Items.Add(Lab); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } Labs_Box.Show(); } else { //if there is practises //Uplode data - practice Labs_Box.Items.Clear(); string curItem_P = Practices_Box.SelectedItem.ToString(); //Uplode data - Prac add_course.SetPracticeBegin(Convert.ToInt32(curItem_P.Substring(0, curItem_P.IndexOf('-')))); string temp_End = curItem_P.Substring((curItem_P.IndexOf('-') + 1), curItem_P.IndexOf('D') - curItem_P.IndexOf('-') - 1); int temp_end = Convert.ToInt32(temp_End); add_course.SetPracticeEnd(temp_end); add_course.SetPracticeDay(curItem_P.Substring(curItem_P.IndexOf('.') + 1, curItem_P.Count() - curItem_P.IndexOf('.') - 1)); int curItem = Convert.ToInt32(Courses_Box.SelectedItem.ToString().Substring(0, Courses_Box.SelectedItem.ToString().IndexOf('-'))); string Query = "select * from Labs_B where CourseID = '" + curItem + "' "; SqlConnection conDatabase = new SqlConnection(Connecting_String); SqlCommand cmdDatabase = new SqlCommand(Query, conDatabase); SqlDataReader myReader; try { conDatabase.Open(); myReader = cmdDatabase.ExecuteReader(); while (myReader.Read()) { string Lab = Convert.ToString(myReader.GetInt32(2)) + "-" + Convert.ToString(myReader.GetInt32(3) + "Day." + Convert.ToString(myReader["day"].ToString())); Labs_Box.Items.Add(Lab); } } catch (Exception ex) { MessageBox.Show(ex.Message); } if (Labs_Box.Items.Count == 0) { Labs_Box.Hide(); MessageBox.Show("No Labs Available"); POPUP_Messege(); } else { Labs_Box.Show(); } } }
//EXIT BOTTUN - SORRY FORGOT TO CHANGE NAME private void Lectures_Box_SelectedIndexChanged(object sender, EventArgs e) { //Filling the ****PRACTICE BOX***** Practices_Box.Items.Clear(); string curItem_L = Lectures_Box.SelectedItem.ToString(); //MessageBox.Show(Convert.ToString(curItem_L.Substring(0, curItem_L.IndexOf('-')))); //MessageBox.Show(Convert.ToString(curItem_L.Substring((curItem_L.IndexOf('-') + 1), curItem_L.IndexOf('D') - curItem_L.IndexOf('-') - 1))); //MessageBox.Show(Convert.ToString(Convert.ToString(curItem_L.Substring(curItem_L.IndexOf('.') + 1, curItem_L.Count() - curItem_L.IndexOf('.') - 1)))); //Uplode data - Lec string temp_End = curItem_L.Substring((curItem_L.IndexOf('-') + 1), curItem_L.IndexOf('D') - curItem_L.IndexOf('-') - 1); int temp_end = Convert.ToInt32(temp_End); add_course.SetLecBegin(Convert.ToInt32(curItem_L.Substring(0, curItem_L.IndexOf('-')))); add_course.SetLecEnd(temp_end); add_course.SetLectureDay(Convert.ToString(curItem_L.Substring(curItem_L.IndexOf('.') + 1, curItem_L.Count() - curItem_L.IndexOf('.') - 1))); //MessageBox.Show(add_course.GetLecBegin().ToString()+"\n\n" + add_course.GetLecEnd() + "\n\n" + add_course.GetLectureDay()); //CurItem is for uploading data int curItem = Convert.ToInt32(Courses_Box.SelectedItem.ToString().Substring(0, Courses_Box.SelectedItem.ToString().IndexOf('-'))); 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(); } } string Query = "select * from schedualing where courseName = '" + course_name + "' and teachingAssitant 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()) { string PracID = Convert.ToString(myReader.GetInt32(7)) + "-" + Convert.ToString(myReader.GetInt32(8) + "Day." + Convert.ToString(myReader["day"].ToString())); if (!overlap_hours_Pra(sd.getID(), Convert.ToInt32(myReader.GetInt32(7)), Convert.ToInt32(myReader.GetInt32(8)), Convert.ToString(myReader.GetString(4)))) { Practices_Box.Items.Add(PracID); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } if (Practices_Box.Items.Count == 0) { MessageBox.Show("No Practices Available"); Labs_Box.Show(); } else { Practices_Box.Show(); } }