public async Task <Turnover> Add(Turnover turnover) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { var sql = new TurnoversSql(); var id = await conn.QueryFirstOrDefaultAsync <int>(sql.Add(turnover.DirectionId, turnover.Name)); return(await ById(id)); } }