private void updateCourses(string x = null)
{
SqlConnection connection = DBConnector.GetInstance().GetConnection();
courses = CourseDataGateway.Find(connection);
string level;
DataTable classrooms;
foreach (DataRow row in courses.Rows)
{
level = row["difficulty"].ToString();
switch (level)
{
case "Z":
level = "Beginner";
break;
case "P":
level = "Intermediate";
break;
case "E":
level = "Expert";
break;
default:
level = "Begginer";
break;
}
classrooms = ClasroomDataGateway.FindByID(connection, (int)row["Classroom_classroom_id"]);
string[] r = { row["course_name"].ToString(), "rekonstrukce:", level };
listView1.Items.Add(new ListViewItem(r));
}
}
public Classrooms(int capacity)
{
InitializeComponent();
SqlConnection connection = DBConnector.GetInstance().GetConnection();
classrooms = ClasroomDataGateway.Find(connection, capacity);
//Debug.WriteLine(classrooms.capacity);
foreach (DataRow row in classrooms.Rows)
{
string[] r = { "", row["room_number"].ToString(), row["capacity"].ToString() };
listView1.Items.Add(new ListViewItem(r));
listView1.CheckBoxes = true;
}
}
