public FilmType GetType()
{
VideoContext contex = new VideoContext();
FilmType Type = contex.FilmTypes.Where(c => c.Type == comboBox1.Text).FirstOrDefault();
return(Type);
}
private void button1_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{
for (int j = 0; j < dataGridView1.RowCount; j++)
{
if (dataGridView1[i, j].Selected == true)
{
dataGridView1.Rows[j].Selected = true;
}
}
}
VideoContext contex = new VideoContext();
int index = dataGridView1.SelectedRows[0].Index, id = 0;
Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
if (disc)
{
inDisc = contex.Discs.Where(c => c.DiscID == id).FirstOrDefault();
}
else
{
if (search)
{
client = contex.Clients.Where(c => c.ClientID == id).FirstOrDefault();
}
else
{
film = contex.Films.Where(f => f.FilmID == id).FirstOrDefault();
}
}
Close();
}
private void button1_Click(object sender, EventArgs e)
{
VideoContext contex = new VideoContext();
b = dateTimePicker1.Value.Date; a = dateTimePicker2.Value.Date;
Close();
}
private void SearchForm_Load(object sender, EventArgs e)
{
VideoContext contex = new VideoContext();
if (disc)
{
dataGridView1.DataSource = contex.Discs.ToList <Disc>();
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Название";
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[2].HeaderText = "Доступность";
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[3].Visible = false;
}
else
{
if (search)
{
dataGridView1.DataSource = contex.Clients.ToList <Client>();
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Имя";
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[2].HeaderText = "Фамилия";
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[3].HeaderText = "Отчество";
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[4].HeaderText = "Возраст";
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[5].HeaderText = "Телефон";
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[6].HeaderText = "В черном списке";
}
else
{
dataGridView1.DataSource = contex.Films.Include("Type").ToList <Film>();
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Название";
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[3].HeaderText = "Тип";
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[4].HeaderText = "Год";
dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[5].Visible = false;
}
}
string[] s = new string[dataGridView1.Columns.Count];
comboBox1.Items.Clear();
for (int i = 1; i < dataGridView1.Columns.Count; i++)
{
if (dataGridView1.Columns[i].Visible == true)
{
s[i] = dataGridView1.Columns[i].HeaderText;
comboBox1.Items.Add(s[i]);
}
}
}
private void InputDisc_Load(object sender, EventArgs e)
{
if (Disc != null)
{
textBox1.Text = Disc.Name;
checkBox1.Checked = Disc.IsAvailable;
VideoContext contex = new VideoContext();
var films = contex.DiscFilms.Include("Film").Where(d => d.DiscID == Disc.DiscID);
foreach (DiscFilms f in films)
{
listBox1.Items.Add(f.Film.Name);
}
}
}
private void InputFilm_Load(object sender, EventArgs e)
{
if (Film != null)
{
VideoContext contex = new VideoContext();
ShowMyImage(Film.Image, pictureBox1.Size.Width, pictureBox1.Size.Height);
textBox1.Text = Film.Name;
textBox2.Text = Film.Year.ToString();
textBox4.Text = Film.Type.ToString();
foreach (int c in GenresID)
{
textBox3.Text += contex.Genres.Where(g => g.GenreID == c).FirstOrDefault() + " ";
}
}
}
private void RefreshDataBase()
{
VideoContext contex = new VideoContext();
if (disc)
{
dataGridView1.DataSource = contex.Discs.ToList <Disc>();
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Название";
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[2].HeaderText = "Доступность";
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[3].Visible = false;
}
else
{
if (search)
{
dataGridView1.DataSource = contex.Clients.ToList <Client>();
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Имя";
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[2].HeaderText = "Фамилия";
dataGridView1.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[3].HeaderText = "Отчество";
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[4].HeaderText = "Возраст";
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[5].HeaderText = "Телефон";
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[6].HeaderText = "В черном списке";
}
else
{
dataGridView1.DataSource = contex.Films.Include("Type").ToList <Film>();
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].HeaderText = "Название";
dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[3].HeaderText = "Тип";
dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[4].HeaderText = "Год";
dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dataGridView1.Columns[5].Visible = false;
}
}
}
public InputJenre(List <int> GenreID, String Type)
{
InitializeComponent();
if (GenreID != null)
{
this.Type = Type;
this.GenreID = GenreID;
Edit = true;
}
VideoContext contex = new VideoContext();
var types = contex.FilmTypes;
foreach (FilmType c in types)
{
comboBox1.Items.Add(c.Type);
}
}
private void textBox3_MouseClick(object sender, MouseEventArgs e)
{
GenresID = new List <int>();
if (textBox3.Text != null)
{
VideoContext contex = new VideoContext();
String s = textBox3.Text;
String[] words = s.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
foreach (String genre in words)
{
GenresID.Add(contex.Genres.Where(g => g.Name == genre).FirstOrDefault().GenreID);
}
InputJenre form = new InputJenre(GenresID, textBox4.Text);
form.ShowDialog();
if (form.GetGenres() != null && form.GetType() != null)
{
Genres = form.GetGenres();
Type = form.GetType();
}
textBox3.Text = "";
}
else
{
InputJenre form = new InputJenre(null, null);
form.ShowDialog();
if (form.GetGenres() != null && form.GetType() != null)
{
Genres = form.GetGenres();
Type = form.GetType();
}
}
if (Type != null && Genres != null)
{
foreach (Genre c in Genres)
{
textBox3.Text += c.Name + " ";
}
textBox4.Text = Type.Type;
}
}
public InputFilm(Film film)
{
InitializeComponent();
if (film != null)
{
this.Film = film;
VideoContext contex = new VideoContext();
var genres = contex.FimsGenres.Where(g => g.FilmID == Film.FilmID);
openFileDialog1 = new OpenFileDialog();
openFileDialog1.FileName = Film.Image;
FilmType inType = contex.FilmTypes.Where(t => t.TypeID == Film.TypeID).FirstOrDefault();
Type = inType;
this.TypeF = film.Type.ToString();
GenresID = new List <int>();
foreach (FilmGenres g in genres)
{
//Genre genre = contex.Genres.Where(c => c.GenreID == g.GenreID).FirstOrDefault();
GenresID.Add(g.GenreID);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "")
{
VideoContext contex = new VideoContext();
inClient = new Client
{
Name = textBox1.Text,
Surname = textBox2.Text,
Patronymic = textBox3.Text,
Age = Convert.ToInt16(textBox4.Text),
Phone = Convert.ToInt64(textBox5.Text),
InBlacklist = checkBox1.Checked
};
if (client != null)
{
Client cl = contex.Clients.Where(c => c.ClientID == client.ClientID).FirstOrDefault();
cl.Name = inClient.Name;
cl.Surname = inClient.Surname;
cl.Patronymic = inClient.Patronymic;
cl.Age = inClient.Age;
cl.Phone = inClient.Phone;
cl.InBlacklist = inClient.InBlacklist;
}
else
{
contex.Clients.Add(inClient);
}
contex.SaveChanges();
Close();
}
else
{
MessageBox.Show("Заполните все поля");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && listBox1.Items.Count != 0)
{
VideoContext contex = new VideoContext();
if (Disc == null)
{
inDisc = new Disc
{
Name = textBox1.Text,
IsAvailable = checkBox1.Checked
};
contex.Discs.Add(inDisc);
contex.SaveChanges();
int discID = contex.Discs.Where(d => d.Name == inDisc.Name).FirstOrDefault().DiscID;
var removefims = contex.DiscFilms.Where(d => d.DiscID == discID);
contex.DiscFilms.RemoveRange(removefims);
for (int i = 0; i < listBox1.Items.Count; i++)
{
String fd;
fd = listBox1.Items[i].ToString();
DiscFilms inDiscFilms = new DiscFilms
{
DiscID = discID,
FilmID = contex.Films.Where(f => f.Name == fd).FirstOrDefault().FilmID
};
contex.DiscFilms.Add(inDiscFilms);
contex.SaveChanges();
}
}
else
{
Disc d = contex.Discs.Where(f => f.DiscID == Disc.DiscID).FirstOrDefault();
d.Name = textBox1.Text;
d.IsAvailable = checkBox1.Checked;
contex.SaveChanges();
int discID = contex.Discs.Where(dw => dw.Name == d.Name).FirstOrDefault().DiscID;
var removefims = contex.DiscFilms.Where(dw => dw.DiscID == discID);
contex.DiscFilms.RemoveRange(removefims);
for (int i = 0; i < listBox1.Items.Count; i++)
{
String fd;
fd = listBox1.Items[i].ToString();
DiscFilms inDiscFilms = new DiscFilms
{
DiscID = discID,
FilmID = contex.Films.Where(f => f.Name == fd).FirstOrDefault().FilmID
};
contex.DiscFilms.Add(inDiscFilms);
contex.SaveChanges();
}
}
Close();
}
else
{
MessageBox.Show("Заполните все поля");
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
VideoContext contex = new VideoContext();
if (textBox1.Text.Length > 0)
{
int index = comboBox1.SelectedIndex + 1;
if (disc)
{
switch (index)
{
case 1:
var a = contex.Discs.Where(c => c.Name.ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
case 2:
a = contex.Discs.Where(c => c.IsAvailable.ToString().ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
}
}
else
{
if (search)
{
switch (index)
{
case 1:
var a = contex.Clients.Where(c => c.Name.ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
case 2:
a = contex.Clients.Where(c => c.Surname.ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
case 3:
a = contex.Clients.Where(c => c.Patronymic.ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
case 4:
a = contex.Clients.Where(c => c.Age.ToString().ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
case 5:
a = contex.Clients.Where(c => c.Phone.ToString().ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
}
}
else
{
switch (index)
{
case 1:
var a = contex.Films.Where(f => f.Name.ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
case 2:
a = contex.Films.Where(f => f.Type.Type.ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
case 3:
a = contex.Films.Where(f => f.Year.ToString().ToLower().StartsWith(textBox1.Text.ToLower()));
dataGridView1.DataSource = a.ToList();
break;
}
}
}
}
else
{
RefreshDataBase();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && pictureBox1.Image != null)
{
VideoContext contex = new VideoContext();
if (Film == null)
{
inFilm = new Film
{
Image = openFileDialog1.FileName,
Name = textBox1.Text,
Year = Convert.ToInt32(textBox2.Text),
TypeID = Type.TypeID
};
contex.Films.Add(inFilm);
contex.SaveChanges();
for (int i = 0; i < Genres.Count; i++)
{
inGenres = new FilmGenres
{
FilmID = inFilm.FilmID,
GenreID = Genres[i].GenreID
};
contex.FimsGenres.Add(inGenres);
contex.SaveChanges();
}
}
else
{
contex = new VideoContext();
GenresID = new List <int>();
Film film = contex.Films.Where(f => f.FilmID == Film.FilmID).FirstOrDefault();
film.Image = openFileDialog1.FileName;
film.Name = textBox1.Text;
film.Year = Convert.ToInt32(textBox2.Text);
film.TypeID = Type.TypeID;
String s = textBox3.Text;
String[] words = s.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
foreach (String genre in words)
{
GenresID.Add(contex.Genres.Where(g => g.Name == genre).FirstOrDefault().GenreID);
}
for (int i = 0; i < GenresID.Count; i++)
{
var flg = contex.FimsGenres.Where(g => g.FilmID == Film.FilmID);
foreach (FilmGenres g in flg)
{
contex.FimsGenres.Remove(g);
}
contex.SaveChanges();
for (int j = 0; j < GenresID.Count; j++)
{
inGenres = new FilmGenres
{
FilmID = Film.FilmID,
GenreID = GenresID[j]
};
contex.FimsGenres.Add(inGenres);
contex.SaveChanges();
}
}
contex.SaveChanges();
}
Close();
}
else
{
MessageBox.Show("Заполните все поля и загрузите фото");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "")
{
VideoContext contex = new VideoContext();
if (button3.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 1).FirstOrDefault();
this.genre.Add(genre);
}
if (button4.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 2).FirstOrDefault();
this.genre.Add(genre);
}
if (button5.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 3).FirstOrDefault();
this.genre.Add(genre);
}
if (button6.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 4).FirstOrDefault();
this.genre.Add(genre);
}
if (button7.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 5).FirstOrDefault();
this.genre.Add(genre);
}
if (button8.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 6).FirstOrDefault();
this.genre.Add(genre);
}
if (button9.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 7).FirstOrDefault();
this.genre.Add(genre);
}
if (button21.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 8).FirstOrDefault();
this.genre.Add(genre);
}
if (button10.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 9).FirstOrDefault();
this.genre.Add(genre);
}
if (button11.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 10).FirstOrDefault();
this.genre.Add(genre);
}
if (button12.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 11).FirstOrDefault();
this.genre.Add(genre);
}
if (button13.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 12).FirstOrDefault();
this.genre.Add(genre);
}
if (button14.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 13).FirstOrDefault();
this.genre.Add(genre);
}
if (button15.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 14).FirstOrDefault();
this.genre.Add(genre);
}
if (button16.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 15).FirstOrDefault();
this.genre.Add(genre);
}
if (button17.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 16).FirstOrDefault();
this.genre.Add(genre);
}
if (button18.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 17).FirstOrDefault();
this.genre.Add(genre);
}
if (button20.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 18).FirstOrDefault();
this.genre.Add(genre);
}
if (button19.BackColor == Color.BlueViolet)
{
Genre genre = contex.Genres.Where(c => c.GenreID == 19).FirstOrDefault();
this.genre.Add(genre);
}
Type = comboBox1.Text;
Close();
}
else
{
MessageBox.Show("Выберите тип и хотя бы один жанр");
}
}
