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);
}
