public void AddDvd(Dvd dvd)
{
if (dvdEntity.Dvd.Count() == 0)
{
dvd.DvdId = 1;
}
else
{
var maxID = dvdEntity.Dvd.Max(d => d.DvdId);
dvd.DvdId = maxID + 1;
}
dvdEntity.Dvd.Add(dvd);
dvdEntity.SaveChanges();
}
public void DeleteDirector(int?directorId)
{
var repository = new DVDLibraryEntities();
var dir = repository.Director.FirstOrDefault(d => d.DirectorID == directorId);
repository.Director.Remove(dir);
repository.SaveChanges();
}
public Director AddDirector(DirectorIdRequest newDirector)
{
var repository = new DVDLibraryEntities();
var directorToAdd = new Director();
directorToAdd.DirectorFirstName = newDirector.FirstName;
directorToAdd.DirectorLastName = newDirector.LastName;
repository.Director.Add(directorToAdd);
repository.SaveChanges();
Director addedDirector = new Director();
addedDirector.DirectorFirstName = newDirector.FirstName;
addedDirector.DirectorLastName = newDirector.LastName;
addedDirector.DirectorID = directorToAdd.DirectorID;
return(addedDirector);
}
public void Delete(int dvdId)
{
var repository = new DVDLibraryEntities();
string director = GetById(dvdId).Director;
var dvd = repository.Dvd.FirstOrDefault(d => d.DvdId == dvdId);
if (dvd != null)
{
repository.Dvd.Remove(dvd);
repository.SaveChanges();
}
if (!string.IsNullOrEmpty(director))
{
DirectorTableCleanUp(director);
}
}
public void Edit(DVD dvd)
{
var repository = new DVDLibraryEntities();
Dvd dvdToEdit = new Dvd();
dvdToEdit.DvdId = dvd.DvdId;
dvdToEdit.Title = dvd.Title;
dvdToEdit.RealeaseYear = dvd.RealeaseYear;
dvdToEdit.Notes = dvd.Notes;
int?ratingId = Helpers.GetRatingId(dvd.Rating);
if (ratingId == null)
{
dvdToEdit.RatingId = null;
}
else
{
dvdToEdit.RatingId = ratingId;
}
int?directorId = GetDirectorId(dvd.Director);
if (directorId == null)
{
dvdToEdit.DirectorId = null;
}
else
{
dvdToEdit.DirectorId = directorId;
}
repository.Entry(dvdToEdit).State = System.Data.Entity.EntityState.Modified;
repository.SaveChanges();
if (!string.IsNullOrEmpty(dvd.Director))
{
DirectorTableCleanUp(dvd.Director);
}
}
public void Add(DVD dvd)
{
var repository = new DVDLibraryEntities();
Dvd dvdToAdd = new Dvd();
dvdToAdd.Title = dvd.Title;
dvdToAdd.RealeaseYear = dvd.RealeaseYear;
dvdToAdd.Notes = dvd.Notes;
int?ratingId = Helpers.GetRatingId(dvd.Rating);
if (ratingId == null)
{
dvdToAdd.RatingId = null;
}
else
{
dvdToAdd.RatingId = ratingId;
}
int?directorId = GetDirectorId(dvd.Director);
if (directorId == null)
{
dvdToAdd.DirectorId = null;
}
else
{
dvdToAdd.DirectorId = directorId;
}
repository.Dvd.Add(dvdToAdd);
repository.SaveChanges();
dvd.DvdId = dvdToAdd.DvdId;
}