public IActionResult CheckLogin(string name, int cardnum)
{
bool loginSuccessful = false;
using (Team90LibraryContext db = new Team90LibraryContext())
{
var query = from p in db.Patrons
select new
{
p.CardNum,
p.Name
};
foreach (var v in query)
{
if (v.CardNum == cardnum && v.Name == name)
{
loginSuccessful = true;
}
}
}
if (!loginSuccessful)
{
return(Json(new { success = false }));
}
else
{
user = name;
card = cardnum;
return(Json(new { success = true }));
}
}
public ActionResult ReturnBook(int serial)
{
// You may have to cast serial to a (uint)
using (Team90LibraryContext db = new Team90LibraryContext())
{
var query = from c in db.CheckedOut
where c.Serial == (uint)serial
select c;
db.CheckedOut.RemoveRange(query);
db.SaveChanges();
}
return(Json(new { success = true }));
}
public ActionResult CheckOutBook(int serial)
{
// You may have to cast serial to a (uint)
using (Team90LibraryContext db = new Team90LibraryContext())
{
CheckedOut c = new CheckedOut();
c.CardNum = (uint)card;
c.Serial = (uint)serial;
db.CheckedOut.Add(c);
db.SaveChanges();
}
return(Json(new { success = true }));
}
public ActionResult ListMyBooks()
{
// TODO: Implement
using (Team90LibraryContext db = new Team90LibraryContext())
{
var query = from p in db.Patrons
where p.CardNum == card
join c in db.CheckedOut on p.CardNum equals c.CardNum
join i in db.Inventory on c.Serial equals i.Serial
join t in db.Titles on i.Isbn equals t.Isbn
select new
{
t.Title,
t.Author,
i.Serial
};
return(Json(query.ToArray()));
}
}
public ActionResult AllTitles()
{
using (Team90LibraryContext db = new Team90LibraryContext())
{
var query = from t in db.Titles
join i in db.Inventory on t.Isbn equals i.Isbn into inv
from x in inv.DefaultIfEmpty()
join c in db.CheckedOut on x.Serial equals c.Serial into chec
from y in chec.DefaultIfEmpty()
join p in db.Patrons on y.CardNum equals p.CardNum into pat
from z in pat.DefaultIfEmpty()
select new
{
t.Isbn,
t.Title,
t.Author,
serial = x == null ? null : (uint?)x.Serial,
name = z.Name == null ? "" : z.Name
};
return(Json(query.ToArray()));
}
}
