/// <summary> /// Adds a Book object to the database /// </summary> /// <param name="title"></param> /// <param name="author"></param> /// <param name="description"></param> /// <param name="genre"></param> /// <param name="dateAdded"></param> /// <param name="price"></param> /// <returns>Book Id</returns> public int AddBook(string title, string author, string description, string genre, DateTime dateAdded, double price) { using (RENTIT21Entities proxy = new RENTIT21Entities()) { SMUbook theBook = new SMUbook() { title = title, author = author, description = description, genre = genre, price = price, dateAdded = dateAdded, SMUrentals = new Collection<SMUrental>(), }; proxy.SMUbooks.Add(theBook); proxy.SaveChanges(); return theBook.id; } }
/// <summary> /// Returns a Book object /// </summary> /// <param name="theBook">A SMUBook object</param> /// <returns></returns> public Book GetBookRepresentation(SMUbook theBook) { using (RENTIT21Entities context = new RENTIT21Entities()) { var books = from book in context.SMUbooks where book.id == theBook.id select book; if (books.Any() == false) { throw new ArgumentException("No book with bookId = " + theBook.id); } return books.First().GetBook(); } }