public static void writeDB(List <Room> rooms)
{
clearDB();
foreach (Room room in rooms)
{
RoomDBService.queryAdd(room);
}
}
public static DataSet getStudentsFromRoom(Room room)
{
string query;
int roomIndex;
roomIndex = RoomDBService.getRoomId(room);
query = string.Format("SELECT * FROM Student WHERE roomId = {0}", roomIndex);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, ConnectionString);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
return(ds);
}
public void parseRooms()
{
rooms.Clear();
DataSet input = RoomDBService.getRooms();
foreach (DataRow row in input.Tables[0].Rows)
{
Room room = RoomParser.parseRoom(row[1].ToString(), row[2].ToString(), row[3].ToString());
List <Student> students = new List <Student>();
DataSet data = StudentDBService.getStudentsFromRoom(room);
students = StudentService.parseStudents(data);
room.Students = students;
rooms.Add(room);
}
}
public static void clearDB()
{
RoomDBService.queryClear();
StudentDBService.queryClear();
}
