Esempio n. 1
0
        private static string ReplaceAlgo(this string src,
                                          int jokerIndexFrom, // get from super method to optimize
                                          ReplacePattern pattern)
        {
            var algoFromParts = pattern.From.Split(Joker);
            var algoToParts   = pattern.To.Split(Joker);

            if (!src.StartsWith(algoFromParts.First()) || !src.EndsWith(algoFromParts.Last()))
            {
                return(src);
            }

            var jEnd = src.LastIndexOf(algoFromParts.Last(), StringComparison.Ordinal);
            int jLength;

            if (algoFromParts.Last() != "")
            {
                jLength = jEnd - jokerIndexFrom;
            }
            else
            {
                jLength = src.Length - jokerIndexFrom;
            }

            var constPart = src.Substring(jokerIndexFrom, jLength);

            return(algoToParts.First() + constPart + algoToParts.Last());
        }
Esempio n. 2
0
 public override int GetHashCode()
 {
     unchecked
     {
         int hashCode = 13;
         hashCode = (hashCode * 17) ^ TypeOfFileSearch.GetHashCode();
         hashCode = (hashCode * 17) ^ FileNames?.GetHashCode() ?? 5;
         hashCode = (hashCode * 17) ^ IgnoreFilePattern?.GetHashCode() ?? 5;
         hashCode = (hashCode * 17) ^ TypeOfSearch.GetHashCode();
         hashCode = (hashCode * 17) ^ SearchPattern?.GetHashCode() ?? 5;
         hashCode = (hashCode * 17) ^ ReplacePattern?.GetHashCode() ?? 5;
         hashCode = (hashCode * 17) ^ CaseSensitive.GetHashCode();
         hashCode = (hashCode * 17) ^ WholeWord.GetHashCode();
         hashCode = (hashCode * 17) ^ Multiline.GetHashCode();
         hashCode = (hashCode * 17) ^ Singleline.GetHashCode();
         hashCode = (hashCode * 17) ^ BooleanOperators.GetHashCode();
         hashCode = (hashCode * 17) ^ IncludeSubfolders.GetHashCode();
         hashCode = (hashCode * 17) ^ IncludeHiddenFiles.GetHashCode();
         hashCode = (hashCode * 17) ^ IncludeBinaryFiles.GetHashCode();
         hashCode = (hashCode * 17) ^ MaxSubfolderDepth.GetHashCode();
         hashCode = (hashCode * 17) ^ UseGitignore.GetHashCode();
         hashCode = (hashCode * 17) ^ IncludeArchive.GetHashCode();
         hashCode = (hashCode * 17) ^ FollowSymlinks.GetHashCode();
         hashCode = (hashCode * 17) ^ CodePage.GetHashCode();
         return(hashCode);
     }
 }
Esempio n. 3
0
        public void reply_watch(UUID client, int level, string[] additionalArgs,
                                Destinations source,
                                UUID agentKey, string agentName)
        {
            MHE(source, client, "[ReplyWatchdog] Pattern add in progress");
            if (OCBotMemory.Memory.AutoReplyWatchPatterns.ContainsKey(additionalArgs[0]))
            {
                ReplacePattern pttrn = OCBotMemory.Memory.AutoReplyWatchPatterns[additionalArgs[0]];
                additionalArgs[1] = additionalArgs[1].Replace('&', ' ');
                pttrn.Triggers    = additionalArgs[1];
                pttrn.Tolerance   = Convert.ToInt32(additionalArgs[2]);
                pttrn.Reply       = additionalArgs[3].Replace('_', ' ');


                OCBotMemory.Memory.AutoReplyWatchPatterns[additionalArgs[0]] = pttrn;
            }
            else
            {
                ReplacePattern ptrn = new ReplacePattern();
                ptrn.Triggers  = additionalArgs[1];
                ptrn.Tolerance = Convert.ToInt32(additionalArgs[2]);
                ptrn.Reply     = additionalArgs[3].Replace('_', ' ');

                OCBotMemory.Memory.AutoReplyWatchPatterns.Add(additionalArgs[0], ptrn);
            }

            OCBotMemory.Memory.Save();

            MHE(source, client, "[ReplyWatchdog] Pattern add completed");
        }
Esempio n. 4
0
    public ReplacePatternViewModel(ReplacePattern replacePattern)
    {
        this.replacePattern = replacePattern;

        AsExpression = replacePattern
                       .ToReactivePropertyAsSynchronized(x => x.AsExpression)
                       .AddTo(this.CompositeDisposable);

        TargetPattern = replacePattern
                        .ToReactivePropertyAsSynchronized(
            x => x.TargetPattern,
            mode: ReactivePropertyMode.Default | ReactivePropertyMode.IgnoreInitialValidationError,
            ignoreValidationErrorValue: true)
                        .SetValidateNotifyError(x => AppExtension.IsValidRegexPattern(x, AsExpression.Value) ? null : "Invalid Pattern")
                        .AddTo(this.CompositeDisposable);

        ReplaceText = replacePattern
                      .ToReactivePropertyAsSynchronized(
            x => x.ReplaceText,
            mode: ReactivePropertyMode.Default | ReactivePropertyMode.IgnoreInitialValidationError,
            ignoreValidationErrorValue: true)
                      .SetValidateNotifyError(x => AppExtension.IsValidReplacePattern(x, AsExpression.Value) ? null : "Invalid Pattern")
                      .AddTo(this.CompositeDisposable);

        AsExpression
        .Subscribe(x => TargetPattern.ForceValidate());
    }
