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