public List <FeaturedVehicleItem> GetFeaturedVehicleList() { List <FeaturedVehicleItem> vehicles = new List <FeaturedVehicleItem>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("FeaturedVehicleSelectAll", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { FeaturedVehicleItem currentRow = new FeaturedVehicleItem(); currentRow.VehicleID = (int)dr["VehicleID"]; currentRow.VehicleYear = (int)dr["VehicleYear"]; currentRow.MakeName = dr["MakeName"].ToString(); currentRow.ModelName = dr["ModelName"].ToString(); currentRow.Price = (decimal)dr["Price"]; currentRow.ImageFileName = dr["ImageFileName"].ToString(); currentRow.Vin = dr["Vin"].ToString(); vehicles.Add(currentRow); } } } return(vehicles); }
public IEnumerable <FeaturedVehicleItem> GetFeatured() { List <FeaturedVehicleItem> featuredList = new List <FeaturedVehicleItem>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetFeatured"); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { FeaturedVehicleItem currentRow = new FeaturedVehicleItem(); currentRow.MakeName = dr["MakeName"].ToString(); currentRow.ModelName = dr["ModelName"].ToString(); currentRow.PictureFileName = dr["PictureFileName"].ToString(); currentRow.Year = (int)dr["Year"]; currentRow.SalesPrice = (decimal)dr["SalesPrice"]; currentRow.vehicleId = (int)dr["VehicleId"]; currentRow.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]); featuredList.Add(currentRow); } return(featuredList); } } }
public IEnumerable <FeaturedVehicleItem> GetFeatured() { var featuredList = _vehicles.Where(v => v.IsFeatured == true).ToList(); var featuredVehicleDetails = GetNamesFromId(featuredList); List <FeaturedVehicleItem> featuredVehicleItems = new List <FeaturedVehicleItem>(); foreach (var vehicle in featuredVehicleDetails) { FeaturedVehicleItem featuredItem = new FeaturedVehicleItem { MakeName = vehicle.MakeName, vehicleId = vehicle.VehicleId, ModelName = vehicle.ModelName, Year = vehicle.Year, PictureFileName = vehicle.PictureFileName, SalesPrice = vehicle.SalesPrice }; featuredVehicleItems.Add(featuredItem); } return(featuredVehicleItems); }