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