//----------------------------------------------------------------------------------------------------------
public IEnumerable <WinnerIdeaForShowDto> FilterWinnerIdea(FilterWinnerIdeaRequestDto searchItem)
{
using (_db = new IdeaManagmentDatabaseEntities())
{
IQueryable <SELECTED_IDEA> selectedIdeas = _db.SELECTED_IDEA;
if (searchItem.Year.HasValue)
{
selectedIdeas = selectedIdeas.Where(x => x.YEAR == searchItem.Year.Value);
}
if (searchItem.Month.HasValue)
{
selectedIdeas = selectedIdeas.Where(x => x.MONTH == searchItem.Month.Value);
}
var res = selectedIdeas.OrderByDescending(x => x.YEAR * (1000) + x.MONTH).Select(s => new WinnerIdeaForShowDto()
{
IdeaId = s.IDEA_ID,
TITLE = s.IDEA.TITLE,
FullName = s.IDEA.USER.FIRST_NAME + " " + s.IDEA.USER.LAST_NAME,
Username = s.IDEA.USERNAME,
AcceptDate = s.YEAR + "/" + s.MONTH + "/" + 1,
//SaveDate = Persia.Calendar.ConvertToPersian(s.IDEA.SAVE_DATE).Simple,
TotalPoints = s.IDEA.IDEA_POINTS.Sum(x => x.POINT)
}).ToList();
foreach (var row in res)
{
row.SaveDate = Persia.Calendar.ConvertToPersian(_db.SELECTED_IDEA.First(x => x.IDEA_ID == row.IdeaId).IDEA.SAVE_DATE).Simple;
}
return(res);
}
}
//-------------------------------------------------------------------------------------------------
public IEnumerable <WinnerIdeaForShowDto> FilterWinnerIdea(FilterWinnerIdeaRequestDto searchItem)
{
return(_Repository.FilterWinnerIdea(searchItem));
}
public IEnumerable <WinnerIdeaForShowDto> FilterWinnerIdea(FilterWinnerIdeaRequestDto searchItem)
{
return(_business.FilterWinnerIdea(searchItem));
}
