public void SnsExcelDownload(AdminFindingDory2017SNSQueryOptions options)
{
var query = service.GetSns(options).OrderByDescending(x => x.CreateDate).ToList();
var data = query.Select(e => new {
공유일 = e.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"),
디바이스 = e.User.Channel,
이름 = e.User.Name,
연락처 = e.User.Mobile,
나이 = e.User.Age,
SNS = e.SnsTypeDisplayName,
아이디 = e.SnsId,
닉네임 = e.SnsName,
URL = e.Post,
IP = e.User.IpAddress
}).ToList();
common.ExcelDownLoad(data, "[2017 도리를찾아서 이벤트] 공유_" + DateTime.Now.ToString("yyyyMMddHHmmss"));
}
public IQueryable <FindingDory2017SNS> GetSns(AdminFindingDory2017SNSQueryOptions options)
{
return(snsRepository.GetAll().AsExpandable().Where(options.BuildPredicate()));
}
public PagedList.IPagedList <FindingDory2017SNS> GetFindingDory2017SNSList([FromUri] AdminFindingDory2017SNSQueryOptions options)
{
var users = service.GetSns(options).OrderByDescending(x => x.CreateDate);
return(new SerializablePagedList <FindingDory2017SNS>(users, options.Page, options.PageSize));
}
