Examples with CourseTypeDAO fi.otavanopisto.pyramus.dao.courses.CourseTypeDAO used on opensource projects

Example 1 with CourseTypeDAO

use of fi.otavanopisto.pyramus.dao.courses.CourseTypeDAO in project pyramus by otavanopisto.

the class CourseTypesSetupWizardViewController method save.

@Override
public void save(PageRequestContext requestContext) throws SetupWizardException {
    CourseTypeDAO courseTypeDAO = DAOFactory.getInstance().getCourseTypeDAO();
    int rowCount = requestContext.getInteger("courseTypesTable.rowCount");
    for (int i = 0; i < rowCount; i++) {
        String colPrefix = "courseTypesTable." + i;
        String name = requestContext.getString(colPrefix + ".name");
        courseTypeDAO.create(name, Boolean.FALSE);
    }
}

Example 2 with CourseTypeDAO

use of fi.otavanopisto.pyramus.dao.courses.CourseTypeDAO in project pyramus by otavanopisto.

the class ArchiveCourseTypeJSONRequestController method process.

/**
 * Processes the request to archive.
 *
 * @param jsonRequestContext The JSON request context
 */
public void process(JSONRequestContext jsonRequestContext) {
    CourseTypeDAO courseTypeDAO = DAOFactory.getInstance().getCourseTypeDAO();
    Long courseTypeId = jsonRequestContext.getLong("courseTypeId");
    courseTypeDAO.archive(courseTypeDAO.findById(courseTypeId));
}

Example 3 with CourseTypeDAO

use of fi.otavanopisto.pyramus.dao.courses.CourseTypeDAO in project pyramus by otavanopisto.

the class CourseAPI method create.

public Long create(Long organizationId, Long moduleId, Long typeId, String name, String nameExtension, String description, String subjectCode) throws InvalidScriptException {
    ModuleDAO moduleDAO = DAOFactory.getInstance().getModuleDAO();
    CourseDAO courseDAO = DAOFactory.getInstance().getCourseDAO();
    SubjectDAO subjectDAO = DAOFactory.getInstance().getSubjectDAO();
    StaffMemberDAO userDAO = DAOFactory.getInstance().getStaffMemberDAO();
    DefaultsDAO defaultsDAO = DAOFactory.getInstance().getDefaultsDAO();
    CourseTypeDAO courseTypeDAO = DAOFactory.getInstance().getCourseTypeDAO();
    OrganizationDAO organizationDAO = DAOFactory.getInstance().getOrganizationDAO();
    Module module = moduleDAO.findById(moduleId);
    if (module == null) {
        throw new InvalidScriptException("Module #" + moduleId + " not found.");
    }
    User loggedUser = userDAO.findById(loggedUserId);
    if (loggedUser == null) {
        throw new InvalidScriptException("Logged user not found.");
    }
    Subject subject = subjectDAO.findByCode(subjectCode);
    if (subject == null) {
        throw new InvalidScriptException("Subject by code '" + subjectCode + "' not found.");
    }
    Organization organization = organizationDAO.findById(organizationId);
    if (organization == null) {
        throw new InvalidScriptException("Default organization not found.");
    }
    CourseType type = typeId != null ? courseTypeDAO.findById(typeId) : null;
    // TODO: Add support for these:
    CourseState courseState = defaultsDAO.getDefaults().getInitialCourseState();
    Date beginDate = null;
    Date endDate = null;
    Double distanceTeachingDays = null;
    Double localTeachingDays = null;
    Double teachingHours = null;
    Double distanceTeachingHours = null;
    Double planningHours = null;
    Double assessingHours = null;
    Date enrolmentTimeEnd = null;
    BigDecimal courseFee = null;
    Currency courseFeeCurrency = null;
    return courseDAO.create(module, organization, name, nameExtension, courseState, type, subject, module.getCourseNumber(), beginDate, endDate, module.getCourseLength().getUnits(), module.getCourseLength().getUnit(), distanceTeachingDays, localTeachingDays, teachingHours, distanceTeachingHours, planningHours, assessingHours, description, module.getMaxParticipantCount(), courseFee, courseFeeCurrency, enrolmentTimeEnd, loggedUser).getId();
}

Example 4 with CourseTypeDAO

use of fi.otavanopisto.pyramus.dao.courses.CourseTypeDAO in project pyramus by otavanopisto.

the class CourseTypeAPI method listIdsByName.

public Long[] listIdsByName(String name) {
    CourseTypeDAO courseTypeDAO = DAOFactory.getInstance().getCourseTypeDAO();
    List<Long> result = new ArrayList<>();
    List<CourseType> courseTypes = courseTypeDAO.listByName(name);
    for (CourseType courseType : courseTypes) {
        result.add(courseType.getId());
    }
    return result.toArray(new Long[0]);
}

