public ICollection <VisualizeCarViewModel> GetOnlyUserCars(string userId)
{
var userCarOffersToVisualize = new List <VisualizeCarViewModel>();
foreach (var carOffer in dbContext.CarOffers.Where(x => x.UserId == userId).ToArray())
{
var car = new VisualizeCarViewModel()
{
Id = carOffer.Id,
Title = carOffer.Title,
Condition = carOffer.Condition.ToString(),
Year = carOffer.Year,
FuelType = carOffer.FuelType.ToString(),
HorsePower = carOffer.HorsePower,
Price = carOffer.Price,
Kilometers = carOffer.Kilometers,
EngineSize = carOffer.EngineSize,
Gearbox = carOffer.Gearbox.ToString(),
Doors = carOffer.Doors
};
car.Image = ConvertByteArrayToImage(carOffer.OfferImage);
userCarOffersToVisualize.Add(car);
}
return(userCarOffersToVisualize);
}
public ICollection <VisualizeCarViewModel> CarsForFeaturing()
{
var carOffersToVisualize = new List <VisualizeCarViewModel>();
foreach (var carOffer in dbContext.CarOffers.OrderByDescending(x => x.CreatedOn).Take(6).ToArray())
{
var car = new VisualizeCarViewModel()
{
Id = carOffer.Id,
Title = carOffer.Title,
Condition = carOffer.Condition.ToString(),
Year = carOffer.Year,
FuelType = carOffer.FuelType.ToString(),
HorsePower = carOffer.HorsePower,
Price = carOffer.Price,
Kilometers = carOffer.Kilometers,
EngineSize = carOffer.EngineSize,
Gearbox = carOffer.Gearbox.ToString(),
Doors = carOffer.Doors
};
car.Image = ConvertByteArrayToImage(carOffer.OfferImage);
carOffersToVisualize.Add(car);
}
return(carOffersToVisualize);
}
public ICollection <VisualizeCarViewModel> CarsForVisualization(string sortingType)
{
var carOffersToVisualize = new List <VisualizeCarViewModel>();
var carOffers = dbContext.CarOffers.ToList();
if (sortingType == "UploadDate")
{
carOffers = carOffers.OrderByDescending(x => x.CreatedOn).ToList();
}
else if (sortingType == "LowestPrice")
{
carOffers = carOffers.OrderBy(x => x.Price).ToList();
}
else if (sortingType == "HighestPrice")
{
carOffers = carOffers.OrderByDescending(x => x.Price).ToList();
}
else if (sortingType == "OldestYear")
{
carOffers = carOffers.OrderBy(x => x.Year).ToList();
}
else if (sortingType == "NewestYear")
{
carOffers = carOffers.OrderByDescending(x => x.Year).ToList();
}
foreach (var carOffer in carOffers)
{
var car = new VisualizeCarViewModel()
{
Id = carOffer.Id,
Title = carOffer.Title,
Condition = carOffer.Condition.ToString(),
Year = carOffer.Year,
FuelType = carOffer.FuelType.ToString(),
HorsePower = carOffer.HorsePower,
Price = carOffer.Price,
Kilometers = carOffer.Kilometers,
EngineSize = carOffer.EngineSize,
Gearbox = carOffer.Gearbox.ToString(),
Doors = carOffer.Doors
};
car.Image = ConvertByteArrayToImage(carOffer.OfferImage);
carOffersToVisualize.Add(car);
}
return(carOffersToVisualize);
}
public ICollection <VisualizeCarViewModel> GetOnlyUserCars(string userId, FiltersInputModel filtersInput)
{
var carOffersToVisualize = new List <VisualizeCarViewModel>();
var filtersQuery = GetFiltersAsQuery(filtersInput);
var carOffers = dbContext.CarOffers.FromSqlRaw(
"select * from CarOffers " +
$"where {filtersQuery}")
.ToList();
foreach (var carOffer in carOffers.Where(x => x.UserId == userId))
{
var car = new VisualizeCarViewModel()
{
Id = carOffer.Id,
Title = carOffer.Title,
Condition = carOffer.Condition.ToString(),
Year = carOffer.Year,
FuelType = carOffer.FuelType.ToString(),
HorsePower = carOffer.HorsePower,
Price = carOffer.Price,
Kilometers = carOffer.Kilometers,
EngineSize = carOffer.EngineSize,
Gearbox = carOffer.Gearbox.ToString(),
Doors = carOffer.Doors
};
car.Image = ConvertByteArrayToImage(carOffer.OfferImage);
carOffersToVisualize.Add(car);
}
return(carOffersToVisualize);
}
