private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create Application object
            MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;

            //Open an MPP file
            projectApplication.FileOpenEx("Project1.mpp",
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                missingValue, missingValue, missingValue, missingValue,
                missingValue);

            //Create a Project object by assigning active project
            Project project = projectApplication.ActiveProject;

            // Enumerate the tasks
            foreach (Task task in project.Tasks)
            {
                //Get critical tasks
                if (task != null)
                    if ((bool)task.Critical)
                    {
                        Console.WriteLine(task.ID + "  " + task.Name);
                        Console.WriteLine(task.Start);
                        Console.WriteLine(task.Finish + "\n");
                    }
            }

            // Make sure to clean up and close the file
            projectApplication.FileCloseAll(PjSaveType.pjDoNotSave);

        }
示例#2
1
        private void ExportToMSProjectButtonClick(object sender, RoutedEventArgs e)
        {
            Microsoft.Office.Interop.MSProject.Application msApplication = null;
            try
            {
                msApplication = new Microsoft.Office.Interop.MSProject.Application();
            }
            catch (COMException)
            {
                MessageBox.Show("You need to have MSProject installed on your computer in order to use the export functionality of the example.", "No Installation");
                return;
            }

            try
            {
                msApplication.AppMaximize();
                msApplication.FileNew(Missing.Value, Missing.Value, Missing.Value, Missing.Value);

                var msProject = msApplication.ActiveProject;
                msProject.ManuallyScheduledTasksAutoRespectLinks = false;
                FillProjectWithTasks(msProject, this.radGanttView1.TasksSource.OfType<IGanttTask>(), null, false);
                FillTasksWithDependencies(msProject.Tasks.OfType<Task>(), this.radGanttView1.TasksSource.OfType<IGanttTask>());
                msApplication.Visible = true;
            }
            catch (COMException)
            {
                try
                {
                    msApplication.Quit(PjSaveType.pjDoNotSave);
                }
                catch (COMException)
                {
                    return;
                }
                MessageBox.Show("You should not interact with MSProject while Exporting is performed! Please, export again.", "Interaction exception");
            }
        }
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create an Application object
            Microsoft.Office.Interop.MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;
            //Open an MPP file
            projectApplication.FileOpenEx("Project1.mpp",
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                missingValue, missingValue, missingValue, missingValue,
                missingValue);
            Microsoft.Office.Interop.MSProject.Project project = projectApplication.ActiveProject;

            int iRecourceId = 1;
            foreach (Task tsk in project.Tasks)
            {
                string developer = "Developer0" + iRecourceId;
                project.Resources.Add(developer, iRecourceId);
                tsk.Assignments.Add(tsk.ID, iRecourceId, missingValue);
                iRecourceId++;
            }

            projectApplication.FileCloseAll(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave);
        }
示例#4
0
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create an Application object
            Microsoft.Office.Interop.MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;

            //Open an MPP file
            projectApplication.FileOpenEx("Project2.mpp",
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue);

            //Create a Project object by assigning active project
            Microsoft.Office.Interop.MSProject.Project project = projectApplication.ActiveProject;

            //Create and add new task
            Microsoft.Office.Interop.MSProject.Task task;
            task          = project.Tasks.Add("Task1", 1);
            task.Start    = "8/23/2012";
            task.Duration = 3 * 8 * 60;
            task.Text1    = "Task1";

            //Save project and close application
            projectApplication.FileCloseAll(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave);
        }
示例#5
0
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create an Application object
            Microsoft.Office.Interop.MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;

            //Open an MPP file
            projectApplication.FileOpenEx("Project1.mpp",
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue);
            Microsoft.Office.Interop.MSProject.Project project = projectApplication.ActiveProject;

            int iRecourceId = 1;

            foreach (Task tsk in project.Tasks)
            {
                string developer = "Developer0" + iRecourceId;
                project.Resources.Add(developer, iRecourceId);
                tsk.Assignments.Add(tsk.ID, iRecourceId, missingValue);
                iRecourceId++;
            }

            projectApplication.FileCloseAll(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave);
        }
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create an Application object
            Microsoft.Office.Interop.MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;
            //Open an MPP file
            projectApplication.FileOpenEx("Project2.mpp",
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                missingValue, missingValue, missingValue, missingValue,
                missingValue);

            //Create a Project object by assigning active project
            Microsoft.Office.Interop.MSProject.Project project = projectApplication.ActiveProject;

            //Create and add new task
            Microsoft.Office.Interop.MSProject.Task task;
            task = project.Tasks.Add("Task1", 1);
            task.Start = "8/23/2012";
            task.Duration = 3 * 8 * 60;
            task.Text1 = "Task1";

            //Save project and close application
            projectApplication.FileCloseAll(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave);

        }
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create Application object
            MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;

            //Open an MPP file
            projectApplication.FileOpenEx("Project1.mpp",
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue);

            //Create a Project object by assigning active project
            Project project = projectApplication.ActiveProject;

            //Loop through each task and read information related to tasks
            foreach (Task task in project.Tasks)
            {
                Console.WriteLine("Reading Task " + task.Name);
                Console.WriteLine("\nID: " + task.ID);
                Console.WriteLine("Start: " + task.Start);
                Console.WriteLine("Finish: " + task.Finish);
                Console.WriteLine("\n===========================\n");

                //Read any other information you need
            }

            //Loop through each resource and read information related to resources
            foreach (Resource resource in project.Resources)
            {
                string resourceType = null;
                switch (resource.Type)
                {
                case PjResourceTypes.pjResourceTypeCost:
                    resourceType = "Cost";
                    break;

                case PjResourceTypes.pjResourceTypeMaterial:
                    resourceType = "Material";
                    break;

                case PjResourceTypes.pjResourceTypeWork:
                    resourceType = "Work";
                    break;
                }
                Console.WriteLine("Reading Resource " + resource.Name);
                Console.WriteLine("\nID: " + resource.ID);
                Console.WriteLine("Type: " + resourceType);
                Console.WriteLine("\n===========================\n");

                //Read any other information you need
            }
            Console.ReadLine();
        }
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create Application object
           MSProject. Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;

            //Open an MPP file
            projectApplication.FileOpenEx("Project1.mpp",
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                missingValue, missingValue, missingValue, missingValue,
                missingValue);

            //Create a Project object by assigning active project
            Project project = projectApplication.ActiveProject;

            //Loop through each task and read information related to tasks
            foreach (Task task in project.Tasks)
            {
                Console.WriteLine("Reading Task " + task.Name);
                Console.WriteLine("\nID: " + task.ID);
                Console.WriteLine("Start: " + task.Start);
                Console.WriteLine("Finish: " + task.Finish);
                Console.WriteLine("\n===========================\n");

                //Read any other information you need
            }

            //Loop through each resource and read information related to resources
            foreach (Resource resource in project.Resources)
            {
                string resourceType = null;
                switch (resource.Type)
                {
                    case PjResourceTypes.pjResourceTypeCost:
                        resourceType = "Cost";
                        break;
                    case PjResourceTypes.pjResourceTypeMaterial:
                        resourceType = "Material";
                        break;
                    case PjResourceTypes.pjResourceTypeWork:
                        resourceType = "Work";
                        break;
                }
                Console.WriteLine("Reading Resource " + resource.Name);
                Console.WriteLine("\nID: " + resource.ID);
                Console.WriteLine("Type: " + resourceType);
                Console.WriteLine("\n===========================\n");

                //Read any other information you need
            }
            Console.ReadLine();
        }
 //public frmProjectSelection(ref MSProject.Application oApplication, ref CSAPInterface oSAPInterface)
 public frmProjectSelection(ref MSProject.Application oApplication, ref CSAPInterface oSAPInterface)
 {
     InitializeComponent();
     // Set reference to MS Project Application object
     rApplication = oApplication;  //Used to set status bar from this form
     // Set reference to the CSAPInterface
     rSAPInterface = oSAPInterface;
     // Get the collection of SAP Project IDs to display
     oSAPInterface.GetProjDefList(ref oProjDefs);
     dataGridPrjDefs.DataSource = oProjDefs;
 }
