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("Введите цифры!", "ОШИБКА");
}
}
