public Car FindById(long id)
{
using (var context = new MaintenanceTrackerContext())
{
return context.Cars.Include("Make").Include("Model").SingleOrDefault(c => c.Id == id);
}
}
public IEnumerable<Car> FindAllCars()
{
using (var context = new MaintenanceTrackerContext() )
{
return context.Cars.Include( "Make" ).Include( "Model" ).ToList();
}
}
public void DeleteCar( long id )
{
using (var context = new MaintenanceTrackerContext())
{
var car = context.Cars.SingleOrDefault( c => c.Id == id );
context.Cars.Remove( car );
context.SaveChanges();
}
}
public Car UpdateCar(Car car)
{
using (var context = new MaintenanceTrackerContext())
{
context.Cars.Attach( car );
context.Entry( car ).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
return car;
}
}
public Car CreateCar(Car car)
{
using ( var context = new MaintenanceTrackerContext() )
{
if ( context.Makes.Find( car.CarMakeId ) != null )
{
car.Make = null;
}
if ( context.Models.Find( car.CarModelId ) != null )
{
car.Model = null;
}
context.Cars.Add( car );
context.SaveChanges();
return car;
}
}