示例#10
0
        private void CcmRibbon_Load(object sender, RibbonUIEventArgs e)
        {
            application = CmmAddIn.thisApp;
            CmmAddIn.OnProjectLoaded += (project) => { 
                this.project = project;

                // Update ribbon display
                var isBuffersHidden = CcmData.GetIsBuffersHidden();
                HideUnhideBuffers(isBuffersHidden);
            };
        }
示例#11
0
        private void ExportToMSProjectButtonClick(object sender, RoutedEventArgs e)
        {
            var msApplication = new Microsoft.Office.Interop.MSProject.Application();
            msApplication.AppMaximize();
            msApplication.FileNew(Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            var msProject = msApplication.ActiveProject;
            msProject.ManuallyScheduledTasksAutoRespectLinks = false;
            FillProjectWithTasks(msProject, this.radGanttView1.TasksSource.OfType<IGanttTask>(), null, false);
            FillTasksWithDependencies(msProject.Tasks.OfType<Task>(), this.radGanttView1.TasksSource.OfType<IGanttTask>());
            msApplication.Visible = true;
        }
示例#12
0
        public static void DisplayCommandBars(object objApp, string appName)
        {
            // Show all the command bars
            // Will need to cast objApp if Option Strict
            string s = "";

            Office.CommandBars cbars = null;

            switch (appName)
            {
            case "Microsoft Excel":
                MsoExcel.Application appExcel = (MsoExcel.Application)objApp;
                cbars = appExcel.CommandBars;
                break;

            case "Microsoft PowerPoint":
                MsoPowerPoint.Application appPowerPoint = (MsoPowerPoint.Application)objApp;
                cbars = appPowerPoint.CommandBars;
                break;

            case "Microsoft Project":
                MsoProject.Application appProject = (MsoProject.Application)objApp;
                cbars = appProject.CommandBars;
                break;

            case "Microsoft Visio":
                MsoVisio.Application appVisio = (MsoVisio.Application)objApp;
                cbars = (Office.CommandBars)appVisio.CommandBars;
                break;

            case "Microsoft Word":
                MsoWord.Application appWord = (MsoWord.Application)objApp;
                cbars = appWord.CommandBars;
                break;

            case "Outlook":
                MsoOutlook.Application appOutlook = (MsoOutlook.Application)objApp;
                MsoOutlook.Explorer    explorer   = appOutlook.ActiveExplorer();
                cbars = explorer.CommandBars;
                break;

            default:
                MessageBox.Show("DisplayCommandBars:Unknown appName->" + appName + "<");
                return;
            }

            foreach (Office.CommandBar bar in cbars)
            {
                s = s + String.Format("{0}\n", bar.Name);
            }

            MessageBox.Show(s);
        }
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            Cursor.Current = Cursors.WaitCursor;

            oApplication = Application;
            // Set oProject as the current ActiveProject
            oProject = new CProject(ref Application);
            // Pass the project in for use in CSAPInterface
            oSAPInterface = new CSAPInterface(ref oProject);

            oApplication.StatusBar = "SAP AddIn loaded successfully.";

            Cursor.Current = Cursors.Default;
        }
示例#14
0
        private void ExportToMSProjectButtonClick(object sender, RoutedEventArgs e)
        {
            MessageBox.Show("MSProject will start exporting RadGanttView soon. While the process in running we do not recommend interacting with MS Project because the export might break.", "Start Exporting", MessageBoxButton.OK, MessageBoxImage.Information);

            try
            {
                msApplication = new Microsoft.Office.Interop.MSProject.Application();
            }
            catch (COMException)
            {
                MessageBox.Show("You need to have MSProject installed on your computer in order to use the export functionality of the example.", "No Installation");
                return;
            }

            System.Windows.Application.Current.MainWindow.WindowState = WindowState.Minimized;

            try
            {
                msApplication.AppMaximize();
                msApplication.FileNew(Missing.Value, Missing.Value, Missing.Value, Missing.Value);

                var msProject = msApplication.ActiveProject;
                msProject.ManuallyScheduledTasksAutoRespectLinks = false;
                FillProjectWithTasks(msProject, this.radGanttView1.TasksSource.OfType <IGanttTask>(), null, false);
                FillTasksWithDependencies(msProject.Tasks.OfType <Task>(), this.radGanttView1.TasksSource.OfType <IGanttTask>());
                msApplication.Visible = true;
            }
            catch (COMException)
            {
                try
                {
                    msApplication.Quit(PjSaveType.pjDoNotSave);
                }
                catch (COMException)
                {
                    return;
                }
                System.Windows.Application.Current.MainWindow.WindowState = WindowState.Normal;
                MessageBox.Show("Export has failed. Please, do not interact with MSProject while Exporting is performed.", "Interaction exception");
            }
        }