Esempio n. 5
0
 public void SetSettings(Setting setting)
 {
     addFileNameToBookmark      = setting.AddFileNameToBookmark;
     replaceFileName            = setting.ReplaceFileName;
     addDirectoryNameToBookmark = setting.AddDirectoryNameToBookmark;
     replaceDirectoryName       = setting.ReplaceDirectoryName;
     property   = setting.Property;
     displayPdf = setting.DisplayPdf;
 }
Esempio n. 6
0
        private static string ReplaceNormal(this string src, ReplacePattern pattern)
        {
            //validations
            if (string.IsNullOrEmpty(pattern.From))
            {
                throw new Exception("It's impossible replace nothing with any thing");
            }

            return(src.Replace(pattern.From, pattern.To));
        }
Esempio n. 7
0
 public override int GetHashCode()
 {
     unchecked
     {
         int hashCode = 13;
         hashCode = (hashCode * 397) ^ FileNames.GetHashCode();
         hashCode = (hashCode * 397) ^ SearchPattern.GetHashCode();
         hashCode = (hashCode * 397) ^ ReplacePattern.GetHashCode();
         return(hashCode);
     }
 }
Esempio n. 8
0
    public async Task ReplaceLogByEnableSetting(bool enableLog, string targetPattern, bool expectedResult)
    {
        const string targetDirPath = @"D:\FileRenamerDiff_Test";
        string       filePathA     = Path.Combine(targetDirPath, "A.txt");
        string       filePathB     = Path.Combine(targetDirPath, "B.csv");

        var fileSystem = new MockFileSystem(new Dictionary <string, MockFileData>()
        {
            [filePathA] = new MockFileData("A"),
            [filePathB] = new MockFileData("B"),
        });

        var model = new MainModel(fileSystem, Scheduler.Immediate);

        model.Initialize();
        model.Setting.SearchFilePaths   = new[] { targetDirPath };
        model.Setting.IsCreateRenameLog = enableLog;
        var rPattern = new ReplacePattern(targetPattern, "X");

        rPattern.ToString()
        .Should().ContainAll(targetPattern, "X");

        model.Setting.ReplaceTexts.Add(rPattern);
        await model.LoadFileElements();

        await model.Replace();

        await model.RenameExecute();

        if (!expectedResult)
        {
            fileSystem.AllFiles
            .Should().NotContain("RenameLog", "ログ設定が無効ならログファイルはないはず");

            return;
        }

        string?logFilePath = fileSystem.AllFiles.Where(x => x.Contains("RenameLog")).FirstOrDefault();
        string?logContent  = logFilePath is null
            ? null
            : fileSystem.File.ReadAllText(logFilePath);

        logContent
        .Should().Contain("A.txt", "リネームログがあるはず");
        logContent
        .Should().Contain("X.txt", "リネームログがあるはず");
    }
