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