private void CommandNew_OnExecuted(object sender, ExecutedRoutedEventArgs e)
        {
            var cf = new DatabaseConnectionWindow(_showHintConnection)
            {
                Owner = this
            };

            _showHintConnection = false;

            if (cf.ShowDialog() != true)
            {
                return;
            }
            _selectedConnection = cf.SelectedConnection;

            if (!InitializeSqlContext())
            {
                return;
            }

            if (string.IsNullOrEmpty(_selectedConnection.UserQueries))
            {
                return;
            }

            var bytes = Encoding.UTF8.GetBytes(_selectedConnection.UserQueries);

            using (var reader = new MemoryStream(bytes))
            {
                QueriesView.ImportFromXML(reader);
            }
        }
        public object GetPath(Security security, Type dataType, object arg, DateTime?from, DateTime?to, IMarketDataDrive drive)
        {
            var fileName = security.GetFileName(dataType, arg, from, to, ExportType);

            var dlg = new VistaSaveFileDialog
            {
                FileName         = fileName,
                RestoreDirectory = true
            };

            switch (ExportType)
            {
            case ExportTypes.Excel:
                dlg.Filter = @"xlsx files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
                break;

            case ExportTypes.Xml:
                dlg.Filter = @"xml files (*.xml)|*.xml|All files (*.*)|*.*";
                break;

            case ExportTypes.Txt:
                dlg.Filter = @"text files (*.txt)|*.txt|All files (*.*)|*.*";
                break;

            case ExportTypes.Sql:
            {
                var wnd = new DatabaseConnectionWindow();

                if (wnd.ShowModal(this))
                {
                    return(wnd.Connection);
                }

                return(null);
            }

            case ExportTypes.Bin:
            {
                var wndFolder = new VistaFolderBrowserDialog();

                if (drive is LocalMarketDataDrive)
                {
                    wndFolder.SelectedPath = drive.Path;
                }

                return(wndFolder.ShowDialog(this.GetWindow()) == true
                                                ? DriveCache.Instance.GetDrive(wndFolder.SelectedPath)
                                                : null);
            }

            default:
            {
                new MessageBoxBuilder()
                .Error()
                .Owner(this)
                .Text(LocalizedStrings.Str2910Params.Put(ExportType))
                .Show();

                return(null);
            }
            }

            return(dlg.ShowDialog(this.GetWindow()) == true ? dlg.FileName : null);
        }