Exemplo n.º 1
0
        public async Task <int> UpdateAuthor(string authorId, Author author)
        {
            int DbResult = 0;

            if (!String.IsNullOrEmpty(authorId) && dataReqiered.IsDataNoEmpty(author))
            {
                int oldDataAuthorId             = Convert.ToInt32(authorId);
                int newDataAuthorId             = Convert.ToInt32(author.Id);
                AuthorPostgreSql updatingAuthor = null;

                updatingAuthor = await db.Authors.FindAsync(oldDataAuthorId);

                if (oldDataAuthorId == newDataAuthorId)
                {
                    updatingAuthor.Name    = author.Name;
                    updatingAuthor.Surname = author.Surname;

                    db.Entry(updatingAuthor).State = EntityState.Modified;

                    try
                    {
                        DbResult = await db.SaveChangesAsync();
                    }
                    catch
                    {
                        return(DbResult);
                    }
                }
            }

            return(DbResult);
        }
Exemplo n.º 2
0
        public async Task <int> UpdateBook(string id, Book book)
        {
            int DbResult = 0;
            int oldDataBookId, newDataBookId, authorId = 0;

            if (!String.IsNullOrEmpty(id) && dataReqiered.IsDataNoEmpty(book))
            {
                try
                {
                    oldDataBookId = Convert.ToInt32(id);
                    newDataBookId = Convert.ToInt32(book.Id);
                    authorId      = Convert.ToInt32(book.AuthorId);
                }
                catch
                {
                    return(DbResult);
                }

                BookPostgreSql updatingBook = null;
                updatingBook = await db.Books.FindAsync(oldDataBookId);

                if (oldDataBookId == newDataBookId)
                {
                    updatingBook.Year        = book.Year;
                    updatingBook.Name        = book.Name;
                    updatingBook.Description = book.Description;
                    updatingBook.AuthorId    = authorId;

                    db.Entry(updatingBook).State = EntityState.Modified;

                    try
                    {
                        DbResult = await db.SaveChangesAsync();
                    }
                    catch
                    {
                        return(DbResult);
                    }
                }
            }

            return(DbResult);
        }