private void AddNewNumBtn(object sender, RoutedEventArgs e) { int uniqueID = 0; if (MainWindow.studInfo.Count > 0) { uniqueID = MainWindow.phoneInfo[MainWindow.phoneInfo.Count - 1].Id + 1; } string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=phones;Integrated Security=True"; string sqlExpression = "INSERT INTO phoneTable(Id, Id_Stud, Id_Type, Phone ) VALUES (" + uniqueID + ", " + idOfStud + ", 1, 0)"; MessageBox.Show(sqlExpression); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); int number = command.ExecuteNonQuery(); MessageBox.Show("Добавлено объектов: " + Convert.ToString(number)); MainWindow.PhoneInfo phonik = new MainWindow.PhoneInfo(); phonik.Id = uniqueID; phonik.Id_Stud = idOfStud; phonik.Id_Type = 1; phonik.Phone = 0; MainWindow.phoneInfo.Add(phonik); //InitializeComponent(); LoadPrivateInfo(); // IMPORTANT THING TO LOAD THIS AFTER INIT and nice kostilino lol } }
private void AddNumBtn(object sender, RoutedEventArgs e) { string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=phones;Integrated Security=True"; try { long phoneNumber = Convert.ToInt64(txphonenum.Text); //номерок if (oldPhoneNumber == phoneNumber) { MessageBox.Show("Этот номер уже занят!", "ПРЕДУПРЕЖДЕНИЕ"); } int typePhone = 1; //тип телефона if (typeBox.Text == "Домашний") { typePhone = 2; } string sqlExpression = "INSERT INTO dbo.phoneTable(Id, Id_Stud, Id_Type, Phone ) VALUES (" + uniqueID + ", " + studId + ", " + typePhone + ", " + phoneNumber + ")"; MessageBox.Show(sqlExpression); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(sqlExpression, connection); int number = command.ExecuteNonQuery(); MessageBox.Show("Добавлено объектов: " + Convert.ToString(number)); MainWindow.PhoneInfo phonik = new MainWindow.PhoneInfo(); phonik.Id = studId; phonik.Id_Stud = studId; phonik.Id_Type = 1; phonik.Phone = 1488; uniqueID = uniqueID + 1; // увеличиваем айдишник, для уникальности oldPhoneNumber = phoneNumber; //фейк проверка, можно просто запросиком чекать, но МНЕ ЛЕНЬ МНЕ ЛЕНЬ, ну а че могу себе позволить } } catch (FormatException) { MessageBox.Show("Введите цифры!", "ОШИБКА"); } }