Esempio n. 9
0
        private static string ReplaceNumericAlgo(this string src,
                                                 int numStartFlagIndex, int numEndFlagIndex,
                                                 ReplacePattern pattern)
        {
            if (pattern.From is null || pattern.To is null)
            {
                throw new ArgumentNullException();
            }
            var algoFromParts = pattern.From.Split(Joker);

            if (!src.StartsWith(algoFromParts.First()) || !src.EndsWith(algoFromParts.Last()))
            {
                return(src);
            }

            if (pattern.From != _prePattern?.From || pattern.To != _prePattern?.To)
            {
                ResetNumeric();
            }

            if (_preNum is null || _numFormat is null)
            {
                var numLength = numEndFlagIndex - numStartFlagIndex - 1;
                var numPart   = pattern.To.Substring(numStartFlagIndex + 1, numLength);
                if (!int.TryParse(numPart, out int num))
                {
                    throw new Exception("you must put a integer number " +
                                        $"between '{NumStartFlag}' and '{NumEndFlag}'");
                }
                _preNum    = num - 1;
                _numFormat = "D" + (numLength - (num < 0 ? 1 : 0));
            }
            _prePattern = pattern;

            var before = pattern.To.Split(NumStartFlag).First();
            var after  = pattern.To.Split(NumEndFlag).Last();

            return(before + (++_preNum).Value.ToString(_numFormat) + after);
        }
    public async Task CommandsCanExecute()
    {
        var fileSystem    = AppExtension.CreateMockFileSystem(new[] { filePathA, filePathB });
        var syncScheduler = new SynchronizationContextScheduler(SynchronizationContext.Current !);
        var model         = new MainModel(fileSystem, syncScheduler);
        var mainVM        = new MainWindowViewModel(model);

        mainVM.Initialize();
        await mainVM.WaitIdle().Timeout(3000d);

        await Task.Delay(100);

        //ステージ1 初期状態
        var canExecuteUsuallyCommand = new ICommand[]
        {
            mainVM.AddFilesFromDialogCommand,
            mainVM.LoadFilesFromCurrentPathCommand,
            mainVM.LoadFilesFromDialogCommand,
            mainVM.LoadFilesFromNewPathCommand,
            mainVM.ShowHelpPageCommand,
            mainVM.ShowInformationPageCommand,
        };

        for (int i = 0; i < canExecuteUsuallyCommand.Length; i++)
        {
            canExecuteUsuallyCommand[i]
            .CanExecute(null)
            .Should().BeTrue($"すべて実行可能はなず (indexCommand:{i})");
        }

        mainVM.ReplaceCommand.CanExecute()
        .Should().BeFalse("実行不可能のはず");

        //ステージ2 ファイル読み込み中
        Task <bool> isIdleTask = mainVM.IsIdle.WaitUntilValueChangedAsync();

        mainVM.LoadFilesFromNewPathCommand.Execute(new[] { targetDirPath });
        await isIdleTask.Timeout(10000d);

        //CI上ではなぜか失敗することもある
        //canExecuteUsuallyCommand
        //    .Concat(new[] { mainVM.ReplaceCommand })
        //    .ForEach((c, i) =>
        //        c.CanExecute(null)
        //        .Should().BeFalse($"すべて実行不可能はなず (indexCommand:{i})"));

        //ステージ2 ファイル読み込み後
        await mainVM.WaitIdle().Timeout(3000);

        await Task.Delay(100);

        var canExecuteCommand = canExecuteUsuallyCommand
                                .Concat(new[] { mainVM.ReplaceCommand })
                                .Select((command, index) => (command, index));

        foreach (var(command, index) in canExecuteCommand)
        {
            command.CanExecute(null)
            .Should().BeTrue($"すべて実行可能はなず (indexCommand:{index})");
        }

        mainVM.RenameExecuteCommand.CanExecute()
        .Should().BeFalse("実行不可能のはず");

        //ステージ3 重複したリネーム後
        var replaceConflict = new ReplacePattern(fileNameA, fileNameB);

        mainVM.SettingVM.Value.ReplaceTexts.Add(new ReplacePatternViewModel(replaceConflict));
        await mainVM.ReplaceCommand.ExecuteAsync();

        await mainVM.WaitIdle().Timeout(3000);

        await Task.Delay(10);

        mainVM.RenameExecuteCommand.CanExecute()
        .Should().BeFalse("まだ実行不可能のはず");

        //ステージ4 なにも変化しないリネーム後
        mainVM.SettingVM.Value.ReplaceTexts.Clear();
        await mainVM.ReplaceCommand.ExecuteAsync();

        await mainVM.WaitIdle().Timeout(3000);

        await Task.Delay(10);

        mainVM.RenameExecuteCommand.CanExecute()
        .Should().BeFalse($"まだ実行不可能のはず。IsIdle:{mainVM.IsIdle.Value}, CountConflicted:{model.CountConflicted.Value}, CountReplaced:{model.CountReplaced.Value}");

        //ステージ5 有効なネーム後
        var replaceSafe   = new ReplacePattern(fileNameA, $"XXX_{fileNameA}");
        var replaceSafeVM = new ReplacePatternViewModel(replaceSafe);

        replaceSafeVM.ToString()
        .Should().ContainAll(fileNameA, "XXX_");
        mainVM.SettingVM.Value.ReplaceTexts.Add(replaceSafeVM);
        await mainVM.ReplaceCommand.ExecuteAsync();

        await mainVM.WaitIdle().Timeout(3000);

        await Task.Delay(10);

        mainVM.RenameExecuteCommand.CanExecute()
        .Should().BeTrue($"実行可能になったはず。IsIdle:{mainVM.IsIdle.Value}, CountConflicted:{model.CountConflicted.Value}, CountReplaced:{model.CountReplaced.Value}");

        //ステージ6 リネーム保存後
        await mainVM.RenameExecuteCommand.ExecuteAsync();

        await mainVM.WaitIdle().Timeout(3000);

        await Task.Delay(10);

        foreach (var(command, index) in canExecuteCommand)
        {
            command.CanExecute(null)
            .Should().BeTrue($"すべて実行可能はなず (indexCommand:{index})");
        }

        mainVM.RenameExecuteCommand.CanExecute()
        .Should().BeFalse($"実行不可能に戻ったはず。IsIdle:{mainVM.IsIdle.Value}, CountConflicted:{model.CountConflicted.Value}, CountReplaced:{model.CountReplaced.Value}");
    }
