public async Task <ResponseOperations> Handle(ParametersDeleteBook request, CancellationToken cancellationToken) { var book = await _context.Book.FindAsync(request.Id); if (book == null) { return(new ResponseOperations() { Ok = false, Message = "We have not found the book ", Id = 0 }); } else { _context.Book.Remove(book); var item = await _context.SaveChangesAsync(); if (item == 0) { return(new ResponseOperations() { Ok = false, Message = "We have not found the book ", Id = 0 }); } else { return(new ResponseOperations() { Ok = true, Message = "The book was deleted successfully ", Id = 0 }); } } }
public async Task <ResponseOperations> Handle(CreateAuthorParameters request, CancellationToken cancellationToken) { var author = new Author() { FirstName = request.FirstName, LastName = request.LastName }; _context.Add(author); var valor = await _context.SaveChangesAsync(); if (valor > 0) { return(new ResponseOperations() { Ok = true, Message = "The author was created.", Id = author.AuthorID }); } else { return(new ResponseOperations() { Ok = false, Message = "Author cannot be inserted", Id = author.AuthorID }); } }
public async Task <ResponseOperations> Handle(CreateActivityParameters request, CancellationToken cancellationToken) { var activity = new Activity() { Completed = request.Completed, DueDate = request.DueDate, Title = request.Title }; _context.Add(activity); var valor = await _context.SaveChangesAsync(); if (valor > 0) { return(new ResponseOperations() { Ok = true, Message = "The activity was created.", Id = activity.ActividadID }); } else { return(new ResponseOperations() { Ok = false, Message = "activity cannot be inserted", Id = activity.ActividadID }); } }
public async Task <ResponseOperations> Handle(UpdateActivityParameters request, CancellationToken cancellationToken) { Activity activityEnt = _context.Activity.Where(p => p.ActividadID == request.ActividadID).FirstOrDefault(); if (activityEnt == null) { return(new ResponseOperations() { Ok = false, Message = "We have not found the activity ", Id = 0 }); } else { activityEnt.Completed = request.Completed; activityEnt.DueDate = request.DueDate; activityEnt.Title = request.Title + "."; var valor = await _context.SaveChangesAsync(); if (valor > 0) { return(new ResponseOperations() { Ok = true, Message = "The activity was updated.", Id = activityEnt.ActividadID }); } else { return(new ResponseOperations() { Ok = false, Message = "activity cannot be updated", Id = activityEnt.ActividadID }); } } }
public async Task <ResponseOperations> Handle(UpdateAuthorParametros request, CancellationToken cancellationToken) { var author = await _context.Author.FindAsync(request.AuthorID); if (author == null) { return(new ResponseOperations() { Ok = false, Message = "We have not found the author ", Id = 0 }); } else { author.FirstName = request.FirstName; author.LastName = request.LastName + "."; var valor = await _context.SaveChangesAsync(); if (valor > 0) { return(new ResponseOperations() { Ok = true, Message = "The author was updated.", Id = author.AuthorID }); } else { return(new ResponseOperations() { Ok = false, Message = "Author cannot be saved. ", Id = author.AuthorID }); } } }
public async Task <ResponseOperations> Handle(UpdateBookParametros request, CancellationToken cancellationToken) { try { var book = await _context.Book.FindAsync(request.BookID); if (book == null) { return(new ResponseOperations() { Ok = false, Message = "We have not found the book ", Id = 0 }); } else { book.Title = request.Title; book.Description = request.Description + "."; book.PageCount = request.PageCount; book.Excerpt = request.Excerpt; book.PublishDate = request.PublishDate; var valor = _context.SaveChanges(); var booklnk = _context.AuthorBook.Where(prop => prop.BookID == request.BookID); foreach (var rem in booklnk) { _context.Entry(rem).State = EntityState.Deleted; // added row _context.AuthorBook.Remove(rem); } _context.SaveChanges(); if (request.AuthorLnk != null) { foreach (var id in request.AuthorLnk) { var authorBook = new AuthorBook { AuthorID = id.AuthorID, BookID = id.BookID }; _context.Entry(authorBook).State = EntityState.Added; // added row _context.AuthorBook.Add(authorBook); } await _context.SaveChangesAsync(); } if (valor > 0) { return(new ResponseOperations() { Ok = true, Message = "The Book was updated.", Id = book.BookID }); } else { return(new ResponseOperations() { Ok = false, Message = "Book cannot be saved. ", Id = book.BookID }); } } } catch (Exception e) { return(new ResponseOperations() { Ok = false, Message = e.Message, Id = 0 }); } }