public VechicleViewModel GetInventorysById(int id) { VechicleViewModel temp = Inventorys.Where(p => p.Id == id).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" }).FirstOrDefault(); return(temp); }
public void Purchased(PurchaseInfo purchase, int salesId) { var vechicle = Inventorys.Where(i => i.Id == purchase.VechicleId).First(); vechicle.PurchasePrice = purchase.Purchase; vechicle.PurchaseTypeId = Inventorys.Where(p => p.PurchaseTypes.PurchaseTypeName == purchase.PurchaseType).First().PurchaseTypeId; vechicle.FeatureVehicle = false; vechicle.PurchaseDate = DateTime.Now; vechicle.SalesPersonId = salesId; (this).SaveChanges(); }
public void DeleteVehicle(int id) { Inventory item = Inventorys.Where(i => i.Id == id).FirstOrDefault(); if (item != null) { var file = item.Picture; string path = Path.Combine(HttpContext.Current.Server.MapPath("~/Images"), Path.GetFileName(file)); File.Delete(path); Inventorys.Remove(item); (this).SaveChanges(); } }