public async Task <object> GetAllReview() { try { var result = dataContext.reviews.Select(x => new Review { ReviewEmail = x.ReviewEmail, CauseID = x.CauseID, ReviewID = x.ReviewID, ReviewMessage = x.ReviewMessage, ReviewTime = x.ReviewTime, UserId = x.UserId, }); var ReviewListDTO = new ReviewListDTO { Reviews = result.ToList() }; res.Data = ReviewListDTO; res.Message = "List of Reviews"; res.Success = true; return(res); } catch (Exception ex) { throw; } }
public async Task <object> GetReviewByUserEmail(string Email) { try { var result = dataContext.reviews.Where(x => x.ReviewEmail == Email.ToString()).AsQueryable().Select(x => new Review { CauseID = x.CauseID, ReviewEmail = x.ReviewEmail, ReviewMessage = x.ReviewMessage, ReviewTime = x.ReviewTime, UserId = x.UserId }); var list = new ReviewListDTO { Reviews = result.ToList() }; if (list == null) { res.Data = null; res.Message = "No Review found by this user was found"; res.Success = false; return(res); } else { res.Data = list; res.Message = "List of Review made by this user returned"; res.Success = true; return(res); } } catch (Exception ex) { throw; } }