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)); }