private static void OnTimer()
        {
            GetOrdersCall       getOrdersApiCall = new GetOrdersCall(apiContext);
            OrderTypeCollection orders           = null;

            try
            {
                orders = getOrdersApiCall.GetOrders(new TimeFilter {
                    TimeFrom = DateTime.Now.AddDays(DaysAgo), TimeTo = DateTime.Now
                }, TradingRoleCodeType.Seller, OrderStatusCodeType.Completed);
            }
            catch (Exception e)
            {
                Console.WriteLine("Unable to connect to the server");
                return;
            }

            int  counter       = 0;
            var  ordersList    = new List <HeaderRecords>();
            bool orderInserted = false;

            foreach (OrderType order in orders)
            {
                try
                {
                    if (!DAL.HeaderRecords.Exists(order.OrderID))
                    {
                        orderInserted = true;
                        #region Header record
                        var headerRecord = new HeaderRecords
                        {
                            OrderID             = order.OrderID,
                            InvoiceID           = order.ShippingDetails.SellingManagerSalesRecordNumber.ToString(),
                            OrderDate           = order.PaidTime.ToShortDateString(),
                            Email               = order.TransactionArray[0].Buyer.Email, //? it gives the value of "invalid request"
                            BilltoFirstName     = order.ShippingAddress.Name,
                            BilltoLastName      = order.ShippingAddress.Name,
                            BilltoCompanyName   = order.BuyerUserID,
                            DeliveryMethod      = order.ShippingServiceSelected.ShippingService == "ShippingMethodStandard" ? "1" : "5",
                            ShippingAndHandling = order.ShippingServiceSelected.ShippingServiceCost.Value.ToString(),
                            Tax                   = order.ShippingDetails.SalesTax.SalesTaxAmount.Value.ToString(),
                            Discount              = "0",
                            OverallTotal          = order.Total.Value.ToString(),
                            ShiptoFirstName       = order.ShippingAddress.Name,
                            ShiptoLastName        = order.ShippingAddress.Name,
                            ShiptoCompanyName     = order.BuyerUserID,
                            ShiptoStreetAddress   = order.ShippingAddress.Street1,
                            ShiptoOptionalAddress = order.ShippingAddress.Street2,
                            ShiptoCity            = order.ShippingAddress.CityName,
                            ShiptoState           = order.ShippingAddress.StateOrProvince,
                            ShiptoZip             = order.ShippingAddress.PostalCode,
                            ShiptoCountry         = order.ShippingAddress.CountryName,
                            ShiptoPhone           = order.ShippingAddress.Phone,
                            CatalogName           = "EBAY",
                            Source                = "EBAY"
                        };
                        #endregion

                        List <DAL.DetailRecord> detailRecordList = new List <DAL.DetailRecord>();
                        foreach (TransactionType transactionItem in order.TransactionArray)
                        {
                            #region Detail record
                            var dr = new DAL.DetailRecord
                            {
                                InvoiceID          = headerRecord.InvoiceID,
                                PurchaseID         = transactionItem.ShippingDetails.SellingManagerSalesRecordNumber.ToString(),
                                SourceCode         = transactionItem.Item.Site.ToString(),
                                ItemID             = transactionItem.Item.ItemID,
                                ProductDescription = transactionItem.Item.Title,
                                Quantity           = transactionItem.QuantityPurchased,
                                UnitPrice          = transactionItem.TransactionPrice.Value,
                                ExtendedPrice      = transactionItem.TransactionPrice.Value * transactionItem.QuantityPurchased
                            };

                            detailRecordList.Add(dr);
                            #endregion
                        }

                        headerRecord.ProductSubtotal = detailRecordList.Sum(x => x.ExtendedPrice).ToString();
                        headerRecord.Commision       = GetCommission(headerRecord.ProductSubtotal);
                        try
                        {
                            #region Inserting objects in database
                            using (var scope = new TransactionScope())
                            {
                                DAL.HeaderRecords.Add(headerRecord);
                                SetSkuCodeForDetailsRecord(detailRecordList);

                                DAL.DetailRecord.Add(detailRecordList);
                                headerRecord.Items.AddRange(detailRecordList);

                                var orderStatus = new DAL.OrderStatus {
                                    OrderID = order.OrderID, Status = 1
                                };
                                DAL.OrderStatus.Add(orderStatus);

                                var orderMessage = new DAL.OrderMessage {
                                    InvoiceID = headerRecord.InvoiceID
                                };
                                DAL.OrderMessage.Add(orderMessage);

                                scope.Complete();
                                Console.WriteLine("Order #: " + counter + " has been inserted");
                            }
                            #endregion
                        }

                        catch (TransactionAbortedException)
                        {
                            Console.WriteLine("TransactionAbortedException has been thrown");
                        }

                        ordersList.Add(headerRecord);
                    }
                    else
                    {
                        Console.WriteLine("Order #: " + counter + " has been skipped");
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine(string.Format("An error occured at the step #: {0}; message: {1}", counter, e.Message));
                }

                finally
                {
                    counter++;
                }
            }

            if (orderInserted)
            {
                CreateXmlFile(ordersList);
            }

            RestartTimer();
        }