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