public ListingDetailItem GetDetails(int listingId) { ListingDetailItem details = null; using (var cn = new SqlConnection()) { cn.ConnectionString = Settings.GetConnectionString(); var parameters = new DynamicParameters(); parameters.Add("@VehicleListingId", listingId); details = cn.Query <ListingDetailItem>("VehicleDetailsById", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault(); } return(details); }
public ListingDetailItem GetDetails(int listingId) { var bodyStyleRepo = new BodyStyleRepoQA(); var colorRepo = new ColorRepoQA(); var transmissionTypeRepo = new TransmissionTypeRepoQA(); var makeRepo = new VehicleMakeRepoQA(); var modelRepo = new VehicleModelRepoQA(); var typeRepo = new VehicleTypeRepoQA(); var listing = GetById(listingId); if (listing == null) { return(null); } else { ListingDetailItem details = new ListingDetailItem(); details.VehicleListingId = listing.VehicleListingId; details.Year = listing.Year; details.VehicleMakeId = listing.VehicleMakeId; details.VehicleMakeName = makeRepo.GetById(listing.VehicleMakeId).VehicleMakeName; details.VehicleModelId = listing.VehicleModelId; details.VehicleModelName = modelRepo.GetById(listing.VehicleModelId).VehicleModelName; details.BodyStyleId = listing.BodyStyleId; details.BodyStyleName = bodyStyleRepo.GetById(listing.BodyStyleId).BodyStyleName; details.TransmissionTypeId = listing.TransmissionTypeId; details.TransmissionTypeName = transmissionTypeRepo.GetById(listing.TransmissionTypeId).TransmissionTypeName; details.SalePrice = listing.SalePrice; details.Mileage = listing.Mileage; details.MSRP = listing.MSRP; details.InteriorColorId = listing.InteriorColorId; details.InteriorColor = colorRepo.GetById(listing.InteriorColorId).ColorName; details.ColorId = listing.ColorId; details.ColorName = colorRepo.GetById(listing.ColorId).ColorName; details.VIN = listing.VIN; details.ImageFileName = listing.ImageFileName; details.Description = listing.Description; return(details); } }