public IHttpActionResult GetWorkerSkill(string id) { var query = WebApiConfig.GraphClient.Cypher .Match("(w:Worker)-[e:EXPERTIN]->(s:Skill)") .Where((Worker w) => w.id == id) .Return((w, s) => new { worker = w.As<Worker>(), skill = Return.As<string>("collect(s.name)") }); var queryData = query.Results.ToList(); var workerSkills = new List<WorkerSkill>(); foreach (var item in queryData) { WorkerSkill workerSkill = new WorkerSkill { workerNumber = item.worker.number, firstName = item.worker.firstName, lastName = item.worker.lastName, skill = item.skill, experience = "EXPERT" }; workerSkills.Add(workerSkill); } query = WebApiConfig.GraphClient.Cypher .Match("(w:Worker)-[e:PROFICIENTIN]->(s:Skill)") .Where((Worker w) => w.id == id) .Return((w, s) => new { worker = w.As<Worker>(), skill = Return.As<string>("collect(s.name)") }); queryData = query.Results.ToList(); foreach (var item in queryData) { WorkerSkill workerSkill = new WorkerSkill { workerNumber = item.worker.number, firstName = item.worker.firstName, lastName = item.worker.lastName, skill = item.skill, experience = "PROFICIENT" }; workerSkills.Add(workerSkill); } UberDocument uberDocument = new UberDocument { Version = "1.0", Data = new List<Data>() }; if (workerSkills.Count > 0) { Data data = new Data(); data.Rel = new List<string>(); data.Rel.Add("self"); data.Rel.Add(Request.Headers.Host + "/api/worker/" + id + "/skill"); List<Data> result = new List<Data>(); foreach(WorkerSkill ws in workerSkills) { result.Add(GetSkillData(id, ws)); } data.Children = result; uberDocument.Data.Add(data); } string uber = JsonConvert.SerializeObject(uberDocument, Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore }); return Ok(new { uber }); }
private Data GetSkillData(string id, WorkerSkill workerSkill) { Data data = new Data() { Name = "worker", Url = new System.Uri(Request.Headers.Host + "/api/worker/" + id + "/skill") }; data.Rel = new List<string>(); data.Rel.Add("item"); data.Rel.Add(Request.Headers.Host + "/api/rels/worker"); List<Data> children = new List<Data>(); children.Add(new Data { Name = "workerNumber", Label = "Worker Number", Value = workerSkill == null ? null : workerSkill.workerNumber }); children.Add(new Data { Name = "firstName", Label = "First Name", Value = workerSkill == null ? null : workerSkill.firstName }); children.Add(new Data { Name = "lastName", Label = "Last Name", Value = workerSkill == null ? null : workerSkill.lastName }); children.Add(new Data { Name = "skill", Label = "Skill", Value = workerSkill == null ? null : workerSkill.skill }); children.Add(new Data { Name = "experience", Label = "Experience", Value = workerSkill == null ? null : workerSkill.experience }); data.Children = children; return data; }