public ActionResult GetRatingWords() { GetRatingWordsRequest request = new GetRatingWordsRequest(); request.UserId = base.UserID; InterestService _interestService = new InterestService(); request.InterestId = _interestService.GetUserInterestID(request.UserId); WordService _wordService = new WordService(); List <WordView> response = _wordService.GetRatingWords(request); return(View(response)); }
public List <WordView> GetRatingWords(GetRatingWordsRequest request) { try { using (DDS_Context dbContext = new DDS_Context()) { List <WordView> response = new List <WordView>(); var entity = dbContext.TempWord.Where(x => x.Status == 4 && x.InterestId == request.InterestId).ToList(); var result = entity; if (result != null) { /*daha önce oy kullandığının kontrolü*/ var isVoted = dbContext.Votes.Where(x => x.DeveloperId == request.UserId).ToList(); var deleteItems = new List <TempWord>(); foreach (var voted in isVoted) { foreach (var item in result) { if (item.Id == voted.WordId) { deleteItems.Add(item); } } } if (deleteItems != null) { foreach (var item in deleteItems) { result.Remove(item); } } /////////////////////////////////////// if (result.Count != 0) { foreach (var item in result) { WordView temp = new WordView(); temp.CreatedDate = Convert.ToString(item.CreatedDate); temp.UpdatedDate = Convert.ToString(item.UpdatedDate); temp.WordId = item.Id; temp.Word = item.Word; var userEntity = dbContext.User.FirstOrDefault(x => x.Id == item.UserId); if (userEntity != null) { temp.UserName = userEntity.Name; temp.UserSurname = userEntity.Surname; } else { temp.UserName = "******"; temp.UserSurname = "UNDEFINED"; } var developerEntity = dbContext.User.FirstOrDefault(x => x.Id == item.DeveloperId); if (developerEntity != null) { temp.DeveloperName = developerEntity.Name; temp.DeveloperSurname = developerEntity.Surname; } else { temp.DeveloperName = "UNDEFINED"; temp.DeveloperSurname = "UNDEFINED"; } var interest = dbContext.Interest.FirstOrDefault(x => x.Id == item.InterestId); if (interest != null) { temp.Interest.InerestId = interest.Id; temp.Interest.InterestName = interest.Name; } temp.Content = item.Content; response.Add(temp); } } } response.Reverse(); return(response); } } catch (Exception ex) { throw ex; } }