public IEnumerable <FeaturedVehicle> GetFeatured() { List <FeaturedVehicle> featured = new List <FeaturedVehicle>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetFeatured", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var vehicle = new FeaturedVehicle(); vehicle.ID = (int)dr["ID"]; vehicle.Make = dr["Make"].ToString(); vehicle.Model = dr["Model"].ToString(); vehicle.Year = (int)dr["Year"]; vehicle.SalePrice = (decimal)dr["SalePrice"]; vehicle.ImageFileName = dr["ImageFileName"].ToString(); featured.Add(vehicle); } } } return(featured); }
public List <FeaturedVehicle> GetFeaturedVehicles() { List <FeaturedVehicle> vehicles = new List <FeaturedVehicle>(); using (var cn = new SqlConnection("Server=localhost;Database=GuildCars;User Id=sa;Password=sqlserver;")) { SqlCommand cmd = new SqlCommand("DisplayFeaturedVehicles", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { FeaturedVehicle currentRow = new FeaturedVehicle(); currentRow.ImageFileName = dr["ImageFilePath"].ToString(); currentRow.MakeName = dr["MakeName"].ToString(); currentRow.ModelName = dr["ModelName"].ToString(); currentRow.VehicleId = (int)dr["VehicleId"]; currentRow.Year = dr["ModelYear"].ToString(); currentRow.Price = (int)dr["Price"]; vehicles.Add(currentRow); } } } return(vehicles); }
public void AddFeatured(int vehicleId) { var feature = new FeaturedVehicle(); feature.FeaturedId = GetNextFeatureId(); feature.VehicleId = vehicleId; _features.Add(feature); }