// GET: Artwork
public ActionResult ViewArtwork()
{
KATEArtGalleryDBContext _allArtContext = new KATEArtGalleryDBContext();
List <ArtWork> artworkDetails = _allArtContext.Artwork.ToList();
return(View(artworkDetails));
}
// GET: Artists
public ActionResult ViewArt()
{
KATEArtGalleryDBContext _allArtistContext = new KATEArtGalleryDBContext();
List <Artist> artistDetails = _allArtistContext.Artist.ToList();
//select new ArtWork
//{
// Title = art.Title,
// //EmployeeId = emp.EmployeeId,
// //DepartmentName = dept.DepartmentName
//}).ToList();
return(View(artistDetails));
}
public ActionResult Delete(int artworkId)
{
if (artworkId != 0)
{
using (KATEArtGalleryDBContext _context = new KATEArtGalleryDBContext())
{
ArtWork artwork = _context.Artwork.Find(artworkId);
_context.Artwork.Remove(artwork);
_context.SaveChanges();
}
}
else
{
ViewBag.Title = "There was a problem";
}
return(RedirectToAction("ViewArtwork"));
}
[HttpPost] // must be here for page to work
public ActionResult Create(ArtWork artworkDetails)
{
using (KATEArtGalleryDBContext _context = new KATEArtGalleryDBContext())
{
if (ModelState.IsValid)
{
ArtWork artwork = new ArtWork
{
Title = artworkDetails.Title,
Category = artworkDetails.Category,
YearOriginalCreated = artworkDetails.YearOriginalCreated,
Medium = artworkDetails.Medium,
Dimensions = artworkDetails.Dimensions,
NumberMade = artworkDetails.NumberMade,
NumberInInventory = artworkDetails.NumberInInventory,
NumberSold = artworkDetails.NumberSold
};
_context.Artwork.Add(artwork);
_context.SaveChanges();
return(RedirectToAction("ViewArtwork"));
}
return(View(artworkDetails));
}
}
