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