Exemple #1
0
        private void InsertToFilm()
        {
            string query = "INSERT INTO Film (Название, Жанр, Актёры, Режиссёр, Страна, Год, " +
                           "[Целевая аудитория 18+], [Кол-во копий], [Тип носителя], Описание, Продолжительность, Рейтинг, [Язык озвучки]) VALUES ('" + NameOfTheFilmTextBox.Text + "','" + CategoryOfFilmComboBox.Text +
                           "','" + ActorsTextBox.Text + "','" + DirectorTextBox.Text +
                           "','" + ProducingCountryComboBox.Text + "','" + int.Parse(YearOfIssueTextBox.Text) + "','" + FilmForAdultsComboBox.Text +
                           "','" + int.Parse(NumberOfCopiesTextBox.Text) + "','" + TheTypeOfMediaComboBox.Text + "','" + SummaryTextBox.Text +
                           "','" + int.Parse(LengthInMinutes.Text) + "','" + Rating.Text + "','" + LanguagesForVoiceComboBox.Text + "')";

            cmd.CommandText = query;
            cmd.Connection  = connection;

            try
            {
                connection.Open();
                addFlag = cmd.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            if (GetLastId() == -1)
            {
                return;
            }
            else
            {
                for (int i = 1; i <= Convert.ToInt16(NumberOfCopiesTextBox.Text); i++)
                {
                    InsertToBusyFilmCopy(GetLastId(), i);
                }
            }

            //Проходим по всему ComboBox и достаём FilmId, после этого заполняем таблицу предыдущих частей
            for (int i = 0; i < listBox.Items.Count; i++)
            {
                string [] subStr = listBox.Items[i].ToString().Split('=');
                int       id     = Convert.ToInt16(subStr[1]);
                FillTablePreviousPartsOfFilm(id);
                comboBox1.Items.Clear();
            }


            CategoryOfFilmComboBox.SelectedIndex = -1;
            CategoryOfFilmComboBox.Text          = "Выберите или введите новый";
            NameOfTheFilmTextBox.Clear();
            ActorsTextBox.Clear();
            DirectorTextBox.Clear();
            ProducingCountryComboBox.SelectedIndex = -1;
            ProducingCountryComboBox.Text          = "Выберите";
            YearOfIssueTextBox.Clear();
            FilmForAdultsComboBox.SelectedIndex = -1;
            FilmForAdultsComboBox.Text          = "Выберите";
            NumberOfCopiesTextBox.Clear();
            TheTypeOfMediaComboBox.SelectedIndex = -1;
            TheTypeOfMediaComboBox.Text          = "Выберите";
            SummaryTextBox.Clear();
            LengthInMinutes.Clear();
            Rating.Clear();
            LanguagesForVoiceComboBox.SelectedIndex = -1;
            LanguagesForVoiceComboBox.Text          = "Выберите";
            listBox.Items.Clear();
            pictureBox.Image  = null;
            pictureBox1.Image = null;
            pictureBox2.Image = null;
            pictureBox3.Image = null;
        }
        private void GetPreviousPartsOfFilm(int FilmId)
        {
            string query = "select * FROM Film WHERE Id like '" + FilmId + "%'";

            byte[] image  = null;
            byte[] image1 = null;
            byte[] image2 = null;
            byte[] image3 = null;

            try
            {
                connection.Open();
                SqlCeCommand cmd = new SqlCeCommand(query, connection);

                SqlCeDataReader reader = cmd.ExecuteReader();

                if (reader.Read())
                {
                    NameOfTheFilmTextBox.Text    = reader["Название"].ToString();
                    CategoryOfFilmTextBox.Text   = reader["Жанр"].ToString();
                    ActorsTextBox.Text           = reader["Актёры"].ToString();
                    DirectorTextBox.Text         = reader["Режиссёр"].ToString();
                    ProducingCountryTextBox.Text = reader["Страна"].ToString();
                    YearOfIssueTextBox.Text      = reader["Год"].ToString();
                    FilmForAdultsTextBox.Text    = reader["Целевая аудитория 18+"].ToString();
                    NumberOfCopiesTextBox.Text   = reader["Кол-во копий"].ToString();
                    TheTypeOfMediaTextBox.Text   = reader["Тип носителя"].ToString();
                    SummaryTextBox.Text          = reader["Описание"].ToString();
                    LengthInMinutes.Text         = reader["Продолжительность"].ToString();
                    Rating.Text = reader["Рейтинг"].ToString();
                    LangForVoiceTextBox.Text = reader["Язык озвучки"].ToString();

                    try
                    {
                        image  = (byte[])reader["Photo1"];
                        image1 = (byte[])reader["Photo2"];
                        image2 = (byte[])reader["Photo3"];
                        image3 = (byte[])reader["Photo4"];
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message, "Отсутствует изображение.", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    }

                    if (image == null)
                    {
                        pictureBox.Image = null;
                    }
                    else
                    {
                        MemoryStream memoryStream = new MemoryStream(image);
                        pictureBox.Image = Image.FromStream(memoryStream);
                    }

                    if (image1 == null)
                    {
                        pictureBox1.Image = null;
                    }
                    else
                    {
                        MemoryStream memoryStream = new MemoryStream(image1);
                        pictureBox1.Image = Image.FromStream(memoryStream);
                    }

                    if (image2 == null)
                    {
                        pictureBox2.Image = null;
                    }
                    else
                    {
                        MemoryStream memoryStream = new MemoryStream(image2);
                        pictureBox2.Image = Image.FromStream(memoryStream);
                    }

                    if (image3 == null)
                    {
                        pictureBox3.Image = null;
                    }
                    else
                    {
                        MemoryStream memoryStream = new MemoryStream(image3);
                        pictureBox3.Image = Image.FromStream(memoryStream);
                    }
                }
                else
                {
                    CategoryOfFilmTextBox.Clear();
                    NameOfTheFilmTextBox.Clear();
                    ActorsTextBox.Clear();
                    DirectorTextBox.Clear();
                    ProducingCountryTextBox.Clear();
                    YearOfIssueTextBox.Clear();
                    FilmForAdultsTextBox.Clear();
                    NumberOfCopiesTextBox.Clear();
                    TheTypeOfMediaTextBox.Clear();
                    SummaryTextBox.Clear();
                    LengthInMinutes.Clear();
                    Rating.Clear();
                    LangForVoiceTextBox.Clear();
                }


                reader.Close();
                connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            Show();
        }