示例#15
0
        // Constructor
        public CProject(ref MSProject.Application Application)
        {
            // sGlobalTemplate is our global MS Project objects
            string sGlobalTemplate = Properties.Settings.Default.TestDir + "SAPProject.mpt";

            rApplication = Application;

            try
            {
                //Load our GlobalTemplate
                //rApplication.FileNew(false, @sGlobalTemplate, false, false);
                rApplication.FileNew(false, @sGlobalTemplate, false, false);
            }
            catch (IOException e)
            {
                MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            //Assign reference from standard MSProject to our own
            rProject = rApplication.ActiveProject;
            rTasks   = rProject.Tasks;
        }
        public BuildSchedule(MSProject.Application projectApp, ProjectServerConnection psc)
        {
            //
            // Required for Windows Form Designer support
            //
            InitializeComponent();

            //
            // TODO: Add any constructor code after InitializeComponent call
            //

            this.projectApp = projectApp;
            this.psc        = psc;
            Project[] userProjects = psc.getProjectManager().getAllProjectsForAccount(psc.getAccount().id);
            foreach (Project project in userProjects)
            {
                ProjectListItem pli = new ProjectListItem();
                pli.Name    = project.name;
                pli.Project = project;
                cbSelectProject.Items.Add(pli);
            }
        }
示例#17
0
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create an Application object
            Microsoft.Office.Interop.MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;

            //Open an MPP file
            projectApplication.FileOpenEx("Project.mpp",
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue);

            //Create a Project object by assigning active project
            Microsoft.Office.Interop.MSProject.Project project = projectApplication.ActiveProject;

            //Add dependencies among the tasks
            project.Tasks.get_UniqueID(2).TaskDependencies.Add(project.Tasks.get_UniqueID(1), PjTaskLinkType.pjFinishToStart);
            project.Tasks.get_UniqueID(3).TaskDependencies.Add(project.Tasks.get_UniqueID(2), PjTaskLinkType.pjFinishToStart);
            project.Tasks.get_UniqueID(4).TaskDependencies.Add(project.Tasks.get_UniqueID(3), PjTaskLinkType.pjFinishToStart);
            project.Tasks.get_UniqueID(5).TaskDependencies.Add(project.Tasks.get_UniqueID(4), PjTaskLinkType.pjFinishToStart);
            project.Tasks.get_UniqueID(5).TaskDependencies.Add(project.Tasks.get_UniqueID(2), PjTaskLinkType.pjFinishToStart);

            //Display the dependencies
            foreach (Task tsk in project.Tasks)
            {
                foreach (TaskDependency dep in project.Tasks.get_UniqueID(tsk.ID).TaskDependencies)
                {
                    Console.WriteLine("From ID = " + dep.From.ID + "=>To ID = " + dep.To.ID);
                }
                Console.WriteLine("____________________________________________________________");
            }

            //Save the project
            projectApplication.FileCloseAll(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave);
        }
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create an Application object
            Microsoft.Office.Interop.MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;

            //Open an MPP file
            projectApplication.FileOpenEx("Project.mpp",
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, missingValue, missingValue,
                missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                missingValue, missingValue, missingValue, missingValue,
                missingValue);

            //Create a Project object by assigning active project
            Microsoft.Office.Interop.MSProject.Project project = projectApplication.ActiveProject;

            //Add dependencies among the tasks
            project.Tasks.get_UniqueID(2).TaskDependencies.Add(project.Tasks.get_UniqueID(1), PjTaskLinkType.pjFinishToStart);
            project.Tasks.get_UniqueID(3).TaskDependencies.Add(project.Tasks.get_UniqueID(2), PjTaskLinkType.pjFinishToStart);
            project.Tasks.get_UniqueID(4).TaskDependencies.Add(project.Tasks.get_UniqueID(3), PjTaskLinkType.pjFinishToStart);
            project.Tasks.get_UniqueID(5).TaskDependencies.Add(project.Tasks.get_UniqueID(4), PjTaskLinkType.pjFinishToStart);
            project.Tasks.get_UniqueID(5).TaskDependencies.Add(project.Tasks.get_UniqueID(2), PjTaskLinkType.pjFinishToStart);

            //Display the dependencies
            foreach (Task tsk in project.Tasks)
            {
                foreach (TaskDependency dep in project.Tasks.get_UniqueID(tsk.ID).TaskDependencies)
                {
                    Console.WriteLine("From ID = " + dep.From.ID + "=>To ID = " + dep.To.ID);
                }
                Console.WriteLine("____________________________________________________________");
            }

            //Save the project
            projectApplication.FileCloseAll(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave);
        }
示例#19
0
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create Application object
            MSProject.Application projectApplication = new MSProject.Application();

            object missingValue = System.Reflection.Missing.Value;

            //Open an MPP file
            projectApplication.FileOpenEx("Project1.mpp",
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue, missingValue, PjPoolOpen.pjPoolReadOnly,
                                          missingValue, missingValue, missingValue, missingValue,
                                          missingValue);

            //Create a Project object by assigning active project
            Project project = projectApplication.ActiveProject;

            // Enumerate the tasks
            foreach (Task task in project.Tasks)
            {
                //Get critical tasks
                if (task != null)
                {
                    if ((bool)task.Critical)
                    {
                        Console.WriteLine(task.ID + "  " + task.Name);
                        Console.WriteLine(task.Start);
                        Console.WriteLine(task.Finish + "\n");
                    }
                }
            }

            // Make sure to clean up and close the file
            projectApplication.FileCloseAll(PjSaveType.pjDoNotSave);
        }
        private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
        {
            // Clean up
            if (frmSAP != null)
            {
                frmSAP.Close();
                frmSAP = null;
            }
            //Disconnect from our SAP DB
            if (oSAPInterface != null)
            {
                oSAPInterface.Logout();
                oSAPInterface = null;
            }

            oApplication = null;

            // Release the AddIn reference
            if (objAddIn != null)
            {
                objAddIn.Dispose();
                objAddIn = null;
            }
        }
示例#21
0
 public CcmData()
 {
     application = CmmAddIn.thisApp;
     project = CmmAddIn.thisApp.ActiveProject;
 }
        public static new int Convert(String inputFile, String outputFile, Hashtable options)
        {
            Boolean running = (Boolean)options["noquit"];

            MSProject.Application app = null;
            object missing            = System.Reflection.Missing.Value;

            try
            {
                try
                {
                    app = (MSProject.Application)Marshal.GetActiveObject("MSProject.Application");
                }
                catch (System.Exception)
                {
                    app     = new MSProject.Application();
                    running = false;
                }
                System.Type type = app.GetType();
                if (type.GetMethod("DocumentExport") == null || System.Convert.ToDouble(app.Version.ToString()) < 14)
                {
                    Console.WriteLine("Not implemented with Office version {0}", app.Version);
                    return((int)ExitCode.UnsupportedFileFormat);
                }

                app.ShowWelcome           = false;
                app.DisplayAlerts         = false;
                app.DisplayPlanningWizard = false;
                app.DisplayWizardErrors   = false;

                Boolean includeProps = !(Boolean)options["excludeprops"];
                Boolean markup       = (Boolean)options["markup"];

                FileInfo fi = new FileInfo(inputFile);
                switch (fi.Extension)
                {
                case ".mpp":
                    MSProject.Project project = null;
                    if (app.FileOpenEx(inputFile, false, MSProject.PjMergeType.pjDoNotMerge, missing, missing, missing, missing, missing, missing, missing, missing, MSProject.PjPoolOpen.pjDoNotOpenPool, missing, missing, false, missing))
                    {
                        project = app.ActiveProject;
                    }
                    if (project == null)
                    {
                        return((int)ExitCode.UnknownError);
                    }
                    app.DocumentExport(outputFile, MSProject.PjDocExportType.pjPDF, includeProps, markup, false, missing, missing);
                    app.FileCloseEx(MSProject.PjSaveType.pjDoNotSave, missing, missing);
                    break;
                }
                return(File.Exists(outputFile) ? (int)ExitCode.Success : (int)ExitCode.UnknownError);
            }
            catch (System.Exception e)
            {
                Console.WriteLine(e.Message);
                return((int)ExitCode.UnknownError);
            }
            finally
            {
                if (app != null && !running)
                {
                    ((MSProject.Application)app).Quit();
                }
                Converter.ReleaseCOMObject(app);
            }
        }
