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