public projectBundle(luisResultContainer._Entities entities) { string configFile = File.ReadAllText("Database/dbconfig.json"); config = JsonConvert.DeserializeObject(configFile); _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, entities.projectDate); List <List <String> > projectSearchResults = _sqlConnector.select(searchQuery); //Create a Project object for each project found and populate it with its values for (int i = 0; i < projectSearchResults.Count; i++) { projects.Add(new Project(fields, projectSearchResults[i].ToArray())); } this.projects = projects.ToArray(); _sqlConnector.CloseConnection(); }
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(); }