Ejemplo n.º 1
0
        public Alias GetAlias(string name, long sessionId)
        {
            if (_keywordService.IsReserved(name))
            {
                return(Alias.Reserved(name));
            }

            var sql = @"
                select
                    n.Name        as Name,
                    s.id          as Id,
                    s.id_session  as IdSession,
                    s.arguments   as Arguments,
                    s.file_name   as FileName,
                    s.notes       as Notes,
                    s.run_as      as RunAs,
                    s.start_mode  as StartMode,
                    s.working_dir as WorkingDirectory
                from
                    alias s
                    inner join alias_name n on s.id = n.id_alias
                where
                    lower(n.name) = lower(@name)
                    and s.id_session = @sessionId";

            using (var c = BuildConnection())
            {
                var result = c.Query <Alias>(sql, new { name, sessionId })
                             .FirstOrDefault();
                return(result ?? Alias.Empty(name));
            }
        }