private void Button1_Click(object sender, RoutedEventArgs e) { try { // создание строки подключения к БД connectionString = new ConnectionStringBuilder(); // проверка способа авторизации в базе данных if (radioButton2.IsChecked == true) { // sql - авторизация if (textBox1.Text != "" && textBox2.Text != "" && passBox.Password != "") { connectionString.DataSource = textBox1.Text + @"\SQLEXPRESS"; connectionString.InitialCatalog = "ConsultDB"; connectionString.IntegratedSecurity = false; connectionString.UserID = textBox2.Text; connectionString.Password = passBox.Password; } else { return; } } else { connectionString.DataSource = @".\SQLEXPRESS"; connectionString.InitialCatalog = "ConsultDB"; connectionString.IntegratedSecurity = true; } // проверка авторизации, подключение или создание базы using (ConnectDB db = new ConnectDB(connectionString.ConnectionString)) { var room = db.Rooms.FirstOrDefault(); } if (radioButton3.IsChecked == true) { // заполнение первичными данными таблицы Rooms using (ConnectDB db = new ConnectDB(connectionString.ConnectionString)) { Room room1 = new Room { NumberRoom = 1, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room2 = new Room { NumberRoom = 2, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room3 = new Room { NumberRoom = 3, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room4 = new Room { NumberRoom = 4, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room5 = new Room { NumberRoom = 5, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room6 = new Room { NumberRoom = 6, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room7 = new Room { NumberRoom = 7, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room8 = new Room { NumberRoom = 8, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room9 = new Room { NumberRoom = 9, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room10 = new Room { NumberRoom = 10, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room11 = new Room { NumberRoom = 11, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room12 = new Room { NumberRoom = 12, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room13 = new Room { NumberRoom = 13, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room14 = new Room { NumberRoom = 14, Roominess = 18, IsAvailable = true, ToArchive = false }; Room room15 = new Room { NumberRoom = 15, Roominess = 18, IsAvailable = true, ToArchive = false }; db.Rooms.Add(room1); db.Rooms.Add(room2); db.Rooms.Add(room3); db.Rooms.Add(room4); db.Rooms.Add(room5); db.Rooms.Add(room6); db.Rooms.Add(room7); db.Rooms.Add(room8); db.Rooms.Add(room9); db.Rooms.Add(room10); db.Rooms.Add(room11); db.Rooms.Add(room12); db.Rooms.Add(room13); db.Rooms.Add(room14); db.Rooms.Add(room15); db.SaveChanges(); } } // сериализация строки подключения BinaryFormatter formatter = new BinaryFormatter(); string txt = ""; using (MemoryStream ms = new MemoryStream()) { formatter.Serialize(ms, connectionString); byte[] brr = ms.ToArray(); txt = Encoding.ASCII.GetString(brr); } // шифрование и запись в файл сериализованной строки подключения using (Aes myAes = Aes.Create()) { byte[] encrypted = EncryptStringToBytes_Aes(txt, myAes.Key, myAes.IV); byte[] full = new byte[48 + encrypted.Length]; Array.Copy(myAes.Key, 0, full, 0, 32); Array.Copy(myAes.IV, 0, full, 32, 16); Array.Copy(encrypted, 0, full, 48, encrypted.Length); using (BinaryWriter bw = new BinaryWriter(File.Open("config.dat", FileMode.Create))) { bw.Write(full); } } this.DialogResult = true; } catch (Exception ex) { MessageBox.Show("Can not connect to the Data Base \n" + ex.Message + "\nEnter correct login and password"); } }