Exemple #1
0
        public void Update(Guid id, string title, string author, bool read = false)
        {
            int iRetorno;

            if (GetById(id) is null)
            {
                throw new Exception("No se encontró libro");
            }
            var updateBook = GetById(id);

            updateBook.title  = title;
            updateBook.author = author;
            updateBook.read   = read;

            using (var context = new ConectionMySql())
            {
                try
                {
                    var ini = context.Update(updateBook);
                    context.SaveChangesAsync();
                }
                catch (Exception ex)
                {
                }
            }
        }
Exemple #2
0
        public void Add(Book book)
        {
            var newBook = new Book();

            using (var context = new ConectionMySql())
            {
                var ini = context.Add(book);
                var res = context.SaveChanges();
            }
        }
Exemple #3
0
        public Book GetById(Guid id)
        {
            var searchedBook = new Book();

            using (var context = new ConectionMySql())
            {
                searchedBook = context.Books.FirstOrDefault(b => b.id == id);
            }

            return(searchedBook);
        }
Exemple #4
0
        public List <Book> GetAll()
        {
            var books = new List <Book>();

            using (var context = new ConectionMySql())
            {
                books = context.Books.ToList();
            }

            return(books);
        }