public ActionResult PriceRangeView(decimal priceFloor, decimal priceCeiling)
{
ArtDetailViewModel art = new ArtDetailViewModel();
art.selectedPriceFloor = priceFloor;
art.selectedPriceCeiling = priceCeiling;
using (Context _context = new Context())
{
art.ArtListings = (from work in _context.ArtWork
join piece in _context.IndividualPiece
on work.ArtWorkId equals piece.ArtWorkId
join artist in _context.Artist
on work.ArtistId equals artist.ArtistId
where piece.Price > art.selectedPriceFloor && piece.Price < art.selectedPriceCeiling
select new ArtWorkWithImagesViewModel
{
ArtWorkId = work.ArtWorkId,
Title = work.Title,
Image = piece.Image,
PurchaseURL = piece.PurchaseURL,
ArtistName = artist.Name,
Medium = work.Medium,
ArtistId = artist.ArtistId
}).Distinct().ToList();
}
return(View("Index", art));
}
public ArtDetailView(object parameter)
{
InitializeComponent();
BindingContext = new ArtDetailViewModel(parameter);
if (Device.RuntimePlatform == "Android")
{
NavigationPage.SetHasNavigationBar(this, false);
}
SharedTransitionNavigationPage.SetTransitionDuration(this, 500);
}
// GET: Home
public ActionResult Index()
{
Context _context = new Context();
ArtDetailViewModel art = new ArtDetailViewModel();
art.ArtListings = (from work in _context.ArtWork
join piece in _context.IndividualPiece
on work.ArtWorkId equals piece.ArtWorkId
join artist in _context.Artist
on work.ArtistId equals artist.ArtistId
group work by new
{
ArtWorkId = work.ArtWorkId,
Title = work.Title,
Image = piece.Image,
PurchaseURL = piece.PurchaseURL,
ArtistId = artist.ArtistId,
ArtistName = artist.Name,
Medium = work.Medium
} into artgroup
select new ArtWorkWithImagesViewModel
{
ArtWorkId = artgroup.Key.ArtWorkId,
Title = artgroup.Key.Title,
Image = artgroup.Key.Image,
PurchaseURL = artgroup.Key.PurchaseURL,
ArtistId = artgroup.Key.ArtistId,
ArtistName = artgroup.Key.ArtistName,
Medium = artgroup.Key.Medium
}).Distinct().ToList();
/*
* List<decimal> artPrices = (from piece in _context.IndividualPiece
* select piece.Price).Distinct().ToList();
* foreach (var item in artPrices)
* {
* art.priceFloor.Add(Math.Round(item, 2));
* art.priceCeiling.Add(Math.Round(item, 2));
* SelectListItem price = new SelectListItem
* {
* Text = item.ToString(),
* Value = item.ToString()
* };
* //art.priceOptions.
* }
*/
return(View(art));
}
public ActionResult IndividualArtistView(int ArtistId)
{
Context _context = new Context();
ArtDetailViewModel art = new ArtDetailViewModel();
art.ArtListings = (from work in _context.ArtWork
join artist in _context.Artist
on work.ArtistId equals artist.ArtistId
where work.ArtistId == ArtistId
join piece in _context.IndividualPiece
on work.ArtWorkId equals piece.ArtWorkId
select new ArtWorkWithImagesViewModel
{
ArtWorkId = work.ArtWorkId,
Title = work.Title,
Image = piece.Image,
PurchaseURL = piece.PurchaseURL,
ArtistName = artist.Name,
Medium = work.Medium
}).Distinct().ToList();
return(View(art));
}
