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
});
}
}