Esempio n. 11
0
        private void button1_Click(object sender, EventArgs e)
        {
            int i = inputAppFullName.Lines.Length;
            string[] text = inputAppFullName.Text.Split(';');
            if (text[0] != null)
            {
                string s = text[0];

                string query6 = "select  PFFullEngName, PFBirthday, PFNumAndSerRussPassport, PFDateGetRussPassport,  PFOrgGetRussPassport, PFNumAndSerForeignPassport, PFDateGetForeignPassport, PFDateEndForeignPassport,PFOrgGetForeignPassport, PFBirthPlace, PFPhone from PhisicalFace where (PFFullRussName = \'" + s + "\')";

                SqlDataReader data3 = Database.executeQuery(query6);
                object[] fields3 = new object[11];
                data3.Read();
                data3.GetValues(fields3);
                data3.Close();

                string PFFullEngName = fields3[0].ToString(), PFBirthday = fields3[1].ToString(), PFNumAndSerRussPassport = fields3[2].ToString();
                string PFDateGetRussPassport = fields3[3].ToString(), PFOrgGetRussPassport = fields3[4].ToString(), PFNumAndSerForeignPassport = fields3[5].ToString();
                string PFDateGetForeignPassport = fields3[6].ToString(), PFDateEndForeignPassport = fields3[7].ToString();
                string PFOrgGetForeignPassport = fields3[8].ToString(), PFBirthPlace = fields3[9].ToString(), PFPhone = fields3[10].ToString();

                fillDocument2(PFFullEngName, PFBirthday, PFNumAndSerRussPassport, PFDateGetRussPassport, PFOrgGetRussPassport, PFNumAndSerForeignPassport, PFDateGetForeignPassport, PFDateEndForeignPassport, PFOrgGetForeignPassport, PFBirthPlace, PFPhone);
            }

            string query5 = "select JFNameOrg, JFCargoCarrier from JuridicalFace where (JFFullNameOrg =\'" + inputAppNameOrgOrPF.Text + "\')";
            SqlDataReader data5 = Database.executeQuery(query5);
            object[] fields5 = new object[2];
            data5.Read();
            data5.GetValues(fields5);
            data5.Close();

            string JFNameOrg = fields5[0].ToString(), JFCargoCarrier = fields5[1].ToString();

            fillDocument3(JFNameOrg, JFCargoCarrier);

            /*if (text[1] != null)
               {
               string h = text[1];
               string query1 = "select  PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport from PhisicalFace where (PFFullRussName = \'" + h + "\')";

               SqlDataReader data1 = Database.executeQuery(query1);
               object[] fields1 = new object[4];
               data1.Read();
               data1.GetValues(fields1);
               data1.Close();

               string PFFullEngName = fields1[0].ToString(), PFBirthday = fields1[1].ToString(),  PFNumAndSerForeignPassport = fields1[2].ToString();
               string PFDateEndForeignPassport = fields1[3].ToString();

               fillDocumentH(PFFullEngName, PFBirthday,  PFNumAndSerForeignPassport, PFDateEndForeignPassport);
               }
               if (text[2] != null)
               {
               string f = text[2];
               string query2 = "select  PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport from PhisicalFace where (PFFullRussName = \'" + f + "\')";

               SqlDataReader data2 = Database.executeQuery(query2);
               object[] fields2 = new object[4];
               data2.Read();
               data2.GetValues(fields2);
               data2.Close();

               string PFFullEngName = fields2[0].ToString(), PFBirthday = fields2[1].ToString(), PFNumAndSerForeignPassport = fields2[2].ToString();
               string PFDateEndForeignPassport = fields2[3].ToString();

               fillDocumentF(PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport);
               }
               if (text[3] != null)
               {
               string k = text[3];
               string query4 = "select  PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport from PhisicalFace where (PFFullRussName = \'" + k + "\')";

               SqlDataReader data4 = Database.executeQuery(query4);
               object[] fields4 = new object[4];
               data4.Read();
               data4.GetValues(fields4);
               data4.Close();

               string PFFullEngName = fields4[0].ToString(), PFBirthday = fields4[1].ToString(), PFNumAndSerForeignPassport = fields4[2].ToString();
               string PFDateEndForeignPassport = fields4[3].ToString();

               fillDocumentK(PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport);
               }*/

            if (actCheckBox.Checked) {
                fillDocumentExcel(@"c:\АСУ-Тур\Акт реализации.xls");
            }
            if (appCheckBox.Checked) {
                List<ReplacePattern> replacePatterns = new List<ReplacePattern>();
                ReplacePattern pattern;
                pattern = new ReplacePattern(); pattern.replaced = "Sanat"; pattern.replacing = inputAppWay.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "name"; pattern.replacing = text[0]; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "arrived"; pattern.replacing = inputAppStartTour.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "num"; pattern.replacing = inputNumDays.Text; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Заявка на бронирование1.dot", replacePatterns);
            }
            if (contractCheckBox.Checked) {
                List<ReplacePattern> replacePatterns = new List<ReplacePattern>();
                ReplacePattern pattern;
                pattern = new ReplacePattern(); pattern.replaced = "contract"; pattern.replacing = inputNumContract.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "way"; pattern.replacing = "Санаторий  " + inputAppWay.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "starttour"; pattern.replacing = inputAppStartTour.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "fullname"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "food"; pattern.replacing = inputFood.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "numdays"; pattern.replacing = inputNumDays.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "cost"; pattern.replacing = inputAppCost.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "rec"; pattern.replacing = sumRec.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "health"; pattern.replacing = inputNumDaysHealth.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "passport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "get"; pattern.replacing = PFOrgGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "date"; pattern.replacing = PFDateGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "fullAllName"; pattern.replacing = inputAppFullName.Text; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Договор.dot", replacePatterns);
            }
            if (acceptCheckBox.Checked) {
                List<ReplacePattern> replacePatterns = new List<ReplacePattern>();
                ReplacePattern pattern;

                pattern = new ReplacePattern(); pattern.replaced = "fullname"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthday"; pattern.replacing = PFBirthday; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "passport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "get"; pattern.replacing = PFOrgGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "date"; pattern.replacing = PFDateGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthplace"; pattern.replacing = PFBirthPlace; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Письменное согласие.dot", replacePatterns);
            }
            if (orderCheckBox.Checked) {
                fillDocumentExcel1(@"c:\АСУ-ТУР\Платёжное поручение.xls");
            }
            if (tourCheckBox.Checked) {
                List<ReplacePattern> replacePatterns = new List<ReplacePattern>();
                ReplacePattern pattern;
                pattern = new ReplacePattern(); pattern.replaced = "contract"; pattern.replacing = inputNumContract.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "sanat"; pattern.replacing = inputAppWay.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "name"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "Org"; pattern.replacing = inputAppNameOrgOrPF.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "arrived"; pattern.replacing = inputAppStartTour.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "days"; pattern.replacing = inputNumDays.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "food"; pattern.replacing = inputFood.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "cost"; pattern.replacing = inputAppCost.Text; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Путёвка.dot", replacePatterns);
            }
            if (contractTourProductCheckBox1.Checked) {
                List<ReplacePattern> replacePatterns = new List<ReplacePattern>();
                ReplacePattern pattern;
                pattern = new ReplacePattern(); pattern.replaced = "fullname"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "route"; pattern.replacing = inputRoute.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "starttour"; pattern.replacing = inputAppStartTour.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "food"; pattern.replacing = inputFood.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "transfer"; pattern.replacing = inputTransfer.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "ticket"; pattern.replacing = inputTick.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "insurance"; pattern.replacing = inputIns.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "cost"; pattern.replacing = inputAppCost.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "sernumpassport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "organddategetpassport"; pattern.replacing = PFOrgGetRussPassport + "  от  " + PFDateGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthplace"; pattern.replacing = PFBirthPlace; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthday"; pattern.replacing = PFBirthday; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "fullAllName"; pattern.replacing = inputAppFullName.Text; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Договор зарубежный.dot", replacePatterns);
            }
            if (contractPersonalDatacheckBox1.Checked) {
                List<ReplacePattern> replacePatterns = new List<ReplacePattern>();
                ReplacePattern pattern;

                pattern = new ReplacePattern(); pattern.replaced = "fullname"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "country"; pattern.replacing = inputAppCountry.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "starttour"; pattern.replacing = inputAppStartTour.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "food"; pattern.replacing = inputFood.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "transfer"; pattern.replacing = inputTransfer.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "ticket"; pattern.replacing = inputTick.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "insurance"; pattern.replacing = inputIns.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "cost"; pattern.replacing = inputAppCost.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "way"; pattern.replacing = inputAppWay.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "numnights"; pattern.replacing = inputNumNights.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "tourprogram"; pattern.replacing = inputTourProgram.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "visa"; pattern.replacing = inputVisa.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthday"; pattern.replacing = PFBirthday; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "fullengname"; pattern.replacing = PFFullEngName; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "sernumengpassport"; pattern.replacing = PFNumAndSerForeignPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "dateendpassport"; pattern.replacing = PFDateEndForeignPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "sernumrusspassport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "place"; pattern.replacing = PFBirthPlace; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "phone"; pattern.replacing = PFPhone; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "orggetrusspassport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "dategetrusspassport"; pattern.replacing = PFBirthPlace; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Договор реализации.dot", replacePatterns);

            }
            if (cashOrderCheckBox1.Checked) {
                fillDocumentExcel2(@"c:\АСУ-Тур\Приходный ордер.xls");
            }
            if (DebOrderCheckBox1.Checked) {
                fillDocumentExcel3(@"c:\АСУ-Тур\Расходный ордер.xls");
            }
        }
