public int Create(CD cd)
{
var entity = new Data.CD {Artist = cd.Artist, Genre = cd.Genre, Title = cd.Title, Year = cd.Year, Id = -1};
var x = _db.CDs.Add(entity);
_db.SaveChanges();
return x.Id;
}
public CD GetCdDetails(int? id)
{
var entity = GetCdEntityFromDataContext(id);
var model = new CD
{
Artist = entity.Artist,
Genre = entity.Genre,
Id = entity.Id,
Title = entity.Title,
Year = entity.Year
};
if (model.Tracks == null)
{
model.Tracks = new Collection<Track>();
}
foreach (var track in entity.Tracks)
{
model.Tracks.Add(new Track
{
Artist = track.Artist,
CD = model,
CDId = model.Id,
Id = track.Id,
Length = track.Length,
Name = track.Name
});
}
return model;
}
public void Delete(CD cd)
{
var entity = _db.CDs.Find(cd.Id);
_db.CDs.Remove(entity);
_db.SaveChanges();
}
public void Save(CD cd)
{
var entity = _db.CDs.FirstOrDefault(x => x.Id == cd.Id);
if (entity == null)
{
throw new ObjectNotFoundException("The requested CD is not in the databse");
}
entity.Artist = cd.Artist;
entity.Genre = cd.Genre;
entity.Title = cd.Title;
entity.Year = cd.Year;
_db.Entry(entity).State = EntityState.Modified;
_db.SaveChanges();
}
public IEnumerable<CD> GetListOfAllCd()
{
//Normally I would use a open source framework for this called
//Automapper (which you can get through NuGet). I'm doing the
//long-handed way here so you can see what I'm doing. I'll use
//Automapper in the other examples
var listOfEntityCd = _db.CDs.ToList();
var listOfModelCd = new List<CD>();
foreach (var entity in listOfEntityCd)
{
var model = new CD
{
Artist = entity.Artist,
Genre = entity.Genre,
Id = entity.Id,
Title = entity.Title,
Year = entity.Year
};
listOfModelCd.Add(model);
}
return listOfModelCd;
}
