Exercise - Insert records by using a runnable class

Completed

Scenario

As the finance and operations apps developer, you have been tasked with inserting customer records into a table for your Fleet Management company. You need to create a runnable class and add code that will insert two records into the FMCustomer table.

Create a runnable class

1. Minimize the Microsoft Edge window.
2. Open Visual Studio, and select Run as administrator.
3. Select Continue without code.
4. Start creating a new project by opening the File menu and selecting New > Project.
5. Search for Finance Operations, select the Finance and Operations project, and then select Next.
6. In the Configure your new project dialog box, enter FleetManagementClassProject in the Project name field.
7. Select Create.
8. To ensure that the proper settings are in place, select Dynamics 365 in the Extensions menu.
9. Select Options.
10. Under the Dynamics 365 node on the left pane, select Projects.
11. Ensure the check boxes are selected for Organize projects by element type and Synchronize database on build for newly created project.
12. Select OK.
13. In the Solution Explorer, right-click the project FleetManagementClassProject.
14. Select Add > New Item.
15. On the left pane, select Dynamics 365 Items and then select Code.
16. On the middle pane, select Runnable Class (Job).
17. Enter FMInsertCustomers in the Name field.
18. Select Add. The FMInsertCustomers class opens in the Code designer window.

Add code to insert customer records

1. In the Code designer window, insert a blank line between lines 6 and 7 by using the Enter key and remove the slashes (///).

2. First, you must declare your variables. You insert records into the FMCustomer table, so you enter the following code on line 7:

      FMCustomer FMCustomer;
   

3. In the Code designer window, insert a blank line between the curly braces for the main method by using the Enter key.

4. Now, you create a class object named FMInsertCustomers and instantiate a new instance of the object. Then you call the run() method on the new object.

      FMInsertCustomers FMInsertCustomers = new  FMInsertCustomers();
      FMInsertCustomers.run();
   

5. Now, you create the methods needed to insert records into the FMCustomer table and use ttsbegin and tts commit to insert the data. This code should go before the main method.

         public void run()
        {
           this.insertRecords();
        }
        private void insertRecords()
        {
           ttsBegin;
   
               FMCustomer.FirstName = "John";
               FMCustomer.LastName = "Smith";
               FMCustomer.Email = "johnsmith@contoso.com";
   
               FMCustomer.insert();
   
               FMCustomer.clear();
               FMCustomer.FirstName = "Sally";
               FMCustomer.LastName = "Smith";
               FMCustomer.Email = "sallysmith@contoso.com";
   
               FMCustomer.insert();
   
            ttsCommit;
       }
   

6. In this code sample, you are inserting John Smith’s record, then clearing the table buffer with clear() method. Then the code inserts another record for Sally.

7. In the Solution Explorer, right-click the FMInsertCustomers class.

8. Select Set as Startup Object.

9. Perform a build by right-clicking the project FleetManagementClassProject in the Solution Explorer and then selecting Build.

10. Run the class without debugging by selecting the Debug menu. Select Start Without Debugging. You can also use the keyboard shortcut Ctrl + F5.