public boolean add(User user) { return dbOperator.add( String.format( ADD_USER, user.getUser_id(), user.getUser_name(), user.getPwd(), user.getDepartment_id() > 0 ? user.getDepartment_id() : null, user.getStaff_position() != null ? "'" + user.getStaff_position() + "'" : null, user.getTotal_annual_leave() != 0 ? user.getTotal_annual_leave() : null)); }
public boolean updateByAnnualleave(User user) { return dbOperator.update( String.format(UPDATE_USER_BY_ANNUALLEAVE, user.getTotal_annual_leave(), user.getUser_id())); }