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