public projectBundle(luisResultContainer._Entities entities)
{
_sqlConnector = new sqlConnector();
_sqlConnector.OpenConnection();
List <Project> projects = new List <Project>();
string searchQuery = projectSelectionQueryBuilder(entities.contactJobTitle, entities.contactName,
entities.organizationName,
entities.projectUsages, entities.projectLocation, entities.projectCriteria, entities.projectDescription,
entities.organizationOverview);
List <List <String> > projectSearchResults = _sqlConnector.select(searchQuery);
for (int i = 0; i < projectSearchResults.Count; i++)
{
projects.Add(new Project(fields, projectSearchResults[i].ToArray()));
}
this.projects = projects.ToArray();
_sqlConnector.CloseConnection();
}