示例#23
0
        private void button2_Click(object sender, EventArgs e)
        {
            //inicializar
            //try
            //{
            MySqlConnection conn = new MySqlConnection(connStr);

            //}
            //catch (Exception errosql)
            //{
            // MessageBox.Show("Error en conexion a la base de datos\n\n" + errosql.Message);
            //}
            double[] request_id     = new double[50];
            double[] act_request_id = new double[50];
            string[] ms_project     = new string[3];

            string act_trello_name;
            string act_init_date;
            string act_mail;
            string act_end_date;
            string act_trello_user;
            double act_estimated_hours;
            double act_time_loaded;
            int    contador  = 0;
            int    contador1 = 0;

            try
            {
                conn.Open();
                MySqlDataReader reader;
                MySqlCommand    command;
                string          commandStr = "SELECT * FROM (SELECT request.req_id, request.req_ms_project, COUNT(activities.req_id) AS act_count FROM request LEFT JOIN activities ON activities.req_id = request.req_id GROUP BY 1) AS src WHERE src.act_count = 0;";
                command = new MySqlCommand(commandStr, conn);
                reader  = command.ExecuteReader();
                if (!reader.HasRows)
                {
                    MessageBox.Show("Error no hay solicitudes para cargar.\nVerifique que las solicitudes a cargar no tegan tareas ya inicializadas");
                }
                while (reader.Read())
                {
                    //MessageBox.Show("aqui\n\n");
                    request_id[contador1] = reader.GetDouble(0);
                    //MessageBox.Show(request_id[contador1].ToString());
                    ms_project[contador1] = reader.GetString(1);
                    contador1++;
                }
                reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                conn.Close();
            }
            catch (Exception errosql)
            {
                MessageBox.Show("Error en la consulta\n\n" + errosql.Message);
            }
            try
            {
                conn.Open();
                MySqlDataReader reader;
                MySqlCommand    command;
                string          commandStr = "SELECT * FROM activities;";
                command = new MySqlCommand(commandStr, conn);
                reader  = command.ExecuteReader();

                while (reader.Read())
                {
                    //MessageBox.Show("aqui\n\n");
                    //act_trello_name[contador] = reader.GetString(2);
                    act_request_id[contador1] = reader.GetDouble(1);
                    //MessageBox.Show(act_request_id[contador1].ToString());
                    contador++;
                }
                reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                conn.Close();
            }
            catch (Exception errosql)
            {
                MessageBox.Show("Error en la consulta1\n\n" + errosql.Message);
            }

            ArrayList tasks = new ArrayList(); // se declara array de las tareas
                                               // creamos un objeto de tipo aplicacion MSProject
            int contTask   = 0;
            int contTitle  = 0;
            int cont1      = 0;
            int contTaskT  = 0;
            int contTitleT = 0;

            string[] task_names       = new string[50];
            MSProject.Application app = null;
            app = new MSProject.Application();

            foreach (String project in ms_project)
            {
                if (project != null)
                {
                    try
                    {
                        contTask  = 0;
                        contTitle = 0;
                        // Si no hay problemas para abrir el project entrará en la condición
                        // Fijense en la info que da FileOpen pues aqui indicarás especificas como lo quieres abrir (escritura/lectura) y la ruta, como está aqui es de la forma que se pueda escribir y leer en él
                        if (app.FileOpen("C:/Home/Intelix/Mayoreo/00-Control-Solicitudes/" + project + "", false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, MSProject.PjPoolOpen.pjPoolReadWrite, Type.Missing, Type.Missing, Type.Missing, Type.Missing))
                        {
                            foreach (MSProject.Project proj in app.Projects)
                            {
                                //Se recorre las tareas
                                foreach (MSProject.Task task in proj.Tasks)
                                {
                                    if (task.Rollup.ToString() == "False")
                                    {
                                        act_trello_name     = task.Name;
                                        act_time_loaded     = task.ActualWork / 60;
                                        act_estimated_hours = task.Work / 60;
                                        act_init_date       = String.Format("{0:yyyy-MM-dd HH:mm:ss}", task.Start);
                                        act_end_date        = String.Format("{0:yyyy-MM-dd HH:mm:ss}", task.Finish);
                                        act_trello_user     = task.ResourceNames;
                                        act_mail            = task.Text10;


                                        try
                                        {
                                            //MessageBox.Show("INSERT INTO activities (act_request_id, act_trello_name, act_init_date, act_end_date, act_estimated_hours, act_time_loaded ,act_porcent, act_title, act_trello_user, act_mail) VALUES (" + request_id[cont1] + ",'" + act_trello_name + "','" + act_init_date + "', '" + act_end_date + "', " + act_estimated_hours + "," + act_time_loaded + ", " + act_porcent + ", 'false', '" + act_trello_user + "', '" + act_mail + "')");
                                            conn.Open();
                                            MySqlDataReader reader;

                                            MySqlCommand command1;

                                            string commandStr1 = "INSERT INTO activities (req_id, act_trello_name, act_init_date, act_end_date, act_estimated_hours, act_time_loaded ,act_porcent, act_title, act_trello_user, act_mail) VALUES (" + request_id[cont1] + ",LTRIM(RTRIM('" + act_trello_name + "')),'" + act_init_date + "', '" + act_end_date + "', " + act_estimated_hours + "," + act_time_loaded + ", " + 0 + ", 'false', '" + act_trello_user + "', '" + act_mail + "')";

                                            command1 = new MySqlCommand(commandStr1, conn);
                                            reader   = command1.ExecuteReader();
                                            reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                                            conn.Close();
                                            contTask++;
                                            contTaskT++;
                                        }
                                        catch (Exception errosql)
                                        {
                                            MessageBox.Show("Error en la consulta1\n\n" + errosql.Message);
                                        }


                                        //continue;
                                    }
                                    else
                                    {
                                        act_trello_name     = task.Name;
                                        act_time_loaded     = task.Number11 / 60;
                                        act_estimated_hours = task.Work / 60;
                                        act_init_date       = String.Format("{0:yyyy-MM-dd HH:mm:ss}", task.Start);
                                        act_end_date        = String.Format("{0:yyyy-MM-dd HH:mm:ss}", task.Finish);



                                        try
                                        {
                                            //MessageBox.Show("INSERT INTO activities (act_request_id, act_trello_name, act_init_date, act_end_date, act_estimated_hours, act_time_loaded ,act_porcent, act_title, act_trello_user, act_mail) VALUES (" + request_id[cont1] + ",'" + act_trello_name + "','" + act_init_date + "', '" + act_end_date + "', " + act_estimated_hours + "," + act_time_loaded + ", " + act_porcent + ", 'true', '', '')");
                                            conn.Open();
                                            MySqlDataReader reader;

                                            MySqlCommand command1;

                                            string commandStr1 = "INSERT INTO activities (req_id, act_trello_name, act_init_date, act_end_date, act_estimated_hours, act_time_loaded ,act_porcent, act_title, act_trello_user, act_mail) VALUES (" + request_id[cont1] + ",LTRIM(RTRIM('" + act_trello_name + "')),'" + act_init_date + "', '" + act_end_date + "', " + act_estimated_hours + "," + act_time_loaded + ", " + 0 + ", 'true', '', '')";

                                            command1 = new MySqlCommand(commandStr1, conn);
                                            reader   = command1.ExecuteReader();
                                            reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                                            conn.Close();
                                            contTitle++;
                                            contTitleT++;
                                        }
                                        catch (Exception errosql)
                                        {
                                            MessageBox.Show("Error en la consulta1\n\n" + errosql.Message);
                                        }
                                    }
                                }
                            }

                            MessageBox.Show(contTask + " tareas agregadas a la base de datos.\n\n" + contTitle + " titulos agregados a la base de datos.\n\nCargadas desde: " + project);
                            app.FileClose(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave, false); //cerramos el fichero
                        }

                        //}
                    }
                    catch (Exception err)
                    {
                        MessageBox.Show("Error en el proyecto\n\n" + err.Message, "Error");
                    }
                    cont1++;
                }
            }
            MessageBox.Show("Se agrego un total de:\n\n\t- " + contTaskT + " tareas a la base de datos.\n\n\t- " + contTitleT + " titulos a la base de datos.");
        }
