//provider method for getting the data connected to repository
public ResourceManagerResponseModel.ResourceDetails GetDemo(ISession session)
{
var result = new ResourceManagerResponseModel.ResourceDetails();
result = repository.GetAnswer(session);
return(result);
}
//method for getting the data from the database using the session variable which is provided
public ResourceManagerResponseModel.ResourceDetails GetAnswer(ISession session)
{
var statementTemplate = Common.Constants.query;
var statementParameters = new Dictionary <string, object> {
{ "title", "The Da Vinci Code" }
};
var result = new ResourceManagerResponseModel.ResourceDetails();
var statementResult = session.Run(statementTemplate, statementParameters);
var record = statementResult.ToList();
foreach (var rec in record)
{
}
//result.title = record["title"].As<string>();
//var castResults = new List<ResourceManagerResponseModel.CastResult>();
//List<object> cast = record["cast"].As<List<object>>();
//foreach (IList<object> castMember in cast)
//{
// var castResult = new ResourceManagerResponseModel.CastResult
// {
// name = castMember[0].As<string>(),
// job = castMember[1].As<string>(),
// role = castMember[2]?.As<List<string>>()
// };
// castResults.Add(castResult);
//}
//result.cast = castResults;
return(result);
}
public IHttpActionResult GetData()
{
var result = new ResourceManagerResponseModel.ResourceDetails();
using (var session = WebApiConfig.Neo4jDriver.Session()) {
result = provider.GetDemo(session);
}
return(Ok(result));
}
public List <ResourceManagerResponseModel.ResourceDetails> GetFetchedData(ISession session)
{
var result = new List <ResourceManagerResponseModel.ResourceDetails>();
var statementTemplate = Common.Constants.query2;
var statementResult = session.Run(statementTemplate);
var record = statementResult.ToList();
foreach (var rec in record)
{
var res1 = new ResourceManagerResponseModel.ResourceDetails();
res1.EmployeeID = rec["EmployeeId"].As <string>();
res1.EmployeeName = rec["EmployeeName"].As <string>();
res1.OldProject = rec["OldProject"].As <string>();
res1.OldProjectDate = rec["OldProjectEndDate"].As <string>();
res1.NewProject = rec["NewProject"].As <string>();
res1.NewProjectStartDate = rec["NewProjectStartDate"].As <string>();
res1.SkillsMatching = rec["SkillsMatching"].As <List <string> >();
result.Add(res1);
}
return(result);
}
