public async Task <IPagedList <ProductDto> > GetDisplayProductPaginationAsync(int pageNumber, int pageSize, string query, int?parentProductId) { if (pageNumber <= 0) { pageNumber = 1; } var result = await _dapperManager.StoredProcedureAsync <ProductDto>("[dbo].[Sp_SearchProductForDisplay]", new { query = query, parentProductId = parentProductId }); var data = result.ToPagedList(pageNumber, pageSize); return(data); }
public async Task <IEnumerable <MenuAccessPermissionDto> > GetMenuAccessPermissionsAsyncByStaffId(int id) { var dto = await _dapperManager.StoredProcedureAsync <MenuAccessPermissionDto>("[dbo].[MenuAccessPermissionForStaff]", new { StaffId = id }); return(dto); }