public IEnumerable <FeaturedVehicleShortItem> GetFeaturedVehicles()
{
List <FeaturedVehicleShortItem> featuredVehicles = new List <FeaturedVehicleShortItem>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GetFeaturedVehicles", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
FeaturedVehicleShortItem currentRow = new FeaturedVehicleShortItem();
currentRow.VehicleId = (int)dr["VehicleId"];
currentRow.VehicleYear = (int)dr["VehicleYear"];
currentRow.MakeDescription = dr["MakeDescription"].ToString();
currentRow.ModelDescription = dr["ModelDescription"].ToString();
currentRow.VehicleSalesPrice = (decimal)dr["VehicleSalesPrice"];
currentRow.VehiclePicture = dr["VehiclePicture"].ToString();
featuredVehicles.Add(currentRow);
}
}
}
return(featuredVehicles);
}
public IEnumerable <FeaturedVehicleShortItem> GetFeaturedVehicles()
{
List <FeaturedVehicleShortItem> list = new List <FeaturedVehicleShortItem>();
foreach (var vehicle in _Vehicles)
{
if (vehicle.VehicleIsFeatured == true)
{
FeaturedVehicleShortItem currentRow = new FeaturedVehicleShortItem();
currentRow.VehicleId = vehicle.VehicleId;
currentRow.VehicleYear = vehicle.VehicleYear;
currentRow.MakeDescription = vehicle.MakeDescription;
currentRow.ModelDescription = vehicle.ModelDescription;
currentRow.VehicleSalesPrice = vehicle.VehicleSalesPrice;
currentRow.VehiclePicture = vehicle.VehiclePicture;
list.Add(currentRow);
}
}
return(list);
}
