public async Task <IEnumerable <SalesOrderDataModel> > GetSalesOrdersPagedAsync(int pageNumber, int pageSize) { var query = $@" SELECT * FROM ( {SqlTextResourceHelper.GetTextResource("GetSalesOrderList")} ) X WHERE X.[RowNum] BETWEEN @FirstRowNum AND @LastRowNum"; return(await DbScope.Connection.QueryAsync <SalesOrderDataModel>(query, param : new { FirstRowNum = ((pageNumber - 1) * pageSize) + 1, LastRowNum = (pageNumber * pageSize) })); }
public async Task <IEnumerable <SalesOrderDataModel> > GetSalesOrdersAsync() { var query = $"{SqlTextResourceHelper.GetTextResource("GetSalesOrderList")}"; return(await DbScope.Connection.QueryAsync <SalesOrderDataModel>(query)); }