public async Task <TripOnRoute> Update(TripOnRoute input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
await conn.ExecuteAsync(_sql.Update(input));
return(await ById(input.Id));
}
}
public async Task <TripOnRoute> Add(TripOnRoute input)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var id = await conn.QueryFirstOrDefaultAsync <int>(_sql.Add(input.RouteId, input.TripId));
return(await ById(id));
}
}
