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(); }