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