Esempio n. 12
0
        public static string Replace(this string src, ReplacePattern pattern)
        {
            ReplaceType replaceType;

            // find Joker ('*') in ``From``
            var jokerIndex = -1;

            for (var i = 0; i < pattern.From.Length; i++)
            {
                if (pattern.From[i] != Joker)
                {
                    continue;
                }
                if (jokerIndex == -1)
                {
                    jokerIndex = i;
                }
                else
                {
                    throw new Exception($"There is two '{Joker}' in From");
                }
            }

            // find '*' or '<' and '>' in ``To``
            var numStartFlagIndex = -1;
            var numEndFlagIndex   = -1;
            var joker2Index       = -1;

            for (var i = 0; i < pattern.To.Length; i++)
            {
                var ch = pattern.To[i];
                switch (ch)
                {
                case Joker:
                    if (joker2Index == -1)
                    {
                        joker2Index = i;
                    }
                    else
                    {
                        throw new Exception($"There is two '{Joker}' in From");
                    }
                    break;

                case NumStartFlag:
                    if (numStartFlagIndex == -1)
                    {
                        numStartFlagIndex = i;
                    }
                    else
                    {
                        throw new Exception($"There is two '{NumStartFlag}' in From");
                    }
                    break;

                case NumEndFlag:
                    if (numEndFlagIndex == -1)
                    {
                        numEndFlagIndex = i;
                    }
                    else
                    {
                        throw new Exception($"There is two '{NumEndFlag}' in From");
                    }
                    break;
                }
            }

            //set ``replaceType``
            if (jokerIndex == -1)
            {
                replaceType = ReplaceType.Normal;
            }
            else
            {
                if (joker2Index != -1)
                {
                    replaceType = ReplaceType.Algo;
                }
                else if (numStartFlagIndex != -1 && numEndFlagIndex != -1)
                {
                    replaceType = ReplaceType.NumericAlgo;
                }
                else
                {
                    throw new Exception("Unknown Replace Type.");
                }
            }

            //validations
            switch (replaceType)
            {
            case ReplaceType.Normal:
                if (numStartFlagIndex != -1)
                {
                    throw new Exception($"There is a '{NumStartFlag}' in Normal replace");
                }
                if (numEndFlagIndex != -1)
                {
                    throw new Exception($"There is a '{NumEndFlag}' in Normal replace");
                }
                if (joker2Index != -1)
                {
                    throw new Exception($"There is a '{Joker}' in Normal replace");
                }
                //impossible
                if (jokerIndex != -1)
                {
                    throw new Exception($"There is a '{Joker}' in Normal replace");
                }
                break;

            case ReplaceType.Algo:
                if (numStartFlagIndex != -1)
                {
                    throw new Exception($"There is a '{numStartFlagIndex}' in Algo replace");
                }
                if (numEndFlagIndex != -1)
                {
                    throw new Exception($"There is a '{numEndFlagIndex}' in Algo replace");
                }
                //impossible
                if (jokerIndex == -1)
                {
                    throw new Exception($"There is no '{Joker}' in 'from' of Algo replace");
                }
                if (joker2Index == -1)
                {
                    throw new Exception($"There is no '{Joker}' in 'to' of Algo replace");
                }
                break;

            case ReplaceType.NumericAlgo:
                if (numStartFlagIndex > numEndFlagIndex)
                {
                    throw new Exception($"'{NumStartFlag}' must be after '{NumEndFlag}'");
                }
                //impossible
                if (numStartFlagIndex == -1)
                {
                    throw new Exception($"There is no '{numStartFlagIndex}' in NumericAlgi replace");
                }
                if (numEndFlagIndex == -1)
                {
                    throw new Exception($"There is no '{numEndFlagIndex}' in NumericAlgo replace");
                }
                if (jokerIndex == -1)
                {
                    throw new Exception($"There is no '{Joker}' in 'from' of NumericAlgo replace");
                }
                if (joker2Index != -1)
                {
                    throw new Exception($"There is a '{Joker}' in 'to' of NumericAlgo replace");
                }
                break;

            default:
                throw new Exception("!!!");
            }

            switch (replaceType)
            {
            case ReplaceType.Normal:
                return(ReplaceNormal(src, pattern));

            case ReplaceType.Algo:
                return(ReplaceAlgo(src, jokerIndex, pattern));

            case ReplaceType.NumericAlgo:
                return(ReplaceNumericAlgo(src, numStartFlagIndex, numEndFlagIndex, pattern));

            default:
                throw new Exception("what the phase dude? :/");
            }
        }
