public static void AddMovie(Movie movie)
{
using (IMDBDB db = new IMDBDB())
{
db.Movie.Add(movie);
db.SaveChanges();
}
}
public static void AddDirector(Director director)
{
using (IMDBDB db = new IMDBDB())
{
db.Director.Add(director);
db.SaveChanges();
}
}
public static void DeleteMovie(int id)
{
using (IMDBDB db = new IMDBDB())
{
var result = db.Movie.Find(id);
db.Movie.Remove(result);
db.SaveChanges();
}
}
public static void UpdateDirector(int id, string name)
{
using (IMDBDB db = new IMDBDB())
{
var result = db.Director.Find(id);
result.DirectorName = name;
db.SaveChanges();
}
}
public static void DeleteDirector(int id)
{
using (IMDBDB db = new IMDBDB())
{
var result = db.Director.Find(id);
db.Director.Remove(result);
db.SaveChanges();
}
}
public static void UpdateMovie(int id, string name, string subject, int rating, int director, int type, DateTime realise)
{
using (IMDBDB db = new IMDBDB())
{
var result = db.Movie.Find(id);
result.MovieName = name;
result.MovieSubject = subject;
result.MovieRating = rating;
result.DirectorID = director;
result.MovieTypeID = type;
result.RealiseDate = realise;
db.SaveChanges();
}
}