Ejemplo n.º 1
0
        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();
        }