public string GetBgJqGridJson(IList <JieYueDocDto> list, long totalRecords, PagingParameter paging, int userId)
{
IList <JsonJqGridRowObject> rows =
list.Select(item => new JsonJqGridRowObject(FormatHelper.GetLongString(item.Id), new[]
{
item.ShenQingrenName,
item.Content,
item.Company,
FormatHelper.GetIntString(item.Year),
item.BaogaoMingcheng,
item.CabinetNo,
item.Path,
FormatHelper.GetIntString(item.JieyueTianshu),
FormatHelper.GetIsoDateString(item.JieyueShijian),
FormatHelper.GetIsoDateString(GetGuihuanShijian(item.JieyueTianshu, item.JieyueShijian, item.ZidingyiGuihuanShijian)),
GetOperating(item.Id, userId),
GetintervalDays(item.JieyueTianshu, item.JieyueShijian, item.ZidingyiGuihuanShijian),
})).ToList();
var jsonJqGridObject = new JsonJqGridObject(rows, totalRecords, paging.PageIndex, paging.PageSize);
return(Serialize(jsonJqGridObject));
}
public IList <FaReportName> Find(PagingParameter paging, string query, bool?enable, out long count)
{
IQueryable <FaReportName> queryable = !string.IsNullOrEmpty(query)
? DataContext.FaReportNames.Where(t => t.Name.Contains(query) || t.Remark.Contains(query))
: DataContext.FaReportNames;
if (enable != null)
{
queryable = queryable.Where(t => t.Enable == enable);
}
count = queryable.Count();
if (count == 0)
{
return(new List <FaReportName>());
}
int pageSize = paging.PageSize;
int pageIndex = paging.PageIndex;
pageIndex = pageIndex - 1;
queryable = queryable.OrderByDescending(t => t.Name).ThenByDescending(t => t.LastUpdated)
.Skip(pageSize * pageIndex).Take(pageSize);
return(queryable.ToList());
}
/// <summary>
/// Returns A Profile with Images and Paged
/// </summary>
/// <param name="userid"></param>
/// <param name="page"></param>
/// <returns></returns>
public UserProfilePage GetProfileByUsername(string userName, PagingParameter page)
{
if (string.IsNullOrEmpty(userName))
{
throw new ArgumentException("User Name can't be null or empty");
}
var result = ((IUserRepository)Database.UserRepository)
.GetPagedUserByUsername(userName, page.PageIndex, page.ItemsPerPage);
var userProfile = new UserProfilePage()
{
User = Mapper.Map <UserDTO>(result),
Images = Mapper.Map <List <ImagePost> >(result.Images),
Parameters = new PagingParameter()
{
ItemsPerPage = page.ItemsPerPage,
PageIndex = page.PageIndex,
TotalItems = ((IImageRepository)Database.ImageRepository).ImagesQuantity(result.Id),
}
};
return(userProfile);
}
public ActionResult <CRMPartner> GetAllPartners([FromQuery] PagingParameter pagingParameter)
{
var query = _choiceRepoistory.GetAllPartners(pagingParameter);
var previousLink = query.HasPrevious ? CreatePartnerResourceUrl(pagingParameter, ResourceUriType.PreviousPage, "GetAllPartners", query.TotalPages) : null;
var nextLink = query.HasNext ? CreatePartnerResourceUrl(pagingParameter, ResourceUriType.NextPage, actionName: "GetAllPartners") : null;
var pageMetaData =
new
{
totalCount = query.TotalCount,
pageSize = query.PageSize,
currentPage = query.CurrentPage,
totalPages = query.TotalPages,
previousPageLink = previousLink,
nextPageLink = nextLink
};
Response.Headers.Add("custom-Pagination", Newtonsoft.Json.JsonConvert.SerializeObject(pageMetaData));
var temp = _mapper.Map <List <CRMPartner>, List <CRMPartnerDTO> >(query);
return(Ok(temp.OrderByDescending(x => x.CRMPartnerId)));
}
public async Task <GameLogResult <MatchCueHistory> > GetMatchCueHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId)
{
var query = _dbContext.MatchCueHistories.Where(x => dateTimeRange.From <= x.Datetime && x.Datetime <= dateTimeRange.To);
// todo: indexが効いてるか要確認
if (playerId.HasValue)
{
query = query.Where(x => x.PlayerId1 == playerId.Value ||
x.PlayerId2 == playerId.Value ||
x.PlayerId3 == playerId.Value ||
x.PlayerId4 == playerId.Value ||
x.PlayerId5 == playerId.Value ||
x.PlayerId6 == playerId.Value);
}
var list = await query.OrderByDescending(x => x.Datetime)
.Skip(pagingParameter.CountPerPage * (pagingParameter.PageNumber - 1))
.Take(pagingParameter.CountPerPage)
.ToListAsync();
var count = await query.CountAsync();
return(new GameLogResult <MatchCueHistory>(list, count));
}
public async Task <Paging <IssueDTO> > GetIssues(PagingParameter pagingParameter)
{
var books = await this.GetAllAsyn();
var source = books.Skip((pagingParameter.CurrentPage - 1) * pagingParameter.PageSize).Take(pagingParameter.PageSize);
var sourcedto = this._mapper.Map <List <IssueDTO> >(source.ToList());
var PageCount = (int)Math.Ceiling((double)books.Count / pagingParameter.PageSize);
Paging <IssueDTO> response = new Paging <IssueDTO>
{
CurrentPage = pagingParameter.CurrentPage,
PageCount = PageCount,
TotalCount = books.Count,
Items = sourcedto,
PageSize = pagingParameter.PageSize
};
response.Pages = new List <int>();
for (int i = 1; i <= PageCount; i++)
{
response.Pages.Add(i);
}
return(response);
}
public async Task <IResponse <IEnumerable <Post> > > GetPostAsync(string username, PagingParameter pagingParameter)
{
try
{
if (string.IsNullOrWhiteSpace(username))
{
return new Response <IEnumerable <Post> > {
IsSuccessful = false, Message = ServiceMessage.InvalidPageId
}
}
;
var posts = await _crawlerUnitOfWork.PostRepo.GetAsync(username, pagingParameter);
if (posts.IsNull())
{
return new Response <IEnumerable <Post> > {
IsSuccessful = false, Message = ServiceMessage.RecordNotExist
}
}
;
return(new Response <IEnumerable <Post> >
{
Result = posts,
IsSuccessful = true,
Message = ServiceMessage.Success
});
}
catch (Exception e)
{
FileLoger.Error(e);
return(new Response <IEnumerable <Post> > {
IsSuccessful = false, Message = ServiceMessage.Exception
});
}
}
public IList <FaCabinetNo> GetCabinetNos(PagingParameter paging, string query, bool?enable, out long count)
{
return(_faCabinetNoRepository.Find(paging, query, enable, out count));
}
public IList <FaReportName> GetReportNames(PagingParameter paging, string query, bool?enable, out long count)
{
return(_faReportNameRepository.Find(paging, query, enable, out count));
}
public PagedList <Booking> GetAllBookings(PagingParameter pagingParameter)
{
var data = _unitOfWork.BookingRepository.GetAllBookings(pagingParameter);
return(data);
}
public async Task <GameLogResult <PlayerAccountCreateHistory> > GetPlayerAccountCreateHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId)
{
var query = _dbContext.PlayerAccountCreateHistories.Where(x => dateTimeRange.From <= x.Datetime && x.Datetime <= dateTimeRange.To);
if (playerId.HasValue)
{
query = query.Where(x => x.PlayerId == playerId.Value);
}
var list = await query.OrderByDescending(x => x.Datetime)
.Skip(pagingParameter.CountPerPage * (pagingParameter.PageNumber - 1))
.Take(pagingParameter.CountPerPage)
.ToListAsync();
var count = await query.CountAsync();
return(new GameLogResult <PlayerAccountCreateHistory>(list, count));
}
public async Task <PaginatedList <SongBrief> > _Page_fromDB(SongFilterParameter queryParameter, PagingParameter pagingParameter)
{
var query = _context.OSSongs
.Include(s => s.CreatedBy)
.AsNoTracking();
_SetIQueryableWhereConditions(query, queryParameter);
var count = await query.CountAsync();
if (pagingParameter != null)
{
bool bIsAscending = (pagingParameter.columnOrder?.ToLower() ?? "asc") == "asc" ? true : false;
pagingParameter.columnToOrder = pagingParameter.columnToOrder?.ToLower() ?? "title";
switch (pagingParameter?.columnToOrder)
{
case "title":
default:
query = bIsAscending ? query.OrderBy(s => s.Title) : query.OrderByDescending(s => s.Title);
break;
// TODO: other cases as needed.
}
//Apply paging
//Offset before limit!
if (pagingParameter.offset != null)
{
query = query.Skip((int)pagingParameter?.offset);
}
if (pagingParameter.limit != null)
{
query = query.Take((int)pagingParameter?.limit);
}
}
var songs = await query.ToListAsync();
return(new PaginatedList <SongBrief>
{
Items = songs.Select(s => new SongBrief(s)).ToList(),
Total = count,
CurrentIndex = pagingParameter?.offset ?? 0,
PageSize = pagingParameter?.limit ?? 0
});
}
public async Task <PaginatedList <SongBrief> > Page(SongFilterParameter queryParameter, PagingParameter pagingParameter)
{
if (_useCache)
{
return(await _Page_fromCache(queryParameter, pagingParameter));
}
else
{
return(await _Page_fromDB(queryParameter, pagingParameter));
}
}
public async Task <PaginatedList <SongBrief> > _Page_fromCache(SongFilterParameter queryParameter, PagingParameter pagingParameter)
{
IEnumerable <OSSong> songs = _FilterSongs(await _GetCache(), queryParameter);
var count = songs.Count();
if (pagingParameter != null)
{
bool bIsAscending = (pagingParameter.columnOrder?.ToLower() ?? "asc") == "asc" ? true : false;
pagingParameter.columnToOrder = pagingParameter.columnToOrder?.ToLower() ?? "title";
switch (pagingParameter?.columnToOrder)
{
case "title":
default:
songs = bIsAscending ? songs.OrderBy(s => s.Title) : songs.OrderByDescending(s => s.Title);
break;
// TODO: other cases as needed.
}
//Apply paging
//Offset before limit!
if (pagingParameter.offset != null)
{
songs = songs.Skip((int)pagingParameter?.offset);
}
if (pagingParameter.limit != null)
{
songs = songs.Take((int)pagingParameter?.limit);
}
}
return(new PaginatedList <SongBrief>
{
Items = songs.Select(s => new SongBrief(s)).ToList(),
Total = count,
CurrentIndex = pagingParameter?.offset ?? 0,
PageSize = pagingParameter?.limit ?? 0
});
}
public ActionResult <PartnerEmployeeDTO> GetPartners([FromQuery] PagingParameter pagingParameter = null)
{
return(Ok(_choiceRepoistory.GetAllPartners(pagingParameter)));
}
public async Task <Either <PaginatedList <SongBrief>, ErrorInfo> > Page(SongFilterParameter queryParameter, PagingParameter pagingParameter)
{
return(await _OSSongRepo.Page(queryParameter, pagingParameter));
}
public async Task <GameLogResult <MatchEntryPlayerHistory> > GetMatchEntryPlayerHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId, string matchId)
{
var query = _dbContext.MatchEntryPlayerHistories.Where(x => dateTimeRange.From <= x.Datetime && x.Datetime <= dateTimeRange.To);
if (playerId.HasValue)
{
query = query.Where(x => x.PlayerId == playerId.Value);
}
if (!string.IsNullOrWhiteSpace(matchId))
{
query = query.Where(x => x.MatchId == matchId);
}
var list = await query.OrderByDescending(x => x.Datetime)
.Skip(pagingParameter.CountPerPage * (pagingParameter.PageNumber - 1))
.Take(pagingParameter.CountPerPage)
.ToListAsync();
var count = await query.CountAsync();
return(new GameLogResult <MatchEntryPlayerHistory>(list, count));
}
public async Task <GameLogResult <PlayerAccountCreateHistory> > GetPlayerAccountCreateHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId)
{
return(await _gameLogRepository.GetPlayerAccountCreateHistoryList(pagingParameter, dateTimeRange, playerId));
}
public string GetFaCabineNosJqGridJson(IList <FaCabinetNo> list, long totalRecords, PagingParameter paging)
{
IList <JsonJqGridRowObject> rows =
list.Select(item => new JsonJqGridRowObject(FormatHelper.GetLongString(item.Id), new[]
{
HtmlHelper.Encode(item.CabinetNo),
item.Path,
GetCabineNoEnable(item.Enable),
FormatHelper.GetIsoDateString(item.LastUpdated),
GetOperating(item.Enable, item.Id)
})).ToList();
var jsonJqGridObject = new JsonJqGridObject(rows, totalRecords, paging.PageIndex, paging.PageSize);
return(Serialize(jsonJqGridObject));
}
public async Task <GameLogResult <LogoutHistory> > GetLogoutHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId, string remoteIp)
{
return(await _gameLogRepository.GetLogoutHistoryList(pagingParameter, dateTimeRange, playerId, remoteIp));
}
public PagedList <CRMPartner> SearchPartnerDetails(PagingParameter pagingParameter, SearchCommonParamters searchCommonParamters)
{
var data = _unitOfWork.PartnerInfoPubFacingRepository.SearchPartnerDetails(pagingParameter, searchCommonParamters);
return(data);
}
public async Task <GameLogResult <ChatSayHistory> > GetChatSayHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, int searchType, long?playerId, string groupId, string matchId, int?side)
{
return(await _gameLogRepository.GetChatSayHistoryList(pagingParameter, dateTimeRange, searchType, playerId, groupId, matchId, side));
}
public PagedList <Booking> SearchBookingDetails(PagingParameter pagingParameter, SearchCommonParamters searchCommonParamters)
{
var data = _unitOfWork.BookingRepository.SearchBookingDetails(pagingParameter, searchCommonParamters);
return(data);
}
public async Task <GameLogResult <ChatDirectHistory> > GetChatDirectHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId)
{
return(await _gameLogRepository.GetChatDirectHistoryList(pagingParameter, dateTimeRange, playerId));
}
public IList <JieYueDocDto> GetPageFaReturnDocs(
PagingParameter paging, FaArchiveListParameter parameter, out long count)
{
return(_faReturnDocRepository.Find(paging, parameter, out count));
}
public async Task <GameLogResult <PartyHistory> > GetPartyHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId, string groupId)
{
return(await _gameLogRepository.GetPartyHistoryList(pagingParameter, dateTimeRange, playerId, groupId));
}
public IList <FaCompany> GetCompanines(PagingParameter paging, string query, bool?enable, out long count)
{
return(_faCompanyRepository.Find(paging, query, enable, out count));
}
public async Task <GameLogResult <MatchExecutionHistory> > GetMatchExecutionHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, string matchId)
{
return(await _gameLogRepository.GetMatchExecutionHistoryList(pagingParameter, dateTimeRange, matchId));
}
public async Task <IEnumerable <Notification> > GetAsync(NotificationStatus status, PagingParameter pagingParameter)
{
try
{
var query = "SELECT * "+
"FROM [Notifier].[Notification] n "+
"WHERE n.Status = @Status " +
"ORDER BY p.NotificationId ASC "+
"OFFSET @PageSize * (@PageNumber - 1) ROWS "+
"FETCH NEXT @PageSize ROWS ONLY;";
return(await _sqlConnection.ExecuteQueryAsync <Notification>(query,
new { Status = status, pagingParameter.PageNumber, pagingParameter.PageSize }));
}
catch (Exception e)
{
FileLoger.Error(e);
return(null);
}
}
public async Task <GameLogResult <MatchExitPlayerHistory> > GetMatchExitPlayerHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId, string matchId)
{
return(await _gameLogRepository.GetMatchExitPlayerHistoryList(pagingParameter, dateTimeRange, playerId, matchId));
}
