@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;
}
