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;
}
