private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
var movies = from m in ctx.Movies
select new { m.MovieSerial, m.Title, m.Year, m.Country, m.ImdbScore };
Movie_dg.ItemsSource = movies.ToList();
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
var actors = from m in ctx.Actors
select new { m.FirstName, m.LastName, m.Id, m.YearBorn };
Actor_dg.ItemsSource = actors.ToList();
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
var actor = (from m in ctx.Actors
where FirstName == m.FirstName && LastName == m.LastName
select m).First();
Movie_dg.ItemsSource = actor.Movies.ToList();
}
}
private void Show_Click(object sender, RoutedEventArgs e)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
if ((bool)rbActor.IsChecked)
{
try
{
var actor = (from m in ctx.Actors
where m.FirstName == tbFirstName.Text && m.LastName == tbLastName.Text
select m).First();
ShowMovieToSomeone window = new ShowMovieToSomeone(tbFirstName.Text, tbLastName.Text);
window.ShowDialog();
}
catch (Exception)
{
MessageBox.Show("Actor dosen't exist.");
this.Close();
}
}
else if ((bool)rbActress.IsChecked)
{
try
{
var actress = (from m in ctx.Actresses
where m.FirstName == tbFirstName.Text && m.LastName == tbLastName.Text
select m).First();
ShowMovieToSomeone window = new ShowMovieToSomeone(tbFirstName.Text, tbLastName.Text);
window.ShowDialog();
}
catch (Exception)
{
MessageBox.Show("Actress dosen't exist.");
this.Close();
}
}
else if ((bool)rbDirector.IsChecked)
{
try
{
var director = (from m in ctx.Directors
where m.FirstName == tbFirstName.Text && m.LastName == tbLastName.Text
select m).First();
ShowMovieToSomeone window = new ShowMovieToSomeone(tbFirstName.Text, tbLastName.Text);
window.ShowDialog();
}
catch (Exception)
{
MessageBox.Show("Director dosen't exist.");
this.Close();
}
}
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
Func <string, IQueryable <Actor> > actorByMovie =
movieName => from a in ctx.Actors
from m in a.Movies
where m.Title == movieName
select a;
Movie_dg.ItemsSource = actorByMovie(MovieName).ToList();
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
var oscars = from m in ctx.Oscars
from a in ctx.Actors
where a.Id == m.ActorId_Id
from ac in ctx.Actresses
where ac.Id == m.ActressId_Id
from d in ctx.Directors
where d.Id == m.DirectorId_Id
from mo in ctx.Movies
where mo.MovieSerial == m.MovieId_MovieSerial
select new { Actor = a.FirstName + " " + a.LastName, Actress = ac.FirstName + " " + ac.LastName, Director = d.FirstName + " " + d.LastName, Movie = mo.Title, m.Year };
Oscars_dg.ItemsSource = oscars.ToList();
}
}
//-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ Add the Actor -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
private void AddActor_Click(object sender, RoutedEventArgs e)
{
AddActor window = new AddActor();
window.ShowDialog();
if (window.actor != null)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
try {
ctx.Actors.Add(window.actor);
ctx.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("This Actress is already exist.");
}
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
try
{
var movies = (from m in ctx.Movies
where tbName.Text == m.Title
select m).First();
ShowSomeoneToMovie window = new ShowSomeoneToMovie(tbName.Text);
window.ShowDialog();
}
catch (Exception)
{
MessageBox.Show("Movie dosen't exist");
this.Close();
}
}
}
//-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ Add the Novie -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
private void AddMovie_Click(object sender, RoutedEventArgs e)
{
AddMovie window = new AddMovie();
window.ShowDialog();
if (window.movie != null)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
try
{
ctx.Movies.Add(window.movie);
ctx.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("This Movie is already exist.");
}
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (isFilled() == true)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
try
{
var theActor = (from m in ctx.Actors where m.FirstName == tbActorFN.Text.Trim() && m.LastName == tbActorLN.Text.Trim() select m).First();
Actor = theActor;
}
catch (Exception)
{
AddActor window = new AddActor();
window.tbFN.Text = tbActorFN.Text;
window.tbLN.Text = tbActorLN.Text;
window.tbFN.IsEnabled = false;
window.tbLN.IsEnabled = false;
window.ShowDialog();
if (window.actor != null)
{
ctx.Actors.Add(window.actor);
ctx.SaveChanges();
}
var aActor = (from m in ctx.Actors where m.FirstName == window.tbFN.Text.Trim() select m).First();
Actor = aActor;
}
try
{
var theActress = (from m in ctx.Actresses where m.FirstName == tbActressFN.Text.Trim() && m.LastName == tbActressLN.Text.Trim() select m).First();
Actress = theActress;
}
catch (Exception)
{
AddActress window = new AddActress();
window.tbFN.Text = tbActressFN.Text;
window.tbLN.Text = tbActressLN.Text;
window.tbFN.IsEnabled = false;
window.tbLN.IsEnabled = false;
window.ShowDialog();
if (window.actress != null)
{
ctx.Actresses.Add(window.actress);
ctx.SaveChanges();
}
var aActress = (from m in ctx.Actresses where m.FirstName == window.tbFN.Text.Trim() select m).First();
Actress = aActress;
}
try
{
var theDirector = (from m in ctx.Directors where m.FirstName == tbDirectorFN.Text.Trim() && m.FirstName == tbDirectorFN.Text.Trim() select m).First();
Director = theDirector;
}
catch (Exception)
{
AddDirector window = new AddDirector();
window.tbFN.Text = tbDirectorFN.Text;
window.tbLN.Text = tbDirectorLN.Text;
window.tbFN.IsEnabled = false;
window.tbLN.IsEnabled = false;
window.ShowDialog();
if (window.director != null)
{
ctx.Directors.Add(window.director);
ctx.SaveChanges();
}
var aDirector = (from m in ctx.Directors where m.FirstName == window.tbFN.Text.Trim() select m).First();
Director = aDirector;
}
try
{
var theMovie = (from m in ctx.Movies where m.Title == tbMovie.Text.Trim() select m).First();
Movie = theMovie;
}
catch (Exception)
{
AddMovie window = new AddMovie();
window.tbTitle.Text = tbMovie.Text;
window.tbTitle.IsEnabled = false;
window.ShowDialog();
if (window.movie != null)
{
ctx.Movies.Add(window.movie);
ctx.SaveChanges();
}
var aMovie = (from m in ctx.Movies where m.Title == window.tbTitle.Text.Trim() select m).First();
Movie = aMovie;
}
try
{
GoldenGlobe = new GoldenGlobe
{
ActressId_Id = Actress.Id,
ActorId_Id = Actor.Id,
DirectorId_Id = Director.Id,
MovieId_MovieSerial = Movie.MovieSerial,
Year = Convert.ToInt32(tbYear.Text.Trim())
};
}
catch (FormatException)
{
MessageBox.Show("Invalid Input.");
this.Close();
}
ctx.SaveChanges();
this.Close();
}
}
else
{
MessageBox.Show("Fill all....");
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if ((bool)rbActor.IsChecked)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
try
{
var theActor = (from m in ctx.Actors where m.FirstName == tbFN.Text.Trim() && m.LastName == tbLN.Text.Trim() select m).First();
Actor = theActor;
}
catch (Exception)
{
AddActor window = new AddActor();
window.tbFN.Text = tbFN.Text;
window.tbLN.Text = tbLN.Text;
window.tbFN.IsEnabled = false;
window.tbLN.IsEnabled = false;
window.ShowDialog();
if (window.actor != null)
{
ctx.Actors.Add(window.actor);
ctx.SaveChanges();
}
var theActor = (from m in ctx.Actors where m.FirstName == window.tbFN.Text.Trim() && m.LastName == window.tbLN.Text.Trim() select m).First();
Actor = theActor;
}
try
{
var theMovie = (from m in ctx.Movies where m.Title == tbAM.Text.Trim() select m).First();
Movie = theMovie;
}
catch (Exception)
{
MessageBox.Show("Your movie doesn't exist");
this.Close();
}
Movie.Actors.Add(Actor);
Actor.Movies.Add(Movie);
ctx.SaveChanges();
this.Close();
}
}
else if ((bool)rbActress.IsChecked)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
try
{
var theActress = (from m in ctx.Actresses where m.FirstName == tbFN.Text.Trim() && m.LastName == tbLN.Text.Trim() select m).First();
Actress = theActress;
}
catch (Exception)
{
AddActress window = new AddActress();
window.tbFN.Text = tbFN.Text;
window.tbLN.Text = tbLN.Text;
window.tbFN.IsEnabled = false;
window.tbLN.IsEnabled = false;
window.ShowDialog();
if (window.actress != null)
{
ctx.Actresses.Add(window.actress);
ctx.SaveChanges();
}
var theActress = (from m in ctx.Actresses where m.FirstName == window.tbFN.Text.Trim() && m.LastName == window.tbLN.Text.Trim() select m).First();
Actress = theActress;
}
try
{
var theMovie = (from m in ctx.Movies where m.Title == tbAM.Text.Trim() select m).First();
Movie = theMovie;
}
catch (Exception)
{
MessageBox.Show("Your movie doesn't exist");
this.Close();
}
Movie.Actresses.Add(Actress);
Actress.Movies.Add(Movie);
ctx.SaveChanges();
this.Close();
}
}
else if ((bool)rbDirector.IsChecked)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
try
{
var theDirector = (from m in ctx.Directors where m.FirstName == tbFN.Text.Trim() && m.LastName == tbLN.Text.Trim() select m).First();
Director = theDirector;
}
catch (Exception)
{
AddDirector window = new AddDirector();
window.tbFN.Text = tbFN.Text;
window.tbLN.Text = tbLN.Text;
window.tbFN.IsEnabled = false;
window.tbLN.IsEnabled = false;
window.ShowDialog();
if (window.director != null)
{
ctx.Directors.Add(window.director);
ctx.SaveChanges();
}
var theDirector = (from m in ctx.Directors where m.FirstName == window.tbFN.Text.Trim() && m.LastName == window.tbLN.Text.Trim() select m).First();
Director = theDirector;
}
try
{
var theMovie = (from m in ctx.Movies where m.Title == tbAM.Text.Trim() select m).First();
Movie = theMovie;
}
catch (Exception)
{
MessageBox.Show("Your movie doesn't exist");
this.Close();
}
Movie.Director = Director;
Director.Movies.Add(Movie);
ctx.SaveChanges();
this.Close();
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (MoviesDBEntities ctx = new MoviesDBEntities())
{
try
{
var movies = (from m in ctx.Movies
where m.Title == tbAM.Text
select m).First();
Movie = movies;
}
catch (Exception)
{
AddMovie window = new AddMovie();
window.ShowDialog();
window.tbTitle.Text = tbAM.Text;
window.tbTitle.IsEnabled = false;
var movies = (from m in ctx.Movies
where m.Title == window.tbTitle.Text
select m).First();
Movie = movies;
}
if ((bool)rbActor.IsChecked)
{
try
{
var actor = (from m in ctx.Actors
where m.FirstName == tbFN.Text && m.LastName == tbLN.Text
select m).First();
actor.Movies.Add(Movie);
Movie.Actors.Add(actor);
ctx.SaveChanges();
this.Close();
}
catch (Exception)
{
MessageBox.Show("Actor dosen't exist.");
this.Close();
}
}
else if ((bool)rbActress.IsChecked)
{
try
{
var actress = (from m in ctx.Actresses
where m.FirstName == tbFN.Text && m.LastName == tbLN.Text
select m).First();
actress.Movies.Add(Movie);
Movie.Actresses.Add(actress);
ctx.SaveChanges();
this.Close();
}
catch (Exception)
{
MessageBox.Show("Actress dosen't exist.");
this.Close();
}
}
else if ((bool)rbDirector.IsChecked)
{
try
{
var director = (from m in ctx.Directors
where m.FirstName == tbFN.Text && m.LastName == tbLN.Text
select m).First();
director.Movies.Add(Movie);
Movie.Director = director;
ctx.SaveChanges();
this.Close();
}
catch (Exception)
{
MessageBox.Show("Director dosen't exist.");
this.Close();
}
}
}
}
