Ejemplo n.º 1
0
        /// <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;
            }
        }
Ejemplo n.º 2
0
        /// <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();
            }
        }