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); }