예제 #1
0
        private void ListView_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (e.AddedItems.Count > 0 && e.AddedItems[0] is SearchPersonToAssignCard person)
            {
                var accountNumber = TextPopupWindow.Prompt("Номер карты", "Внимание!");
                if (accountNumber == null || accountNumber.Length != 16 || !long.TryParse(accountNumber, out _))
                {
                    return;
                }

                var sql = $"INSERT INTO person_card (passport_serial, account_number) VALUES ('{person.PassportSerial}', '{accountNumber}')";
                using (var sqlcmd = new SqlCommandExecutor(sql))
                    if (sqlcmd.TryExecuteScalar(out _))
                    {
                        WatermarkTextBox_TextChanged(sender, null);
                        ViewModel.AssigmentHistory.Add(new AssigmentHistory()
                        {
                            PassportSerial = person.PassportSerial,
                            LastName       = person.LastName,
                            FirstName      = person.FirstName,
                            Patronymic     = person.Patronymic,
                            BirthDate      = person.BirthDate,
                            AccountNumber  = accountNumber.Substring(7, 8)
                        });
                    }
            }
        }
 internal void ShowDefTypeCounts(object obj)
 {
     try
     {
         var ruleAppDef = this.RuleApplicationService.RuleApplicationDef;
         var window     = new TextPopupWindow();
         window.Populate("Def Type Usage", ruleAppDef.GetDefTypeCountSummary());
         window.Show();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
예제 #3
0
        // Изменение исходящего команды
        private void MenuItem_ChangeOutgoing_OnClick(object sender, RoutedEventArgs e)
        {
            var outgoing = TextPopupWindow.Prompt("Введи номер нового исходника", "Внимание!");

            if (outgoing == null)
            {
                return;
            }
            var newOutgoing = int.Parse(outgoing);

            using (var sqlcmd = new SqlCommandExecutor($"EXEC pr_TransferTeam \'{ViewModel.SelectedTeam.Inventory}\', \'{newOutgoing}\'"))
                if (sqlcmd.TryExecuteNonQuery(out _))
                {
                    ViewModel.SelectedTeam.Inventory = newOutgoing.ToString();
                }

            Button_RefreshTeamList_Click(sender, e);
        }