public Integer insertFeature(EventEmailFeatureBean eventEmailFeatureBean) {
Integer numOfRowsInserted = 0;
// EVENTEMAILFEATUREID VARCHAR(45) NOT NULL, FEATURENAME VARCHAR(75) NOT NULL, FK_EVENTEMAILID
// VARCHAR(45) NOT NULL, VALUE VARCHAR(500) NOT NULL
if (eventEmailFeatureBean != null
&& !Utility.isNullOrEmpty(eventEmailFeatureBean.getEventEmailFeatureId())) {
String sQuery =
"INSERT INTO GTEVENTEMAILFEATURES (EVENTEMAILFEATUREID,FEATURENAME,FK_EVENTEMAILID, VALUE) VALUES (?,?,?, ?)";
ArrayList<Object> aParams =
DBDAO.createConstraint(
eventEmailFeatureBean.getEventEmailFeatureId(),
eventEmailFeatureBean.getFeatureType().toString(),
eventEmailFeatureBean.getEventEmailId(),
eventEmailFeatureBean.getValue());
numOfRowsInserted =
DBDAO.putRowsQuery(
sQuery, aParams, EVENTADMIN_DB, "EventEmailFeatureData.java", "insertFeature() ");
}
return numOfRowsInserted;
}
public Integer updateFeature(EventEmailFeatureBean eventEmailFeatureBean) {
Integer numOfRowsInserted = 0;
if (eventEmailFeatureBean != null
&& !Utility.isNullOrEmpty(eventEmailFeatureBean.getEventEmailFeatureId())) {
String sQuery =
"UPDATE GTEVENTEMAILFEATURES SET VALUE = ? WHERE FEATURENAME = ? AND FK_EVENTEMAILID = ?";
ArrayList<Object> aParams =
DBDAO.createConstraint(
eventEmailFeatureBean.getValue(),
eventEmailFeatureBean.getFeatureType().toString(),
eventEmailFeatureBean.getEventEmailId());
numOfRowsInserted =
DBDAO.putRowsQuery(
sQuery, aParams, EVENTADMIN_DB, "EventEmailFeatureData.java", "updateFeature() ");
}
return numOfRowsInserted;
}