public InviteModel insert(InviteModel invite) throws DAOException {
logger.info("insert() - " + invite);
InviteModel rtn = null;
Connection conn = this.getConnection();
PreparedStatement stmt = null;
String sql = null;
try {
sql =
"insert into invite (invite_id, csp_cloudname, inviter_cloudname, invited_email_address, email_subject, email_message, time_created) values (?, ?, ?, ?, ?, ?, now())";
logger.info(sql + " : " + invite);
stmt = conn.prepareStatement(sql);
stmt.setString(1, invite.getInviteId());
stmt.setString(2, invite.getCspCloudName());
stmt.setString(3, invite.getInviterCloudName());
stmt.setString(4, invite.getInvitedEmailAddress());
stmt.setString(5, invite.getEmailSubject());
stmt.setString(6, invite.getEmailMessage());
int rows = stmt.executeUpdate();
if (rows != 1) {
logger.error(sql + " : " + invite + " return " + rows + " rows ");
} else {
rtn = invite;
}
stmt.close();
stmt = null;
} catch (SQLException e) {
String err = "Failed to execute SQL statement - " + sql;
logger.error(err, e);
throw new DAOException(err, e);
} finally {
this.closeConnection(conn, stmt);
}
if (rtn == null) {
logger.error("Invite insert failed - " + invite);
}
return rtn;
}
