public IHttpActionResult GetWorkerBranch(string id) { var query = WebApiConfig.GraphClient.Cypher .Match("(w:Worker)-[e:WORKSIN]->(b:Branch)") .Where((Worker w) => w.id == id) .Return((w, b) => new { worker = w.As <Worker>(), branch = Return.As <string>("collect(b.number)") }); var queryData = query.Results.ToList(); var workerBranches = new List <WorkerBranch>(); foreach (var item in queryData) { WorkerBranch workerBranch = new WorkerBranch { workerNumber = item.worker.number, firstName = item.worker.firstName, lastName = item.worker.lastName, BranchNumber = item.branch }; workerBranches.Add(workerBranch); } UberDocument uberDocument = new UberDocument { Version = "1.0", Data = new List <Data>() }; if (workerBranches.Count > 0) { Data data = new Data(); data.Rel = new List <string>(); data.Rel.Add("self"); data.Rel.Add(Request.Headers.Host + "/api/worker/" + id + "/branch"); List <Data> result = new List <Data>(); foreach (WorkerBranch wb in workerBranches) { result.Add(GetBranchData(id, wb)); } data.Children = result; uberDocument.Data.Add(data); } string uber = JsonConvert.SerializeObject(uberDocument, Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore }); return(Ok(new { uber })); }
public IHttpActionResult Read(string id) { var query = WebApiConfig.GraphClient.Cypher .Match("(w:Worker)") .Where((Worker w) => w.id == id) .Return(w => w.As <Worker>()); var workers = query.Results.ToList(); UberDocument uberDocument = new UberDocument { Version = "1.0", Data = new List <Data>() }; Worker worker = null; if (workers.Count > 0) { worker = workers[0]; Data data = new Data(); data.Rel = new List <string>(); data.Rel.Add("self"); data.Rel.Add(Request.Headers.Host + "/api/worker/" + id); List <Data> result = new List <Data>(); result.Add(GetReadData(id, worker)); result.Add(GetSkillData(id, null)); result.Add(GetBranchData(id, null)); result.Add(GetActionData(id, Actions.Replace)); result.Add(GetActionData(id, Actions.Remove)); data.Children = result; uberDocument.Data.Add(data); } string uber = JsonConvert.SerializeObject(uberDocument, Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore }); return(Ok(new { uber })); }
public IHttpActionResult Definition() { UberDocument uberDocument = new UberDocument { Version = "1.0", Data = new List <Data>() }; Data data = new Data(); data.Rel = new List <string>(); data.Rel.Add("self"); data.Rel.Add(Request.Headers.Host + "/api"); //string authToken = Request.Headers.Authorization.Parameter; List <string> allowedActions = GetAllowedActions(string.Empty); data.Children = GetDataElements(allowedActions, "{id}", null, null); uberDocument.Data.Add(data); string uber = JsonConvert.SerializeObject(uberDocument, Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore }); return(Ok(new { uber })); }
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 })); }