Fonctionnalités utilitaires dans Aspose.Tasks pour .NET

Calculer le chemin critique

Le chemin critique est les tâches, ou tâche, qui déterminent finalement quand votre projet se terminera. Garder une trace du chemin critique et des ressources qui leur sont attribuées aide à maintenir le projet à temps. Microsoft Project calcule le chemin critique basé sur des tâches qui n’ont pas de mou, ont des contraintes de date spécifiques (doivent commencer, doivent se terminer, dès que possible ou aussi tard que possible) ou avoir la même date de fin, ou plus tard, que le projet. Aspose.Tasks vous permet de calculer le chemin critique.

La classe Project fournit la propriété CriticalPath qui est utilisée pour récupérer la collection de tâches qui composent le chemin critique du projet. Le morceau de code suivant calcule et affiche les tâches dans le chemin critique.

Project project = new Project("New Project.mpp");
project.CalculationMode = CalculationMode.Automatic;

Task subtask1 = project.RootTask.Children.Add("1");
Task subtask2 = project.RootTask.Children.Add("2");
Task subtask3 = project.RootTask.Children.Add("3");
project.TaskLinks.Add(subtask1, subtask2, TaskLinkType.FinishToStart);

// Display the critical path now
foreach (Task task in project.CriticalPath)
{
    Console.WriteLine(task.Get(Tsk.Name));
}

Printing the TaskWritingException

A project consists of a number of tasks and Aspose.Tasks for .NET API allows adding, removing and updating task information. If there’s a problem when writing tasks, use TasksWritingException to catch them.

Aspose.Tasks for .NET supports printing a message when there’s an exception in writing a task. This is done with TaskWritingException, in a similar way to how TaskReadingException is used.

The log message is contained in the public property TasksWritingException.LogText, as shown in the following code example.

try
{
    Project project = new Project("New Project.mpp");
    Console.Write("This example will only work if you apply a valid Aspose License. You can purchase full license or get 30 day temporary license from http://www.aspose.com/purchase/default.aspx.");
    project.Save("output.mpp", SaveFileFormat.MPP);
}
catch (TasksWritingException ex)
{
    Console.WriteLine(ex.LogText);
}
catch (NotSupportedException ex)
{
    Console.WriteLine(ex.Message + "\nThis example will only work if you apply a valid Aspose License. You can purchase full license or get 30 day temporary license from http://www.aspose.com/purchase/default.aspx.");
}

Working with Filter Data from MPP Files

Aspose.Tasks allows developers to read information about filters applied to MPP file data. This article shows how to retrieve filter definition and filter criteria data from a Microsoft Project MPP file.

Reading Filter Definition Data

// Instantiate project and access task filters
Project project = new Project("ReadFilterDefinitionData.mpp");
List<Filter> taskFilters = project.TaskFilters.ToList();
Console.WriteLine("Task Filters Count: " + taskFilters.Count);
Console.WriteLine("All Tasks: " + taskFilters[0].Name);
Console.WriteLine("Task Item: " + taskFilters[0].FilterType);
Console.WriteLine("Task Filters Show In Menu: " + taskFilters[0].ShowInMenu);
Console.WriteLine("Task filter ShowRelatedSummaryRows: " + taskFilters[0].ShowRelatedSummaryRows);

// Access resource filters
List<Filter> filters = project.ResourceFilters.ToList();
Console.WriteLine("Project.ResourceFilters count: " + filters.Count);
Console.WriteLine("Resource Filter Item Type: Item.ResourceType: " + filters[0].FilterType);
Console.WriteLine("Resource filter ShowInMenu" + filters[0].ShowInMenu);
Console.WriteLine("Resource filter ShowRelatedSummaryRows: " + filters[0].ShowRelatedSummaryRows);

Reading Filter Criteria Data

Project project = new Project("New Project.mpp");

Filter filter = project.TaskFilters.ToList()[1];
Console.WriteLine(filter.Criteria.CriteriaRows.Count);
Console.WriteLine(filter.Criteria.Operation.ToString());

FilterCriteria criteria1 = filter.Criteria.CriteriaRows[0];
Console.WriteLine(criteria1.Test.ToString());
Console.WriteLine(criteria1.Field.ToString());
Console.WriteLine(criteria1.Values[0].ToString());

FilterCriteria criteria2 = filter.Criteria.CriteriaRows[1];
Console.WriteLine(criteria2.Operation.ToString());
Console.WriteLine(criteria2.CriteriaRows.Count);

FilterCriteria criteria21 = criteria2.CriteriaRows[0];
Console.WriteLine(criteria21.Test.ToString());
Console.WriteLine(criteria21.Field.ToString());
Console.WriteLine(criteria21.Values[0].ToString());

