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 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 Dvd Add(Dvd dvd)
{
Dvd newDvd = new Dvd();
newDvd.DvdId = dvd.DvdId;
newDvd.Title = dvd.Title;
newDvd.Director = dvd.Director;
newDvd.ReleaseYear = dvd.ReleaseYear;
newDvd.Rating = dvd.Rating;
newDvd.Notes = dvd.Notes;
context.Dvds.Add(newDvd);
context.SaveChanges();
return(dvd);
}
public void SaveDvd(Dvds dvd)
{
using (var ctx = new DvdLibraryEntities())
{
ctx.Dvds.Add(dvd);
ctx.SaveChanges();
}
}
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 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();
}
}
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 void Create(Dvd dvd)
{
DvdEF d = new DvdEF
{
Notes = dvd.Notes,
Title = dvd.Title,
ReleaseYear = dvd.ReleaseYear,
DvdId = dvd.DvdId
};
d.Director = new Director {
DirectorName = dvd.DirectorName
};
d.Rating = new Rating {
RatingValue = dvd.RatingValue
};
context.Dvd.Add(d);
context.SaveChanges();
}
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 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 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();
}
}
public void Create(Dvd newDvd)
{
context.Dvds.Add(newDvd);
context.SaveChanges();
}
public void AddDvd(Dvd dvd)
{
context.Dvds.Add(dvd);
context.SaveChanges();
}
public Dvd Create(Dvd dvd)
{
_database.Dvds.Add(dvd);
_database.SaveChanges();
return(dvd);
}
