public IEnumerable <InventoryReportListingItem> GetInventory()
{
List <InventoryReportListingItem> inventoryReportItems = new List <InventoryReportListingItem>();
using (var dbConnection = new SqlConnection(Settings.GetConnectionString()))
{
try
{
SqlCommand cmd = new SqlCommand("SelectAllInventoryForReport", dbConnection);
cmd.CommandType = CommandType.StoredProcedure;
dbConnection.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
InventoryReportListingItem inventoryReportItem = new InventoryReportListingItem();
inventoryReportItem.Year = (dr["Year"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(dr["Year"]));
inventoryReportItem.IsNew = dr.GetBoolean(dr.GetOrdinal("IsNew"));
inventoryReportItem.StockValue = (decimal)dr["StockValue"];
inventoryReportItem.IsSold = dr.GetBoolean(dr.GetOrdinal("IsSold"));
inventoryReportItem.Make = dr["Make"].ToString();
inventoryReportItem.Model = dr["Model"].ToString();
inventoryReportItems.Add(inventoryReportItem);
}
}
return(inventoryReportItems);
}
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(inventoryReportItems);
}
}
public IEnumerable <InventoryReportListingItem> GetInventory()
{
List <Car> cars = carRepo.GetAllCars().ToList();
foreach (var car in cars)
{
InventoryReportListingItem reportItem = new InventoryReportListingItem
{
IsNew = car.IsNew,
Make = makeRepo.GetMakeById(car.MakeId.ToString()).MakeName,
Model = modelRepo.GetModelById(car.ModelId).ModelName,
UnitsInStock = car.UnitsInStock,
StockValue = car.MSRP * car.UnitsInStock,
Year = car.ModelYear
};
_inventoryReports.Add(reportItem);
}
return(_inventoryReports);
}
