public static void Run() { // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName); try { // ExStart:SupportForSQLiteDatabase string connectionString = "Data Source=" + dataDir + "\\PPMDBSQLite.db"; const int projectId = 4502; // Create Primavera DB Settings using connection string and project id PrimaveraDbSettings primaveraDbSettings = new PrimaveraDbSettings(connectionString, projectId); primaveraDbSettings.ProviderInvariantName = "System.Data.SQLite"; // Create new project using primavera db settings Project project = new Project(primaveraDbSettings); // ExEnd:SupportForSQLiteDatabase } catch (Exception ex) { Console.WriteLine(ex.Message + "\nPlease setup proper datasource (connectionString, ProviderInvariantName) etc"); } }
public void ImportProjectFromPrimaveraDBSQLite() { try { // ExStart:ImportProjectFromPrimaveraDBSQLite // ExFor: DbSettings // ExFor: DbSettings.#ctor(String) // ExFor: DbSettings.ConnectionString // ExFor: DbSettings.ProviderInvariantName // ExSummary: Shows how to read a project from a Primavera XML file with multiple projects by using a provider name. var connectionString = "Data Source=" + DataDir + "\\PPMDBSQLite.db"; // Create Primavera DB Settings using connection string and project id var settings = new PrimaveraDbSettings(connectionString, 4502); settings.ProviderInvariantName = "System.Data.SQLite"; Console.WriteLine("Connection String: " + settings.ConnectionString); Console.WriteLine("Provider Name: " + settings.ProviderInvariantName); var project = new Project(settings); project.Save(OutDir + "SupportForSQLiteDatabase_out.mpp", SaveFileFormat.MPP); // ExEnd:ImportProjectFromPrimaveraDBSQLite } catch (ArgumentException ex) { Console.WriteLine(ex.Message + "\nPlease setup proper data source (connectionString, ProviderInvariantName) etc"); } catch (TasksReadingException ex) { Console.WriteLine(ex.Message + "\nPlease setup proper data source (connectionString, ProviderInvariantName) etc"); } }
public static void Run() { // ExStart:ImportProjectFromPrimaveraDB SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder(); sb.DataSource = "192.168.56.3,1433"; sb.Encrypt = true; sb.TrustServerCertificate = true; sb.InitialCatalog = "PrimaveraEDB"; sb.NetworkLibrary = "DBMSSOCN"; sb.UserID = "privuser"; sb.Password = "******"; // Initialize a new instance of the PrimaveraDbSettings class with connection string and project id PrimaveraDbSettings settings = new PrimaveraDbSettings(sb.ConnectionString, 4502); // Initialize a new instance of the Project class Project project = new Project(settings); // ExEnd:ImportProjectFromPrimaveraDB }
public static void Run() { // ExStart:SupportForSQLiteDatabase // The path to the documents directory. string dataDir = RunExamples.GetDataDir_PrintingAndExporting(); try { const string connectionString = "SQLiteDatabaseConnectionString"; const int projectId = 4502; PrimaveraDbSettings primaveraDbSettings = new PrimaveraDbSettings(connectionString, projectId); primaveraDbSettings.ProviderInvariantName = "System.Data.SQLite"; Project project = new Project(primaveraDbSettings); } catch (Exception ex) { Console.WriteLine(ex.Message + "\nPlease setup proper datasource (connectionString, ProviderInvariantName) etc"); } // ExEnd:SupportForSQLiteDatabase }
public void ImportProjectFromPrimaveraDB() { try { // ExStart:ImportProjectFromPrimaveraDB // ExFor: PrimaveraDbSettings // ExFor: PrimaveraDbSettings.#ctor(String,Int32) // ExFor: PrimaveraDbSettings.ProjectId // ExSummary: Shows how to import a project from a Primavera database. var sb = new SqlConnectionStringBuilder(); sb.DataSource = "192.168.56.3,1433"; sb.Encrypt = true; sb.TrustServerCertificate = true; sb.InitialCatalog = "PrimaveraEDB"; sb.NetworkLibrary = "DBMSSOCN"; sb.UserID = "privuser"; sb.Password = "******"; sb.ConnectTimeout = 2; // ExSkip // Initialize a new instance of the PrimaveraDbSettings class with connection string and project id var settings = new PrimaveraDbSettings(sb.ConnectionString, 4502); Console.WriteLine("Project UID to read: " + settings.ProjectId); // read the project with UID = 4502 var project = new Project(settings); Console.WriteLine(project.Get(Prj.Uid)); // ExEnd:ImportProjectFromPrimaveraDB } catch (NotSupportedException ex) { Console.WriteLine(ex.Message + "\nPlease setup proper data source (connectionString, ProviderInvariantName) etc"); } catch (TasksReadingException ex) { Console.WriteLine(ex.Message); } }
public static void Run() { // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName); try { //ExStart:SupportForSQLiteDatabase string connectionString = "Data Source=" + dataDir + "\\PPMDBSQLite.db"; const int ProjectId = 4502; // Create Primavera DB Settings using connection string and project id PrimaveraDbSettings primaveraDbSettings = new PrimaveraDbSettings(connectionString, ProjectId); primaveraDbSettings.ProviderInvariantName = "System.Data.SQLite"; // Create new project using primavera db settings Project project = new Project(primaveraDbSettings); //ExEnd:SupportForSQLiteDatabase } catch (Exception ex) { Console.WriteLine(ex.Message + "\nPlease setup proper data source (connectionString, ProviderInvariantName) etc"); } }