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