public IActionResult CheckLogin(string name, int cardnum) { bool loginSuccessful = false; //run a query to determine if there is a patron in the DB that matches the given name and cardnum using (Team64LibraryContext db = new Team64LibraryContext()) { 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 ListMyBooks() { // Query the database to get the books you have checked out using (Team64LibraryContext db = new Team64LibraryContext()) { var query = from c in db.CheckedOut where c.CardNum == card join i in db.Inventory on c.Serial equals i.Serial select new { title = i.IsbnNavigation.Title, author = i.IsbnNavigation.Author, serial = i.Serial }; return(Json(query.ToArray())); } }
public ActionResult AllTitles() { // Query the database using left joins to get all of the titles using (Team64LibraryContext db = new Team64LibraryContext()) { var query = from t in db.Titles join i in db.Inventory on t.Isbn equals i.Isbn into inv from join1 in inv.DefaultIfEmpty() join c in db.CheckedOut on join1.Serial equals c.Serial into chkOut from join2 in chkOut.DefaultIfEmpty() join p in db.Patrons on join2.CardNum equals p.CardNum into patrons from join3 in patrons.DefaultIfEmpty() select new { isbn = t.Isbn, title = t.Title, author = t.Author, serial = join1 == null ? null : (uint?)join1.Serial, name = join3 == null ? "" : join3.Name }; return(Json(query.ToArray())); } }