public async Task <ParkingPaging> GetAll(int skip, int limit, string filter) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { string sqlfilter, sql; CreateFilter(filter, out sqlfilter, out sql); var result = (await conn.QueryAsync <Parking, Stantion, Parking>( sql, (parking, stantion) => { parking.Stantion = stantion; return(parking); }, new { skip = skip, limit = limit }) ).ToArray(); var sqlc = $"{ParkingCommon.sqlCountCommon} {sqlfilter}"; var count = conn.ExecuteScalar <int>(sqlc); var output = new ParkingPaging { Data = result.ToList(), Total = count }; return(output); } }
public async Task <ParkingPaging> GetAll(int skip, int limit) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { var sql = Sql.SqlQueryCach["Parkings.All"]; var result = (await conn.QueryAsync <Parking, Stantion, Parking>( sql, (parking, stantion) => { parking.Stantion = stantion; return(parking); }, new { skip = skip, limit = limit }) ).ToArray(); var sqlc = Sql.SqlQueryCach["Parkings.CountAll"]; var count = (await conn.QueryAsync <int>(sqlc)).FirstOrDefault(); var output = new ParkingPaging { Data = result.ToList(), Total = count }; return(output); } }