public IActionResult CheckLogin(string name, int cardnum)
{
bool loginSuccessful = false;
using (Team8LibraryContext db = new Team8LibraryContext())
{
var query =
from p in db.Patrons
where p.Name == name && p.CardNum == cardnum
select
new { name = p.Name, cardNum = p.CardNum };
if (query.Any())
{
loginSuccessful = true;
}
}
if (!loginSuccessful)
{
return(Json(new { success = false }));
}
else
{
user = name;
card = cardnum;
return(Json(new { success = true }));
}
}
public ActionResult ReturnBook(int serial)
{
// Query the database for the rows to be deleted.
using (Team8LibraryContext db = new Team8LibraryContext())
{
var query =
from co in db.CheckedOut
select new { co.Serial, co.CardNum };
var retBook = new CheckedOut();
foreach (var q in query)
{
System.Diagnostics.Debug.WriteLine(q);
if (q.Serial == (uint)serial)
{
retBook.CardNum = q.CardNum;
retBook.Serial = q.Serial;
db.CheckedOut.Remove(retBook);
}
}
db.SaveChanges();
return(Json(new { success = true }));
}
}
public ActionResult CheckOutBook(int serial)
{
// You may have to cast serial to a (uint)
using (Team8LibraryContext db = new Team8LibraryContext())
{
CheckedOut co = new CheckedOut();
co.CardNum = (uint)card;
co.Serial = (uint)serial;
db.CheckedOut.Add(co);
db.SaveChanges();
return(Json(new { success = true }));
}
}
public ActionResult ListMyBooks()
{
using (Team8LibraryContext db = new Team8LibraryContext())
{
var query =
from t in db.Titles
join i in db.Inventory
on t.Isbn equals i.Isbn into iJoint
from iJointFix in iJoint.DefaultIfEmpty()
join co in db.CheckedOut
on iJointFix.Serial equals co.Serial into coJoin
from coJoinFix in coJoin.DefaultIfEmpty()
join p in db.Patrons
on coJoinFix.CardNum equals p.CardNum into pJoin
from pJoinFix in pJoin.DefaultIfEmpty()
where pJoinFix.CardNum == card
select
new { Title = t.Title, Author = t.Author, Serial = iJointFix.Serial };
return(Json(query.ToArray()));
};
}
public ActionResult AllTitles()
{
using (Team8LibraryContext db = new Team8LibraryContext())
{
var query =
from t in db.Titles
//Left Join with Inventory on isbn
join i in db.Inventory
on t.Isbn equals i.Isbn into ijoint
from checkpat in ijoint.DefaultIfEmpty()
//Left join CheckedOut on serial
join co in db.CheckedOut
on checkpat.Serial equals co.Serial into coj
from newcheckpat in coj.DefaultIfEmpty()
//Left join Patrons
join p in db.Patrons
on newcheckpat.CardNum equals p.CardNum into pfinal
from pp in pfinal.DefaultIfEmpty()
select
new { ISBN = t.Isbn, Title = t.Title, Author = t.Author, Serial = checkpat == null ? (decimal?)null : checkpat.Serial, Name = pp == null ? "" : pp.Name };
return(Json(query.ToArray()));
};
}
