public IList <SaleOrder> GetSaleOrders()
        {
            Thread.Sleep(1000);
            IList <SaleOrder> products = new List <SaleOrder>();
            DataTable         ds;

            using (SaleOrderDataService data = new SaleOrderDataService())
            {
                string sql = "SELECT *  FROM [Sales].[SalesOrderHeader] WHERE SalesOrderNumber like '%43%'";

                ds = data.GetSaleOrders(sql);
            }
            products = ConvertToSaleOrder(ds);

            return(products);
        }
        public async Task <IList <SaleOrder> > GetSaleOrdersTask()
        {
            await Task.Delay(1000);

            IList <SaleOrder> products = new List <SaleOrder>();
            DataTable         ds;

            using (SaleOrderDataService data = new SaleOrderDataService())
            {
                string sql = "SELECT *  FROM  [Sales].[SalesOrderHeader] WHERE SalesOrderNumber like '%43%'";

                ds = await data.GetSaleOrdersAsync(sql);
            }
            products = ConvertToSaleOrder(ds);

            return(products);
        }