public IEnumerable <InputAdvisor> GetInputAdvisorInputs(int inputAdvisorID) { try { var inputAdvisorParam = InputAdvisorParameters.GetInputAdvisorIDParameter(projectDBManager, inputAdvisorID); DataTable dtInputAdvisor = projectDBManager.GetDataTable("SELECT * FROM project.get_input_advisor_inputs_by_id(@input_advisor_id)", CommandType.Text, inputAdvisorParam.ToArray()); List <InputAdvisor> inputAdvisorInputs = dtInputAdvisor.AsEnumerable() .Select(x => new InputAdvisor() { ProjectID = x.Field <int>("projectid"), ResourceID = x.Field <int>("resourceid"), Object = JObject.Parse(x.Field <string>("object")), CreatedBy = x.Field <string>("createdby") }).ToList(); return(inputAdvisorInputs); } catch (Exception getInputAdvisorInputException) { throw new Exception(ExceptionMessages.GET_INPUT_ADVISOR_INPUTS_BY_ID_DATA_ACCESS_ERROR_MSG, getInputAdvisorInputException); } }