protected void updateLocationProperties(Location location, PropertyMap changes) {

    boolean isAdminBound = location.getLocationType().getBoundAdminLevel() != null;

    for (Map.Entry<String, Object> change : changes.entrySet()) {

      String property = change.getKey();
      Object value = change.getValue();

      if (!isAdminBound && "locationName".equals(property)) {
        location.setName((String) value);

      } else if ("locationAxe".equals(property)) {
        location.setAxe((String) value);

      } else if ("x".equals(property)) {
        location.setX((Double) value);

      } else if ("y".equals(property)) {
        location.setY((Double) changes.get("y"));

      } else if (isAdminBound
          && AdminLevelDTO.getPropertyName(location.getLocationType().getBoundAdminLevel().getId())
              .equals(property)) {

        location.setName(adminDAO.findById(((AdminEntityDTO) value).getId()).getName());
      }
    }
  }
  protected void updateAdminProperties(Location location, PropertyMap changes, boolean creating) {

    for (Map.Entry<String, Object> change : changes.entrySet()) {
      String property = change.getKey();
      Object value = change.getValue();

      if (property.startsWith(AdminLevelDTO.PROPERTY_PREFIX)) {

        int levelId = AdminLevelDTO.levelIdForPropertyName(property);
        AdminEntityDTO entity = (AdminEntityDTO) value;

        if (creating) {
          if (entity != null) {
            locationDAO.addAdminMembership(location.getId(), entity.getId());
          }
        } else {
          if (entity != null) {
            locationDAO.updateAdminMembership(location.getId(), levelId, entity.getId());
          } else {
            locationDAO.removeMembership(location.getId(), levelId);
          }
        }
      }
    }
  }
  protected void updateAttributeValueProperties(Site site, PropertyMap changes, boolean creating) {

    Map<Integer, Boolean> attributeValues = new HashMap<Integer, Boolean>();

    for (Map.Entry<String, Object> change : changes.entrySet()) {
      if (change.getKey().startsWith(AttributeDTO.PROPERTY_PREFIX)) {
        attributeValues.put(
            AttributeDTO.idForPropertyName(change.getKey()), (Boolean) change.getValue());
      }
    }
    if (!attributeValues.isEmpty()) {
      siteDAO.updateAttributeValues(site.getId(), attributeValues);
    }
  }
  protected void updatePeriodProperties(
      ReportingPeriod period, PropertyMap changes, boolean creating) {
    for (Map.Entry<String, Object> change : changes.entrySet()) {

      String property = change.getKey();
      Object value = change.getValue();

      if ("date1".equals(property)) {
        period.setDate1((Date) value);

      } else if ("date2".equals(property)) {
        period.setDate2((Date) value);
      }
    }
  }
  protected void updateIndicatorValueProperties(
      ReportingPeriod period, PropertyMap changes, boolean creating) {

    for (Map.Entry<String, Object> change : changes.entrySet()) {

      String property = change.getKey();
      Object value = change.getValue();

      if (property.startsWith(IndicatorDTO.PROPERTY_PREFIX)) {

        int indicatorId = IndicatorDTO.indicatorIdForPropertyName(property);

        if (creating) {
          if (value != null) {
            reportingPeriodDAO.addIndicatorValue(period.getId(), indicatorId, (Double) value);
          }
        } else {
          reportingPeriodDAO.updateIndicatorValue(period.getId(), indicatorId, (Double) value);
        }
      }
    }
  }
  protected void updateSiteProperties(Site site, PropertyMap changes, boolean creating) {

    for (Map.Entry<String, Object> change : changes.entrySet()) {

      String property = change.getKey();
      Object value = change.getValue();

      if ("date1".equals(property)) {
        site.setDate1((Date) value);

      } else if ("date2".equals(property)) {
        site.setDate2((Date) value);

      } else if ("assessmentId".equals(property)) {
        site.setAssessment(siteDAO.findById((Integer) value));

      } else if ("comments".equals(property)) {
        site.setComments((String) value);

      } else if ("status".equals(property)) {
        site.setStatus((Integer) value);
      }
    }
  }
  @Override
  public Integer create(User user, PropertyMap properties) {

    Activity activity = null;
    UserDatabase database;
    LocationType locationType;
    OrgUnit partner = null;

    if (properties.containsKey("activityId")) {
      activity = activityDAO.findById((Integer) properties.get("activityId"));
      locationType = activity.getLocationType();
      database = activity.getDatabase();

    } else if (properties.containsKey("databaseId")) {
      database = userDatabaseDAO.findById((Integer) properties.get("databaseId"));
      Set<LocationType> locationTypes = database.getCountry().getLocationTypes();
      if (locationTypes.isEmpty()) {
        throw new RuntimeException(
            "A site cannot be created without a location type, and the country '"
                + database.getCountry().getName()
                + "' (id = "
                + database.getCountry().getId()
                + ") has no location types defined.");
      }
      locationType = locationTypes.iterator().next();
      if (user.getOrganization() != null) {
        partner = user.getOrganization().getRoot();
      }
    } else {
      throw new RuntimeException("An activityId or databaseId must be provided to create a site");
    }

    if (properties.containsKey("partner")) {
      partner = partnerDAO.findById(((PartnerDTO) properties.get("partner")).getId());
    }

    if (partner == null) {
      throw new RuntimeException("No orgUnit id provided for new site");
    }

    /*
     * Create and save a new Location object in the database
     */

    Location location = new Location();
    location.setLocationType(locationType);
    updateLocationProperties(location, properties);

    locationDAO.persist(location);

    updateAdminProperties(location, properties, true);

    /*
     * Create and persist the Site object
     */

    Site site = new Site();
    site.setLocation(location);
    site.setActivity(activity);
    site.setDatabase(database);
    site.setPartner(partner);
    site.setDateCreated(new Date());

    updateSiteProperties(site, properties, true);

    siteDAO.persist(site);

    updateAttributeValueProperties(site, properties, true);

    /*
     * Create the reporting period object
     * IF this is a report-once activity (punctual)
     *
     * otherwise ReportingPeriods are modeled separately on the client.
     */

    if (activity != null && activity.getReportingFrequency() == ActivityDTO.REPORT_ONCE) {

      ReportingPeriod period = new ReportingPeriod();
      period.setSite(site);
      period.setMonitoring(false);

      updatePeriodProperties(period, properties, true);

      reportingPeriodDAO.persist(period);

      updateIndicatorValueProperties(period, properties, true);
    }

    return site.getId();
  }