public IActionResult CheckLogin(string name, int cardnum) { // TODO: Fill in. Determine if login is successful or not. bool loginSuccessful = false; using (Team3LibraryContext db = new Team3LibraryContext()) { var query = from p in db.Patrons where p.Name == name && p.CardNum == cardnum select p; if (!query.Any()) { loginSuccessful = false; } else { loginSuccessful = true; } } if (!loginSuccessful) { return(Json(new { success = false })); } else { user = name; card = cardnum; return(Json(new { success = true })); } }
public ActionResult CheckOutBook(int serial) { // You may have to cast serial to a (uint) CheckedOut co = new CheckedOut(); co.Serial = (uint)serial; co.CardNum = (uint)card; using (Team3LibraryContext db = new Team3LibraryContext()) { db.CheckedOut.Add(co); db.SaveChanges(); } return(Json(new { success = true })); }
public ActionResult ListMyBooks() { using (Team3LibraryContext db = new Team3LibraryContext()) { var query = from p in db.Patrons join co in db.CheckedOut on p.CardNum equals co.CardNum join i in db.Inventory on co.Serial equals i.Serial join t in db.Titles on i.Isbn equals t.Isbn where p.CardNum == card select new { title = t.Title, author = t.Author, serial = i.Serial }; return(Json(query.ToArray())); } }
public ActionResult AllTitles() { using (Team3LibraryContext db = new Team3LibraryContext()) { var query = from t in db.Titles join i in db.Inventory on t.Isbn equals i.Isbn into join1 from j1 in join1.DefaultIfEmpty() join c in db.CheckedOut on j1.Serial equals c.Serial into join2 from j2 in join2.DefaultIfEmpty() join p in db.Patrons on j2.CardNum equals p.CardNum into join3 from j3 in join3.DefaultIfEmpty() select new { isbn = t.Isbn, title = t.Title, author = t.Author, serial = j1 == null ? default(uint?) : j1.Serial, name = j3 == null ? String.Empty : j3.Name }; return(Json(query.ToArray())); } }