public Models.DVD DeleteDvd(int dvdId)
{
var myRepo = new DvdDatabaseEntities();
var dvd = myRepo.DVD.Find(dvdId);
Models.DVD dvdToBeDeleted = new Models.DVD
{
Title = dvd.Title,
ReleaseYear = dvd.ReleaseYear,
Director = dvd.Director.Name,
Rating = dvd.Rating.Name,
Notes = dvd.Notes
};
myRepo.DVD.Remove(dvd);
myRepo.SaveChanges();
return(dvdToBeDeleted);
}
public ActionResult Create(Models.DVD newDVD)
{
try
{
MemoryStream ms = new MemoryStream();
DataContractJsonSerializer dcjs = new DataContractJsonSerializer(typeof(Models.DVD));
dcjs.WriteObject(ms, newDVD);
wc.Headers["content-type"] = "application/json";
wc.UploadData(url + "PostDVD", "POST", ms.ToArray());
ModelState.AddModelError("", "Add ok");
}
catch (Exception)
{
ModelState.AddModelError("", "add error occured");
}
return(View());
}
public Models.DVD GetDvdById(int dvdId)
{
var myRepo = new DvdDatabaseEntities();
var dvd = myRepo.DVD.Find(dvdId);
Models.DVD dvdToBeReturned = new Models.DVD();
if (dvd != null)
{
dvdToBeReturned.DVDId = dvdId;
dvdToBeReturned.Title = dvd.Title;
dvdToBeReturned.ReleaseYear = dvd.ReleaseYear;
dvdToBeReturned.Director = dvd.Director.Name;
dvdToBeReturned.Rating = dvd.Rating.Name;
dvdToBeReturned.Notes = dvd.Notes;
return(dvdToBeReturned);
}
else
{
return(null);
}
}
public Models.DVD EditDvd(Models.DVD current, Models.DVD updated)
{
var myRepo = new DvdDatabaseEntities();
var director = myRepo.Director.FirstOrDefault(d => d.Name == updated.Director);
if (director == null)
{
//director.Name = updated.Director;
director = myRepo.Director.Add(new Director {
Name = updated.Director
});
myRepo.SaveChanges();
}
var rating = myRepo.Rating.FirstOrDefault(r => r.Name == updated.Rating);
if (rating == null)
{
rating = myRepo.Rating.Add(new Rating {
Name = updated.Rating
});
myRepo.SaveChanges();
}
EF.DVD dvdEntry = new EF.DVD
{
DVDId = current.DVDId,
Title = updated.Title,
ReleaseYear = updated.ReleaseYear,
DirectorId = director.DirectorId,
RatingId = rating.RatingId,
Notes = updated.Notes
};
myRepo.Entry(dvdEntry).State = EntityState.Modified;
myRepo.SaveChanges();
return(current);
}
public Models.DVD AddDvd(Models.DVD dvdToAdd)
{
var myRepo = new DvdDatabaseEntities();
var director = myRepo.Director.FirstOrDefault(d => d.Name == dvdToAdd.Director);
if (director == null)
{
director = myRepo.Director.Add(new Director {
Name = dvdToAdd.Director
});
myRepo.SaveChanges();
}
var rating = myRepo.Rating.FirstOrDefault(r => r.Name == dvdToAdd.Rating);
if (rating == null)
{
rating = myRepo.Rating.Add(new Rating {
Name = dvdToAdd.Rating
});
myRepo.SaveChanges();
}
var dvd = myRepo.DVD.Add(
new EF.DVD
{
Title = dvdToAdd.Title,
ReleaseYear = dvdToAdd.ReleaseYear,
DirectorId = director.DirectorId,
RatingId = rating.RatingId,
Notes = dvdToAdd.Notes
});
myRepo.SaveChanges();
dvdToAdd.DVDId = dvd.DVDId;
return(dvdToAdd);
}
