private void Button_Click(object sender, RoutedEventArgs e) { Window5 a = new Window5(); if (ch2.IsChecked == true) { a.Tag = "true"; } if (ch2.IsChecked == false) { a.Tag = "false"; } a.Show(); this.Close(); }
private async void Button_Click_1(object sender, RoutedEventArgs e) { if (combo.Text == "") { combo.Background = Brushes.Red; combo.Opacity = 0.2; return; } if (label_time.Text == "") { label_time.Background = Brushes.Red; label_time.Opacity = 0.4; return; } if (textBox_Copy.Text == "") { textBox_Copy.Background = Brushes.Red; textBox_Copy.Opacity = 0.4; return; } if (textBox_Copyy.Text == "") { textBox_Copyy.Background = Brushes.Red; textBox_Copyy.Opacity = 0.4; return; } if (textBox_Copy3.Text == "0") { textBox_Copy3.Background = Brushes.Red; textBox_Copy3.Opacity = 0.4; return; } if (textBox_Copy1.Text == "") { textBox_Copy1.Background = Brushes.Red; textBox_Copy1.Opacity = 0.4; return; } if (textBox_Copy2.Text == "") { textBox_Copy2.Background = Brushes.Red; textBox_Copy2.Opacity = 0.4; return; } SqlConnection = new OleDbConnection(connectString); SqlConnection.Open(); OleDbDataReader sqlReader = null; OleDbCommand command1 = new OleDbCommand("SELECT * FROM [Салон]", SqlConnection); sqlReader = command1.ExecuteReader(); while (sqlReader.Read()) { if ((textBox_Copy.Text + ":" + textBox_Copyy.Text + " " + label_time.Text) == Convert.ToString(sqlReader["Дата"])) { MessageBox.Show("Это время занято другой записью"); return; } } command1 = new OleDbCommand("INSERT INTO [Салон] (Клиент,Телефон,Мастер,Салон,Услуга,Цена,Дата)VALUES(@1,@2,@3,@4,@5,@6,@7)", SqlConnection); command1.Parameters.AddWithValue("1", textBox_Copy1.Text); command1.Parameters.AddWithValue("2", textBox_Copy2.Text); command1.Parameters.AddWithValue("3", combo.Text); if (this.Tag.ToString() == "false") { command1.Parameters.AddWithValue("4", false); } else { command1.Parameters.AddWithValue("4", true); } string for_str = ""; for (int i = 0; i < strArr.Count(); i++) { if (strArr[i] != null) { for_str += strArr[i] + "/"; } } command1.Parameters.AddWithValue("5", for_str); command1.Parameters.AddWithValue("6", Convert.ToInt32(textBox_Copy3.Text)); command1.Parameters.AddWithValue("7", textBox_Copy.Text + ":" + textBox_Copyy.Text + " " + label_time.Text); await command1.ExecuteNonQueryAsync(); MessageBox.Show("Запись успешно добалена!"); Window5 a = new Window5(); a.Tag = this.Tag; a.Show(); this.Close(); }