public int DeleteRoomByID(int?schoolID, int?roomID) { int returnCode; // Check if arguments are null if (schoolID != null && roomID != null) { // Look for school in DB Schools existingSchool; Rooms existingRoom; existingSchool = SchoolUtils.LookForSchool((int)schoolID); existingRoom = RoomUtils.LookForRoom((int)schoolID, (int)roomID); // If ID already existing => modifyname if (existingSchool != null && existingRoom != null) { // Delete Roomin DB ; returnCode = 1 if operation successful in method // 0 if not returnCode = RoomUtils.DeleteRoomByID((int)schoolID, (int)roomID); } else // School not existing or Room not existing, returnCode = -1 { returnCode = -1; } } else { // Arguments not valid returnCode = -1; } return(returnCode); }
public int InsertRoom(int?schoolID, string roomName) { int returnCode; // Check if arguments are null if (schoolID != null && roomName != null) { // Look for school in DB Schools existingSchool; existingSchool = SchoolUtils.LookForSchool((int)schoolID); // If School already existing if (existingSchool != null) { // Looking if room already exists Rooms newRoom; newRoom = RoomUtils.LookForRoom((int)schoolID, roomName); if (newRoom == null) { // Create a new Room in DB ; returnCode = 1 if operation successful in method // 0 if not returnCode = RoomUtils.InsertRoom((int)schoolID, roomName); } else { returnCode = 0; // Room already existing } } else // School not existing, returnCode = -1 { returnCode = -1; } } else { // Arguments not valid returnCode = -1; } return(returnCode); }