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