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;
        }