/**
* This method generates the prepare statement from userEntity object.
*
* @param preparedStatement
* @param user
* @return
* @throws SQLException
*/
public PreparedStatement generatePreparedStatement(
PreparedStatement preparedStatement, UserEntity user) throws SQLException {
preparedStatement.setString(1, user.getNameId());
preparedStatement.setString(2, user.getIdentityProvider());
preparedStatement.setString(3, user.getFirstName());
preparedStatement.setString(4, user.getLastName());
preparedStatement.setString(5, user.getPhotoBlobUrl());
preparedStatement.setString(6, user.getEmailAddress());
preparedStatement.setInt(7, user.getPhoneCountryCode());
preparedStatement.setLong(8, user.getPhoneNumber());
preparedStatement.setDate(9, new java.sql.Date(user.getDateCreated().getTime()));
preparedStatement.setDate(10, new java.sql.Date(user.getCreatedBy().getTime()));
preparedStatement.setDate(11, new java.sql.Date(user.getDateModified().getTime()));
preparedStatement.setDate(12, new java.sql.Date(user.getModifiedBy().getTime()));
return preparedStatement;
}
