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 DeleteSchoolByName(string name)
{
int returnCode;
// Checking name
if (name != null)
{
// Looking if School exists in DB
Schools deletingSchool;
deletingSchool = SchoolUtils.LookForSchool(name);
if (deletingSchool != null)
{ // If school exists => Try to delete
// Check if school has rooms
if (SchoolUtils.SchoolHadRooms(deletingSchool))
{ // Impossible to delete a school, return -1
returnCode = -1;
}
else
{ // School can be deleted safely
returnCode = SchoolUtils.DeleteSchool(name);
}
}
else
{ // If school not existing => School not deleted, returns 0
returnCode = 0;
}
}
else
{ // Arguments not valid
returnCode = -1;
}
return(returnCode);
}
public int DeleteSchoolByID(int?id)
{
int returnCode;
// Checking id
if (id != null)
{
// Looking if School exists in DB
Schools deletingSchool;
deletingSchool = SchoolUtils.LookForSchool((int)id);
if (deletingSchool != null)
{// If school exists => Try to delete
returnCode = SchoolUtils.DeleteSchool((int)id);
}
else
{// If school not existing => School not deleted, returns 0
returnCode = 0;
}
}
else
{ // Arguments not valid
returnCode = -1;
}
return(returnCode);
}
public int ModifySchool(int?id, string newName)
{
int returnCode;
// Check if arguments are null
if (id != null && newName != null)
{
// Look for school in DB
Schools renamingSchool;
renamingSchool = SchoolUtils.LookForSchool((int)id);
// If ID already existing => modifyname
if (renamingSchool != null)
{
// Create School in DB ; returnCode = 1 if operation successful in method
returnCode = SchoolUtils.ModifySchoolName((int)id, newName);
}
else // School not existing, returnCode = -1
{
returnCode = -1;
}
}
else
{ // Arguments not valid
returnCode = -1;
}
return(returnCode);
}
public int InsertSchool(string name)
{
int returnCode;
if (name != null)
{
Schools newSchool;
// Look for school in DB
newSchool = SchoolUtils.LookForSchool(name);
// If Name not existing => Create a new schol
if (newSchool == null)
{
// Create School in DB ; returnCode = 1 if operation successful in method
returnCode = SchoolUtils.InsertSchool(name);
}
else // If school already exists : return 0
{
returnCode = 0;
}
}
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);
}