示例#24
0
 private void ThisAddIn_Startup(object sender, System.EventArgs e)
 {
     thisApp = Application;
     this.Application.NewProject += Application_NewProject;
 }
示例#25
0
        //"Server=127.0.0.1;Database=dbgestionocupacion;Uid=root;Pwd=";
        //"Server=10.48.13.154;Database=dbgestionocupacion;Uid=userInt;Pwd=userInt123456";
        private void button1_Click(object sender, EventArgs e)
        {
            /* try
             * {*/
            MySqlConnection conn = new MySqlConnection(connStr);

            /*}
             * catch (Exception errosql)
             * {
             * MessageBox.Show("Error en conexion a la base de datos\n\n" + errosql.Message);
             * }*/
            //tabla Request
            List <int>    req_id     = new List <int>();
            List <String> ms_project = new List <String>();
            //Tabla activities
            List <String>   act_trello_name    = new List <String>();
            List <DateTime> act_init_date      = new List <DateTime>();
            List <DateTime> act_init_real_date = new List <DateTime>();
            List <DateTime> act_end_date       = new List <DateTime>();
            List <DateTime> act_real_end_date  = new List <DateTime>();
            List <String>   act_title          = new List <String>();
            List <String>   mails = new List <String>();
            List <double>   act_estimated_hours = new List <double>();
            List <double>   act_time_loaded     = new List <double>();
            List <double>   act_porcent         = new List <double>();
            List <bool>     used = new List <bool>();
            //Llaves
            List <int> for_req_id = new List <int>();

            try
            {
                conn.Open();
                MySqlDataReader reader;
                MySqlCommand    command;
                string          commandStr = "SELECT * FROM request WHERE req_cargar='false' AND sta_id = 'open';";
                command = new MySqlCommand(commandStr, conn);
                reader  = command.ExecuteReader();

                while (reader.Read())
                {
                    //MessageBox.Show("aqui\n\n");
                    req_id.Add(reader.GetInt32(0));
                    ms_project.Add(reader.GetString(4));
                }
                reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                conn.Close();
            }
            catch (Exception errosql)
            {
                MessageBox.Show("Error en la consulta\n\n" + errosql.Message);
            }
            try
            {
                conn.Open();
                MySqlDataReader reader;
                MySqlCommand    command;
                string          commandStr = "SELECT * FROM activities ORDER BY act_id asc;";
                command = new MySqlCommand(commandStr, conn);
                reader  = command.ExecuteReader();

                while (reader.Read())
                {
                    for_req_id.Add(getintNotNull(reader, 1));
                    act_trello_name.Add(getStringNotNull(reader, 2));
                    act_init_date.Add(getDateTimeNotNull(reader, 5));

                    act_init_real_date.Add(getDateTimeNotNull(reader, 6));

                    act_end_date.Add(getDateTimeNotNull(reader, 7));

                    act_real_end_date.Add(getDateTimeNotNull(reader, 8));

                    act_estimated_hours.Add(getdoubleNotNull(reader, 9));

                    act_time_loaded.Add(getdoubleNotNull(reader, 17));
                    act_porcent.Add(getdoubleNotNull(reader, 19));
                    act_title.Add(getStringNotNull(reader, 20));
                    mails.Add(getStringNotNull(reader, 21));
                    used.Add(false);
                }
                reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                conn.Close();
            }
            catch (Exception errosql)
            {
                MessageBox.Show("Error en la consulta\n\n" + errosql.Message);
            }

            ArrayList tasks = new ArrayList(); // se declara array de las tareas

            // creamos un objeto de tipo aplicacion MSProject
            MSProject.Application app = null;
            app = new MSProject.Application();
            int  cont = 0;
            int  filteredListCount;
            bool test;

            for (int i = 0; i < ms_project.Count; i++)
            {
                if (ms_project[i] != null)
                {
                    MessageBox.Show("Nombre del Project: " + ms_project[i]);

                    try
                    {
                        // Si no hay problemas para abrir el project entrará en la condición
                        // Fijense en la info que da FileOpen pues aqui indicarás especificas como lo quieres abrir (escritura/lectura) y la ruta, como está aqui es de la forma que se pueda escribir y leer en él
                        if (app.FileOpen("C:/Home/Intelix/Mayoreo/00-Control-Solicitudes/" + ms_project[i] + "", false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, MSProject.PjPoolOpen.pjPoolReadWrite, Type.Missing, Type.Missing, Type.Missing, Type.Missing))
                        {
                            //Se recorren los proyectos activos
                            foreach (MSProject.Project proj in app.Projects)
                            {
                                //MessageBox.Show(string.Join(",", for_req_id.ToArray()));
                                filteredListCount = for_req_id.Where(x => x == req_id[i]).ToList().Count;

                                if (proj.Tasks.Count < filteredListCount)
                                {
                                    MessageBox.Show("Para esta solicitud se añadieron cartas desde trello");
                                    //proj.Tasks.Add(act_trello_name[i], i + 1);
                                    for (int k = proj.Tasks.Count; k < filteredListCount; k++)
                                    {
                                        proj.Tasks.Add("", k + 1);
                                    }
                                }
                                //Se recorre las tareas
                                foreach (MSProject.Task task in proj.Tasks)
                                {
                                    //proj.Tasks.Add(act_trello_name[i], i + 1);
                                    for (int j = 0; j < act_trello_name.Count; j++)
                                    {
                                        test = ((act_trello_name[j] == task.Name || "" == task.Name) &&
                                                task.Rollup.ToString() == "False" &&
                                                act_title[j] == "false" &&
                                                req_id[i] == for_req_id[j] &&
                                                used[j] == false);
                                        if (test)
                                        {
                                            used[j]       = true;
                                            task.Name     = act_trello_name[j];
                                            task.Text10   = mails[j];
                                            task.Number11 = act_time_loaded[j];
                                            task.Start10  = act_init_real_date[j];
                                            task.Finish10 = act_real_end_date[j];
                                            task.Number10 = act_porcent[j];
                                            cont++;
                                            continue;
                                        }
                                        if (act_title[j] == "true" && used[j] == false)
                                        {
                                            used[j] = true;
                                        }
                                        if (task.Rollup.ToString() == "True")
                                        {
                                            continue;
                                        }
                                    }
                                }
                                MessageBox.Show(cont + " tareas actualizadas");
                                app.FileClose(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave, false); //cerramos el fichero
                            }
                        }
                    }
                    catch (Exception err)
                    {
                        MessageBox.Show("Error en el proyecto\n\n" + err.Message, "Error");
                    }
                }
            }
        }
