public List <BodyStyles> GetAllBodyStyles() { List <BodyStyles> bodyStyles = new List <BodyStyles>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("BodyStylesSelectAll", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { BodyStyles currentRow = new BodyStyles(); currentRow.BodyStyleId = (int)dr["BodyStyleId"]; currentRow.BodyStyleDescription = dr["BodyStyleDescription"].ToString(); bodyStyles.Add(currentRow); } } } return(bodyStyles); }
public void SetStyles(IEnumerable <BodyStyle> bodyStyle) { foreach (var body in bodyStyle) { BodyStyles.Add(new SelectListItem() { Value = body.BodyStyleId.ToString(), Text = body.Description }); } }
public void SetBodyStyles(IEnumerable <BodyStyleModel> bodyStyles) { foreach (var bodystyle in bodyStyles) { BodyStyles.Add(new SelectListItem() { Value = bodystyle.BodyStyle, Text = bodystyle.BodyStyle }); } }
public void SetBodyStyles(IEnumerable <LookupValue> bodyStyles) { foreach (var bs in bodyStyles) { BodyStyles.Add(new SelectListItem() { Value = bs.Description.ToString(), Text = bs.Description.ToString() }); } }
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(); }
public BodyStyle GetBodyStyleById(int id) { return(BodyStyles.Where(i => i.BodyStyleId == id).FirstOrDefault()); }