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); }
/// <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); } }