//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);
}
}
