private static List <User> makeUsersOutOfReader(SqlDataReader reader) { List <User> user = new List <User>(); while (reader.Read()) { int id = reader.GetInt32(0); String login = reader.GetString(1), password = reader.GetString(2); Boolean activeFlag = reader.GetByte(3) == 1; DateTime createdDate = reader.GetDateTime(4); int createdBy = reader.GetInt32(5); int lastModifiedBy = reader.GetInt32(6); DateTime lastModifiedDate = reader.GetDateTime(7); List <int> supportedAppId = ApplicationDAO.getAppIdForThisUser(id); List <Role> role = RoleDAO.getAllRolesForThisUser(id); user.Add(new User(id, login, password, supportedAppId, role, activeFlag, createdDate, lastModifiedDate, createdBy, lastModifiedBy)); } return(user); }