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