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