public ActionResult AllTitles()
{
// TODO: Implement
using (Team59LibraryContext db = new Team59LibraryContext())
{
var query =
from t in db.Titles
join i in db.Inventory
on t.Isbn equals i.Isbn
into TJoinI
from ti in TJoinI.DefaultIfEmpty()
join c in db.CheckedOut
on ti.Serial equals c.Serial
into TIJoinC
from tic in TIJoinC.DefaultIfEmpty()
join p in db.Patrons
on tic.CardNum equals p.CardNum
into result
from res in result.DefaultIfEmpty()
select new
{
isbn = t.Isbn,
title = t.Title,
author = t.Author,
serial = ti != null ? (uint?)ti.Serial : null,
name = res != null ? res.Name : ""
};
return(Json(query.ToArray()));
}
}
public IActionResult CheckLogin(string name, int cardnum)
{
// TODO: Fill in. Determine if login is successful or not.
bool loginSuccessful = false;
using (Team59LibraryContext db = new Team59LibraryContext())
{
var query =
from p in db.Patrons
where p.Name == name && p.CardNum == cardnum
select new { p.Name, 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()
{
// TODO: Implement
using (Team59LibraryContext db = new Team59LibraryContext())
{
var query =
from t in db.Titles
join i in db.Inventory
on t.Isbn equals i.Isbn
into TjoinI
from ti in TjoinI.DefaultIfEmpty()
join c in db.CheckedOut
on ti.Serial equals c.Serial
into result
from res in result.DefaultIfEmpty()
where res.CardNum == card
select new
{
title = t.Title,
author = t.Author,
serial = (uint)ti.Serial
};
return(Json(query.ToArray()));
}
}
public ActionResult ReturnBook(int serial)
{
// TODO: Implement
// You may have to cast serial to a (uint)
using (Team59LibraryContext db = new Team59LibraryContext())
{
CheckedOut c = new CheckedOut();
c.Serial = (uint)serial;
c.CardNum = (uint)card;
db.CheckedOut.Remove(c);
db.SaveChanges();
}
return(Json(new { success = true }));
}
