private PaginationMetadata CreatePaginationMetadata(TransactionFilterEntityModel filterModel, int totalRecordCount) { var metadata = new PaginationMetadata { Page = filterModel.Page, PageSize = filterModel.PageSize, TotalPages = PaginationHelper.CalculateTotalPages(filterModel, totalRecordCount), TotalRecordCount = totalRecordCount }; return(metadata); }
private DynamicParameters CreateParametersForGetFilteredAsync(TransactionFilterEntityModel filterModel) { var skip = PaginationHelper.CalculateSkip(filterModel); var take = PaginationHelper.CalculateTake(filterModel); var parameters = new DynamicParameters(); parameters.Add("@AccessKey", filterModel.AccessKey); parameters.Add("@Skip", skip); parameters.Add("@Take", take); parameters.Add("@StartDate", filterModel.StartDate, DbType.DateTime2); parameters.Add("@EndDate", filterModel.EndDate, DbType.DateTime2); parameters.Add("@Symbol", filterModel.Symbol); parameters.Add("@TransactionType", filterModel.TransactionType); parameters.Add("@OrderByField", filterModel.OrderByField); parameters.Add("@OrderByDirection", filterModel.OrderByDirection); return(parameters); }