public IActionResult CheckLogin(string name, int cardnum)
{
// TODO: Fill in. Determine if login is successful or not.
bool loginSuccessful = false;
using (Team12LibraryContext db = new Team12LibraryContext()) {
var query =
from p in db.Patrons
where p.CardNum == cardnum &&
p.Name == name
select p;
if (query.Any())
{
loginSuccessful = true;
}
// system.diagnostics.debug.writeline("login " + v);
}
if (!loginSuccessful)
{
return(Json(new { success = false }));
}
else
{
user = name;
card = cardnum;
return(Json(new { success = true }));
}
}
public ActionResult ListMyBooks()
{
using (Team12LibraryContext db = new Team12LibraryContext()) {
var query =
from c in db.CheckedOut
where c.CardNum == card
join i in db.Inventory
on c.Serial equals i.Serial into Serials
from s in Serials
join t in db.Titles
on s.Isbn equals t.Isbn
select new { Title = t.Title, Author = t.Author, Serial = s.Serial };
return(Json(query.ToArray()));
}
}
public ActionResult CheckOutBook(int serial)
{
// You may have to cast serial to a (uint)
CheckedOut co = new CheckedOut {
CardNum = (uint)card, Serial = (uint)serial
};
using (Team12LibraryContext db = new Team12LibraryContext()) {
db.CheckedOut.Add(co);
try {
db.SaveChanges();
}
catch (Exception e) {
System.Diagnostics.Debug.WriteLine(e.Message);
return(Json(new { sucess = false }));
}
}
return(Json(new { success = true }));
}
public ActionResult AllTitles()
{
using (Team12LibraryContext db = new Team12LibraryContext()) {
var query =
from t in db.Titles
join i in db.Inventory
on t.Isbn equals i.Isbn into combined
from cmbd in combined.DefaultIfEmpty()
join c in db.CheckedOut
on cmbd.Serial equals c.Serial into combined2
from cmbd2 in combined2.DefaultIfEmpty()
join p in db.Patrons
on cmbd2.CardNum equals p.CardNum into master
from m in master.DefaultIfEmpty()
select new { isbn = t.Isbn, title = t.Title, author = t.Author, serial = cmbd == null ? (decimal?)null : cmbd.Serial, name = m == null ? "" : m.Name };
return(Json(query.ToArray()));
}
}
public ActionResult ReturnBook(int serial)
{
using (Team12LibraryContext db = new Team12LibraryContext()) {
var query =
from co in db.CheckedOut
where co.Serial == serial && co.CardNum == card
select co;
foreach (var q in query)
{
db.CheckedOut.Remove(q);
}
try {
db.SaveChanges();
}
catch (Exception e) {
System.Diagnostics.Debug.WriteLine(e.Message);
return(Json(new { sucess = false }));
}
}
return(Json(new { success = true }));
}
