public DataTable GetPendingPurchaseOrderByIdAndWarehouse(string purchaseOrderId, string warehouseId)
        {
            PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = purchaseOrder.GetPendingPurchaseOrderByIdAndWarehouse(purchaseOrderId, warehouseId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                purchaseOrder = null;
            }
        }