public string CreateProjectCategory(CreateProjectParams createProjectParams)
        {
            var connection = new OracleConnection {
                ConnectionString = Constants.ConnectionString
            };
            var           commText = "APR_PROJECT_SUBS_CATEGORY_K.INSERT_PROJECT_SUBS_CATEGORY_p";
            OracleCommand cmd      = new OracleCommand(commText, connection)
            {
                CommandType = CommandType.StoredProcedure
            };

            OracleParameter subCategoryIdOracleParameter = cmd.Parameters.Add("p_SUBS_CATEGORY_ID", OracleDbType.Varchar2, ParameterDirection.Input);

            subCategoryIdOracleParameter.Value = createProjectParams.Categoryid;
            OracleParameter projectCodeOracleParameter = cmd.Parameters.Add("p_PROJECT_CODE", OracleDbType.Varchar2, ParameterDirection.Input);

            projectCodeOracleParameter.Value = createProjectParams.Projectcode;
            OracleParameter subCategoryNameOracleParameter = cmd.Parameters.Add("p_SUBS_CATEGORY_NAME", OracleDbType.Varchar2, ParameterDirection.Input);

            subCategoryNameOracleParameter.Value = createProjectParams.Categoryname;
            OracleParameter resultOracleParameter = cmd.Parameters.Add("p_results", OracleDbType.RefCursor, ParameterDirection.Input);

            connection.Open();
            cmd.ExecuteNonQuery();
            var myReader = ((OracleRefCursor)resultOracleParameter.Value).GetDataReader();

            if (!myReader.Read())
            {
                return(null);
            }
            var ProjectCategoryId = myReader[0].ToString();

            connection.Dispose();
            return(ProjectCategoryId);
        }
 public async Task <Project> CreateProjectAsync(CreateProjectParams @params, CancellationToken?token = default(CancellationToken?))
 {
     using (var response = await Post(BuildEndpoint($"projects"), @params, token))
         using (var content = response.Content)
         {
             return(await Factory.CreateProjectAsync(response));
         }
 }
        public static IDictionary <string, object> getCreateProjectProperties(CreateProjectParams createProjectParams)
        {
            IDictionary <string, object> properties = new Dictionary <string, object>();

            properties[DIRECTORY_PATH] = createProjectParams.DirectoryPath;
            properties[NAME]           = createProjectParams.Name;
            properties[OVERWRITE]      = createProjectParams.Overwrite;
            return(properties);
        }
Esempio n. 4
0
        /// <summary>
        /// Create a NeoLoad project. </summary>
        /// <param name="createProjectParams"> </param>
        /// <exception cref="GeneralSecurityException"> </exception>
        /// <exception cref="IOException"> </exception>
        /// <exception cref="URISyntaxException"> </exception>
        /// <exception cref="NeotysAPIException"> </exception>
        public void CreateProject(CreateProjectParams createProjectParams)
        {
            if (!Enabled)
            {
                return;
            }
            IDictionary <string, object> properties = DesignApiUtils.getCreateProjectProperties(createProjectParams);

            properties[DesignApiUtils.API_KEY] = apiKey;
            try
            {
                CreateEntity(DesignApiUtils.CREATE_PROJECT, properties);
            }
            catch (ODataException oDataException)
            {
                throw new NeotysAPIException(oDataException);
            }
        }