private List <KamerIndeling> ReadTables(DataTable dataTable) { List <KamerIndeling> kamerindelings = new List <KamerIndeling>(); foreach (DataRow dr in dataTable.Rows) { KamerIndeling Kamerindelings = new KamerIndeling() { RoomNumber = (int)dr["RoomId"], FirstName = (String)dr["First_Name"], LastName = (String)dr["Last_Name"], Capacity = (int)dr["Capacity"] }; kamerindelings.Add(Kamerindelings); } return(kamerindelings); }
public List <KamerIndeling> GetKamerIndelings() { try { List <KamerIndeling> kamerindeling = kamerIndeling_db.Db_Get_All_KamerIndelings_Students(); List <KamerIndeling> kamerindeling2 = kamerIndeling_db.Db_Get_All_KamerIndelings_Lecturers(); List <KamerIndeling> kamerindeling3 = new List <KamerIndeling>(); foreach (KamerIndeling k in kamerindeling) { kamerindeling3.Add(k); } foreach (KamerIndeling k in kamerindeling2) { kamerindeling3.Add(k); } return(kamerindeling3); } catch (Exception) { // something went wrong connecting to the database, so we will add a fake student to the list to make sure the rest of the application continues working! List <KamerIndeling> kamerindeling = new List <KamerIndeling>(); KamerIndeling a = new KamerIndeling(); a.FirstName = "Mr. Test Lecturer"; a.LastName = "Mr. Test KamerIndeling"; a.RoomNumber = 63; kamerindeling.Add(a); KamerIndeling b = new KamerIndeling(); b.FirstName = "Ms. Test Lecturer"; b.LastName = "Ms. Test KamerIndeling"; b.RoomNumber = 64; kamerindeling.Add(b); return(kamerindeling); //throw new Exception("Someren couldn't connect to the database"); } }