public ActionResult ReturnBook(int serial) { // Query the database for the rows to be deleted. using (Team8LibraryContext db = new Team8LibraryContext()) { var query = from co in db.CheckedOut select new { co.Serial, co.CardNum }; var retBook = new CheckedOut(); foreach (var q in query) { System.Diagnostics.Debug.WriteLine(q); if (q.Serial == (uint)serial) { retBook.CardNum = q.CardNum; retBook.Serial = q.Serial; db.CheckedOut.Remove(retBook); } } db.SaveChanges(); return(Json(new { success = true })); } }
public ActionResult CheckOutBook(int serial) { // You may have to cast serial to a (uint) using (Team8LibraryContext db = new Team8LibraryContext()) { CheckedOut co = new CheckedOut(); co.CardNum = (uint)card; co.Serial = (uint)serial; db.CheckedOut.Add(co); db.SaveChanges(); return(Json(new { success = true })); } }