public ActionResult DeleteConfirmed(int id)
{
HoldingTable holdingtable = db.HoldingTables.Find(id);
db.HoldingTables.Remove(holdingtable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public string UpdateHolding(HoldingTable holding)
{
var currentHolding = db.HOLDINGs.Where(h => h.ID == holding.ID).Single();
//currentHolding.ID = holding.ID;
//currentHolding.InCirculation = holding.InCirculation;
//currentHolding.InUsed = holding.InUsed;
//currentHolding.IsConfusion = holding.IsConfusion;
//currentHolding.IsLost = holding.IsLost;
//currentHolding.ItemID = holding.ItemID;
//currentHolding.LibID = holding.LibID;
//currentHolding.LoanTypeID = holding.LoanTypeID;
//currentHolding.LocationID = holding.LocationID;
//currentHolding.LockedReason = holding.LockedReason;
currentHolding.Note = holding.Note;
// currentHolding.OnHold = holding.OnHold;
// currentHolding.POID = holding.POID;
currentHolding.Price = holding.Price;
currentHolding.Rate = db.ACQ_CURRENCY.Where(c => c.CurrencyCode == holding.Currency).Select(d => d.Rate).Single();
// currentHolding.Reason = holding.Reason;
// currentHolding.ReceiptedDate = DateTime.ParseExact(holding.ReceiptedDate,"dd/MM/yyyy",null) ;
currentHolding.RecordNumber = holding.RecordNumber;
currentHolding.Shelf = holding.Shelf;
// currentHolding.UseCount = holding.UseCount;
currentHolding.Volume = holding.Volume;
// currentHolding.ILLID = holding.ILLID;
// currentHolding.DateLastUsed = DateTime.ParseExact(holding.Date, "dd/MM/yyyy", null);
currentHolding.Currency = holding.Currency;
// currentHolding.CopyNumber = holding.CopyNumber;
currentHolding.CallNumber = holding.CallNumber;
// currentHolding.Availlable = holding.Availlable;
// currentHolding.AcquiredSourceID = holding.AcquiredSourceID;
currentHolding.AcquiredDate = DateTime.ParseExact(holding.AcquiredDate, "yyyy-MM-dd", null);
// currentHolding.Acquired = holding.Acquired;
try
{
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return("Cập nhật thành công!");
}
//
// GET: /HoldingTable/Details/5
public ActionResult Details(int id = 0)
{
HoldingTable holdingtable = db.HoldingTables.Find(id);
if (holdingtable == null)
{
return(HttpNotFound());
}
return(View(holdingtable));
}
public ActionResult Edit(HoldingTable holdingtable)
{
if (ModelState.IsValid)
{
db.Entry(holdingtable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(holdingtable));
}
public ActionResult Create(HoldingTable holdingtable)
{
if (ModelState.IsValid)
{
db.HoldingTables.Add(holdingtable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(holdingtable));
}
