@Override public SettingsVO selectSystemSettings(int communityId) throws DbException { DataSet dataSet = dbSession.executeQuery(SELECT_SYSTEM_SETTINGS_BY_COMMUNITY_ID, communityId); SettingsVO settingsVO = new SettingsVO(); settingsVO.setBillGenerationDay(dataSet.getIntValue(0, "BILL_GENERATION_DAY")); settingsVO.setAutoBillGenerationEnabled( stringToBoolean( StringUtil.getStringValue(dataSet.getIntValue(0, "AUTO_BILL_GENERATION_ENABLED")))); settingsVO.setCommunicationEnabled( stringToBoolean( StringUtil.getStringValue(dataSet.getIntValue(0, "COMMUNICATION_ENABLED")))); /* SMS related stuff */ settingsVO.setSmsEnabled( stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "SMS_ENABLED")))); settingsVO.setSmsGatewayType( GatewayType.getGatewayType(dataSet.getIntValue(0, "SMS_GATEWAY_TYPE"))); settingsVO.setSmsGatewayUsername(dataSet.getStringValue(0, "SMS_GATEWAY_USERNAME")); settingsVO.setSmsGatewayPassword(dataSet.getStringValue(0, "SMS_GATEWAY_PASSWORD")); settingsVO.setSmsGatewaySource(dataSet.getStringValue(0, "SMS_GATEWAY_SOURCE")); /* Email related stuff */ settingsVO.setEmailEnabled( stringToBoolean(StringUtil.getStringValue(dataSet.getIntValue(0, "EMAIL_ENABLED")))); settingsVO.setEmailGatewayType( GatewayType.getGatewayType(dataSet.getIntValue(0, "EMAIL_GATEWAY_TYPE"))); settingsVO.setEmailServerUsername(dataSet.getStringValue(0, "EMAIL_SERVER_USERNAME")); settingsVO.setEmailServerPassword(dataSet.getStringValue(0, "EMAIL_SERVER_PASSWORD")); settingsVO.setEmailServer(dataSet.getStringValue(0, "EMAIL_SERVER")); settingsVO.setEmailServerPort(dataSet.getIntValue(0, "EMAIL_SERVER_PORT")); settingsVO.setLastBillGeneratedDate(dataSet.getDateValue(0, "LAST_BILL_GENERATED_DATE")); settingsVO.setNextBillGenerationDate(dataSet.getDateValue(0, "NEXT_BILL_GENERATION_DATE")); settingsVO.setNextLatePaymentGenerationDate( dataSet.getDateValue(0, "NEXT_LATE_PAYMENT_GENERATION_DATE")); settingsVO.setLatePaymentReminderSent( stringToBoolean( StringUtil.getStringValue(dataSet.getIntValue(0, "LATE_PAYMENT_REMINDER_SENT")))); return settingsVO; }