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)); }
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); }
public string CorreosPersonas([FromBody] IdsPersonas data) { ConexionEspol conexionEspol = new ConexionEspol(); return(String.Join(",", JsonConvert.DeserializeObject <List <string> >(conexionEspol.correosPersonas(data.ids).Result))); }