示例#26
0
        public static void RemoveMenu(object objApp, string appName, Office.CommandBar cbar, string menuName, string Name)
        {
            Office.CommandBars cbars = null;

            try
            {
                switch (appName)
                {
                case "Microsoft Excel":
                    MsoExcel.Application appExcel = (MsoExcel.Application)objApp;
                    cbars = appExcel.CommandBars;
                    break;

                case "Microsoft PowerPoint":
                    MsoPowerPoint.Application appPowerPoint = (MsoPowerPoint.Application)objApp;
                    cbars = appPowerPoint.CommandBars;
                    break;

                case "Microsoft Project":
                    MsoProject.Application appProject = (MsoProject.Application)objApp;
                    cbars = appProject.CommandBars;
                    break;

                case "Microsoft Visio":
                    MsoVisio.Application appVisio = (MsoVisio.Application)objApp;
                    cbars = (Office.CommandBars)appVisio.CommandBars;
                    break;

                case "Microsoft Word":
                    MsoWord.Application appWord = (MsoWord.Application)objApp;
                    cbars = appWord.CommandBars;
                    break;

                // TODO: There is no ActiveExplorer when we exit app.  How to handle?
                //case "Outlook":
                //    Outlook.Application appOutlook = (Outlook.Application)objApp;
                //    Outlook.Explorer explorer = appOutlook.ActiveExplorer();
                //    cbars = explorer.CommandBars;
                //    break;

                default:
                    MessageBox.Show("RemoveMenu:Unknown appName->" + appName + "<");
                    return;
                }

                cbar = cbars[menuName];

                foreach (Office.CommandBarControl cbc in cbar.Controls)
                {
                    if (cbc.Caption == Name)
                    {
                        cbc.Delete(Missing.Value);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                throw;
            }
        }
示例#27
0
        public IEnumerable <Prueba> GetAllPruebas()
        {
            /* try
             * {*/
            //cadenas de construcción de conexión a servidor
            string          connStr = "Server=10.48.13.154;Database=integracion;Uid=userInt;Pwd=userInt123456";
            MySqlConnection conn    = new MySqlConnection(connStr);

            /*}
             * catch (Exception errosql)
             * {
             * MessageBox.Show("Error en conexion a la base de datos\n\n" + errosql.Message);
             * }*/
            double[]   request_id          = new double[50];
            string[]   ms_project          = new string[50];
            string[]   act_trello_name     = new string[50];
            DateTime[] act_init_date       = new DateTime[50];
            DateTime[] act_init_real_date  = new DateTime[50];
            DateTime[] act_end_date        = new DateTime[50];
            DateTime[] act_real_end_date   = new DateTime[50];
            double[]   act_estimated_hours = new double[50];
            double[]   act_time_loaded     = new double[50];
            double[]   act_porcent         = new double[50];
            int        contador            = 0;
            int        contador1           = 0;

            try
            {
                conn.Open();
                MySqlDataReader reader;
                MySqlCommand    command;
                string          commandStr = "SELECT * FROM request WHERE req_cargar='true';";
                command = new MySqlCommand(commandStr, conn);
                reader  = command.ExecuteReader();

                while (reader.Read())
                {
                    //MessageBox.Show("aqui\n\n");
                    request_id[contador1] = reader.GetDouble(0);
                    ms_project[contador1] = reader.GetString(4);
                    contador1++;
                }
                reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                conn.Close();
            }
            catch (Exception errosql)
            {
                Pruebas[0] = new Prueba {
                    Resultados = "Error en la consulta\n\n" + errosql.Message
                };
            }
            try
            {
                conn.Open();
                MySqlDataReader reader;
                MySqlCommand    command;
                string          commandStr = "SELECT * FROM activities WHERE act_title = 'false';";
                command = new MySqlCommand(commandStr, conn);
                reader  = command.ExecuteReader();

                while (reader.Read())
                {
                    //MessageBox.Show("aqui\n\n");
                    act_trello_name[contador] = reader.GetString(2);
                    //MessageBox.Show(act_trello_name[contador]);
                    act_init_date[contador] = reader.GetDateTime(5);

                    act_init_real_date[contador] = reader.GetDateTime(6);

                    act_end_date[contador] = reader.GetDateTime(7);

                    act_real_end_date[contador] = reader.GetDateTime(8);

                    act_estimated_hours[contador] = reader.GetDouble(9);

                    act_time_loaded[contador] = reader.GetDouble(17);
                    //MessageBox.Show(act_time_loaded[contador].ToString());
                    act_porcent[contador] = reader.GetDouble(19);
                    //MessageBox.Show(act_porcent[contador].ToString());
                    contador++;
                }
                reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                conn.Close();
            }
            catch (Exception errosql)
            {
                Pruebas[1] = new Prueba {
                    Resultados = "Error en la consulta\n\n" + errosql.Message
                };
            }

            ArrayList tasks = new ArrayList(); // se declara array de las tareas

            // creamos un objeto de tipo aplicacion MSProject
            MSProject.Application app = null;
            app = new MSProject.Application();
            int cont = 0;

            foreach (String project in ms_project)
            {
                if (project != null)
                {
                    try
                    {
                        // Si no hay problemas para abrir el project entrará en la condición
                        // Fijense en la info que da FileOpen pues aqui indicarás especificas como lo quieres abrir (escritura/lectura) y la ruta, como está aqui es de la forma que se pueda escribir y leer en él
                        if (app.FileOpen("C:/Home/Intelix/Mayoreo/00-Control-Solicitudes/" + project + "", false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, MSProject.PjPoolOpen.pjPoolReadWrite, Type.Missing, Type.Missing, Type.Missing, Type.Missing))
                        {
                            //Se recorren los proyectos activos
                            foreach (MSProject.Project proj in app.Projects)
                            {
                                //Se recorre las tareas
                                foreach (MSProject.Task task in proj.Tasks)
                                {
                                    for (int i = 0; i < act_trello_name.Length; i++)
                                    {
                                        if (act_trello_name[i] == task.Name && task.Rollup.ToString() == "False")
                                        {
                                            task.Number11 = act_time_loaded[i];
                                            task.Start10  = act_init_real_date[i];
                                            task.Finish10 = act_real_end_date[i];
                                            task.Number10 = act_porcent[i]; //actualizamos en el project el porcentaje
                                            if (cont % 10 == 0 && cont != 0)
                                            {
                                            }
                                            cont++;
                                            continue;
                                        }
                                    }
                                }
                                app.FileClose(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave, false); //cerramos el fichero
                            }
                        }
                    }
                    catch (Exception err)
                    {
                        Pruebas[2] = new Prueba {
                            Resultados = "Error en el proyecto\n\n" + err.Message
                        };
                    }
                }
            }
            return(Pruebas);
        }
        private void LaunchMSProject()
        {
            try
            {
                this.application = new MSProject.Application();
                application.Visible = true;
                System.Threading.Thread.Sleep(5000);
                application.Projects.Add(System.Type.Missing, System.Type.Missing, System.Type.Missing);
                this.project = this.application.ActiveProject;

                this.SetCalendarNoHolidays();

                this.launched = true;
                #region Example code from http://social.technet.microsoft.com/Forums/ru-RU/project2010custprog/thread/0d4b2b34-3051-4b27-bb51-e3cae64ac9f9
                //bool launched = false;
                //for (int timerSec = 0; timerSec < 20 && !launched; timerSec++)
                //{
                //    try
                //    {
                //        this.application.WorkOffline(false);
                //        launched = true;
                //        break;
                //    }
                //    catch
                //    {
                //    }
                //}

                //if (!launched)
                //{
                //    application.DocClose();
                //    System.Threading.Thread.Sleep(1500);
                //    application.Quit(MSProject.PjSaveType.pjDoNotSave);
                //    throw new ApplicationException("Unable to start an instance of MS Project");
                //}
                #endregion

            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
            }
        }
        public static new int Convert(String inputFile, String outputFile, Hashtable options)
        {
            Boolean running = (Boolean)options["noquit"];
            MSProject.Application app = null;
            object missing = System.Reflection.Missing.Value;
            try
            {
                try
                {
                    app = (MSProject.Application)Marshal.GetActiveObject("MSProject.Application");
                }
                catch (System.Exception)
                {
                    app = new MSProject.Application();
                    running = false;
                }
                System.Type type = app.GetType();
                if (type.GetMethod("DocumentExport") == null || System.Convert.ToDouble(app.Version.ToString()) < 14)
                {
                    Console.WriteLine("Not implemented with Office version {0}", app.Version);
                    return (int)ExitCode.UnsupportedFileFormat;
                }

                app.ShowWelcome = false;
                app.DisplayAlerts = false;
                app.DisplayPlanningWizard = false;
                app.DisplayWizardErrors = false;

                Boolean includeProps = !(Boolean)options["excludeprops"];
                Boolean markup = (Boolean)options["markup"];
                
                FileInfo fi = new FileInfo(inputFile);
                switch(fi.Extension)
                {
                    case ".mpp":
                        MSProject.Project project = null;
                        if (app.FileOpenEx(inputFile, false, MSProject.PjMergeType.pjDoNotMerge,missing, missing, missing, missing, missing, missing, missing, missing, MSProject.PjPoolOpen.pjDoNotOpenPool, missing, missing, false, missing)) {
                            project = app.ActiveProject;
                        }
                        if (project == null)
                        {
                            return (int)ExitCode.UnknownError;
                        }
                        app.DocumentExport(outputFile, MSProject.PjDocExportType.pjPDF, includeProps, markup, false, missing, missing);
                        app.FileCloseEx(MSProject.PjSaveType.pjDoNotSave, missing, missing);
                        break;
                }
                return File.Exists(outputFile) ? (int)ExitCode.Success : (int)ExitCode.UnknownError;
            }
            catch (System.Exception e)
            {
                Console.WriteLine(e.Message);
                return (int)ExitCode.UnknownError;
            }
            finally
            {
                if (app != null && !running)
                {
                    ((MSProject.Application)app).Quit();
                }
                Converter.releaseCOMObject(app);
            }
        }
示例#30
0
        public IEnumerable <Prueba> GetAllPruebas()
        {
            string          connStr = "Server=10.48.13.154;Database=integracion;Uid=userInt;Pwd=userInt123456";
            MySqlConnection conn    = new MySqlConnection(connStr);

            Pruebas[0] = new Prueba {
                Resultados = "Todo bien\n\n"
            };
            //}
            //catch (Exception errosql)
            //{
            // MessageBox.Show("Error en conexion a la base de datos\n\n" + errosql.Message);
            //}
            double[] request_id     = new double[50];
            double[] act_request_id = new double[50];
            string[] ms_project     = new string[3];

            string act_trello_name;
            string act_init_date;
            string act_mail;
            string act_end_date;
            string act_trello_user;
            double act_estimated_hours;
            double act_time_loaded;
            double act_porcent;
            int    contador  = 0;
            int    contador1 = 0;

            try
            {
                conn.Open();
                MySqlDataReader reader;
                MySqlCommand    command;
                string          commandStr = "SELECT * FROM request WHERE req_cargar='true';";
                command = new MySqlCommand(commandStr, conn);
                reader  = command.ExecuteReader();

                while (reader.Read())
                {
                    //MessageBox.Show("aqui\n\n");
                    request_id[contador1] = reader.GetDouble(0);
                    //MessageBox.Show(request_id[contador1].ToString());
                    ms_project[contador1] = reader.GetString(4);
                    contador1++;
                }
                reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                conn.Close();
            }
            catch (Exception errosql)
            {
                Pruebas[1] = new Prueba {
                    Resultados = "Error en la consulta\n\n" + errosql.Message
                };
            }
            try
            {
                conn.Open();
                MySqlDataReader reader;
                MySqlCommand    command;
                string          commandStr = "SELECT * FROM activities;";
                command = new MySqlCommand(commandStr, conn);
                reader  = command.ExecuteReader();

                while (reader.Read())
                {
                    //MessageBox.Show("aqui\n\n");
                    //act_trello_name[contador] = reader.GetString(2);
                    act_request_id[contador1] = reader.GetDouble(1);
                    //MessageBox.Show(act_request_id[contador1].ToString());
                    contador++;
                }
                reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                conn.Close();
            }
            catch (Exception errosql)
            {
                Pruebas[2] = new Prueba {
                    Resultados = "Error en la consulta1\n\n" + errosql.Message
                };
            }

            ArrayList tasks = new ArrayList(); // se declara array de las tareas
                                               // creamos un objeto de tipo aplicacion MSProject
            int cont  = 0;
            int cont1 = 0;

            string[] task_names       = new string[50];
            MSProject.Application app = null;
            app        = new MSProject.Application();
            Pruebas[3] = new Prueba {
                arr = ms_project
            };
            foreach (String project in ms_project)
            {
                if (project != null)
                {
                    try
                    {
                        // Si no hay problemas para abrir el project entrará en la condición
                        // Fijense en la info que da FileOpen pues aqui indicarás especificas como lo quieres abrir (escritura/lectura) y la ruta, como está aqui es de la forma que se pueda escribir y leer en él
                        if (app.FileOpen("C:/Home/Intelix/Mayoreo/00-Control-Solicitudes/" + project + "", false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, MSProject.PjPoolOpen.pjPoolReadWrite, Type.Missing, Type.Missing, Type.Missing, Type.Missing))
                        {
                            foreach (MSProject.Project proj in app.Projects)
                            {
                                //Se recorre las tareas
                                foreach (MSProject.Task task in proj.Tasks)
                                {
                                    if (task.Rollup.ToString() == "False")
                                    {
                                        act_trello_name     = task.Name;
                                        act_time_loaded     = task.ActualWork / 60;
                                        act_estimated_hours = task.Work / 60;
                                        act_init_date       = String.Format("{0:yyyy-MM-dd HH:mm:ss}", task.Start);
                                        act_end_date        = String.Format("{0:yyyy-MM-dd HH:mm:ss}", task.Finish);
                                        act_trello_user     = task.ResourceNames;
                                        act_mail            = task.Text10;
                                        act_porcent         = task.Number10;
                                        if (cont % 10 == 0 && cont != 0)
                                        {
                                        }


                                        try
                                        {
                                            //MessageBox.Show("INSERT INTO activities (act_request_id, act_trello_name, act_init_date, act_end_date, act_estimated_hours, act_time_loaded ,act_porcent, act_title, act_trello_user, act_mail) VALUES (" + request_id[cont1] + ",'" + act_trello_name + "','" + act_init_date + "', '" + act_end_date + "', " + act_estimated_hours + "," + act_time_loaded + ", " + act_porcent + ", 'false', '" + act_trello_user + "', '" + act_mail + "')");
                                            conn.Open();
                                            MySqlDataReader reader;

                                            MySqlCommand command1;

                                            string commandStr1 = "INSERT INTO activities (act_request_id, act_trello_name, act_init_date, act_end_date, act_estimated_hours, act_time_loaded ,act_porcent, act_title, act_trello_user, act_mail) VALUES (" + request_id[cont1] + ",'" + act_trello_name + "','" + act_init_date + "', '" + act_end_date + "', " + act_estimated_hours + "," + act_time_loaded + ", " + act_porcent + ", 'false', '" + act_trello_user + "', '" + act_mail + "')";

                                            command1 = new MySqlCommand(commandStr1, conn);
                                            reader   = command1.ExecuteReader();
                                            reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                                            conn.Close();
                                            cont++;
                                        }
                                        catch (Exception errosql)
                                        {
                                            Pruebas[4] = new Prueba {
                                                Resultados = "Error en la consulta\n\n" + errosql.Message
                                            };
                                        }


                                        //continue;
                                    }
                                    else
                                    {
                                        act_trello_name     = task.Name;
                                        act_time_loaded     = task.Number11 / 60;
                                        act_estimated_hours = task.Work / 60;
                                        act_init_date       = String.Format("{0:yyyy-MM-dd HH:mm:ss}", task.Start);
                                        act_end_date        = String.Format("{0:yyyy-MM-dd HH:mm:ss}", task.Finish);
                                        act_porcent         = task.Number10;

                                        if (cont % 10 == 0 && cont != 0)
                                        {
                                        }


                                        try
                                        {
                                            //MessageBox.Show("INSERT INTO activities (act_request_id, act_trello_name, act_init_date, act_end_date, act_estimated_hours, act_time_loaded ,act_porcent, act_title, act_trello_user, act_mail) VALUES (" + request_id[cont1] + ",'" + act_trello_name + "','" + act_init_date + "', '" + act_end_date + "', " + act_estimated_hours + "," + act_time_loaded + ", " + act_porcent + ", 'true', '', '')");
                                            conn.Open();
                                            MySqlDataReader reader;

                                            MySqlCommand command1;

                                            string commandStr1 = "INSERT INTO activities (act_request_id, act_trello_name, act_init_date, act_end_date, act_estimated_hours, act_time_loaded ,act_porcent, act_title, act_trello_user, act_mail) VALUES (" + request_id[cont1] + ",'" + act_trello_name + "','" + act_init_date + "', '" + act_end_date + "', " + act_estimated_hours + "," + act_time_loaded + ", " + act_porcent + ", 'true', '', '')";

                                            command1 = new MySqlCommand(commandStr1, conn);
                                            reader   = command1.ExecuteReader();
                                            reader.Close(); //importante cerrar el reader pues solo se puede tener uno abierto a la vez
                                            conn.Close();
                                            cont++;
                                        }
                                        catch (Exception errosql)
                                        {
                                            Pruebas[5] = new Prueba {
                                                Resultados = "Error en la consulta\n\n" + errosql.Message
                                            };
                                        }
                                    }
                                }
                            }


                            app.FileClose(Microsoft.Office.Interop.MSProject.PjSaveType.pjSave, false); //cerramos el fichero
                        }

                        //}
                    }
                    catch (Exception err)
                    {
                        Pruebas[6] = new Prueba {
                            Resultados = "Error en la consulta\n\n" + err.Message
                        };
                    }
                    cont1++;
                }
            }
            return(Pruebas);
        }
示例#31
0
        private void btImport_Click(object sender, EventArgs e)
        {
            var address  = tbAddress.Text.Trim();
            var userName = tbUserName.Text.Trim();
            var password = tbPassword.Text.Trim();

            Properties.Settings.Default["Address"]  = address;
            Properties.Settings.Default["UserName"] = userName;
            Properties.Settings.Default["Password"] = JonGallowaySecuriyString.EncryptString(JonGallowaySecuriyString.ToSecureString(password));

            using (var client = new WebClient())
            {
                var protocol  = "http";
                var urlprefix = $"{protocol}://{address}/api/2.0/";

                client.Encoding                = System.Text.Encoding.UTF8;
                client.Headers["Accept"]       = "text/xml";
                client.Headers["Content-type"] = "application/x-www-form-urlencoded";

                string    res = "";
                string    token;
                XDocument xdoc;
                try
                {
                    res   = client.UploadString(urlprefix + "authentication.xml", $"userName={userName}&password={password}");
                    xdoc  = XDocument.Parse(res);
                    token = xdoc.XPathSelectElement("//token").Value;
                }
                catch (WebException ex)
                {
                    SLog.Append(SLog.Type.Error, ex.Message);
                    return;
                }
                catch (XmlSyntaxException ex)
                {
                    SLog.Append(SLog.Type.Error, ex.Message);
                    return;
                }

                SLog.Append($"Token: {token}");

                client.Headers["Authorization"] = token;
                res  = client.DownloadString($"{urlprefix}project/@self.xml");
                xdoc = XDocument.Parse(res);

                var selectProject = new SelectProject()
                {
                    Projects =
                        xdoc.XPathSelectElements("//response")
                        .ToDictionary(node => node.XPathSelectElement("./id").Value,
                                      node => node.XPathSelectElement("./title").Value)
                };

                if (selectProject.ShowDialog() != DialogResult.OK)
                {
                    SLog.Append(SLog.Type.Warning, "User cancel"); return;
                }
                var projectId = selectProject.SelectedProjectId;
                SLog.Append($"ProjectID: {projectId}");

                res  = client.DownloadString($"{urlprefix}project/{projectId}/task.xml");
                xdoc = XDocument.Parse(res);

                // Resource list
                var persons = new Dictionary <string, string>();
                foreach (var xperson in xdoc.XPathSelectElements("/result/response/responsibles"))
                {
                    var id = xperson.XPathSelectElement("id").Value;
                    if (persons.ContainsKey(id))
                    {
                        continue;
                    }
                    var displayName = xperson.XPathSelectElement("displayName").Value;
                    persons[id] = displayName;
                }

                // Task list
                var msapp = new MSProject.Application {
                    Visible = true
                };
                var msproject = msapp.Projects.Add();
                foreach (var person in persons)
                {
                    var msresource = msproject.Resources.Add(person.Value);
                    msresource.Code             = person.Key;
                    msresource.EnterpriseText40 = person.Key;
                }

                foreach (var xtask in xdoc.XPathSelectElements("/result/response"))
                {
                    var title  = xtask.XPathSelectElement("title").Value;
                    var mstask = msproject.Tasks.Add(title);
                    mstask.EnterpriseText40 = xtask.XPathSelectElement("id").Value;
                    var xresource = xtask.XPathSelectElement("responsibles");
                    if (xresource != null)
                    {
                        mstask.ResourceNames = xresource.XPathSelectElement("displayName").Value;
                    }
                    var xstart = xtask.XPathSelectElement("startDate");
                    if (xstart != null)
                    {
                        mstask.Start = DateTime.Parse(xstart.Value);
                    }
                    var xfinish = xtask.XPathSelectElement("deadline");
                    if (xfinish != null)
                    {
                        mstask.Finish = DateTime.Parse(xfinish.Value);
                    }
                    var xnotes = xtask.XPathSelectElement("description");
                    if (xnotes != null)
                    {
                        mstask.Notes = xnotes.Value;
                    }
                }
            }
            SaveSettings();
        }