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