Пример #1
0
        public IEnumerable <string> emailsPersonas([FromBody] IdsPersonas data)
        {
            var ids   = data.idsPersonas.AsEnumerable();
            var query =
                from persona in context.TBL_PERSONA
                join id in ids on persona.intIdPersona equals(int) id
                select new
            {
                persona
            };

            return(query.Select(x => x.persona.strEmail));
        }
Пример #2
0
        public IQueryable nombresPersonas([FromBody] IdsPersonas data)
        {
            var ids   = data.idsPersonas.AsEnumerable();
            var query =
                from persona in context.TBL_PERSONA
                join id in ids on persona.intIdPersona equals(int) id
                select new
            {
                idPersona      = persona.intIdPersona,
                nombreCompleto = persona.strNombres + " " + persona.strApellidos
            };

            return(query);
        }
Пример #3
0
        public string CorreosPersonas([FromBody] IdsPersonas data)
        {
            ConexionEspol conexionEspol = new ConexionEspol();

            return(String.Join(",", JsonConvert.DeserializeObject <List <string> >(conexionEspol.correosPersonas(data.ids).Result)));
        }