public async Task <RescueStationPoco> AddAsync(RescueStationPoco poco)
{
var parameters = new
{
p_station_name = poco.StationName
};
string sql = "insert into rescue_stations(station_name) values(@p_station_name) returning *;";
using (IDbConnection conn = Connection)
{
var addedStationPoco = await conn.QueryFirstOrDefaultAsync <RescueStationPoco>(sql, parameters);
return(addedStationPoco);
}
}
public async Task <RescueStationPoco> UpdateAsync(RescueStationPoco poco)
{
var parameters = new
{
p_station_id = poco.StationId,
p_station_name = poco.StationName,
p_updated_at = DateTimeOffset.UtcNow
};
var sqlBuilder = new StringBuilder("update rescue_stations set station_name = @p_station_name, ");
sqlBuilder.Append("updated_at = @p_updated_at ");
sqlBuilder.Append("where station_id = @p_station_id; ");
sqlBuilder.Append("select * from rescue_stations where station_id = @p_station_id;");
using (IDbConnection conn = Connection)
{
var updatedStationPoco = await conn.QueryFirstOrDefaultAsync <RescueStationPoco>(sqlBuilder.ToString(), parameters);
return(updatedStationPoco);
}
}
