Module 1: DATA AND PROCESS MODEL
Module 2: MASTER TABLES AND PAGES
Module 3: DOCUMENTS
Module 4: POSTING
Module 5: FEATURE INTEGRATION
Module 6: REPORTING
Module 7: STATISTICS
Module 8: DIMENSIONS
Module 9: ROLE TAILORING
Module 10: INTERFACES
Module 11: WEB SERVICES
Module 12: TESTING AND DEBUGGING
Module 13: SQL SERVER OPTIMIZATION
- Lesson 1: SQL Server for Microsoft Dynamics NAV
- Lesson 2: Representation of NAV Tables and Indexes in SQL Server
- Lesson 3: Collation Options
- Lesson 4: SQL Server Query Optimizer
- Lesson 5: SQL Server Query Optimizer
- Lesson 6: Data Access Redesign
- Lesson 7: C/AL Database Functions and Performance on SQL Server
- Lesson 8: Bulk Inserts
- Lesson 9: Locking, Blocking, and Deadlocks
- Lesson 10: SIFT Data Storage in SQL Server
- Lesson 11: SQL Server Profiler
Lesson 2: Registration Web Service
Registration Web Service
Registration Web Service : CRONUS International Ltd. wants to automate the seminar registration process as much as it can. It plans to deploy a website that lets web users see the list of available seminars and register for scheduled seminars.
The functional requirements document for the CRONUS International Ltd.
implementation includes the following requirements:
- External applications must be able to retrieve the list of scheduled seminars. The information that is available to the external applications must include at least the following: o Name of the seminar o Starting date of the seminar o Duration of the seminar o Status of the seminar o Maximum participants o Number of registered participants
- External applications must be unable to delete or modify information about scheduled seminars.
- External applications must be able to register new users for a seminar if the maximum number of participants has not been reached.
Your obvious choice is to use the SOAP web services and expose the necessary functionality.
Retrieving List of Scheduled Seminars
External applications must be able to retrieve the list of scheduled seminars.
Reading data is best achieved through a page web service, where you can use the ReadMultiple method to retrieve multiple records from a page. Because the data must only be read, your simplest choice is to expose the Seminar Registration.
List page. This page already includes most of the information that is specified in the requirement. The only information that CRONUS requires, and that the page does not expose, is the number of registered participants. You can solve this by adding a new flow field to the table, and to the page in Microsoft Dynamics NAV.
You should try to expose only necessary information to external applications. Make sure that no sensitive data is available to anyone who does not absolutely require such data. Because the Seminar Registration List page includes more information than is specified in the requirement, consider creating a completely new page specifically for integrating with web services.