public VehicleBase GetVehicleById(int id)
{
// Attempt to fetch from the data store
var fetchedObject = ds.Vehicles.Include("Manufacturer").SingleOrDefault(i => i.Id == id);
if (fetchedObject == null)
{
return(null);
}
else
{
// Prepare the return result
var v = new VehicleBase()
{
Id = fetchedObject.Id,
Model = fetchedObject.Model,
Trim = fetchedObject.Trim,
ModelYear = fetchedObject.ModelYear,
MSRP = fetchedObject.MSRP,
ManufacturerId = fetchedObject.Manufacturer.Id,
ManufacturerName = fetchedObject.Manufacturer.Name
};
// Return the result
return(v);
}
}
// Vehicle
// ############################################################
// Get all, get one
public IEnumerable <VehicleBase> GetAllVehicles()
{
// Fetch from the data store
var fetchedObjects = ds.Vehicles.Include("Manufacturer").OrderBy(m => m.Model);
// Prepare the return result
var vehicles = new List <VehicleBase>();
foreach (var item in fetchedObjects)
{
var v = new VehicleBase()
{
Id = item.Id,
Model = item.Model,
Trim = item.Trim,
ModelYear = item.ModelYear,
MSRP = item.MSRP,
ManufacturerId = item.Manufacturer.Id,
ManufacturerName = item.Manufacturer.Name
};
vehicles.Add(v);
}
// Return the result
return(vehicles);
}
// ############################################################
// Add new
public VehicleBase AddNewVehicle(VehicleAdd newItem)
{
// Attempt to fetch the associated object
var m = ds.Manufacturers.Find(newItem.ManufacturerId);
if (m == null)
{
return(null);
}
else
{
// Associated object is valid, so continue
// Create a new design model object
var addedItem = new Vehicle()
{
Model = newItem.Model,
Trim = newItem.Trim,
ModelYear = newItem.ModelYear,
MSRP = newItem.MSRP,
Manufacturer = m
};
// Add and save
ds.Vehicles.Add(addedItem);
ds.SaveChanges();
// Prepare the return object
var v = new VehicleBase()
{
Id = addedItem.Id,
Model = addedItem.Model,
Trim = addedItem.Trim,
ModelYear = addedItem.ModelYear,
MSRP = addedItem.MSRP,
ManufacturerId = m.Id,
ManufacturerName = m.Name
};
// Return the result
return(v);
}
}
// ############################################################
// Add new
public VehicleBase AddNewVehicle(VehicleAdd newItem)
{
// Attempt to fetch the associated object
var m = ds.Manufacturers.Find(newItem.ManufacturerId);
if (m == null)
{
return null;
}
else
{
// Associated object is valid, so continue
// Create a new design model object
var addedItem = new Vehicle()
{
Model = newItem.Model,
Trim = newItem.Trim,
ModelYear = newItem.ModelYear,
MSRP = newItem.MSRP,
Manufacturer = m
};
// Add and save
ds.Vehicles.Add(addedItem);
ds.SaveChanges();
// Prepare the return object
var v = new VehicleBase()
{
Id = addedItem.Id,
Model = addedItem.Model,
Trim = addedItem.Trim,
ModelYear = addedItem.ModelYear,
MSRP = addedItem.MSRP,
ManufacturerId = m.Id,
ManufacturerName = m.Name
};
// Return the result
return v;
}
}
public VehicleBase GetVehicleById(int id)
{
// Attempt to fetch from the data store
var fetchedObject = ds.Vehicles.Include("Manufacturer").SingleOrDefault(i => i.Id == id);
if (fetchedObject == null)
{
return null;
}
else
{
// Prepare the return result
var v = new VehicleBase()
{
Id = fetchedObject.Id,
Model = fetchedObject.Model,
Trim = fetchedObject.Trim,
ModelYear = fetchedObject.ModelYear,
MSRP = fetchedObject.MSRP,
ManufacturerId = fetchedObject.Manufacturer.Id,
ManufacturerName = fetchedObject.Manufacturer.Name
};
// Return the result
return v;
}
}
// Vehicle
// ############################################################
// Get all, get one
public IEnumerable<VehicleBase> GetAllVehicles()
{
// Fetch from the data store
var fetchedObjects = ds.Vehicles.Include("Manufacturer").OrderBy(m => m.Model);
// Prepare the return result
var vehicles = new List<VehicleBase>();
foreach (var item in fetchedObjects)
{
var v = new VehicleBase()
{
Id = item.Id,
Model = item.Model,
Trim = item.Trim,
ModelYear = item.ModelYear,
MSRP = item.MSRP,
ManufacturerId = item.Manufacturer.Id,
ManufacturerName = item.Manufacturer.Name
};
vehicles.Add(v);
}
// Return the result
return vehicles;
}
