
Topic 8, Trey Research
Background
You develop an intranet portal for Trey Research. End users of the portal are researchers and office staff.
Business Requirements
All end users must be able to customize their profile with relevant information. Researchers must store research papers, upload supporting documents, and search content.
Storage
The portal must use an existing Microsoft SQL Server database to access and store work profile information and research papers.
Data Access
- The portal must use Business Connectivity Services (BCS) to access data from
external systems.
- Researchers must search content from SharePoint and external systems.
- Researchers must manage a research topic and related content as a single entity.
User Profile
- Employees must be able to customize their profile.
- Administrators must be able to create new profile properties.
Technical Requirements
Data Store
The data model for the database entities is shown below:

Users must not be allowed to update the Employees.Username and ResearchPapers.ID fields. The fields uniquely distinguish the corresponding entity.
Access External Data - You must create an external content type named TreyResearch to access the SQL data source. During development, the data source will be accessible locally. - You must develop an app to access the fields named Employee Name and Research Paper Title. - Researchers must be able to find all research papers that are written by a particular employee. - A research paper always must be associated with the employee that wrote it.
Document Management
- Researchers must be able to upload research papers and relevant supporting
materials into a document set named Research Content. - All the document sets must be stored in a list named ResearchPapers. - All documents that are uploaded must contain the prefix DOC in the file name.
Environment
The SQL database will be on a different physical server when the solution is deployed to a production environment. The solution must use the SQL Server user named sqltrey to connect to the database. The BCS service is configured and running in the production environment.
Personalize
- You must use custom profile properties to add a new section to the user profile properties page. - The solution must use the client-side object model (CSOM) to upload employee
profile pictures. - Employees must be able to change their display name on the site. - Each employee's page must display the value of the DisplayName and Title fields.
Search
- The Microsoft Bing API web service must be used to search for research papers. No code must be written. - The app must use a Content Enrichment web service named Abstractlndexer. The app must use the Abstractlndexer service to index search content. - The solution must store large-sized media files in a dedicated SQL Server database. - The database must use the ResearchPapers.ID field as the foreign key to associate the field with the TreyResearch external content type.
Application Structure
Relevant portions of the solution files are shown below. (Line numbers in the code segments are included for reference only and include a two-character prefix that denotes the specific file to which they belong.)
App.js

ManageUserProfiles.es ContentManagement.es

