private List<order_header> GetOrderHeader(int ServiceProviderId) { List<order_header> ReturnList = new List<order_header>(); foreach (OrderHeader oh in SyncClient.GetOrderHeader(GetFromDate, DateTimeNow, ServiceProviderId)) { order_header tmp = QueryOrderHeader(oh.Id); Boolean NewValue = false; if (tmp == null) { tmp = new order_header(); NewValue = true; } tmp.createdAt = System.DateTime.Parse(oh.CreateDat); tmp.currency_code = oh.CurrencyCode; tmp.customer_note = oh.CustomerNote; tmp.Id = oh.Id; tmp.ip_address = oh.IpAddress; tmp.orderpayment_type = oh.OrderpaymentType; tmp.order_state_id = oh.OrderStateId; tmp.sow_user_id = oh.SowUserId; tmp.subtotal = oh.Subtotal; tmp.subtotal_ex_tax = oh.SubtotalExTax; tmp.tax = oh.Tax; tmp.total = oh.Total; if (NewValue) { dbContext.Set<order_header>().Add(tmp); } dbContext.SaveChanges(); ReturnList.Add(tmp); } return ReturnList; }