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); } }
// Изменение исходящего команды 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); }