//----------------------------------------------------------------------------------------------------------
public IEnumerable <IdeaForShowDto> FilterAllNotDecidedIdea(FilterAllNotDecidedIdeaRequestDto searchItem)
{
IEnumerable <IdeaForShowDto> res = null;
using (_db = new IdeaManagmentDatabaseEntities())
{
IQueryable <IDEA> temp = _db.IDEAS.Where(x => x.STATUS_ID == 0);
temp = _filterYearAndMonth(temp, searchItem.Year, searchItem.Month);
res = temp.OrderByDescending(x => x.SAVE_DATE).Select(x => new IdeaForShowDto()
{
Id = x.ID,
Username = x.USERNAME,
FullName = x.USER.FIRST_NAME + " " + x.USER.LAST_NAME,
Status = x.IDEA_STATUS.TITLE,
StatusId = x.STATUS_ID,
Title = x.TITLE,
TotalPoints = x.IDEA_POINTS.Any()? x.IDEA_POINTS.Sum(w => w.POINT):0
}).ToList();
foreach (var row in res)
{
row.SaveDate = Persia.Calendar.ConvertToPersian(_db.IDEAS.First(x => x.ID == row.Id).SAVE_DATE).Simple;
}
}
return(res);
}
//-------------------------------------------------------------------------------------------------
public IEnumerable <IdeaForShowDto> FilterAllNotDecidedIdea(FilterAllNotDecidedIdeaRequestDto searchItem)
{
return(_Repository.FilterAllNotDecidedIdea(searchItem));
}
