public void Update(Dvd dvd) { if (dvd.Title == " " || string.IsNullOrEmpty(dvd.Title)) { return; } //Empty or invalid release year else if (dvd.ReleaseYear < 1000 || dvd.ReleaseYear > 9999) { return; } //Empty director name else if (dvd.Director == " " || string.IsNullOrEmpty(dvd.Director)) { return; } //Empty rating else if (dvd.Rating == " " || string.IsNullOrEmpty(dvd.Rating)) { return; } var context = new DvdLibraryEntities(); context.Dvds.Attach(dvd); context.Entry(dvd).State = EntityState.Modified; context.SaveChanges(); }
public void Create(Dvd dvd) { if (dvd.Title == " " || string.IsNullOrEmpty(dvd.Title)) { return; } //Empty or invalid release year else if (dvd.ReleaseYear < 1000 || dvd.ReleaseYear > 9999) { return; } //Empty director name else if (dvd.Director == " " || string.IsNullOrEmpty(dvd.Director)) { return; } //Empty rating else if (dvd.Rating == " " || string.IsNullOrEmpty(dvd.Rating)) { return; } using (var context = new DvdLibraryEntities()) { context.Dvds.Add(dvd); context.SaveChanges(); } }
public List <Dvd> GetByYear(int dvdYear) { var repository = new DvdLibraryEntities(); List <Dvd> returnList = new List <Dvd>(); var dvdList = repository.Dvds.ToList(); foreach (DvdInfo d in dvdList) { var DVD = d; if (DVD.Release.ReleaseYear == dvdYear) { returnList.Add( new Dvd { DvdID = d.DvdID, Title = d.DvdTitle, ReleaseYear = d.Release.ReleaseYear, Director = d.Director.DirectorName, Rating = d.Rating.RatingName, Notes = d.Notes }); } } return(returnList); }
public Dvd Get(int id) { using (var context = new DvdLibraryEntities()) { return(context.Dvds.SingleOrDefault(d => d.DvdId == id)); } }
public List <Dvd> GetAll() { using (var context = new DvdLibraryEntities()) { return(context.Dvds.ToList()); } }
public void SaveDvd(Dvds dvd) { using (var ctx = new DvdLibraryEntities()) { ctx.Dvds.Add(dvd); ctx.SaveChanges(); } }
public void DeleteDvd(int dvdId) { using (var ctx = new DvdLibraryEntities()) { var deleteThis = ctx.Dvds.SingleOrDefault(d => d.DvdId == dvdId); ctx.Dvds.Remove(deleteThis); ctx.SaveChanges(); } }
public List <Dvd> GetAllByRating(string rating) { using (var context = new DvdLibraryEntities()) { List <Dvd> dvds = context.Dvds.Where(d => d.Rating == rating).ToList(); if (dvds.Any()) { return(dvds); } return(null); } }
public void Delete(int id) { using (var context = new DvdLibraryEntities()) { Dvd dvd = context.Dvds.SingleOrDefault(d => d.DvdId == id); if (dvd != null) { context.Dvds.Remove(dvd); context.SaveChanges(); } } }
public List <Dvd> GetAllByYear(int releaseYear) { using (var context = new DvdLibraryEntities()) { List <Dvd> dvds = context.Dvds.Where(d => d.ReleaseYear == releaseYear).ToList(); if (dvds.Any()) { return(dvds); } return(null); } }
public void UpdateDvd(Dvds dvd) { using (var ctx = new DvdLibraryEntities()) { var updateThis = ctx.Dvds.SingleOrDefault(d => d.DvdId == dvd.DvdId); updateThis.Title = dvd.Title; updateThis.ReleaseYear = dvd.ReleaseYear; updateThis.Director = dvd.Director; updateThis.Rating = dvd.Rating; updateThis.Notes = dvd.Notes; ctx.SaveChanges(); } }
public List <Dvd> GetAllByTitle(string title) { if (string.IsNullOrEmpty(title)) { return(null); } using (var context = new DvdLibraryEntities()) { List <Dvd> dvds = context.Dvds.Where(d => d.Title.Contains(title)).ToList(); if (dvds.Any()) { return(dvds); } return(null); } }
public List <Dvds> GetAll() { _listOfDvds.Clear(); using (var ctx = new DvdLibraryEntities()) { var allDvds = ctx.Dvds; foreach (var dvd in allDvds) { _listOfDvds.Add(dvd); } } return(_listOfDvds); }
public List <Dvd> GetAllByDirector(string director) { if (string.IsNullOrEmpty(director)) { return(null); } using (var context = new DvdLibraryEntities()) { List <Dvd> dvds = context.Dvds.Where(d => d.Director.Contains(director)).ToList(); if (dvds.Any()) { return(dvds); } return(null); } }
public void Add(Dvd dvd) { var repository = new DvdLibraryEntities(); var myRelease = repository.Releases.FirstOrDefault(d => d.ReleaseYear == dvd.ReleaseYear); if (myRelease == null) { myRelease = repository.Releases.Add(new Release { ReleaseYear = dvd.ReleaseYear }); repository.SaveChanges(); } var myDirector = repository.Directors.FirstOrDefault(d => d.DirectorName == dvd.Director); if (myDirector == null) { myDirector = repository.Directors.Add(new Director { DirectorName = dvd.Director }); repository.SaveChanges(); } var myRating = repository.Ratings.FirstOrDefault(d => d.RatingName == dvd.Rating); if (myRating == null) { myRating = repository.Ratings.Add(new Rating { RatingName = dvd.Rating }); repository.SaveChanges(); } var myDvdInfo = repository.Dvds.Add( new EF.DvdInfo { DvdTitle = dvd.Title, Release = myRelease, Director = myDirector, Rating = myRating }); repository.SaveChanges(); // return myDvdInfo.DvdID; }
public static void DeleteAllFromDb() { var repo = new DvdRepositoryEntity(); var dvds = repo.GetAll().ToList(); // movie exists? foreach (var dvd in dvds) { int id = dvd.DvdId; repo.Delete(id); } Migrations.Configuration configuration = new Migrations.Configuration(); DvdLibraryEntities entities = new DvdLibraryEntities(); configuration.Seed(entities); }
public void Edit(Dvd dvd) { var repository = new DvdLibraryEntities(); Dvd oldDvd = GetByID(dvd.DvdID); if (oldDvd != null) { var myRelease = repository.Releases.FirstOrDefault(d => d.ReleaseYear == dvd.ReleaseYear); if (myRelease == null) { myRelease = repository.Releases.Add(new Release { ReleaseYear = dvd.ReleaseYear }); repository.SaveChanges(); } var myDirector = repository.Directors.FirstOrDefault(d => d.DirectorName == dvd.Director); if (myDirector == null) { myDirector = repository.Directors.Add(new Director { DirectorName = dvd.Director }); repository.SaveChanges(); } var myRating = repository.Ratings.FirstOrDefault(d => d.RatingName == dvd.Rating); if (myRating == null) { myRating = repository.Ratings.Add(new Rating { RatingName = dvd.Rating }); repository.SaveChanges(); } DvdInfo edited = new DvdInfo { DvdTitle = dvd.Title, Release = myRelease, Director = myDirector, Rating = myRating }; repository.Entry(edited).State = EntityState.Modified; repository.SaveChanges(); } }
protected override void Seed(DvdLibraryEntities context) { context.Dvds.AddOrUpdate( m => m.dvdId, new Dvd { dvdId = 1, title = "The Hobbit", director = "Peter Jackson", realeaseYear = 2012, rating = "PG-13", notes = "There and Back Again" }, new Dvd { dvdId = 2, title = "The Fellowship of the Ring", director = "Peter Jackson", realeaseYear = 2001, rating = "PG-13", notes = "The One Ring" }, new Dvd { dvdId = 3, title = "The Two Towers", director = "Peter Jackson", realeaseYear = 2002, rating = "PG-13", notes = "Minas Tirith" }, new Dvd { dvdId = 4, title = "The Return of the King", director = "Peter Jackson", realeaseYear = 2003, rating = "PG-13", notes = "Mount Doom" } ); }
public List <Dvd> GetAll() { var repository = new DvdLibraryEntities(); List <Dvd> dvdListM = new List <Dvd>(); var dvdList = repository.Dvds.ToList(); foreach (EF.DvdInfo d in dvdList) { dvdListM.Add( new Dvd { DvdID = d.DvdID, Title = d.DvdTitle, ReleaseYear = d.Release.ReleaseYear, Director = d.Director.DirectorName, Rating = d.Rating.RatingName, Notes = d.Notes }); } return(dvdListM); }
public Dvd GetByID(int dvdID) { var repository = new DvdLibraryEntities(); var dvdToGet = repository.Dvds.Find(dvdID); Dvd returnDvd = new Dvd(); if (dvdToGet != null) { returnDvd.DvdID = dvdToGet.DvdID; returnDvd.Title = dvdToGet.DvdTitle; returnDvd.ReleaseYear = dvdToGet.Release.ReleaseYear; returnDvd.Director = dvdToGet.Director.DirectorName; returnDvd.Rating = dvdToGet.Rating.RatingName; returnDvd.Notes = dvdToGet.Notes; return(returnDvd); } else { return(null); } }
public void Delete(int dvdID) { var repository = new DvdLibraryEntities(); var dvd = repository.Dvds.Find(dvdID); if (dvd != null) { Dvd delete = new Dvd { DvdID = dvd.DvdID, Title = dvd.DvdTitle, ReleaseYear = dvd.Release.ReleaseYear, Director = dvd.Director.DirectorName, Rating = dvd.Rating.RatingName, Notes = dvd.Notes }; repository.Dvds.Remove(dvd); repository.SaveChanges(); } }
static DvdRepositoryEF() { _database = new DvdLibraryEntities(); }
public EFRepository() { context = new DvdLibraryEntities(); }
public EFDvdRepo(DvdLibraryEntities context) { this.context = context; }