Example 5 with CourseTypeDAO

use of fi.otavanopisto.pyramus.dao.courses.CourseTypeDAO in project pyramus by otavanopisto.

the class EditCourseJSONRequestController method process.

/**
 * Processes the request to edit a course.
 * The request should contain the following parameters:
 * <dl>
 *   <dt><code>name</code></dt>
 *   <dd>The name of the course.</dd>
 *   <dt><code>nameExtension</code></dt>
 *   <dd>The name extension of the course.</dd>
 *   <dt><code>state</code></dt>
 *   <dd>The ID of the initial course state.</dd>
 *   <dt><code>description</code></dt>
 *   <dd>The description of the course, in HTML.</dd>
 *   <dt><code>module</code></dt>
 *   <dd>The ID of the module the course is associated with.</dd>
 *   <dt><code>subject</code></dt>
 *   <dd>The ID of the subject of the course.</dd>
 *   <dt><code>courseNumber</code></dt>
 *   <dd>The course number of the course.</dd>
 *   <dt><code>beginDate</code></dt>
 *   <dd>The beginning date of the course, as a timestamp in ms.</dd>
 *   <dt><code>endDate</code></dt>
 *   <dd>The end date of the course, as a timestamp in ms.</dd>
 *   <dt><code>enrolmentTimeEnd</code></dt>
 *   <dd>The time when enrollment for the course ends, as a timestamp in ms.</dd>
 *   <dt><code>courseLength</code></dt>
 *   <dd>The length of the course, in units specified in <code>courseLengthTimeUnit</code>.</dd>
 *   <dt><code>courseLengthTimeUnit</code></dt>
 *   <dd>The ID of the time unit for the courses.</dd>
 *   <dt><code>maxParticipantCount</code></dt>
 *   <dd>The maximum number of participants for this course.</dd>
 *   <dt><code>distanceTeachingDays</code></dt>
 *   <dd>The number of days of distance teaching.</dd>
 *   <dt><code>localTeachingDays</code></dt>
 *   <dd>The number of days of local teaching.</dd>
 *   <dt><code>teachingHours</code></dt>
 *   <dd>The total number of teaching hours.</dd>
 *   <dt><code>planningHours</code></dt>
 *   <dd>The total number of hours used for planning.
 *   <dt><code>assessingHours</code></dt>
 *   <dd>The total number of hours used for assessing.
 *   <dt><code>tags</code></dt>
 *   <dd>The tags associated with the course, separated by spaces.</dd>
 * </dl>
 * The following are not single but multiple parameters, arranged
 * as collections of objects. Each parameter is defined by the
 * following scheme (zero indexed):<br/>
 * <code>
 * <i>collection name</i>.<i>property name</i>
 * </code>
 * or<br/>
 * <code>
 * <i>collection name</i>.<i>object index</i>.<i>property name</i>
 * </code>
 * <dl>
 *   <dt><code>courseDescription.*.catId</code></dt>
 *   <dd>The course description category ID to add the description to.
 *   <dt><code>courseDescription.*.text</code></dt>
 *   <dd>The description of the course.</dd>
 *   <dt><code>personnelTable.rowCount</code></dt>
 *   <dd>The number of personnel in the course.</dd>
 *   <dt><code>personnelTable.*.userId</code></dt>
 *   <dd>The ID of the user in the personnel table.</dd>
 *   <dt><code>personnelTable.*.roleId</code></dt>
 *   <dd>The role ID of the user in the personnel table.</dd>
 *   <dt><code>components.componentCount</code></dt>
 *   <dd>The number of course components in this course.</dd>
 *   <dt><code>components.*.0.name</code></dt>
 *   <dd>The name of the course component.</dd>
 *   <dt><code>components.*.0.length</code></dt>
 *   <dd>The length of the course component, in default time units.</dd>
 *   <dt><code>components.*.0.description</code></dt>
 *   <dd>The description of the course component.</dd>
 *   <dt><code>components.*.resourceCategoryCount</code></dt>
 *   <dd>The number of resource categories in the course component.</dd>
 *   <dt><code>components.*.*.resources.rowCount</code></dt>
 *   <dd>The number of resources in the resource category.</dd>
 *   <dt><code>components.*.*.resources.*.resourceId</code></dt>
 *   <dd>The ID of the resource.</dd>
 *   <dt><code>components.*.*.resources.*.quantity</code></dt>
 *   <dd>The quantity of the resource.</dd>
 *   <dt><code>components.*.*.resources.*.usage</code></dt>
 *   <dd>The usage of the resource.</dd>
 *   <dt><code>educationType.*.*</code></dt>
 *   <dd>The education types and subtypes (as numerical IDs) of the course.</dd>
 *   <dt><code>basicResourcesTable.rowCount</code></dt>
 *   <dd>The number of basic resources associated with the course.</dd>
 *   <dt><code>basicResourcesTable.*.hours</code></dt>
 *   <dd>The number of hours the resource is used.</dd>
 *   <dt><code>basicResourcesTable.*.hourlyCost</code></dt>
 *   <dd>The hourly cost of the resource.</dd>
 *   <dt><code>basicResourcesTable.*.units</code></dt>
 *   <dd>The number of units of the resource used.</dd>
 *   <dt><code>basicResourcesTable.*.unitCost</code></dt>
 *   <dd>The cost of a single unit of the resource.</dd>
 *   <dt><code>basicResourcesTable.*.resourceId</code></dt>
 *   <dd>The ID of the resource.</dd>
 *   <dt><code>studentResourcesTable.rowCount</code></dt>
 *   <dd>The number of student resources associated with the course.</dd>
 *   <dt><code>studentResourcesTable.*.hours</code></dt>
 *   <dd>The number of hours the resource is used.</dd>
 *   <dt><code>studentResourcesTable.*.hourlyCost</code></dt>
 *   <dd>The hourly cost of the resource.</dd>
 *   <dt><code>studentResourcesTable.*.unitCost</code></dt>
 *   <dd>The cost of a single unit of the resource.</dd>
 *   <dt><code>studentResourcesTable.*.resourceId</code></dt>
 *   <dd>The ID of the resource.</dd>
 *   <dt><code>gradeResourcesTable.rowCount</code></dt>
 *   <dd>The number of grade resources associated with the course.</dd>
 *   <dt><code>gradeResourcesTable.*.hours</code></dt>
 *   <dd>The number of hours the resource is used.</dd>
 *   <dt><code>gradeResourcesTable.*.hourlyCost</code></dt>
 *   <dd>The hourly cost of the resource.</dd>
 *   <dt><code>gradeResourcesTable.*.unitCost</code></dt>
 *   <dd>The cost of a single unit of the resource.</dd>
 *   <dt><code>gradeResourcesTable.*.resourceId</code></dt>
 *   <dd>The ID of the resource.</dd>
 *   <dt><code>otherCostsTable.rowCount</code></dt>
 *   <dd>The number of other costs associated with this course.</dd>
 *   <dt><code>otherCostsTable.*.name</code></dt>
 *   <dd>The name of the cost.</dd>
 *   <dt><code>otherCostsTable.*.count</code></dt>
 *   <dd>The amount of the cost.</dd>
 *   <dt><code>studentsTable.rowCount</code></dt>
 *   <dd>The number of students attending this course.</dd>
 *   <dt><code>studentsTable.*.studentId</code></dt>
 *   <dd>The ID of the student.</dd>
 *   <dt><code>studentsTable.*.enrolmentDate</code></dt>
 *   <dd>The enrollment date of the student, as a timestamp in ms.</dd>
 *   <dt><code>studentsTable.*.enrolmentType</code></dt>
 *   <dd>The ID of the enrollment type of the student.</dd>
 *   <dt><code>studentsTable.*.participationType</code></dt>
 *   <dd>The ID of the participation type of the student.</dd>
 *   <dt><code>studentsTable.*.lodging</code></dt>
 *   <dd><code>true</code> if the student is lodging on campus.</dd>
 *   <dt><code>studentsTable.*.optionality</code></dt>
 *   <dd>The optionality of the course for the student:
 *   <code>MANDATORY</code> or <code>OPTIONAL</code></dd>
 * </dl>
 *
 * @param requestContext The JSON request context
 */
