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