public static void AddGuitar(DTO.Guitar newGuitar)
{
GuitarsEntities db = new GuitarsEntities();
var dbGuitars = db.Guitars;
var guitar = new Guitar();
if (newGuitar.Brand.Trim().Length == 0)
{
throw new Exception("Brand is a required field.");
}
guitar.Brand = newGuitar.Brand;
guitar.Model = newGuitar.Model;
guitar.Year = newGuitar.Year;
guitar.Finish = newGuitar.Finish;
guitar.Id = newGuitar.Id;
try {
dbGuitars.Add(guitar);
db.SaveChanges();
}
catch (Exception ex) {
//LOG EXCEPTION
throw ex;
}
}
public static List <DTO.Guitar> GetGuitars()
{
var db = new GuitarsEntities();
var dbGuitars = db.Guitars.OrderBy(p => p.Brand).ToList();
var dtoGuitars = new List <DTO.Guitar>();
foreach (var dbGuitar in dbGuitars)
{
var dtoGuitar = new DTO.Guitar();
dtoGuitar.Id = dbGuitar.Id;
dtoGuitar.Brand = dbGuitar.Brand;
dtoGuitar.Model = dbGuitar.Model;
dtoGuitar.Year = dbGuitar.Year;
dtoGuitar.Finish = dbGuitar.Finish;
dtoGuitars.Add(dtoGuitar);
}
return(dtoGuitars);
}
