public async Task <QueryResult <Training> > GetAll(TrainingQuery queryObj)
{
var query = context.Trainings
.Include(training => training.MarketStatus)
.Include(training => training.Category)
.Include(training => training.Tags)
.Include(training => training.Voivodeship)
.AsQueryable();
if (queryObj.Categories.Length > 0)
{
query = query.Where(v => queryObj.Categories.Contains(v.Category.Name));
}
if (queryObj.Localizations.Length > 0)
{
query = query.Where(v => queryObj.Localizations.Contains(v.Voivodeship.Id));
}
if (queryObj.InstructorId.HasValue)
{
query = query.Where(v => queryObj.InstructorId == v.InstructorId);
}
int trainingsCount = query.ToList().Count();
query = query.ApplyOrdering(queryObj, COLUMNS_MAP);
query = query.ApplyPaging(queryObj);
var trainings = await query.ToListAsync();
var queryResult = new QueryResult <Training>();
queryResult.items = trainings;
queryResult.itemsCount = trainingsCount;
return(queryResult);
}
public IEnumerator TestGetTrainingQuery()
{
Log.Debug("DiscoveryServiceV2IntegrationTests", "Attempting to GetTrainingQuery...");
TrainingExample trainingExample = new TrainingExample()
{
CollectionId = collectionId,
DocumentId = documentId
};
TrainingQuery trainingQueryResponse = null;
service.GetTrainingQuery(
callback: (DetailedResponse <TrainingQuery> response, IBMError error) =>
{
Log.Debug("DiscoveryServiceV2IntegrationTests", "GetTrainingQuery result: {0}", response.Response);
trainingQueryResponse = response.Result;
Assert.IsNotNull(trainingQueryResponse);
Assert.IsNull(error);
},
projectId: projectId,
queryId: queryId
);
while (trainingQueryResponse == null)
{
yield return(null);
}
}
public IEnumerator TestUpdateTrainingQuery()
{
Log.Debug("DiscoveryServiceV2IntegrationTests", "Attempting to UpdateTrainingQuery...");
TrainingExample trainingExample = new TrainingExample()
{
CollectionId = collectionId,
DocumentId = documentId
};
TrainingQuery trainingQueryResponse = null;
service.UpdateTrainingQuery(
callback: (DetailedResponse <TrainingQuery> response, IBMError error) =>
{
Log.Debug("DiscoveryServiceV2IntegrationTests", "UpdateTrainingQuery result: {0}", response.Response);
trainingQueryResponse = response.Result;
queryId = trainingQueryResponse.QueryId;
Assert.IsNotNull(trainingQueryResponse);
Assert.IsNull(error);
},
projectId: projectId,
queryId: queryId,
examples: new List <TrainingExample>()
{
trainingExample
},
filter: "entities.text:IBM",
naturalLanguageQuery: "This is a new example of a query"
);
while (trainingQueryResponse == null)
{
yield return(null);
}
}
public static async void Search(CustomSearchControl SearchControl)
{
var client = Helper.getServiceClient();
TrainingQuery query = new TrainingQuery(); //by default we have an empty query
if (SearchControl.OptionOne.IsChecked == true)
{
query = new TrainingQuery()
{
EmployeeNumber = SearchControl.SearchTextBox.Text
};
}
else if (SearchControl.OptionTwo.IsChecked == true)
{
query = new TrainingQuery()
{
TrainingID = Int32.Parse(SearchControl.SearchTextBox.Text)
};
}
int pagesize = SearchControl.PageSize;
int pagePosition = SearchControl.PagePosition;
var response = await client.QueryTrainingAsync(query, pagesize, pagePosition);
//No response; exit
if (response == null)
{
MessageBox.Show("Service isn't responding, please try again later", "Message", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
SearchControl.ResultCount = response.TotalResultCount;
//Fill the datagrid with the results
SearchControl.ResultsGrid.ItemsSource = new ObservableCollection <HR_EMP_TRAININGS>(response.Result.ToList <HR_EMP_TRAININGS>());;
}
public async Task <IActionResult> getTrainings(TrainingQueryResource queryResource)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
TrainingQuery trainingQuery = mapper.Map <TrainingQueryResource, TrainingQuery>(queryResource);
QueryResult <Training> queryResult = await trainingRepository.GetAll(trainingQuery);
var response = mapper.Map <QueryResult <Training>, QueryResultResource <TrainingResource> >(queryResult);
return(Ok(response));
}
//[UnityTest, Order(103)]
public IEnumerator TestDeleteTrainingQuery()
{
Log.Debug("DiscoveryServiceV2IntegrationTests", "Attempting to DeleteTrainingQuery...");
DocumentAccepted addDocumentResponse = null;
string documentId = "";
string queryId = "";
using (FileStream fs = File.OpenRead(addDocumentFile))
{
using (MemoryStream ms = new MemoryStream())
{
fs.CopyTo(ms);
service.AddDocument(
callback: (DetailedResponse <DocumentAccepted> response, IBMError error) =>
{
Log.Debug("DiscoveryServiceV1IntegrationTests", "AddDocument result: {0}", response.Response);
addDocumentResponse = response.Result;
documentId = addDocumentResponse.DocumentId;
Assert.IsNotNull(addDocumentResponse);
Assert.IsNotNull(documentId);
Assert.IsNull(error);
},
projectId: projectId,
collectionId: collectionId,
file: ms,
fileContentType: Utility.GetMimeType(Path.GetExtension(addDocumentFile)),
filename: Path.GetFileName(addDocumentFile)
);
while (addDocumentResponse == null)
{
yield return(null);
}
}
}
TrainingExample trainingExample = new TrainingExample()
{
CollectionId = collectionId,
DocumentId = documentId,
Relevance = 1L
};
TrainingQuery trainingQueryResponse = null;
service.CreateTrainingQuery(
callback: (DetailedResponse <TrainingQuery> response, IBMError error) =>
{
Log.Debug("DiscoveryServiceV2IntegrationTests", "CreateTrainingQuery result: {0}", response.Response);
trainingQueryResponse = response.Result;
queryId = trainingQueryResponse.QueryId;
Assert.IsNotNull(trainingQueryResponse);
Assert.IsNull(error);
},
projectId: projectId,
examples: new List <TrainingExample>()
{
trainingExample
},
filter: "entities.text:IBM",
naturalLanguageQuery: "This is an example of a query"
);
while (trainingQueryResponse == null)
{
yield return(null);
}
bool deleteTrainingQueryResponse = false;
service.DeleteTrainingQuery(
callback: (DetailedResponse <object> response, IBMError error) =>
{
Assert.IsNull(error);
deleteTrainingQueryResponse = true;
},
projectId: projectId,
queryId: queryId
);
while (!deleteTrainingQueryResponse)
{
yield return(null);
}
DeleteDocumentResponse deleteDocumentResponse = null;
service.DeleteDocument(
callback: (DetailedResponse <DeleteDocumentResponse> response, IBMError error) =>
{
Log.Debug("DiscoveryServiceV2IntegrationTests", "DeleteDocument result: {0}", response.Response);
deleteDocumentResponse = response.Result;
Assert.IsNotNull(deleteDocumentResponse);
Assert.IsNull(error);
},
projectId: projectId,
collectionId: collectionId,
documentId: documentId
);
while (deleteDocumentResponse == null)
{
yield return(null);
}
}
