public ActionResult CheckOutBook(int serial)
{
uint userial = (uint)serial;
uint ucard = (uint)card;
db.CheckedOut.Add(new CheckedOut {
CardNum = ucard, Serial = userial
});
db.SaveChanges();
return(Json(new { success = true }));
}
/// <summary>
/// For SampleTest2
/// </summary>
/// <returns></returns>
private Team55LibraryContext MakeMediumLibrary()
{
/*MOCK DATABASE SETUP*/
var optionsBuilder = new DbContextOptionsBuilder <Team55LibraryContext>();
Team55LibraryContext db = new Team55LibraryContext(optionsBuilder.UseInMemoryDatabase("medium_library").Options);
/*END MOCK DATABASE SETUP*/
/*Add in data*/
Titles profilesInCourage = new Titles
{
Isbn = "978-0062278791", Title = "Profiles in Courage", Author = "Kennedy"
};
Titles theLorax = new Titles
{
Isbn = "978-0394823379", Title = "The Lorax", Author = "Seuss"
};
Titles dune = new Titles
{
Isbn = "978-0441172719", Title = "Dune", Author = "Herbert"
};
Patrons dan = new Patrons {
Name = "Dan", CardNum = 4
};
Inventory inv = new Inventory {
Serial = 1001, Isbn = "978-0441172719"
};
Inventory inv2 = new Inventory {
Serial = 1002, Isbn = "978-0441172719"
};
Inventory invPIC = new Inventory {
Serial = 1006, Isbn = profilesInCourage.Isbn
};
db.Titles.Add(dune);
db.Patrons.Add(dan);
db.Inventory.Add(inv);
db.Inventory.Add(inv2);
db.Inventory.Add(invPIC);
db.SaveChanges();
return(db);
}
/// <summary>
/// For SampleTest1
/// </summary>
/// <returns></returns>
private Team55LibraryContext MakeTinyLibrary()
{
/*MOCK DATABASE SETUP*/
var optionsBuilder = new DbContextOptionsBuilder <Team55LibraryContext>();
Team55LibraryContext db = new Team55LibraryContext(optionsBuilder.UseInMemoryDatabase("tiny_library").Options);
/*END MOCK DATABASE SETUP*/
/*Add in data*/
Titles t = new Titles();
t.Author = "Tony Diep";
t.Title = "Tony's Life";
t.Isbn = "978-1111111111";
db.Titles.Add(t);
db.SaveChanges();
return(db);
}