public void process(JSONRequestContext requestContext) {
    StaffMemberDAO userDAO = DAOFactory.getInstance().getStaffMemberDAO();
    StudentDAO studentDAO = DAOFactory.getInstance().getStudentDAO();
    CourseDAO courseDAO = DAOFactory.getInstance().getCourseDAO();
    ResourceDAO resourceDAO = DAOFactory.getInstance().getResourceDAO();
    CourseDescriptionDAO courseDescriptionDAO = DAOFactory.getInstance().getCourseDescriptionDAO();
    CourseStudentDAO courseStudentDAO = DAOFactory.getInstance().getCourseStudentDAO();
    CourseStateDAO courseStateDAO = DAOFactory.getInstance().getCourseStateDAO();
    CourseParticipationTypeDAO participationTypeDAO = DAOFactory.getInstance().getCourseParticipationTypeDAO();
    CourseComponentResourceDAO componentResourceDAO = DAOFactory.getInstance().getCourseComponentResourceDAO();
    CourseEnrolmentTypeDAO enrolmentTypeDAO = DAOFactory.getInstance().getCourseEnrolmentTypeDAO();
    CourseComponentDAO componentDAO = DAOFactory.getInstance().getCourseComponentDAO();
    CourseStaffMemberDAO courseStaffMemberDAO = DAOFactory.getInstance().getCourseStaffMemberDAO();
    CourseStaffMemberRoleDAO courseStaffMemberRoleDAO = DAOFactory.getInstance().getCourseStaffMemberRoleDAO();
    CourseDescriptionDAO descriptionDAO = DAOFactory.getInstance().getCourseDescriptionDAO();
    CourseDescriptionCategoryDAO descriptionCategoryDAO = DAOFactory.getInstance().getCourseDescriptionCategoryDAO();
    OtherCostDAO otherCostDAO = DAOFactory.getInstance().getOtherCostDAO();
    BasicCourseResourceDAO basicCourseResourceDAO = DAOFactory.getInstance().getBasicCourseResourceDAO();
    StudentCourseResourceDAO studentCourseResourceDAO = DAOFactory.getInstance().getStudentCourseResourceDAO();
    GradeCourseResourceDAO gradeCourseResourceDAO = DAOFactory.getInstance().getGradeCourseResourceDAO();
    CourseEducationTypeDAO courseEducationTypeDAO = DAOFactory.getInstance().getCourseEducationTypeDAO();
    CourseEducationSubtypeDAO courseEducationSubtypeDAO = DAOFactory.getInstance().getCourseEducationSubtypeDAO();
    EducationalTimeUnitDAO educationalTimeUnitDAO = DAOFactory.getInstance().getEducationalTimeUnitDAO();
    EducationTypeDAO educationTypeDAO = DAOFactory.getInstance().getEducationTypeDAO();
    EducationSubtypeDAO educationSubtypeDAO = DAOFactory.getInstance().getEducationSubtypeDAO();
    SubjectDAO subjectDAO = DAOFactory.getInstance().getSubjectDAO();
    TagDAO tagDAO = DAOFactory.getInstance().getTagDAO();
    DefaultsDAO defaultsDAO = DAOFactory.getInstance().getDefaultsDAO();
    CourseTypeDAO courseTypeDAO = DAOFactory.getInstance().getCourseTypeDAO();
    CurriculumDAO curriculumDAO = DAOFactory.getInstance().getCurriculumDAO();
    ModuleDAO moduleDAO = DAOFactory.getInstance().getModuleDAO();
    OrganizationDAO organizationDAO = DAOFactory.getInstance().getOrganizationDAO();
    StaffMemberDAO staffMemberDAO = DAOFactory.getInstance().getStaffMemberDAO();
    Locale locale = requestContext.getRequest().getLocale();
    StaffMember loggedUser = staffMemberDAO.findById(requestContext.getLoggedUserId());
    Organization organization = organizationDAO.findById(requestContext.getLong("organizationId"));
    if (!UserUtils.canAccessOrganization(loggedUser, organization)) {
        throw new SmvcRuntimeException(PyramusStatusCode.UNAUTHORIZED, "Invalid organization.");
    }
    // Course basic information
    Long courseId = requestContext.getLong("course");
    Course course = courseDAO.findById(courseId);
    String name = requestContext.getString("name");
    String nameExtension = requestContext.getString("nameExtension");
    Long courseStateId = requestContext.getLong("state");
    Long courseTypeId = requestContext.getLong("type");
    Long maxParticipantCount = requestContext.getLong("maxParticipantCount");
    Date enrolmentTimeEnd = requestContext.getDate("enrolmentTimeEnd");
    CourseState courseState = courseStateId == null ? course.getState() : courseStateDAO.findById(courseStateId);
    CourseType courseType = courseTypeId != null ? courseTypeDAO.findById(courseTypeId) : null;
    String description = requestContext.getString("description");
    Subject subject = subjectDAO.findById(requestContext.getLong("subject"));
    Integer courseNumber = requestContext.getInteger("courseNumber");
    Date beginDate = requestContext.getDate("beginDate");
    Date endDate = requestContext.getDate("endDate");
    Double courseLength = requestContext.getDouble("courseLength");
    EducationalTimeUnit courseLengthTimeUnit = educationalTimeUnitDAO.findById(requestContext.getLong("courseLengthTimeUnit"));
    Double distanceTeachingDays = requestContext.getDouble("distanceTeachingDays");
    Double localTeachingDays = requestContext.getDouble("localTeachingDays");
    Double teachingHours = requestContext.getDouble("teachingHours");
    Double distanceTeachingHours = requestContext.getDouble("distanceTeachingHours");
    Double planningHours = requestContext.getDouble("planningHours");
    Double assessingHours = requestContext.getDouble("assessingHours");
    String tagsText = requestContext.getString("tags");
    BigDecimal courseFee = requestContext.getBigDecimal("courseFee");
    Currency courseFeeCurrency = requestContext.getCurrency("courseFeeCurrency");
    Long version = requestContext.getLong("version");
    if (!course.getVersion().equals(version))
        throw new StaleObjectStateException(Course.class.getName(), course.getId());
    List<Curriculum> allCurriculums = curriculumDAO.listUnarchived();
    Set<Curriculum> curriculums = new HashSet<>();
    for (Curriculum curriculum : allCurriculums) {
        if ("1".equals(requestContext.getString("curriculum." + curriculum.getId()))) {
            curriculums.add(curriculum);
        }
    }
    Set<Tag> tagEntities = new HashSet<>();
    if (!StringUtils.isBlank(tagsText)) {
        List<String> tags = Arrays.asList(tagsText.split("[\\ ,]"));
        for (String tag : tags) {
            if (!StringUtils.isBlank(tag)) {
                Tag tagEntity = tagDAO.findByText(tag.trim());
                if (tagEntity == null)
                    tagEntity = tagDAO.create(tag);
                tagEntities.add(tagEntity);
            }
        }
    }
    StaffMember staffMember = userDAO.findById(requestContext.getLoggedUserId());
    courseDAO.update(course, organization, name, nameExtension, courseState, courseType, subject, courseNumber, beginDate, endDate, courseLength, courseLengthTimeUnit, distanceTeachingDays, localTeachingDays, teachingHours, distanceTeachingHours, planningHours, assessingHours, description, maxParticipantCount, enrolmentTimeEnd, staffMember);
    courseDAO.updateCurriculums(course, curriculums);
    if (Role.ADMINISTRATOR.equals(loggedUser.getRole())) {
        Boolean isCourseTemplate = requestContext.getBoolean("isCourseTemplate");
        courseDAO.updateCourseTemplate(course, Boolean.TRUE.equals(isCourseTemplate));
    }
    Long moduleId = requestContext.getLong("moduleId");
    Long currentModuleId = course.getModule() != null ? course.getModule().getId() : null;
    if ((moduleId != null) && (!moduleId.equals(currentModuleId))) {
        Module module = moduleDAO.findById(moduleId);
        courseDAO.updateModule(course, module);
    }
    courseDAO.updateCourseFee(course, courseFee, courseFeeCurrency, staffMember);
    // Tags
    courseDAO.setCourseTags(course, tagEntities);
    // Education types and subtypes submitted from the web page
    Map<Long, Vector<Long>> chosenEducationTypes = new HashMap<>();
    Enumeration<String> parameterNames = requestContext.getRequest().getParameterNames();
    while (parameterNames.hasMoreElements()) {
        name = (String) parameterNames.nextElement();
        if (name.startsWith("educationType.")) {
            String[] nameElements = name.split("\\.");
            Long educationTypeId = new Long(nameElements[1]);
            Long educationSubtypeId = new Long(nameElements[2]);
            Vector<Long> v = chosenEducationTypes.containsKey(educationTypeId) ? chosenEducationTypes.get(educationTypeId) : new Vector<Long>();
            v.add(educationSubtypeId);
            if (!chosenEducationTypes.containsKey(educationTypeId)) {
                chosenEducationTypes.put(educationTypeId, v);
            }
        }
    }
    // Remove education types and subtypes
    List<CourseEducationType> courseEducationTypes = course.getCourseEducationTypes();
    for (int i = courseEducationTypes.size() - 1; i >= 0; i--) {
        CourseEducationType courseEducationType = courseEducationTypes.get(i);
        if (!chosenEducationTypes.containsKey(courseEducationType.getEducationType().getId())) {
            courseEducationTypeDAO.delete(courseEducationType);
        } else {
            Vector<Long> v = chosenEducationTypes.get(courseEducationType.getEducationType().getId());
            List<CourseEducationSubtype> courseEducationSubtypes = courseEducationType.getCourseEducationSubtypes();
            for (int j = courseEducationSubtypes.size() - 1; j >= 0; j--) {
                CourseEducationSubtype courseEducationSubtype = courseEducationSubtypes.get(j);
                if (!v.contains(courseEducationSubtype.getEducationSubtype().getId())) {
                    courseEducationType.removeSubtype(courseEducationSubtype);
                }
            }
        }
    }
    for (Map.Entry<Long, Vector<Long>> entry : chosenEducationTypes.entrySet()) {
        EducationType educationType = educationTypeDAO.findById(entry.getKey());
        CourseEducationType courseEducationType;
        if (!course.contains(educationType)) {
            courseEducationType = courseEducationTypeDAO.create(course, educationType);
        } else {
            courseEducationType = course.getCourseEducationTypeByEducationTypeId(entry.getKey());
        }
        for (Long educationSubtypeId : entry.getValue()) {
            EducationSubtype educationSubtype = educationSubtypeDAO.findById(educationSubtypeId);
            if (!courseEducationType.contains(educationSubtype)) {
                courseEducationSubtypeDAO.create(courseEducationType, educationSubtype);
            }
        }
    }
    // Course Descriptions
    List<CourseDescriptionCategory> descriptionCategories = descriptionCategoryDAO.listUnarchived();
    Set<CourseDescription> nonExistingDescriptions = new HashSet<>();
    for (CourseDescriptionCategory cat : descriptionCategories) {
        String varName = "courseDescription." + cat.getId().toString();
        Long descriptionCatId = requestContext.getLong(varName + ".catId");
        String descriptionText = requestContext.getString(varName + ".text");
        CourseDescription oldDesc = descriptionDAO.findByCourseAndCategory(course, cat);
        if (descriptionCatId != null && descriptionCatId.intValue() != -1) {
            // Description has been submitted from form
            if (oldDesc != null)
                descriptionDAO.update(oldDesc, course, cat, descriptionText);
            else
                descriptionDAO.create(course, cat, descriptionText);
        } else {
            // Description wasn't submitted from form, if it exists, it's marked for deletion
            if (oldDesc != null)
                nonExistingDescriptions.add(oldDesc);
        }
    }
    // Delete non existing descriptions
    for (CourseDescription desc : nonExistingDescriptions) {
        courseDescriptionDAO.delete(desc);
    }
    // Personnel
    Set<Long> existingIds = new HashSet<>();
    int rowCount = requestContext.getInteger("personnelTable.rowCount").intValue();
    for (int i = 0; i < rowCount; i++) {
        String colPrefix = "personnelTable." + i;
        Long courseUserId = requestContext.getLong(colPrefix + ".courseUserId");
        Long userId = requestContext.getLong(colPrefix + ".userId");
        Long roleId = requestContext.getLong(colPrefix + ".roleId");
        staffMember = userDAO.findById(userId);
        CourseStaffMemberRole role = courseStaffMemberRoleDAO.findById(roleId);
        if (courseUserId == -1) {
            courseUserId = courseStaffMemberDAO.create(course, staffMember, role).getId();
        } else {
            courseStaffMemberDAO.updateRole(courseStaffMemberDAO.findById(courseUserId), role);
        }
        existingIds.add(courseUserId);
    }
    List<CourseStaffMember> courseUsers = courseStaffMemberDAO.listByCourse(courseDAO.findById(courseId));
    for (CourseStaffMember courseUser : courseUsers) {
        if (!existingIds.contains(courseUser.getId())) {
            courseStaffMemberDAO.delete(courseUser);
        }
    }
    // Course components
    rowCount = requestContext.getInteger("components.componentCount").intValue();
    for (int i = 0; i < rowCount; i++) {
        String colPrefix = "components.component." + i;
        Long componentId = requestContext.getLong(colPrefix + ".0.componentId");
        String componentName = requestContext.getString(colPrefix + ".0.name");
        Double componentLength = requestContext.getDouble(colPrefix + ".0.length");
        String componentDescription = requestContext.getString(colPrefix + ".0.description");
        // TODO Component length; should be just hours but it currently depends on the default time unit - ok?
        EducationalTimeUnit componentTimeUnit = defaultsDAO.getDefaults().getBaseTimeUnit();
        CourseComponent courseComponent;
        if (componentId == -1) {
            courseComponent = componentDAO.create(course, componentLength, componentTimeUnit, componentName, componentDescription);
        } else {
            courseComponent = componentDAO.update(componentDAO.findById(componentId), componentLength, componentTimeUnit, componentName, componentDescription);
        }
        Long resourceCategoryCount = requestContext.getLong(colPrefix + ".resourceCategoryCount");
        for (int categoryIndex = 0; categoryIndex < resourceCategoryCount; categoryIndex++) {
            String resourcesPrefix = colPrefix + "." + categoryIndex + ".resources";
            Long resourcesCount = requestContext.getLong(resourcesPrefix + ".rowCount");
            for (int j = 0; j < resourcesCount; j++) {
                String resourcePrefix = resourcesPrefix + "." + j;
                Long id = requestContext.getLong(resourcePrefix + ".id");
                Long resourceId = requestContext.getLong(resourcePrefix + ".resourceId");
                Resource resource = resourceDAO.findById(resourceId);
                Double usagePercent;
                if (resource.getResourceType() == ResourceType.MATERIAL_RESOURCE) {
                    usagePercent = requestContext.getDouble(resourcePrefix + ".quantity") * 100;
                } else {
                    usagePercent = requestContext.getDouble(resourcePrefix + ".usage");
                }
                if (id == -1) {
                    componentResourceDAO.create(courseComponent, resource, usagePercent);
                } else {
                    CourseComponentResource courseComponentResource = componentResourceDAO.findById(id);
                    componentResourceDAO.updateUsagePercent(courseComponentResource, usagePercent);
                }
            }
        }
    }
    // Basic course resources
    existingIds = new HashSet<>();
    rowCount = requestContext.getInteger("basicResourcesTable.rowCount").intValue();
    for (int i = 0; i < rowCount; i++) {
        String colPrefix = "basicResourcesTable." + i;
        Double hours = requestContext.getDouble(colPrefix + ".hours");
        if (hours == null) {
            hours = 0.0;
        }
        MonetaryAmount hourlyCost = new MonetaryAmount();
        hourlyCost.setAmount(requestContext.getDouble(colPrefix + ".hourlyCost"));
        Integer units = requestContext.getInteger(colPrefix + ".units");
        MonetaryAmount unitCost = new MonetaryAmount();
        unitCost.setAmount(requestContext.getDouble(colPrefix + ".unitCost"));
        Long resourceId = requestContext.getLong(colPrefix + ".resourceId");
        Resource resource = resourceDAO.findById(resourceId);
        Long basicResourceId = requestContext.getLong(colPrefix + ".basicResourceId");
        if (basicResourceId == -1) {
            basicResourceId = basicCourseResourceDAO.create(course, resource, hours, hourlyCost, units, unitCost).getId();
        } else {
            basicCourseResourceDAO.update(basicCourseResourceDAO.findById(basicResourceId), hours, hourlyCost, units, unitCost);
        }
        existingIds.add(basicResourceId);
    }
    List<BasicCourseResource> basicCourseResources = basicCourseResourceDAO.listByCourse(course);
    for (BasicCourseResource basicCourseResource : basicCourseResources) {
        if (!existingIds.contains(basicCourseResource.getId())) {
            basicCourseResourceDAO.delete(basicCourseResource);
        }
    }
    // Student course resources
    existingIds = new HashSet<>();
    rowCount = requestContext.getInteger("studentResourcesTable.rowCount").intValue();
    for (int i = 0; i < rowCount; i++) {
        String colPrefix = "studentResourcesTable." + i;
        Double hours = requestContext.getDouble(colPrefix + ".hours");
        if (hours == null) {
            hours = 0.0;
        }
        MonetaryAmount hourlyCost = new MonetaryAmount();
        hourlyCost.setAmount(requestContext.getDouble(colPrefix + ".hourlyCost"));
        MonetaryAmount unitCost = new MonetaryAmount();
        hourlyCost.setAmount(requestContext.getDouble(colPrefix + ".unitCost"));
        Long resourceId = requestContext.getLong(colPrefix + ".resourceId");
        Resource resource = resourceDAO.findById(resourceId);
        Long studentResourceId = requestContext.getLong(colPrefix + ".studentResourceId");
        if (studentResourceId == -1) {
            studentResourceId = studentCourseResourceDAO.create(course, resource, hours, hourlyCost, unitCost).getId();
        } else {
            studentCourseResourceDAO.update(studentCourseResourceDAO.findById(studentResourceId), hours, hourlyCost, unitCost);
        }
        existingIds.add(studentResourceId);
    }
    List<StudentCourseResource> studentCourseResources = studentCourseResourceDAO.listByCourse(course);
    for (StudentCourseResource studentCourseResource : studentCourseResources) {
        if (!existingIds.contains(studentCourseResource.getId())) {
            studentCourseResourceDAO.delete(studentCourseResource);
        }
    }
    // Grade course resources
    existingIds = new HashSet<>();
    rowCount = requestContext.getInteger("gradeResourcesTable.rowCount").intValue();
    for (int i = 0; i < rowCount; i++) {
        String colPrefix = "gradeResourcesTable." + i;
        Double hours = requestContext.getDouble(colPrefix + ".hours");
        if (hours == null) {
            hours = 0.0;
        }
        MonetaryAmount hourlyCost = new MonetaryAmount();
        hourlyCost.setAmount(requestContext.getDouble(colPrefix + ".hourlyCost"));
        MonetaryAmount unitCost = new MonetaryAmount();
        unitCost.setAmount(requestContext.getDouble(colPrefix + ".unitCost"));
        Long resourceId = requestContext.getLong(colPrefix + ".resourceId");
        Resource resource = resourceDAO.findById(resourceId);
        Long gradeResourceId = requestContext.getLong(colPrefix + ".gradeResourceId");
        if (gradeResourceId == -1) {
            gradeResourceId = gradeCourseResourceDAO.create(course, resource, hours, hourlyCost, unitCost).getId();
        } else {
            gradeCourseResourceDAO.update(gradeCourseResourceDAO.findById(gradeResourceId), hours, hourlyCost, unitCost);
        }
        existingIds.add(gradeResourceId);
    }
    List<GradeCourseResource> gradeCourseResources = gradeCourseResourceDAO.listByCourse(course);
    for (GradeCourseResource gradeCourseResource : gradeCourseResources) {
        if (!existingIds.contains(gradeCourseResource.getId())) {
            gradeCourseResourceDAO.delete(gradeCourseResource);
        }
    }
    // Other costs
    existingIds = new HashSet<>();
    rowCount = requestContext.getInteger("otherCostsTable.rowCount").intValue();
    for (int i = 0; i < rowCount; i++) {
        String colPrefix = "otherCostsTable." + i;
        name = requestContext.getString(colPrefix + ".name");
        MonetaryAmount cost = new MonetaryAmount();
        cost.setAmount(requestContext.getDouble(colPrefix + ".cost"));
        Long otherCostId = requestContext.getLong(colPrefix + ".otherCostId");
        if (otherCostId == -1) {
            otherCostId = otherCostDAO.create(course, name, cost).getId();
        } else {
            otherCostDAO.update(otherCostDAO.findById(otherCostId), name, cost);
        }
        existingIds.add(otherCostId);
    }
    List<OtherCost> otherCosts = otherCostDAO.listByCourse(course);
    for (OtherCost otherCost : otherCosts) {
        if (!existingIds.contains(otherCost.getId())) {
            otherCostDAO.delete(otherCost);
        }
    }
    // Students
    existingIds = new HashSet<>();
    rowCount = requestContext.getInteger("studentsTable.rowCount");
    for (int i = 0; i < rowCount; i++) {
        String colPrefix = "studentsTable." + i;
        Long studentId = requestContext.getLong(colPrefix + ".studentId");
        Long courseStudentId = requestContext.getLong(colPrefix + ".courseStudentId");
        Date enrolmentDate = requestContext.getDate(colPrefix + ".enrolmentDate");
        Long enrolmentTypeId = requestContext.getLong(colPrefix + ".enrolmentType");
        Long participationTypeId = requestContext.getLong(colPrefix + ".participationType");
        Boolean lodging = requestContext.getBoolean(colPrefix + ".lodging");
        CourseEnrolmentType enrolmentType = enrolmentTypeId != null ? enrolmentTypeDAO.findById(enrolmentTypeId) : null;
        CourseParticipationType participationType = participationTypeId != null ? participationTypeDAO.findById(participationTypeId) : null;
        CourseStudent courseStudent;
        CourseOptionality optionality = (CourseOptionality) requestContext.getEnum(colPrefix + ".optionality", CourseOptionality.class);
        if (courseStudentId == -1) {
            /* New student */
            Student student = studentDAO.findById(studentId);
            String organizationName = null;
            String additionalInfo = null;
            Room room = null;
            BigDecimal lodgingFee = null;
            Currency lodgingFeeCurrency = null;
            BigDecimal reservationFee = null;
            Currency reservationFeeCurrency = null;
            if (course.isCourseTemplate()) {
                throw new SmvcRuntimeException(PyramusStatusCode.UNDEFINED, Messages.getInstance().getText(locale, "generic.errors.cannotAddStudentsToCourseTemplate"));
            }
            try {
                courseStudent = courseStudentDAO.create(course, student, enrolmentType, participationType, enrolmentDate, lodging, optionality, null, organizationName, additionalInfo, room, lodgingFee, lodgingFeeCurrency, reservationFee, reservationFeeCurrency, Boolean.FALSE);
            } catch (DuplicateCourseStudentException dcse) {
                throw new SmvcRuntimeException(PyramusStatusCode.UNDEFINED, Messages.getInstance().getText(locale, "generic.errors.duplicateCourseStudent", new Object[] { student.getFullName() }));
            }
        } else {
            boolean modified = new Integer(1).equals(requestContext.getInteger(colPrefix + ".modified"));
            if (modified) {
                /* Existing student */
                Student student = studentDAO.findById(studentId);
                courseStudent = courseStudentDAO.findById(courseStudentId);
                try {
                    courseStudentDAO.update(courseStudent, student, enrolmentType, participationType, enrolmentDate, lodging, optionality);
                } catch (DuplicateCourseStudentException dcse) {
                    throw new SmvcRuntimeException(PyramusStatusCode.UNDEFINED, Messages.getInstance().getText(locale, "generic.errors.duplicateCourseStudent", new Object[] { student.getFullName() }));
                }
            }
        }
    }
    processSignupStudyProgrammes(requestContext, course, loggedUser);
    processSignupStudentGroups(requestContext, course, loggedUser);
    requestContext.setRedirectURL(requestContext.getReferer(true));
}