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()));
}
}
