public ICollection <VisualizeMotorcycleViewModel> GetOnlyUserMotorcycles(string userId, FiltersInputModel filtersInput)
{
var motorcycleOffersToVisualize = new List <VisualizeMotorcycleViewModel>();
var filtersQuery = GetFiltersAsQuery(filtersInput);
var motorcycleOffers = dbContext.MotorcycleOffers.FromSqlRaw(
"select * from MotorcycleOffers " +
$"where {filtersQuery}")
.ToList();
foreach (var motorcycleOffer in motorcycleOffers.Where(x => x.UserId == userId))
{
var motorcycle = new VisualizeMotorcycleViewModel()
{
Id = motorcycleOffer.Id,
Title = motorcycleOffer.Title,
Condition = motorcycleOffer.Condition.ToString(),
Year = motorcycleOffer.Year,
FuelType = motorcycleOffer.FuelType.ToString(),
HorsePower = motorcycleOffer.HorsePower,
Price = motorcycleOffer.Price,
Kilometers = motorcycleOffer.Kilometers,
CubicCentimeters = motorcycleOffer.CubicCentimeters,
Gearbox = motorcycleOffer.Gearbox.ToString(),
};
motorcycle.Image = ConvertByteArrayToImage(motorcycleOffer.OfferImage);
motorcycleOffersToVisualize.Add(motorcycle);
}
return(motorcycleOffersToVisualize);
}
public ICollection <VisualizeMotorcycleViewModel> MotorcyclesForVisualization()
{
var motorcycleOffersToVisualize = new List <VisualizeMotorcycleViewModel>();
foreach (var motorcycleOffer in dbContext.MotorcycleOffers.ToArray())
{
var motorcycle = new VisualizeMotorcycleViewModel()
{
Id = motorcycleOffer.Id,
Title = motorcycleOffer.Title,
Condition = motorcycleOffer.Condition.ToString(),
Year = motorcycleOffer.Year,
FuelType = motorcycleOffer.FuelType.ToString(),
HorsePower = motorcycleOffer.HorsePower,
Price = motorcycleOffer.Price,
Kilometers = motorcycleOffer.Kilometers,
CubicCentimeters = motorcycleOffer.CubicCentimeters,
Gearbox = motorcycleOffer.Gearbox.ToString(),
};
motorcycle.Image = ConvertByteArrayToImage(motorcycleOffer.OfferImage);
motorcycleOffersToVisualize.Add(motorcycle);
}
return(motorcycleOffersToVisualize);
}
public ICollection <VisualizeMotorcycleViewModel> GetOnlyUserMotorcycles(string userId, string sortingType)
{
var userMotorcycleOffersToVisualize = new List <VisualizeMotorcycleViewModel>();
var motorcycleOffers = dbContext.MotorcycleOffers.Where(x => x.UserId == userId).ToList();
if (sortingType == "UploadDate")
{
motorcycleOffers = motorcycleOffers.OrderByDescending(x => x.CreatedOn).ToList();
}
else if (sortingType == "LowestPrice")
{
motorcycleOffers = motorcycleOffers.OrderBy(x => x.Price).ToList();
}
else if (sortingType == "HighestPrice")
{
motorcycleOffers = motorcycleOffers.OrderByDescending(x => x.Price).ToList();
}
else if (sortingType == "OldestYear")
{
motorcycleOffers = motorcycleOffers.OrderBy(x => x.Year).ToList();
}
else if (sortingType == "NewestYear")
{
motorcycleOffers = motorcycleOffers.OrderByDescending(x => x.Year).ToList();
}
foreach (var motorcycleOffer in motorcycleOffers)
{
var motorcycle = new VisualizeMotorcycleViewModel()
{
Id = motorcycleOffer.Id,
Title = motorcycleOffer.Title,
Condition = motorcycleOffer.Condition.ToString(),
Year = motorcycleOffer.Year,
FuelType = motorcycleOffer.FuelType.ToString(),
HorsePower = motorcycleOffer.HorsePower,
Price = motorcycleOffer.Price,
Kilometers = motorcycleOffer.Kilometers,
CubicCentimeters = motorcycleOffer.CubicCentimeters,
Gearbox = motorcycleOffer.Gearbox.ToString(),
};
motorcycle.Image = ConvertByteArrayToImage(motorcycleOffer.OfferImage);
userMotorcycleOffersToVisualize.Add(motorcycle);
}
return(userMotorcycleOffersToVisualize);
}
