using System;

using System.Linq;

using System.Collections.Generic;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

public class Program

{

    public static void Main()

    {

    string dataJSON = @"[

    {

      'ServiceItem': '1',

      'Description': 'Furnace',

      'ServiceItemSummary': null,

      'Manufacturer': 'Carrier',

      'Model': '58MCA080-12',

      'SerialNumber': '2903A12877',

      'YearManufactured': null,

      'Location': null,

      'LaborWarranty': 'N',

      'LaborWarrantyExpDate': null,

      'MaterialWarranty': 'N',

      'MaterialWarrantyExpDate': null,

      'UniqueAttchID': null,

      'SMServiceItemID': 11510,

      'Notes': null,

      'Class': '02',

      'Type': '04',

      'Active': 'Y'

    },

    {

      'ServiceItem': '2',

      'Description': 'A/C',

      'ServiceItemSummary': null,

      'Manufacturer': 'Carrier',

      'Model': '38CKC030340',

      'SerialNumber': '0604E18226',

      'YearManufactured': null,

      'Location': null,

      'LaborWarranty': 'N',

      'LaborWarrantyExpDate': null,

      'MaterialWarranty': 'N',

      'MaterialWarrantyExpDate': null,

      'UniqueAttchID': null,

      'SMServiceItemID': 8444,

      'Notes': null,

      'Class': '02',

      'Type': '01',

      'Active': 'Y'

    },

    {

      'ServiceItem': '5',

      'Description': 'EVAP COIL INSTALLED 6/21/18',

      'ServiceItemSummary': null,

      'Manufacturer': 'YORK',

      'Model': 'CF30BXA1',

      'SerialNumber': 'W1B8530156',

      'YearManufactured': null,

      'Location': null,

      'LaborWarranty': 'N',

      'LaborWarrantyExpDate': null,

      'MaterialWarranty': 'N',

      'MaterialWarrantyExpDate': null,

      'UniqueAttchID': null,

      'SMServiceItemID': 16481,

      'Notes': null,

      'Class': '02',

      'Type': '14',

      'Active': 'Y'

    },

    {

      'ServiceItem': 'Ac',

      'Description': 'AC INSTALLED 6/21/18',

      'ServiceItemSummary': null,

      'Manufacturer': 'York',

      'Model': 'YCG30B21SA',

      'SerialNumber': 'W1B7449739',

      'YearManufactured': 2017,

      'Location': null,

      'LaborWarranty': 'N',

      'LaborWarrantyExpDate': null,

      'MaterialWarranty': 'N',

      'MaterialWarrantyExpDate': null,

      'UniqueAttchID': null,

      'SMServiceItemID': 16215,

      'Notes': null,

      'Class': '02',

      'Type': '01',

      'Active': 'Y'

    },

    {

      'ServiceItem': 'Furnace',

      'Description': 'Furnace INSTALLED 6/21/18',

      'ServiceItemSummary': null,

      'Manufacturer': 'York',

      'Model': 'TM9V080B12MP11CA',

      'SerialNumber': 'W1A8468896',

      'YearManufactured': 2018,

      'Location': null,

      'LaborWarranty': 'N',

      'LaborWarrantyExpDate': null,

      'MaterialWarranty': 'N',

      'MaterialWarrantyExpDate': null,

      'UniqueAttchID': null,

      'SMServiceItemID': 16214,

      'Notes': '16x25x4 filter',

      'Class': '02',

      'Type': '04',

      'Active': 'Y'

    }

  ]";

    string dataJSON2 = @"[

    {

      'SMServiceSiteID': 26198,

      'SMCo': 1,

      'ServiceSite': '160216',

      'CustGroup': 1,

      'Customer': 18072,

      'Description': 'Milwaukee Condo',

      'Address1': '730 N Plankinton Ave',

      'Address2': '10c/10d',

      'City': 'Milwaukee',

      'State': 'WI ',

      'Zip': '53203',

      'Country': 'US',

      'Phone': '608-444-1087',

      'DefaultServiceCenter': 'Res',

      'ContactGroup': 1,

      'ContactSeq': 7035,

      'RateTemplate': null,

      'Active': 'Y',

      'Notes': 'Created from SM Call 66188',

      'UniqueAttchID': null,

      'BillToARCustomer': null,

      'TaxGroup': 1,

      'TaxCode': '4',

      'UseTaxCode': null,

      'ReportID': null,

      'CustomerPOSetting': null,

      'PrimaryTechnician': null,

      'InvoiceGrouping': null,

      'Type': 'Customer',

      'Job': null,

      'JCCo': null,

      'CostingMethod': null,

      'NonBillable': 'N',

      'Certified': 'N',

      'PRLocalCode': null,

      'InsCode': null,

      'BillingEmail': null,

      'CraftTemplate': 1,

      'Reviewer': null,

      'AltBillAddr': null,

      'InvoiceGroupingPOOverride': null,

      'Contacts': [

        {

          'SMServiceSiteContactID': 8768,

          'ContactGroup': 1,

          'ContactSeq': 7035,

          'IncludeTripCloseEmail': 'N'

        }

      ]

    },

