public IEnumerable <VechicleViewModel> GetAll()
{
List <VechicleViewModel> repo = new List <VechicleViewModel>();
return(Inventorys.Include("Mdles").Include("Typs").Include("BodyStyles")
.Include("Transmissions").Include("Colors").Include("Interiors")
.Include("PurchaseTypes").Select(i => new VechicleViewModel
{
InventoryId = i.Id,
Make = i.Mdles.Makes.MakeName,
Model = i.Mdles.ModelName,
Type = i.Typs.TypeName,
BodyStyle = i.BodyStyles.BodyStyleName,
Year = i.Year,
Transmission = i.Transmissions.TransmissionName,
Color = i.Colors.ColorName,
Interior = i.Interiors.InteriorName,
Mileage = i.Mileage,
VIN = i.VIN,
MSRP = i.MSRP,
SalesPrice = i.SalesPrice,
Description = i.Description,
Picture = i.Picture,
FeatureVehicle = i.FeatureVehicle,
StillAvailable = i.PurchaseTypeId == null ? "Yes" : "No",
SalesId = i.SalesPersonId,
PurchasedPrice = i.PurchasePrice,
PurhasedDate = i.PurchaseDate
}));
}
public void EditVechicle(VechicleViewModel vechicle)
{
var editVehicle = Inventorys.Include("Mdles").Include("Typs").Include("BodyStyles")
.Include("Transmissions").Include("Colors").Include("Interiors")
.Include("PurchaseTypes").FirstOrDefault(p => p.Id == vechicle.InventoryId);
editVehicle.Id = vechicle.InventoryId;
editVehicle.Mdles.MakeId = Makes.FirstOrDefault(p => p.MakeName == vechicle.Make).MakeId;
editVehicle.MdleId = Models.FirstOrDefault(p => p.ModelName == vechicle.Model).MdleId;
editVehicle.BodyStyleId = BodyStyles.FirstOrDefault(p => p.BodyStyleName == vechicle.BodyStyle).BodyStyleId;
editVehicle.ColorId = Colors.SingleOrDefault(p => p.ColorName == vechicle.Color).ColorId;
editVehicle.TypId = Typs.SingleOrDefault(p => p.TypeName == vechicle.Type).TypId;
editVehicle.Year = vechicle.Year;
editVehicle.TransmissionId = Transmissions.SingleOrDefault(p => p.TransmissionName == vechicle.Transmission).TransmissionId;
editVehicle.InteriorId = Interiors.FirstOrDefault(p => p.InteriorName == vechicle.Interior).InteriorId;
editVehicle.Mileage = vechicle.Mileage;
editVehicle.VIN = vechicle.VIN;
editVehicle.MSRP = vechicle.MSRP;
editVehicle.SalesPrice = vechicle.SalesPrice;
editVehicle.Description = vechicle.Description;
editVehicle.FeatureVehicle = vechicle.FeatureVehicle;
if (editVehicle.Picture != null)
{
var oldFile = editVehicle.Picture;
string path = Path.Combine(HttpContext.Current.Server.MapPath("~/Images"),
Path.GetFileName(oldFile));
File.Delete(path);
}
if (vechicle.File != null && vechicle.File.ContentLength > 0)
{
string[] fileName = vechicle.File.FileName.Split('.');
string newName = "inventory-" + editVehicle.Id + "." + fileName.Last();
string path = Path.Combine(HttpContext.Current.Server.MapPath("~/Images"),
Path.GetFileName(newName));
vechicle.File.SaveAs(path);
editVehicle.Picture = newName;
}
(this).SaveChanges();
}
