public async Task DeleteSwitch(PKSwitch sw) { using (var conn = await _conn.Obtain()) await conn.ExecuteAsync("delete from switches where id = @Id", new { Id = sw.Id }); _logger.Information("Deleted switch {Switch}"); }
public async Task <IEnumerable <PKMember> > GetSwitchMembers(PKSwitch sw) { using (var conn = await _conn.Obtain()) return(await conn.QueryAsync <PKMember>( "select * from switch_members, members where switch_members.member = members.id and switch_members.switch = @Switch order by switch_members.id", new { Switch = sw.Id })); }
public async Task MoveSwitch(PKSwitch sw, Instant time) { using (var conn = await _conn.Obtain()) await conn.ExecuteAsync("update switches set timestamp = @Time where id = @Id", new { Time = time, Id = sw.Id }); _logger.Information("Moved switch {Switch} to {Time}", sw.Id, time); }
public async Task <IEnumerable <int> > GetSwitchMemberIds(PKSwitch sw) { using (var conn = await _conn.Obtain()) return(await conn.QueryAsync <int>("select member from switch_members where switch = @Switch order by switch_members.id", new { Switch = sw.Id })); }