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