Esempio n. 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)
                        });
                    }
            }
        }