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