public ActionResult ReturnBook(int serial)
{
CheckedOut co = new CheckedOut
{
Serial = (uint)serial,
CardNum = (uint)card
};
using (Team34LibraryContext _context = new Team34LibraryContext())
{
_context.Remove(co);
_context.SaveChanges();
}
return(Json(new
{
success = true
}));
}
public ActionResult ListMyBooks()
{
using (Team34LibraryContext _context = new Team34LibraryContext())
{
var query =
from i in _context.Inventory
join co in _context.CheckedOut on i.Serial equals co.Serial
where co.CardNum == card
join t in _context.Titles on i.Isbn equals t.Isbn into l
from list in l.DefaultIfEmpty()
select new
{
title = list.Title,
author = list.Author,
serial = co.Serial
};
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 (Team34LibraryContext _context = new Team34LibraryContext())
{
var query =
from p in _context.Patrons
select new
{
PatronName = p.Name,
PatronNumber = p.CardNum
};
foreach (var q in query)
{
if (cardnum == q.PatronNumber && name.Equals(q.PatronName))
{
loginSuccessful = true;
break;
}
}
}
if (!loginSuccessful)
{
return(Json(new
{
success = false
}));
}
else
{
user = name;
card = cardnum;
return(Json(new
{
success = true
}));
}
}
public ActionResult AllTitles()
{
using (Team34LibraryContext _context = new Team34LibraryContext()) {
var query =
from i in _context.Inventory
join t in _context.Titles on i.Isbn equals t.Isbn into l
from list in l.DefaultIfEmpty()
select new
{
name =
from p in _context.Patrons
join co in _context.CheckedOut on p.CardNum equals co.CardNum
where co.Serial == i.Serial
select p.Name,
title = list.Title,
author = list.Author,
serial = i.Serial,
isbn = i.Isbn,
};
return(Json(query.ToArray()));
}
}
