public EventEmailFeatureBean getEventEmailFeature(EventEmailFeatureBean eventEmailFeatureBean) {
EventEmailFeatureBean finalFeatureBean = new EventEmailFeatureBean();
if (eventEmailFeatureBean != null
&& !Utility.isNullOrEmpty(eventEmailFeatureBean.getEventEmailId())) {
String sQuery =
"SELECT * FROM GTEVENTEMAILFEATURES WHERE FEATURENAME = ? AND FK_EVENTEMAILID = ?";
ArrayList<Object> aParams =
DBDAO.createConstraint(
eventEmailFeatureBean.getFeatureType().toString(),
eventEmailFeatureBean.getEventEmailId());
ArrayList<HashMap<String, String>> arrResult =
DBDAO.getDBData(
EVENTADMIN_DB,
sQuery,
aParams,
false,
"EventEmailFeatureData.java",
"getEventEmailFeature()");
if (arrResult != null && !arrResult.isEmpty()) {
for (HashMap<String, String> hmResult : arrResult) {
finalFeatureBean = new EventEmailFeatureBean(hmResult);
}
}
}
return finalFeatureBean;
}
public ArrayList<EventEmailFeatureBean> getMultipleFeatures(
ArrayList<EventEmailFeatureBean> arrEventEmailFeatureBean, String sEventEmailId) {
ArrayList<EventEmailFeatureBean> arrMultipleFeatureBean =
new ArrayList<EventEmailFeatureBean>();
String sQuery = "SELECT * FROM GTEVENTEMAILFEATURES WHERE FK_EVENTEMAILID = ? ";
ArrayList<Object> aParams = DBDAO.createConstraint(sEventEmailId);
if (arrEventEmailFeatureBean != null && !arrEventEmailFeatureBean.isEmpty()) {
sQuery =
sQuery
+ " AND FEATURENAME IN ("
+ DBDAO.createParamQuestionMarks(arrEventEmailFeatureBean.size())
+ ")";
for (EventEmailFeatureBean tmpventEmailFeatureBean : arrEventEmailFeatureBean) {
aParams.add(tmpventEmailFeatureBean.getFeatureType().toString());
}
}
ArrayList<HashMap<String, String>> arrResult =
DBDAO.getDBData(
EVENTADMIN_DB,
sQuery,
aParams,
false,
"EventEmailFeatureData.java",
"getMultipleFeatures()");
if (arrResult != null && !arrResult.isEmpty()) {
for (HashMap<String, String> hmResult : arrResult) {
EventEmailFeatureBean eventEmailFeatureBean = new EventEmailFeatureBean(hmResult);
arrMultipleFeatureBean.add(eventEmailFeatureBean);
}
}
return arrMultipleFeatureBean;
}