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;
}
