public async Task InsertUserBookMappingEntry(UserBookModel userBook)
{
var parameters = new SqlParameter[]
{
new SqlParameter(Constants.Parameters.USER_ID, userBook.UserId),
new SqlParameter(Constants.Parameters.BOOK_NAME, userBook.BookName),
new SqlParameter(Constants.Parameters.IS_FAVORITE, userBook.IsFavorite),
new SqlParameter(Constants.Parameters.IS_READ, userBook.IsRead),
new SqlParameter(Constants.Parameters.BOOK_REVIEW, (object)userBook.BookReview ?? DBNull.Value)
};
await base.ExecuteStoredProcedure(Constants.Procedures.LM_INSERT_UPDATE_USER_BOOK_MAPPING, parameters);
}
public async Task <ActionResult> Put(UserBookModel userBook)
{
try
{
userBook.UserId = int.Parse(User.Identity.Name);
var getBooksReviews = await this.bookManager.UpdateBookReview(userBook);
return(Ok(getBooksReviews));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult> Post(UserBookModel userBook)
{
try
{
userBook.UserId = int.Parse(User.Identity.Name);
await this.bookManager.InsertUserBookMappingEntry(userBook);
return(Accepted());
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <BookReviewModel> UpdateBookReview(UserBookModel userBook)
{
try
{
var bookReview = await this.bookRepository.UpdateBookReview(userBook);
var userBookReview = MapBookReview(bookReview.Tables[0]);
return(userBookReview);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult History(int id)
{
if (userOperations.Authentication(User.Identity.Name) == true)
{
IEnumerable <User> Users = dataOperations.GetUsersTakenBook(id);
Book book = dataOperations.Find(id);
UserBookModel userBookModel = new UserBookModel {
Users = Users, book = book
};
return(View(userBookModel));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public async Task <DataSet> UpdateBookReview(UserBookModel userBook)
{
var parameters = new SqlParameter[]
{
new SqlParameter(Constants.Parameters.USER_ID, userBook.UserId),
new SqlParameter(Constants.Parameters.BOOK_NAME, userBook.BookName),
new SqlParameter(Constants.Parameters.BOOK_REVIEW, userBook.BookReview)
};
await base.ExecuteStoredProcedure(Constants.Procedures.LM_UPDATE_REVIEW_BOOK, parameters);
var parameter = new SqlParameter[]
{
new SqlParameter(Constants.Parameters.BOOK_NAME, userBook.BookName)
};
return(await base.ReadFromStoredProcedure(Constants.Procedures.LM_GET_ALL_USER_REVIEWS, parameter));
}
public async Task InsertUserBookMappingEntry(UserBookModel userBook)
{
await this.bookRepository.InsertUserBookMappingEntry(userBook);
}