    {

      'SMServiceSiteID': 14427,

      'SMCo': 1,

      'ServiceSite': '2888',

      'CustGroup': 1,

      'Customer': 18072,

      'Description': 'Moore, Pam',

      'Address1': '30 Hawks Landing Circle',

      'Address2': null,

      'City': 'Verona',

      'State': 'WI',

      'Zip': '53593',

      'Country': 'US',

      'Phone': null,

      'DefaultServiceCenter': 'Res',

      'ContactGroup': null,

      'ContactSeq': null,

      'RateTemplate': 'SVCRT',

      'Active': 'Y',

      'Notes': '2 year PMA on furnace and AC thru Spring of 18\r\n\r\n**Replaced furnace & AC in June 2018 - due for complimentary furnace tune up in fall of 2018 and complimentary AC tune up in spring of 2019 - CS\r\n-free furnace tune up completed 11/2/2018 - CS',

      'UniqueAttchID': null,

      'BillToARCustomer': null,

      'TaxGroup': 1,

      'TaxCode': '1',

      'UseTaxCode': '1',

      'ReportID': null,

      'CustomerPOSetting': null,

      'PrimaryTechnician': null,

      'InvoiceGrouping': null,

      'Type': 'Customer',

      'Job': null,

      'JCCo': null,

      'CostingMethod': null,

      'NonBillable': 'N',

      'Certified': 'N',

      'PRLocalCode': null,

      'InsCode': null,

      'BillingEmail': 'pam05moore@yahoo.com',

      'CraftTemplate': 3,

      'Reviewer': null,

      'AltBillAddr': null,

      'InvoiceGroupingPOOverride': null,

      'ServiceableItems': [

        {

          'ServiceItem': '1',

          'Description': 'Furnace',

          'ServiceItemSummary': null,

          'Manufacturer': 'Carrier',

          'Model': '58MCA080-12',

          'SerialNumber': '2903A12877',

          'YearManufactured': null,

          'Location': null,

          'LaborWarranty': 'N',

          'LaborWarrantyExpDate': null,

          'MaterialWarranty': 'N',

          'MaterialWarrantyExpDate': null,

          'UniqueAttchID': null,

          'SMServiceItemID': 11510,

          'Notes': null,

          'Class': '02',

          'Type': '04',

          'Active': 'Y'

        },

        {

          'ServiceItem': '2',

          'Description': 'A/C',

          'ServiceItemSummary': null,

          'Manufacturer': 'Carrier',

          'Model': '38CKC030340',

          'SerialNumber': '0604E18226',

          'YearManufactured': null,

          'Location': null,

          'LaborWarranty': 'N',

          'LaborWarrantyExpDate': null,

          'MaterialWarranty': 'N',

          'MaterialWarrantyExpDate': null,

          'UniqueAttchID': null,

          'SMServiceItemID': 8444,

          'Notes': null,

          'Class': '02',

          'Type': '01',

          'Active': 'Y'

        },

        {

          'ServiceItem': '5',

          'Description': 'EVAP COIL INSTALLED 6/21/18',

          'ServiceItemSummary': null,

          'Manufacturer': 'YORK',

          'Model': 'CF30BXA1',

          'SerialNumber': 'W1B8530156',

          'YearManufactured': null,

          'Location': null,

          'LaborWarranty': 'N',

          'LaborWarrantyExpDate': null,

          'MaterialWarranty': 'N',

          'MaterialWarrantyExpDate': null,

          'UniqueAttchID': null,

          'SMServiceItemID': 16481,

          'Notes': null,

          'Class': '02',

          'Type': '14',

          'Active': 'Y'

        },

        {

          'ServiceItem': 'Ac',

          'Description': 'AC INSTALLED 6/21/18',

          'ServiceItemSummary': null,

          'Manufacturer': 'York',

          'Model': 'YCG30B21SA',

          'SerialNumber': 'W1B7449739',

          'YearManufactured': 2017,

          'Location': null,

          'LaborWarranty': 'N',

          'LaborWarrantyExpDate': null,

          'MaterialWarranty': 'N',

          'MaterialWarrantyExpDate': null,

          'UniqueAttchID': null,

          'SMServiceItemID': 16215,

          'Notes': null,

          'Class': '02',

          'Type': '01',

          'Active': 'Y'

        },

        {

          'ServiceItem': 'Furnace',

          'Description': 'Furnace INSTALLED 6/21/18',

          'ServiceItemSummary': null,

          'Manufacturer': 'York',

          'Model': 'TM9V080B12MP11CA',

          'SerialNumber': 'W1A8468896',

          'YearManufactured': 2018,

          'Location': null,

          'LaborWarranty': 'N',

          'LaborWarrantyExpDate': null,

          'MaterialWarranty': 'N',

          'MaterialWarrantyExpDate': null,

          'UniqueAttchID': null,

          'SMServiceItemID': 16214,

          'Notes': '16x25x4 filter',

          'Class': '02',

          'Type': '04',

          'Active': 'Y'

        }

      ]

    }

  ]";

    string dataJSON3 = @"{

    'id': 838714,

    'active': true,

    'name': 'Moore, Pam',

    'type': 'Commercial',

    'address': {

      'street': '30 Hawks Landing Circle',

      'unit': '',

      'city': 'Verona',

      'state': 'WI',

      'zip': '53593',

      'country': 'N/A'

    },

    'customFields': [

      {

        'typeId': 837178,

        'name': 'Vista Id',

        'value': '1/18072'

      }

    ],

    'balance': 0,

    'doNotMail': false,

    'doNotService': false,

    'createdOn': '2022-07-19T18:23:12.6245967+00:00',

    'createdById': 23,

    'modifiedOn': '2022-07-19T18:23:13.0172745+00:00',

    'locations': [

      {

        'id': 838716,

        'customerId': 838714,

        'active': true,

        'name': '160216',

        'address': {

          'street': '730 N Plankinton Ave',

          'unit': '10c/10d',

          'city': 'Milwaukee',

          'state': 'WI ',

          'zip': '53203',

          'country': 'USA'

        },

        'customFields': [],

        'createdOn': '2022-07-19T18:23:12.7704289+00:00',

        'createdById': 23,

        'modifiedOn': '2022-07-19T18:23:12.8929085+00:00',

        'contacts': [

          {

            'id': 838717,

            'type': 'Phone',

            'value': '6084441087',

            'memo': 'Pam '

          }

        ]

      },

      {

        'id': 838718,

        'customerId': 838714,

        'active': true,

        'name': '2888',

        'address': {

          'street': '30 Hawks Landing Circle',

          'unit': '',

          'city': 'Verona',

          'state': 'WI',

          'zip': '53593',

          'country': 'USA'

        },

        'customFields': [],

        'createdOn': '2022-07-19T18:23:12.9685874+00:00',

        'createdById': 23,

        'modifiedOn': '2022-07-19T18:23:12.9685874+00:00',

        'contacts': []

      },

      {

        'id': 838719,

        'customerId': 838714,

        'active': true,

        'name': 'Vista Main',

        'address': {

          'street': '30 Hawks Landing Circle',

          'unit': '',

          'city': 'Verona',

          'state': 'WI',

          'zip': '53593',

          'country': 'N/A'

        },

        'customFields': [],

        'createdOn': '2022-07-19T18:23:12.9923771+00:00',

        'createdById': 23,

        'modifiedOn': '2022-07-19T18:23:12.9923771+00:00',

        'contacts': []

      }

    ],

    'contacts': []

  }";

     var DataArray = JsonConvert.DeserializeObject<dynamic>(dataJSON);

     var Data2 = JsonConvert.DeserializeObject<dynamic>(dataJSON2);

     var Data3 = JsonConvert.DeserializeObject<dynamic>(dataJSON3);

    foreach(var Data in DataArray){

         var servSite =

      JArray.FromObject((object)Data2)

      .Where(d => d["ServiceableItems"]

      .Any(a => a.Value<int>("SMServiceItemID") ==

           Data.Value<int>("SMServiceItemID")))

      .First();

​

      var locationId = 0;

​

      if(1 = 1)

      )

      {

        locationId = JArray.FromObject((object)

          StepResponse("add-servicetitan-customer").result.locations)

          .Where(d => d.Value<string>("name") == 

             servSite.Value<string>("ServiceSite"))

          .Select(s => s.Value<int>("id"))

        .FirstOrDefault();

      }

      else

      {

        locationId = 1;

      }

​

      var objSItem = new JObject {

        new JProperty("locationId", locationId),

        new JProperty("name",

              Data.Value<string>("ServiceItem")),

        new JProperty("serialNumber",

              Data.Value<string>("SerialNumber")),

        new JProperty("memo",

              Data.Value<string>("Description")),

        new JProperty("manufacturer",

              Data.Value<string>("Manufacturer")),

        new JProperty("model",

              Data.Value<string>("Model")),

        new JProperty("manufacturerWarrantyEnd",

            (Data.Value<string>

             ("MaterialWarrantyExpDate") == null

              ? null

              : Data.Value

              <DateTime>("MaterialWarrantyExpDate")

                        )),

        new JProperty("serviceProviderWarrantyEnd",

            (Data.Value<string>

             ("LaborWarrantyExpDate") == null

              ? null

              : Data.Value

              <DateTime>("LaborWarrantyExpDate")

              ))

      };

​

      Console.WriteLine(objSItem);

    }

​

    }

}