public IActionResult CheckLogin(string name, int cardnum) { bool loginSuccessful = false; using (Team8LibraryContext db = new Team8LibraryContext()) { var query = from p in db.Patrons where p.Name == name && p.CardNum == cardnum select new { name = p.Name, cardNum = p.CardNum }; if (query.Any()) { loginSuccessful = true; } } if (!loginSuccessful) { return(Json(new { success = false })); } else { user = name; card = cardnum; return(Json(new { success = true })); } }
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 })); } }
public ActionResult ListMyBooks() { using (Team8LibraryContext db = new Team8LibraryContext()) { var query = from t in db.Titles join i in db.Inventory on t.Isbn equals i.Isbn into iJoint from iJointFix in iJoint.DefaultIfEmpty() join co in db.CheckedOut on iJointFix.Serial equals co.Serial into coJoin from coJoinFix in coJoin.DefaultIfEmpty() join p in db.Patrons on coJoinFix.CardNum equals p.CardNum into pJoin from pJoinFix in pJoin.DefaultIfEmpty() where pJoinFix.CardNum == card select new { Title = t.Title, Author = t.Author, Serial = iJointFix.Serial }; return(Json(query.ToArray())); }; }
public ActionResult AllTitles() { using (Team8LibraryContext db = new Team8LibraryContext()) { var query = from t in db.Titles //Left Join with Inventory on isbn join i in db.Inventory on t.Isbn equals i.Isbn into ijoint from checkpat in ijoint.DefaultIfEmpty() //Left join CheckedOut on serial join co in db.CheckedOut on checkpat.Serial equals co.Serial into coj from newcheckpat in coj.DefaultIfEmpty() //Left join Patrons join p in db.Patrons on newcheckpat.CardNum equals p.CardNum into pfinal from pp in pfinal.DefaultIfEmpty() select new { ISBN = t.Isbn, Title = t.Title, Author = t.Author, Serial = checkpat == null ? (decimal?)null : checkpat.Serial, Name = pp == null ? "" : pp.Name }; return(Json(query.ToArray())); }; }