private List<order_item_report> GetOrderItemReport(int ServiceProviderId) { List<order_item_report> ReturnList = new List<order_item_report>(); foreach (OrderItemReport OIR in SyncClient.GetOrderItemReport(GetFromDate, DateTimeNow, ServiceProviderId)) { order_item_report tmp = QueryOrderItemReport(new Guid(OIR.Id)); Boolean NewValue = false; if (tmp == null) { tmp = new order_item_report(); NewValue = true; } tmp.Id = new Guid(OIR.Id); tmp.comment = OIR.ReportComment; tmp.createdat = System.DateTime.Parse(OIR.CreateDat); tmp.order_item_id = OIR.OrderItemId; if (NewValue) { dbContext.Set<order_item_report>().Add(tmp); } dbContext.SaveChanges(); ReturnList.Add(tmp); } return ReturnList; }