Esempio n. 13
0
        private void button1_Click(object sender, EventArgs e)
        {
            int i = inputAppFullName.Lines.Length;

            string[] text = inputAppFullName.Text.Split(';');
            if (text[0] != null)
            {
                string s = text[0];


                string query6 = "select  PFFullEngName, PFBirthday, PFNumAndSerRussPassport, PFDateGetRussPassport,  PFOrgGetRussPassport, PFNumAndSerForeignPassport, PFDateGetForeignPassport, PFDateEndForeignPassport,PFOrgGetForeignPassport, PFBirthPlace, PFPhone from PhisicalFace where (PFFullRussName = \'" + s + "\')";

                SqlDataReader data3   = Database.executeQuery(query6);
                object[]      fields3 = new object[11];
                data3.Read();
                data3.GetValues(fields3);
                data3.Close();

                string PFFullEngName = fields3[0].ToString(), PFBirthday = fields3[1].ToString(), PFNumAndSerRussPassport = fields3[2].ToString();
                string PFDateGetRussPassport = fields3[3].ToString(), PFOrgGetRussPassport = fields3[4].ToString(), PFNumAndSerForeignPassport = fields3[5].ToString();
                string PFDateGetForeignPassport = fields3[6].ToString(), PFDateEndForeignPassport = fields3[7].ToString();
                string PFOrgGetForeignPassport = fields3[8].ToString(), PFBirthPlace = fields3[9].ToString(), PFPhone = fields3[10].ToString();

                fillDocument2(PFFullEngName, PFBirthday, PFNumAndSerRussPassport, PFDateGetRussPassport, PFOrgGetRussPassport, PFNumAndSerForeignPassport, PFDateGetForeignPassport, PFDateEndForeignPassport, PFOrgGetForeignPassport, PFBirthPlace, PFPhone);
            }



            string        query5 = "select JFNameOrg, JFCargoCarrier from JuridicalFace where (JFFullNameOrg =\'" + inputAppNameOrgOrPF.Text + "\')";
            SqlDataReader data5  = Database.executeQuery(query5);

            object[] fields5 = new object[2];
            data5.Read();
            data5.GetValues(fields5);
            data5.Close();

            string JFNameOrg = fields5[0].ToString(), JFCargoCarrier = fields5[1].ToString();

            fillDocument3(JFNameOrg, JFCargoCarrier);

            /*if (text[1] != null)
             * {
             * string h = text[1];
             * string query1 = "select  PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport from PhisicalFace where (PFFullRussName = \'" + h + "\')";
             *
             * SqlDataReader data1 = Database.executeQuery(query1);
             * object[] fields1 = new object[4];
             * data1.Read();
             * data1.GetValues(fields1);
             * data1.Close();
             *
             * string PFFullEngName = fields1[0].ToString(), PFBirthday = fields1[1].ToString(),  PFNumAndSerForeignPassport = fields1[2].ToString();
             * string PFDateEndForeignPassport = fields1[3].ToString();
             *
             * fillDocumentH(PFFullEngName, PFBirthday,  PFNumAndSerForeignPassport, PFDateEndForeignPassport);
             * }
             * if (text[2] != null)
             * {
             * string f = text[2];
             * string query2 = "select  PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport from PhisicalFace where (PFFullRussName = \'" + f + "\')";
             *
             * SqlDataReader data2 = Database.executeQuery(query2);
             * object[] fields2 = new object[4];
             * data2.Read();
             * data2.GetValues(fields2);
             * data2.Close();
             *
             * string PFFullEngName = fields2[0].ToString(), PFBirthday = fields2[1].ToString(), PFNumAndSerForeignPassport = fields2[2].ToString();
             * string PFDateEndForeignPassport = fields2[3].ToString();
             *
             * fillDocumentF(PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport);
             * }
             * if (text[3] != null)
             * {
             * string k = text[3];
             * string query4 = "select  PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport from PhisicalFace where (PFFullRussName = \'" + k + "\')";
             *
             * SqlDataReader data4 = Database.executeQuery(query4);
             * object[] fields4 = new object[4];
             * data4.Read();
             * data4.GetValues(fields4);
             * data4.Close();
             *
             * string PFFullEngName = fields4[0].ToString(), PFBirthday = fields4[1].ToString(), PFNumAndSerForeignPassport = fields4[2].ToString();
             * string PFDateEndForeignPassport = fields4[3].ToString();
             *
             * fillDocumentK(PFFullEngName, PFBirthday, PFNumAndSerForeignPassport, PFDateEndForeignPassport);
             * }*/



            if (actCheckBox.Checked)
            {
                fillDocumentExcel(@"c:\АСУ-Тур\Акт реализации.xls");
            }
            if (appCheckBox.Checked)
            {
                List <ReplacePattern> replacePatterns = new List <ReplacePattern>();
                ReplacePattern        pattern;
                pattern = new ReplacePattern(); pattern.replaced = "Sanat"; pattern.replacing = inputAppWay.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "name"; pattern.replacing = text[0]; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "arrived"; pattern.replacing = inputAppStartTour.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "num"; pattern.replacing = inputNumDays.Text; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Заявка на бронирование1.dot", replacePatterns);
            }
            if (contractCheckBox.Checked)
            {
                List <ReplacePattern> replacePatterns = new List <ReplacePattern>();
                ReplacePattern        pattern;
                pattern = new ReplacePattern(); pattern.replaced = "contract"; pattern.replacing = inputNumContract.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "way"; pattern.replacing = "Санаторий  " + inputAppWay.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "starttour"; pattern.replacing = inputAppStartTour.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "fullname"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "food"; pattern.replacing = inputFood.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "numdays"; pattern.replacing = inputNumDays.Text; pattern.how = 1; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "cost"; pattern.replacing = inputAppCost.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "rec"; pattern.replacing = sumRec.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "health"; pattern.replacing = inputNumDaysHealth.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "passport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "get"; pattern.replacing = PFOrgGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "date"; pattern.replacing = PFDateGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "fullAllName"; pattern.replacing = inputAppFullName.Text; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Договор.dot", replacePatterns);
            }
            if (acceptCheckBox.Checked)
            {
                List <ReplacePattern> replacePatterns = new List <ReplacePattern>();
                ReplacePattern        pattern;


                pattern = new ReplacePattern(); pattern.replaced = "fullname"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthday"; pattern.replacing = PFBirthday; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "passport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "get"; pattern.replacing = PFOrgGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "date"; pattern.replacing = PFDateGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthplace"; pattern.replacing = PFBirthPlace; pattern.how = 0; replacePatterns.Add(pattern);


                fillDocument(@"c:\АСУ-Тур\Письменное согласие.dot", replacePatterns);
            }
            if (orderCheckBox.Checked)
            {
                fillDocumentExcel1(@"c:\АСУ-ТУР\Платёжное поручение.xls");
            }
            if (tourCheckBox.Checked)
            {
                List <ReplacePattern> replacePatterns = new List <ReplacePattern>();
                ReplacePattern        pattern;
                pattern = new ReplacePattern(); pattern.replaced = "contract"; pattern.replacing = inputNumContract.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "sanat"; pattern.replacing = inputAppWay.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "name"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "Org"; pattern.replacing = inputAppNameOrgOrPF.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "arrived"; pattern.replacing = inputAppStartTour.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "days"; pattern.replacing = inputNumDays.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "food"; pattern.replacing = inputFood.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "cost"; pattern.replacing = inputAppCost.Text; pattern.how = 0; replacePatterns.Add(pattern);

                fillDocument(@"c:\АСУ-Тур\Путёвка.dot", replacePatterns);
            }
            if (contractTourProductCheckBox1.Checked)
            {
                List <ReplacePattern> replacePatterns = new List <ReplacePattern>();
                ReplacePattern        pattern;
                pattern = new ReplacePattern(); pattern.replaced = "fullname"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "route"; pattern.replacing = inputRoute.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "starttour"; pattern.replacing = inputAppStartTour.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "food"; pattern.replacing = inputFood.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "transfer"; pattern.replacing = inputTransfer.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "ticket"; pattern.replacing = inputTick.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "insurance"; pattern.replacing = inputIns.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "cost"; pattern.replacing = inputAppCost.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "sernumpassport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "organddategetpassport"; pattern.replacing = PFOrgGetRussPassport + "  от  " + PFDateGetRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthplace"; pattern.replacing = PFBirthPlace; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthday"; pattern.replacing = PFBirthday; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "fullAllName"; pattern.replacing = inputAppFullName.Text; pattern.how = 0; replacePatterns.Add(pattern);


                fillDocument(@"c:\АСУ-Тур\Договор зарубежный.dot", replacePatterns);
            }
            if (contractPersonalDatacheckBox1.Checked)
            {
                List <ReplacePattern> replacePatterns = new List <ReplacePattern>();
                ReplacePattern        pattern;

                pattern = new ReplacePattern(); pattern.replaced = "fullname"; pattern.replacing = text[0]; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "country"; pattern.replacing = inputAppCountry.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "starttour"; pattern.replacing = inputAppStartTour.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "category"; pattern.replacing = inputAppNumberAndCategory.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "food"; pattern.replacing = inputFood.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "transfer"; pattern.replacing = inputTransfer.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "ticket"; pattern.replacing = inputTick.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "insurance"; pattern.replacing = inputIns.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "cost"; pattern.replacing = inputAppCost.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "way"; pattern.replacing = inputAppWay.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "numnights"; pattern.replacing = inputNumNights.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "tourprogram"; pattern.replacing = inputTourProgram.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "visa"; pattern.replacing = inputVisa.Text; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "birthday"; pattern.replacing = PFBirthday; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "fullengname"; pattern.replacing = PFFullEngName; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "sernumengpassport"; pattern.replacing = PFNumAndSerForeignPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "dateendpassport"; pattern.replacing = PFDateEndForeignPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "sernumrusspassport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "place"; pattern.replacing = PFBirthPlace; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "phone"; pattern.replacing = PFPhone; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "orggetrusspassport"; pattern.replacing = PFNumAndSerRussPassport; pattern.how = 0; replacePatterns.Add(pattern);
                pattern = new ReplacePattern(); pattern.replaced = "dategetrusspassport"; pattern.replacing = PFBirthPlace; pattern.how = 0; replacePatterns.Add(pattern);


                fillDocument(@"c:\АСУ-Тур\Договор реализации.dot", replacePatterns);
            }
            if (cashOrderCheckBox1.Checked)
            {
                fillDocumentExcel2(@"c:\АСУ-Тур\Приходный ордер.xls");
            }
            if (DebOrderCheckBox1.Checked)
            {
                fillDocumentExcel3(@"c:\АСУ-Тур\Расходный ордер.xls");
            }
        }