FilterCriteria criteria22 = criteria2.CriteriaRows[1];
Console.WriteLine(criteria22.Test.ToString());
Console.WriteLine(criteria22.Field.ToString());
Console.WriteLine(criteria22.Values[0].ToString());
Console.WriteLine(filter.Criteria);

Reading Group Definition Data

A Microsoft Project data file may contain data in groups. Aspose.Tasks for .NET provides the facility to read the group definition data as shown in the below example.

Project project = new Project("New Project.mpp"); 

Console.WriteLine("Task Groups Count: " + project.TaskGroups.Count);

Group taskGroup = project.TaskGroups.ToList()[1];
Console.WriteLine("Group Name:", taskGroup.Name);
Console.WriteLine("Group Criteria count: " + taskGroup.GroupCriteria.Count);
Console.WriteLine("************* Retrieving Task Group's Criterion information *************");

GroupCriterion criterion = taskGroup.GroupCriteria.ToList()[0];
Console.WriteLine("Criterion Field: " + criterion.Field.ToString());
Console.WriteLine("Criterion GroupOn: " + criterion.GroupOn.ToString());
Console.WriteLine("Criterion Cell Color: " + criterion.CellColor);
Console.WriteLine("Criterion Pattern: " + criterion.Pattern.ToString());

if (taskGroup == criterion.ParentGroup)
{
    Console.WriteLine("Parent Group is equal to task Group.");
}

Console.WriteLine("*********** Retrieving Criterion's Font Information ***********");
Console.WriteLine("Font Name: " + criterion.Font.Name);
Console.WriteLine("Font Size: " + criterion.Font.Size);
Console.WriteLine("Font Style: " + criterion.Font.Style);
Console.WriteLine("Ascending/Descending: " + criterion.Ascending);

Reading Table Data from MPP File

The Aspose.Tasks for .NET API supports reading table data from Microsoft Project data files. Project.Tables implements the ICollection interface to provide access to an MPP file’s table data. The feature is supported for all versions of Microsoft Project data files, including MPP 2003, 2007, 2010 and 2013.

The below example shows how to retrieve table data from a Microsoft Project MPP file. The values of table properties such as width, title, title alignment and data alignment are displayed here for demonstration.

Project project = new Project("New Project.mpp");

// Access table
Table task1 = project.Tables.ToList()[0];
Console.WriteLine("Table Fields Count" + task1.TableFields.Count);

// Display all table fields information
foreach (TableField tableField in task1.TableFields)
{
    Console.WriteLine("Field width: " + tableField.Width);
    Console.WriteLine("Field Title: " + tableField.Title);
    Console.WriteLine("Field Title Alignment: " + tableField.AlignTitle.ToString());
    Console.WriteLine("Field Align Data: " + tableField.AlignData.ToString());
}

Extracting Embedded Objects from Task or Review form

Microsoft Project data files (MPP/XML) may contain embedded objects such as documents, excel sheets, PDF, images etc. in Task or Resource views. Aspose.Tasks for .NET API provides the capability to extract these from a project’s Task or Resource view as shown in the below topics.

Extracting Embedded Objects

Embedded objects (those which were created from the file by selecting a file path) are packed into OLE Package inside MPP file. To extract the original file you can use Content and FullPath properties of an instance of the OleObject class.

Project project = new Project("ExtractEmbeddedObjects.mpp");
OleObject ole = project.OleObjects.ToList()[0];
// We have to check this property because it can be null if the embedded object was created inside the ms project application Or, alternatively, you can use this check: if (ole.FileFormat == "Package")
if (!string.IsNullOrEmpty(ole.FullPath))
{
    using (FileStream stream = new FileStream("out.ole", FileMode.Create))
    {
        stream.Write(ole.Content, 0, ole.Content.Length);
    }
}

Embedded objects which were created inside Microsoft Project application can be extracted this way:

IDictionary<string, string> fileFormatExt = new Dictionary<string, string>();
fileFormatExt.Add("RTF", "_rtfFile_out.rtf");
fileFormatExt.Add("MSWordDoc", "_wordFile_out.docx");
fileFormatExt.Add("ExcelML12", "_excelFile_out.xlsx");
Project project = new Project("New Project.mpp"); 
foreach (OleObject oleObject in project.OleObjects)
{
    if (!string.IsNullOrEmpty(oleObject.FileFormat) && fileFormatExt.ContainsKey(oleObject.FileFormat))
    {
        using (FileStream stream = new FileStream("EmbeddedContent_" + fileFormatExt[oleObject.FileFormat], FileMode.Create))
        {
            stream.Write(oleObject.Content, 0, oleObject.Content.Length);
        }
    }
}