/// <summary> /// Add a new movie into DB /// </summary> /// <param name="movieinput">Movie info</param> /// <returns></returns> public bool AddMovie(MovieModel movieinput) { Movie _movie = new Movie(); _movie.MovieName = movieinput.MovieName; _movie.Plot = movieinput.Plot; _movie.ReleaseYear = movieinput.ReleaseYear; _movie.Producer = Db.Producers.FirstOrDefault(s => s.ProducerID == movieinput.ProducerId); Db.Movies.InsertOnSubmit(_movie); List <Movie_Actor> _actors = movieinput.ActorsArray.Select(a => new Movie_Actor { Actor = Db.Actors.FirstOrDefault(s => s.ActorId == a), Movie = _movie }).ToList(); Db.Movie_Actors.InsertAllOnSubmit(_actors); Db.SubmitChanges(); return(true); }
/// <summary> /// Add new Actor /// </summary> /// <param name="proinput"></param> /// <returns></returns> public bool AddNewActor(ActorModel proinput) { Actor _actor = new Actor(); _actor.ActorName = proinput.ActorName; _actor.DateOfBirth = proinput.DOB; _actor.Bio = proinput.Bio; _actor.Gender = Convert.ToBoolean(proinput.Gender); Db.Actors.InsertOnSubmit(_actor); Db.SubmitChanges(); return(true); }
public bool AddNewProducer(ProducerModel proinput) { Producer _producer = new Producer(); _producer.ProducerName = proinput.ProducerName; _producer.DateOfBirth = proinput.DOB; _producer.Bio = proinput.Bio; _producer.Gender = Convert.ToBoolean(proinput.Gender); Db.Producers.InsertOnSubmit(_producer); Db.SubmitChanges(); return(true); }