public ActionResult EditIp(EditIpViewModel editIpViewModel)
{
if (ModelState.IsValid)
{
IndividualPiece individualPiece = new IndividualPiece
{
IndividualPieceId = editIpViewModel.IndividualPieceId,
ArtWorkId = editIpViewModel.SelectedArtWorkId,
Category = editIpViewModel.Category,
Image = editIpViewModel.Image,
Cost = editIpViewModel.Cost,
Price = editIpViewModel.Price,
Sold = editIpViewModel.Sold,
Location = editIpViewModel.Location,
EditionNumber = editIpViewModel.EditionNumber,
Medium = editIpViewModel.Medium,
Dimensions = editIpViewModel.Dimensions
};
db.Entry(individualPiece).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(editIpViewModel));
}
public ActionResult CreatePiece(PieceViewModel pieces)
{
using (DataStoreContext db = new DataStoreContext())
{
if (ModelState.IsValid)
{
var matchingArtWork = db.ArtWork.First(a => a.Title == pieces.Title).ArtWorkId;
if (matchingArtWork > 0)
{
IndividualPiece piece = new IndividualPiece
{
ArtWorkId = matchingArtWork,
Image = pieces.Image,
Price = pieces.AskingPrice,
Cost = pieces.Cost,
Sold = pieces.Sold,
EditionNumber = pieces.EditionNumber,
Location = pieces.Location,
InvoiceId = null
};
db.IndividualPiece.Add(piece);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.Title = "Our system currently only supports adding new prints of existing art.";
}
}
return(View(pieces));
}
}
public ActionResult CreateIndividualPiece(ArtWorkDropViewModel createIndividualPiece)
{
if (ModelState.IsValid)
{
var ip = new IndividualPiece
{
ArtWorkId = createIndividualPiece.SelectedArtWorkId,
Category = createIndividualPiece.Category,
Image = createIndividualPiece.Image,
Cost = createIndividualPiece.Cost,
Price = createIndividualPiece.Price,
Sold = createIndividualPiece.Sold,
Location = createIndividualPiece.Location,
EditionNumber = createIndividualPiece.EditionNumber,
Medium = createIndividualPiece.Medium,
Dimensions = createIndividualPiece.Dimensions
};
db.IndividualPiece.Add(ip);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(createIndividualPiece));
}
public ActionResult DeleteIpConfirmed(int id)
{
IndividualPiece individualPiece = db.IndividualPiece.Find(id);
db.IndividualPiece.Remove(individualPiece);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(OwnerInventoryListViewModel ownerInvDetails)
{
var artistId = getNextArtistId(ownerInvDetails.Name);
var artworkId = getNextArtworkId();
var ipId = getNextIpId();
using (Context _context = new Context())
{
if (ModelState.IsValid)
{
Artist artist = new Artist
{
Name = ownerInvDetails.Name,
ArtistId = artistId,
BirthYear = ownerInvDetails.BirthYear
};
_context.Artist.Add(artist); // saves data to the context
_context.SaveChanges(); // saves data to database
}
if (ModelState.IsValid)
{
ArtWork artwork = new ArtWork
{
ArtWorkId = artworkId,
Title = ownerInvDetails.Title,
ArtistId = artistId,
Category = ownerInvDetails.Category
};
_context.ArtWork.Add(artwork); // saves data to the context
_context.SaveChanges(); // saves data to database
}
if (ModelState.IsValid)
{
IndividualPiece ip = new IndividualPiece
{
IndividualPieceId = ipId,
ArtWorkId = artworkId,
Cost = ownerInvDetails.Cost,
Price = ownerInvDetails.Price,
Sold = ownerInvDetails.Sold,
Location = ownerInvDetails.Location,
};
_context.IndividualPiece.Add(ip); // saves data to the context
_context.SaveChanges(); // saves data to database
}
}
return(RedirectToAction("Index"));
}
// GET: Owner/Delete/5
public ActionResult Delete(int IndividualPieceId)
{
if (IndividualPieceId != 0)
{
using (Context _context = new Context())
{
IndividualPiece idvP = _context.IndividualPiece.Find(IndividualPieceId);
_context.IndividualPiece.Remove(idvP);
_context.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
// GET: Owner/Delete/5
public ActionResult DeleteIp(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IndividualPiece individualPiece = db.IndividualPiece.Find(id);
if (individualPiece == null)
{
return(HttpNotFound());
}
return(View(individualPiece));
}
// DELETE
public ActionResult DeletePiece(int IndividualPieceId)
{
if (IndividualPieceId != 0)
{
using (DataStoreContext db = new DataStoreContext())
{
IndividualPiece piece = db.IndividualPiece.Find(IndividualPieceId);
db.IndividualPiece.Remove(piece);
db.SaveChanges();
}
}
else
{
ViewBag.Title = "There was a problem";
}
return(RedirectToAction("Index"));
}
// GET: Owner/Edit/5
public ActionResult EditIp(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IndividualPiece individualPiece = db.IndividualPiece.Find(id);
IEnumerable <SelectListItem> selectList =
from a in db.ArtWork
select new SelectListItem
{
Text = a.Title,
Value = a.ArtWorkId.ToString(),
Selected = a.ArtWorkId.ToString() == id.ToString()
};
EditIpViewModel ip = new EditIpViewModel()
{
IndividualPieceId = individualPiece.IndividualPieceId,
ArtWorkList = selectList,
ArtWorkId = individualPiece.ArtWorkId,
Category = individualPiece.Category,
Image = individualPiece.Image,
Cost = individualPiece.Cost,
Price = individualPiece.Price,
Sold = individualPiece.Sold,
Location = individualPiece.Location,
EditionNumber = individualPiece.EditionNumber,
Medium = individualPiece.Medium,
Dimensions = individualPiece.Dimensions
};
if (ip == null)
{
return(HttpNotFound());
}
return(View(ip));
}
