//private void PackIcon_MouseDoubleClick(object sender, MouseButtonEventArgs e) //{ // Hide(); // //new InsertMovie(movie).ShowDialog(); // ShowDialog(); //} private void Actor(object sender, RoutedEventArgs e) { try { //if (Validator.ValidTextBoxes(this.Name.Text, this.CinemaName.Text)) //{ using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("InsertActorMovie", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter name = new SqlParameter(); name.ParameterName = "@name"; name.Value = this.Name1.Text; name.Value = this.Name2.Text; name.Value = this.Name3.Text; name.Value = this.Name4.Text; name.Value = this.Name5.Text; //int.Parse(CinemaName.Text); SqlParameter cinema = new SqlParameter(); cinema.ParameterName = "@cinema"; cinema.Value = this.SurName1.Text; cmd.Parameters.Add(name); cmd.Parameters.Add(cinema); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = System.Data.SqlDbType.Bit; rc.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Inserting completed successfully!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Inserting error"); } } //} //else MessageBox.Show("Enter data!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void DeleteCinema(object sender, RoutedEventArgs e) { try { if (Validator.ValidTextBoxes(this.CinemaName.Text, this.Region.Text)) { using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("DeleteCinema", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter name = new SqlParameter(); name.ParameterName = "@name"; name.Value = this.CinemaName.Text; SqlParameter region = new SqlParameter(); region.ParameterName = "@region"; region.Value = this.Region.Text; cmd.Parameters.Add(name); cmd.Parameters.Add(region); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = System.Data.SqlDbType.Bit; rc.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Удаление произошло успешно!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Ошибка удаления. Проверьте введённые данные."); } } } else { MessageBox.Show("Введите данные!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void BindComboBox(ComboBox comboBoxName) { SqlConnection cn = Connector.GetConnection(); SqlDataAdapter da = new SqlDataAdapter("SELECT NAME FROM CINEMA", cn); DataSet ds = new DataSet(); da.Fill(ds, "CINEMA"); Name.ItemsSource = ds.Tables[0].DefaultView; Name.DisplayMemberPath = ds.Tables[0].Columns["NAME"].ToString(); }
public void BindComboBoxGenre(ComboBox comboBoxName1) { SqlConnection cn = Connector.GetConnection(); SqlDataAdapter da = new SqlDataAdapter("Select NAME FROM GENRE", cn); DataSet ds = new DataSet(); da.Fill(ds, "GENRE"); Genre.ItemsSource = ds.Tables[0].DefaultView; Genre.DisplayMemberPath = ds.Tables[0].Columns["NAME"].ToString(); }
public void BindComboBoxCountry(ComboBox comboBoxName) { SqlConnection cn = Connector.GetConnection(); SqlDataAdapter da = new SqlDataAdapter("Select NAME FROM COUNTRY", cn); DataSet ds = new DataSet(); da.Fill(ds, "COUNTRY"); Country.ItemsSource = ds.Tables[0].DefaultView; Country.DisplayMemberPath = ds.Tables[0].Columns["NAME"].ToString(); }
public void BindComboBoxMovieRelease(ComboBox comboBoxName) { SqlConnection cn = Connector.GetConnection(); SqlDataAdapter da = new SqlDataAdapter("SELECT RELEASE FROM MOVIE", cn); DataSet ds = new DataSet(); da.Fill(ds, "MOVIE"); Release.ItemsSource = ds.Tables[0].DefaultView; Release.DisplayMemberPath = ds.Tables[0].Columns["RELEASE"].ToString(); }
public void BindComboBoxActorSurname(ComboBox comboBoxName) { SqlConnection cn = Connector.GetConnection(); SqlDataAdapter da = new SqlDataAdapter("SELECT SURNAME FROM ACTOR", cn); DataSet ds = new DataSet(); da.Fill(ds, "ACTOR"); Actor_surname.ItemsSource = ds.Tables[0].DefaultView; Actor_surname.DisplayMemberPath = ds.Tables[0].Columns["SURNAME"].ToString(); }
private void AddCinemaFromXLMFile(object sender, RoutedEventArgs e) { try { using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("ImportFromXML", cn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter path = new SqlParameter(); path.ParameterName = "@path"; path.SqlDbType = SqlDbType.NVarChar; path.Size = 256; path.Value = this.FileName; cmd.Parameters.Add(path); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = SqlDbType.Bit; rc.Direction = ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Импорт из XML произошёл успешно!"); } else { MessageBox.Show("Ошибка импорта из XML!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void OnExportToXML(object sender, RoutedEventArgs e) { try { using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("ExportToXML", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@path", this.FileNameExport); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = SqlDbType.Bit; rc.Direction = ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Экспорт в XML произошёл успешно!"); } else { MessageBox.Show("Ошибка экспорта в XML!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Update(object sender, RoutedEventArgs e) { try { using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("UpdateCinema", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter check2 = new SqlParameter(); check2.ParameterName = "@check2"; check2.Value = this.check2.IsChecked == true ? true : false; SqlParameter check3 = new SqlParameter(); check3.ParameterName = "@check3"; check3.Value = this.check3.IsChecked == true ? true : false; SqlParameter check4 = new SqlParameter(); check4.ParameterName = "@check4"; check4.Value = this.check4.IsChecked == true ? true : false; SqlParameter check5 = new SqlParameter(); check5.ParameterName = "@check5"; check5.Value = this.check5.IsChecked == true ? true : false; SqlParameter check6 = new SqlParameter(); check6.ParameterName = "@check6"; check6.Value = this.check6.IsChecked == true ? true : false; SqlParameter name = new SqlParameter(); name.ParameterName = "@name"; name.Value = this.Name.Text; SqlParameter address = new SqlParameter(); address.ParameterName = "@address"; address.Value = this.Address.Text; SqlParameter region = new SqlParameter(); region.ParameterName = "@region"; region.Value = this.Region.Text; SqlParameter website = new SqlParameter(); website.ParameterName = "@website"; website.Value = this.Website.Text; SqlParameter ticketoffice = new SqlParameter(); ticketoffice.ParameterName = "@ticketoffice"; ticketoffice.Value = this.TicketOffice.Text; SqlParameter halls = new SqlParameter(); halls.ParameterName = "@halls"; halls.Value = this.Halls.Text; cmd.Parameters.Add(name); cmd.Parameters.Add(address); cmd.Parameters.Add(region); cmd.Parameters.Add(website); cmd.Parameters.Add(ticketoffice); cmd.Parameters.Add(halls); cmd.Parameters.Add(check2); cmd.Parameters.Add(check3); cmd.Parameters.Add(check4); cmd.Parameters.Add(check5); cmd.Parameters.Add(check6); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = System.Data.SqlDbType.Bit; rc.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Обновление произошло успешно!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Ошибка обновления!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Update(object sender, RoutedEventArgs e) { try { using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("UpdateMovie", cn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter check2 = new SqlParameter(); check2.ParameterName = "@check2"; check2.Value = this.check2.IsChecked == true ? true : false; SqlParameter check3 = new SqlParameter(); check3.ParameterName = "@check3"; check3.Value = this.check3.IsChecked == true ? true : false; SqlParameter check4 = new SqlParameter(); check4.ParameterName = "@check4"; check4.Value = this.check4.IsChecked == true ? true : false; SqlParameter check5 = new SqlParameter(); check5.ParameterName = "@check5"; check5.Value = this.check5.IsChecked == true ? true : false; SqlParameter check6 = new SqlParameter(); check6.ParameterName = "@check6"; check6.Value = this.check6.IsChecked == true ? true : false; SqlParameter check7 = new SqlParameter(); check7.ParameterName = "@check7"; check7.Value = this.check7.IsChecked == true ? true : false; SqlParameter check8 = new SqlParameter(); check8.ParameterName = "@check8"; check8.Value = this.check8.IsChecked == true ? true : false; SqlParameter check9 = new SqlParameter(); check9.ParameterName = "@check9"; check9.Value = this.check9.IsChecked == true ? true : false; SqlParameter name = new SqlParameter(); name.ParameterName = "@name"; name.Value = this.Name.Text; SqlParameter surname = new SqlParameter(); surname.ParameterName = "@release"; surname.Value = this.pick.SelectedDate; SqlParameter country = new SqlParameter(); country.ParameterName = "@country"; country.Value = this.Country.Text; SqlParameter genre = new SqlParameter(); genre.ParameterName = "@genre"; genre.Value = this.Genre.Text; SqlParameter time = new SqlParameter(); time.ParameterName = "@runningtime"; time.Value = this.Running_time.Text; SqlParameter directorname = new SqlParameter(); directorname.ParameterName = "@directorname"; directorname.Value = this.Director_name.Text; SqlParameter directorsurname = new SqlParameter(); directorsurname.ParameterName = "@directorsurname"; directorsurname.Value = this.Director_surname.Text; SqlParameter screenplay = new SqlParameter(); screenplay.ParameterName = "@screenplay"; screenplay.Value = this.Screenplay.Text; SqlParameter composer = new SqlParameter(); composer.ParameterName = "@composer"; composer.Value = this.Composer.Text; SqlParameter actorname = new SqlParameter(); actorname.ParameterName = "@actorname"; actorname.Value = this.Actor_name.Text; SqlParameter actorsurname = new SqlParameter(); actorsurname.ParameterName = "@actorsurname"; actorsurname.Value = this.Actor_surname.Text; SqlParameter plot = new SqlParameter(); plot.ParameterName = "@plot"; plot.Value = this.Plot.Text; cmd.Parameters.Add(name); cmd.Parameters.Add(surname); cmd.Parameters.Add(country); cmd.Parameters.Add(genre); cmd.Parameters.Add(time); cmd.Parameters.Add(directorname); cmd.Parameters.Add(directorsurname); cmd.Parameters.Add(screenplay); cmd.Parameters.Add(composer); cmd.Parameters.Add(actorname); cmd.Parameters.Add(actorsurname); cmd.Parameters.Add(plot); cmd.Parameters.Add(check2); cmd.Parameters.Add(check3); cmd.Parameters.Add(check4); cmd.Parameters.Add(check5); cmd.Parameters.Add(check6); cmd.Parameters.Add(check7); cmd.Parameters.Add(check8); cmd.Parameters.Add(check9); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = System.Data.SqlDbType.Bit; rc.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Обновление произошло успешно!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Ошибка обновления!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Hall(object sender, RoutedEventArgs e) { try { if (Validator.ValidTextBoxes(this.Name.Text, this.CinemaName.Text, this.Rows.Text, this.Seats.Text)) { using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("InsertHall", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter name = new SqlParameter(); name.ParameterName = "@name"; name.Value = this.Name.Text; SqlParameter cinema = new SqlParameter(); cinema.ParameterName = "@cinema"; cinema.Value = this.CinemaName.Text; SqlParameter rows = new SqlParameter(); rows.ParameterName = "@rows"; rows.Value = this.Rows.Text; SqlParameter seats = new SqlParameter(); seats.ParameterName = "@seats"; seats.Value = this.Seats.Text; cmd.Parameters.Add(name); cmd.Parameters.Add(cinema); cmd.Parameters.Add(rows); cmd.Parameters.Add(seats); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = System.Data.SqlDbType.Bit; rc.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Добавление произошло успешно!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Ошибка добавления!"); } } } else { MessageBox.Show("Введите данные!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Director(object sender, RoutedEventArgs e) { try { if (Validator.ValidTextBoxes(this.Name.Text, this.Surname.Text, this.Country.Text, this.Age.Text)) { if (imageName != "") { FileStream fs = new FileStream(imageName, FileMode.Open, FileAccess.Read); byte[] imgByteArr = new byte[fs.Length]; fs.Read(imgByteArr, 0, Convert.ToInt32(fs.Length)); fs.Close(); using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("InsertDirector", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter name = new SqlParameter(); name.ParameterName = "@name"; name.Value = this.Name.Text; SqlParameter surname = new SqlParameter(); surname.ParameterName = "@surname"; surname.Value = this.Surname.Text; SqlParameter country = new SqlParameter(); country.ParameterName = "@country"; country.Value = this.Country.Text; SqlParameter age = new SqlParameter(); age.ParameterName = "@age"; age.Value = this.Age.Text; cmd.Parameters.Add(name); cmd.Parameters.Add(surname); cmd.Parameters.Add(country); cmd.Parameters.Add(age); cmd.Parameters.Add(new SqlParameter("image", imgByteArr)); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = System.Data.SqlDbType.Bit; rc.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Добавление произошло успешно!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Ошибка добавления!"); } } } } else { MessageBox.Show("Введите данные!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Session(object sender, RoutedEventArgs e) { try { if (Validator.ValidTextBoxes(this.Movie.Text, this.Cinema.Text, this.Hall.Text, this.Cost.Text, this.Time.Text)) { using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("InsertSession", cn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter movie = new SqlParameter(); movie.ParameterName = "@movie"; movie.Value = this.Movie.Text; SqlParameter cinema = new SqlParameter(); cinema.ParameterName = "@cinema"; cinema.Value = this.Cinema.Text; SqlParameter hall = new SqlParameter(); hall.ParameterName = "@hall"; hall.Value = this.Hall.Text; SqlParameter date = new SqlParameter(); date.ParameterName = "@date"; date.Value = this.Date.SelectedDate; SqlParameter cost = new SqlParameter(); cost.ParameterName = "@cost"; cost.Value = this.Cost.Text; SqlParameter time = new SqlParameter(); time.ParameterName = "@time"; time.Value = TimeSpan.Parse(Time.Text); cmd.Parameters.Add(movie); cmd.Parameters.Add(cinema); cmd.Parameters.Add(hall); cmd.Parameters.Add(date); cmd.Parameters.Add(cost); cmd.Parameters.Add(time); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = SqlDbType.Bit; rc.Direction = ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Добавление произошло успешно!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Ошибка добавления!"); } } } else { MessageBox.Show("Введите данные!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Cinema(object sender, RoutedEventArgs e) { try { if (Validator.ValidTextBoxes(this.Name.Text, this.Address.Text, this.Region.Text, this.Website.Text, this.TicketOffice.Text, this.Halls.Text)) { using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("InsertCinema", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter name = new SqlParameter(); name.ParameterName = "@name"; name.Value = this.Name.Text; SqlParameter address = new SqlParameter(); address.ParameterName = "@address"; address.Value = this.Address.Text; SqlParameter region = new SqlParameter(); region.ParameterName = "@region"; region.Value = this.Region.Text; SqlParameter website = new SqlParameter(); website.ParameterName = "@website"; website.Value = this.Website.Text; SqlParameter ticketoffice = new SqlParameter(); ticketoffice.ParameterName = "@ticketoffice"; ticketoffice.Value = this.TicketOffice.Text; SqlParameter halls = new SqlParameter(); halls.ParameterName = "@halls"; halls.Value = this.Halls.Text; cmd.Parameters.Add(name); cmd.Parameters.Add(address); cmd.Parameters.Add(region); cmd.Parameters.Add(website); cmd.Parameters.Add(ticketoffice); cmd.Parameters.Add(halls); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = System.Data.SqlDbType.Bit; rc.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Добавление произошло успешно!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Ошибка добавления!"); } } } else { MessageBox.Show("Введите данные!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Movie(object sender, RoutedEventArgs e) { try { if (Validator.ValidTextBoxes(this.Name.Text, this.Country.Text, this.Genre.Text, this.Running_time.Text, this.Director_name.Text, this.Director_surname.Text, this.Screenplay.Text, this.Composer.Text, this.Actor_name.Text, this.Actor_surname.Text, this.Plot.Text)) { if (imageName != "") { //Initialize a file stream to read the image file FileStream fs = new FileStream(imageName, FileMode.Open, FileAccess.Read); //Initialize a byte array with size of stream byte[] imgByteArr = new byte[fs.Length]; //Read data from the file stream and put into the byte array fs.Read(imgByteArr, 0, Convert.ToInt32(fs.Length)); //Close a file stream fs.Close(); using (SqlConnection cn = Connector.GetConnection()) { cn.Open(); SqlCommand cmd = new SqlCommand("InsertMovie", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter name = new SqlParameter(); name.ParameterName = "@name"; name.Value = this.Name.Text; SqlParameter surname = new SqlParameter(); surname.ParameterName = "@release"; surname.Value = this.pick.SelectedDate; SqlParameter country = new SqlParameter(); country.ParameterName = "@country"; country.Value = this.Country.Text; SqlParameter genre = new SqlParameter(); genre.ParameterName = "@genre"; genre.Value = this.Genre.Text; SqlParameter time = new SqlParameter(); time.ParameterName = "@runningtime"; time.Value = this.Running_time.Text; SqlParameter directorname = new SqlParameter(); directorname.ParameterName = "@directorname"; directorname.Value = this.Director_name.Text; SqlParameter directorsurname = new SqlParameter(); directorsurname.ParameterName = "@directorsurname"; directorsurname.Value = this.Director_surname.Text; SqlParameter screenplay = new SqlParameter(); screenplay.ParameterName = "@screenplay"; screenplay.Value = this.Screenplay.Text; SqlParameter composer = new SqlParameter(); composer.ParameterName = "@composer"; composer.Value = this.Composer.Text; SqlParameter actorname = new SqlParameter(); actorname.ParameterName = "@actorname"; actorname.Value = this.Actor_name.Text; SqlParameter actorsurname = new SqlParameter(); actorsurname.ParameterName = "@actorsurname"; actorsurname.Value = this.Actor_surname.Text; SqlParameter plot = new SqlParameter(); plot.ParameterName = "@plot"; plot.Value = this.Plot.Text; cmd.Parameters.Add(name); cmd.Parameters.Add(surname); cmd.Parameters.Add(country); cmd.Parameters.Add(genre); cmd.Parameters.Add(time); cmd.Parameters.Add(directorname); cmd.Parameters.Add(directorsurname); cmd.Parameters.Add(screenplay); cmd.Parameters.Add(composer); cmd.Parameters.Add(actorname); cmd.Parameters.Add(actorsurname); cmd.Parameters.Add(plot); cmd.Parameters.Add(new SqlParameter("image", imgByteArr)); SqlParameter rc = new SqlParameter(); rc.ParameterName = "@rc"; rc.SqlDbType = SqlDbType.Bit; rc.Direction = ParameterDirection.Output; cmd.Parameters.Add(rc); cmd.ExecuteNonQuery(); cn.Close(); if ((bool)cmd.Parameters["@rc"].Value) { MessageBox.Show("Добавление произошло успешно!"); MainWindow mainWnd = new MainWindow(); mainWnd.Show(); this.Close(); } else { MessageBox.Show("Ошибка добавления!"); } } } } else { MessageBox.Show("Введите данные!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }