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