public ActionResult SoldWork(string location)
{
var artWork = (from ip in db.IndividualPiece
join aw in db.ArtWork
on ip.ArtWorkId equals aw.ArtWorkId
join ar in db.Artist
on aw.ArtistId equals ar.ArtistId
where ip.Sold == true
where ip.Location.Replace(" ", "") == location.Replace(" ", "")
select new ArtViewModel
{
ArtWorkId = ip.ArtWorkId,
Title = aw.Title,
Category = ip.Category,
Name = ar.Name,
Image = ip.Image,
Medium = ip.Medium,
Price = ip.Price,
Profit = (ip.Price - ip.Cost),
Edition = ip.EditionNumber
}).ToList();
ArtListViewModel artListViewModel = new ArtListViewModel
{
artViewModel = artWork,
Location = location
};
return(View(artListViewModel));
}
public ActionResult OwnerArtCollection(OwnerIndexViewModel ownerIndexViewModel)
{
var artWork = (from ip in db.IndividualPiece
join aw in db.ArtWork
on ip.ArtWorkId equals aw.ArtWorkId
join ar in db.Artist
on aw.ArtistId equals ar.ArtistId
where ip.Sold == false
where ip.Location.Replace(" ", "") == ownerIndexViewModel.Location.Replace(" ", "")
select new ArtViewModel
{
ArtWorkId = ip.ArtWorkId,
Title = aw.Title,
Category = ip.Category,
Name = ar.Name,
Image = ip.Image,
Medium = ip.Medium,
Price = ip.Price,
Cost = ip.Cost,
Edition = ip.EditionNumber,
IndividualPieceId = ip.IndividualPieceId,
Location = ownerIndexViewModel.Location
}).ToList();
ArtListViewModel artListViewModel = new ArtListViewModel
{
artViewModel = artWork,
Location = ownerIndexViewModel.Location
};
return(View(artListViewModel));
}
