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