public DVD CreateDVD(DVD dvd) { var repository = new DVDContext(); DVD returnNewDVD = new DVD(); var selectedDVDs = (from selectedDVD in repository.DVDs select new { Title = dvd.Title, ReleaseYear = dvd.ReleaseYear, Director = dvd.Director, Rating = dvd.Rating, Notes = dvd.Notes }).ToList().Select(d => new DVD() { Title = d.Title, ReleaseYear = d.ReleaseYear, Director = d.Director, Rating = d.Rating, Notes = d.Notes }); foreach (DVD newDVD in selectedDVDs.Take(1)) { repository.DVDs.Add(newDVD); repository.SaveChanges(); returnNewDVD = newDVD; } return(returnNewDVD); }
public List <DVD> ReadDVDList() { var repository = new DVDContext(); List <DVD> dvdList = repository.DVDs.ToList(); return(dvdList); }
public DVD ReadDVD(int dvdId) { var repository = new DVDContext(); var chosenDVD = repository.DVDs.FirstOrDefault(d => d.DVDId == dvdId); return(chosenDVD); }
public void DeleteDVD(int dvdId) { var repository = new DVDContext(); var chosenDVD = repository.DVDs.FirstOrDefault(d => d.DVDId == dvdId); repository.DVDs.Remove(chosenDVD); repository.SaveChanges(); }
public void UpdateDVD(DVD dvd) { var repository = new DVDContext(); var chosenDVD = repository.DVDs.FirstOrDefault(d => d.DVDId == dvd.DVDId); repository.Entry(chosenDVD).CurrentValues.SetValues(dvd); repository.SaveChanges(); }
public List <DVD> ReadDVDTitle(string title) { var repository = new DVDContext(); List <DVD> dvdList = repository.DVDs.ToList(); List <DVD> searchList = dvdList.FindAll(d => d.Title.ToUpper().Contains(title.ToUpper())); return(searchList); }
public List <DVD> ReadDVDRating(string rating) { var repository = new DVDContext(); List <DVD> dvdList = repository.DVDs.ToList(); List <DVD> searchList = dvdList.FindAll(d => d.Rating.ToUpper().Contains(rating.ToUpper())); return(searchList); }
public List <DVD> ReadDVDDirector(string director) { var repository = new DVDContext(); List <DVD> dvdList = repository.DVDs.ToList(); List <DVD> searchList = dvdList.FindAll(d => d.Director.ToUpper().Contains(director.ToUpper())); return(searchList); }
public List <DVD> ReadDVDYear(string year) { var repository = new DVDContext(); List <DVD> dvdList = repository.DVDs.ToList(); List <DVD> searchList = dvdList.FindAll(d => d.ReleaseYear.ToString().Equals(year)); // .Contains(year.ToUpper())); return(searchList); }
public GenreController(DVDContext context) { _context = context; }
public CertificateController(DVDContext context) { _context = context; }
public FilmTitleController(DVDContext context) { _context = context; }
public ProducerController(DVDContext context) { _context = context; }
public FilmsActorRolsController(DVDContext context) { _context = context; }
public ActorController(DVDContext context) { _context = context; }
public FilmTitlesProducersController(DVDContext context) { _context = context; }
public RoleController(DVDContext context) { _context = context; }
public FilmGenresController(DVDContext context) { _context = context; }
public FilmCertificatesController(DVDContext context) { _context = context; }