private List<service_provider> GetServiceProvider(int ServiceProviderId)
        {
            List<service_provider> ReturnList = new List<service_provider>();
            foreach (ServiceProvider sp in SyncClient.GetServiceProvider(GetFromDate, DateTimeNow, ServiceProviderId))
            {
                service_provider tmp = QueryServiceProvider(sp.Id);
                Boolean NewValue = false;
                if (tmp == null)
                {
                    tmp = new service_provider();
                    NewValue = true;
                }
                tmp.address_1 = sp.Address1;
                tmp.address_2 = sp.Address2;
                tmp.city = sp.City;
                tmp.company_name = sp.CompanyName;
                tmp.country_id = sp.CountryId;
                tmp.createdAt = System.DateTime.Parse(sp.Timestamp);
                tmp.Id = sp.Id;
                tmp.phone_1 = sp.Phone1;
                tmp.phone_2 = sp.Phone2;
                tmp.tax_number = sp.Taxnumber;
                tmp.zip = sp.Zip;
                tmp.zone_id = sp.ZoneId;

                if (NewValue)
                {
                    dbContext.Set<service_provider>().Add(tmp);
                }
                dbContext.SaveChanges();
                ReturnList.Add(tmp);
            }
            return ReturnList;
        }
        private int SendServiceProvider()
        {
            DateTime FromDate = DateTime.Parse(GetFromDate);
            service_provider LocalServiceProvider = QueryServiceProvider(FromDate);


            if (LocalServiceProvider != null)
            {
                ServiceProvider[] SendServiceProvider = new ServiceProvider[1];

                ServiceProvider tmp = new ServiceProvider();
                tmp.Timestamp = LocalServiceProvider.createdAt.ToString("dd.MM.yyyy HH:mm:ss", CultureInfo.InvariantCulture);
                tmp.Id = LocalServiceProvider.Id;
                tmp.Address1 = LocalServiceProvider.address_1;
                tmp.Address2 = LocalServiceProvider.address_2;
                tmp.City = LocalServiceProvider.city;
                tmp.CompanyName = LocalServiceProvider.company_name;
                tmp.CountryId = LocalServiceProvider.country_id;
                tmp.Phone1 = LocalServiceProvider.phone_1;
                tmp.Phone2 = LocalServiceProvider.phone_2;
                tmp.Taxnumber = LocalServiceProvider.tax_number;
                tmp.Zip = LocalServiceProvider.zip;
                if (LocalServiceProvider.zone_id < 1)
                {
                    tmp.ZoneId = 207;                       //Wenn die ZoneId Null ist, wird sie auf 207 (Wien) geändert. 
                }
                else
                {
                    tmp.ZoneId = LocalServiceProvider.zone_id;
                }

                //tmp.Appendix = LocalOrderItemReportAppendix[i].appendix;      funktioniert im Sync noch nicht

                SendServiceProvider[0] = tmp;

                return SyncClient.PutServiceProvider(SendServiceProvider, DateTimeNow, false);
            }
            return 0;

        }