private void validateDates(AcScheduledFlightUploadErrorVo e) {
AcScheduledFlightUpload u = e.getScheduledFlightUpload();
if (!u.hasStartLocalDt()) return;
if (!u.hasEndLocalDt()) return;
if (u.getStartLocalDt().isAfter(u.getEndLocalDt()))
e.addError("Invalid Start/End date combination");
}
public AcScheduledFlightUpload read(JwSqlResultSet rs) {
AcScheduledFlightUpload e;
e = getAccess().newScheduledFlightUpload();
e.setId(rs.getInteger());
e.setOperatorCarrierCode(rs.getString());
e.setOperatorNumber(rs.getString());
e.setRelationship(AcFlightRelationshipEnum.getFromCode(rs.getString()));
e.setOriginAirportCode(rs.getString());
e.setDestinationAirportCode(rs.getString());
e.setDepartureLocalTm(rs.getTime());
e.setArrivalLocalTm(rs.getTime());
e.setDayOffset(rs.getInteger());
e.setBoundingStartLocalDt(rs.getDate());
e.setBoundingEndLocalDt(rs.getDate());
e.setFrequency(rs.getDayFrequency());
e.setEquipmentCode(rs.getString());
e.setSource(AcScheduledFlightCalendarSourceEnum.getFromCode(rs.getString()));
e.setAbsoluteSource(AcScheduledFlightCalendarAbsoluteSourceEnum.getFromCode(rs.getString()));
e.setCancel(rs.getBoolean());
e.setCreatedUtcTs(rs.getTimestamp());
e.setSequence(rs.getInteger());
return e;
}
public JwSqlUpdate composeUpdate(AcScheduledFlightUpload e) {
JwSqlUpdate st = createUpdate();
st.setTable(TABLE);
st.setValue(OPERATOR_CARRIER_CODE, e.getOperatorCarrierCode());
st.setValue(OPERATOR_NUMBER, e.getOperatorNumber());
st.setValue(RELATIONSHIP, e.getRelationship().getCode());
st.setValue(ORIGIN_AIRPORT_CODE, e.getOriginAirportCode());
st.setValue(DESTINATION_AIRPORT_CODE, e.getDestinationAirportCode());
st.setValue(DEPARTURE_LOCAL_TM, e.getDepartureLocalTm());
st.setValue(ARRIVAL_LOCAL_TM, e.getArrivalLocalTm());
st.setValue(DAY_OFFSET, e.getDayOffset());
st.setValue(BOUNDING_START_LOCAL_DT, e.getBoundingStartLocalDt());
st.setValue(BOUNDING_END_LOCAL_DT, e.getBoundingEndLocalDt());
st.setValue(FREQUENCY, e.getFrequency());
st.setValue(EQUIPMENT_CODE, e.getEquipmentCode());
st.setValue(SOURCE, e.getSource().getCode());
st.setValue(ABSOLUTE_SOURCE, e.hasAbsoluteSource() ? e.getAbsoluteSource().getCode() : null);
st.setValue(CANCEL, e.getCancel());
st.setValue(CREATED_UTC_TS, e.getCreatedUtcTs());
st.setValue(SEQUENCE, e.getSequence());
st.where().isEqual(ID, e.getId());
return st;
}
public void update(AcScheduledFlightUpload e) {
e.validate();
JwSqlUpdate st = composeUpdate(e);
int i = execute(st);
if (i != 1) error("Unable to update AcScheduledFlightUpload. Rows updated: %s.", i);
}
public void generateIds(JwList<AcScheduledFlightUpload> v) {
Integer i = getNextId();
for (AcScheduledFlightUpload e : v) e.setId(i++);
}
public JwSqlInsert _checkAndComposeInsert(JwList<AcScheduledFlightUpload> v, boolean insertIds) {
for (AcScheduledFlightUpload e : v) {
defaultUpdateCount(e);
e.validate();
verifyNoMatching(e);
}
JwSqlInsert st = createInsert();
st.setTable(TABLE);
populateInsertColumns(st, insertIds);
for (AcScheduledFlightUpload e : v) {
st.startNewRow();
if (insertIds) st.addIntegerValue(e.getId());
st.addStringValue(e.getOperatorCarrierCode());
st.addStringValue(e.getOperatorNumber());
st.addStringValue(e.getRelationship().getCode());
st.addStringValue(e.getOriginAirportCode());
st.addStringValue(e.getDestinationAirportCode());
st.addTimeValue(e.getDepartureLocalTm());
st.addTimeValue(e.getArrivalLocalTm());
st.addIntegerValue(e.getDayOffset());
st.addDateValue(e.getBoundingStartLocalDt());
st.addDateValue(e.getBoundingEndLocalDt());
st.addDayFrequencyValue(e.getFrequency());
st.addStringValue(e.getEquipmentCode());
st.addStringValue(e.getSource().getCode());
st.addStringValue(e.hasAbsoluteSource() ? e.getAbsoluteSource().getCode() : null);
st.addBooleanValue(e.getCancel());
st.addTimestampValue(e.getCreatedUtcTs());
st.addIntegerValue(e.getSequence());
}
return st;
}