public IActionResult CheckLogin(string name, int cardnum) { // TODO: Fill in. Determine if login is successful or not. bool loginSuccessful = false; using (Team89LibraryContext db = new Team89LibraryContext()) { var query = from q in db.Patrons where q.CardNum == cardnum && q.Name == name select q; var arr = query.ToArray <Patrons>(); if (arr.Length != 0) { user = name; card = cardnum; loginSuccessful = true; } } if (!loginSuccessful) { return(Json(new { success = false })); } else { user = name; card = cardnum; return(Json(new { success = true })); } }
public ActionResult CheckOutBook(int serial) { using (Team89LibraryContext db = new Team89LibraryContext()) { // You may have to cast serial to a (uint) CheckedOut book = new CheckedOut(); book.Serial = (uint)serial; book.CardNum = (uint)card; db.CheckedOut.Add(book); db.SaveChanges(); } return(Json(new { success = true })); }
public ActionResult ListMyBooks() { // TODO: Implement using (Team89LibraryContext db = new Team89LibraryContext()) { var query = from p in db.Titles join g in db.Inventory on p.Isbn equals g.Isbn into books from b in books.DefaultIfEmpty() join c in db.CheckedOut on b.Serial equals c.Serial into inUse from i in inUse.DefaultIfEmpty() join u in db.Patrons on i.CardNum equals u.CardNum into result from r in result.DefaultIfEmpty() where r.CardNum == card select new { Title = p.Title, Author = p.Author, Serial = b == null ? null : (uint?)b.Serial, //Might have a null value use Ternary }; return(Json(query.ToArray())); } }
public void UseLibraryContext(Team89LibraryContext ctx) { db = ctx; }
public HomeController() { db = new Team89LibraryContext(); }