public FeaturedVehiclesViewModel GetAllFeatures()
{
FeaturedVehiclesViewModel featured = new FeaturedVehiclesViewModel();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = _connection;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "GetAllFeatures";
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
FeatureViewModel current = new FeatureViewModel();
current.VehicleId = (int)dr["VehicleId"];
current.YearMakeModel = dr["YearMakeModel"].ToString();
current.SalePrice = (decimal)dr["SalePrice"];
featured.features.Add(current);
}
}
}
return(featured);
}
public FeaturedVehiclesViewModel GetAllFeatures()
{
var returnFeatures = new FeaturedVehiclesViewModel();
foreach (var f in _features)
{
var currentCar = GetById(f.VehicleId);
var current = new FeatureViewModel()
{
SalePrice = currentCar.SalePrice,
VehicleId = currentCar.VehicleId,
YearMakeModel = currentCar.Year.ToString() + " " + currentCar.Make + " " + currentCar.Model
};
returnFeatures.features.Add(current);
}
return(returnFeatures);
}
