public IEnumerable <FeaturedShortListItem> GetAllFeaturedCars()
{
List <Car> featuredCars = _cars.FindAll(c => c.IsFeatured == true);
List <FeaturedShortListItem> featuredCarsShortList = new List <FeaturedShortListItem>();
MakeRepositoryMock makeRepo = new MakeRepositoryMock();
ModelRepositoryMock modelRepo = new ModelRepositoryMock();
foreach (var car in featuredCars)
{
FeaturedShortListItem featuredCar = new FeaturedShortListItem
{
CarId = car.CarId,
ImageURL = car.IMGFilePath,
Make = makeRepo.GetMakeById(car.MakeId).MakeName,
Model = modelRepo.GetModelById(car.ModelId).ModelName,
MakeId = car.MakeId,
ModelId = car.ModelId,
Year = car.ModelYear,
Price = car.SalePrice
};
featuredCarsShortList.Add(featuredCar);
}
return(featuredCarsShortList);
}
public IEnumerable <FeaturedShortListItem> GetAllFeaturedCars()
{
List <FeaturedShortListItem> featuredCars = new List <FeaturedShortListItem>();
using (var dbConnection = new SqlConnection(Settings.GetConnectionString()))
{
try
{
SqlCommand cmd = new SqlCommand("SelectFeaturedCars", dbConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@isFeatured", "true");
dbConnection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
FeaturedShortListItem featuredCar = new FeaturedShortListItem();
featuredCar.CarId = (int)dr["CarId"];
featuredCar.ImageURL = dr["IMGFilePath"].ToString();
featuredCar.MakeId = (int)dr["MakeId"];
featuredCar.ModelId = (int)dr["ModelId"];
featuredCar.Make = dr["MakeName"].ToString();
featuredCar.Model = dr["ModelName"].ToString();
featuredCar.Year = (dr["ModelYear"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["ModelYear"]));
featuredCar.Price = (decimal)dr["SalePrice"];
featuredCars.Add(featuredCar);
}
}
return(featuredCars);
}
catch (Exception ex)
{
string errorMessage = String.Format(CultureInfo.CurrentCulture,
"Exception Type: {0}, Message: {1}{2}",
ex.GetType(),
ex.Message,
ex.InnerException == null ? String.Empty :
String.Format(CultureInfo.CurrentCulture,
" InnerException Type: {0}, Message: {1}",
ex.InnerException.GetType(),
ex.InnerException.Message));
System.Diagnostics.Debug.WriteLine(errorMessage);
dbConnection.Close();
}
return(featuredCars);
}
}
