/// <summary>
/// Get Publish project by name
/// </summary>
/// <param name="name">the name of the project</param>
/// <param name="context">csom context</param>
/// <returns></returns>
public csom.PublishedProject GetProjectByName(string name, csom.ProjectContext context)
{
IEnumerable <csom.PublishedProject> projs = context.LoadQuery(context.Projects.Where(p => p.Name == name));
context.ExecuteQuery();
if (!projs.Any()) // no project found
{
return(null);
}
return(projs.FirstOrDefault());
}
/// <sumary>
/// Funcion que permite conectarse a Project Server por medio de parametros de un archivo XML
/// </summary>
private void conn()
{
ProjectCont1 = new csom.ProjectContext(pwaPath);
SecureString securePassword = new SecureString();
foreach (char c in passWord.ToCharArray())
{
securePassword.AppendChar(c);
}
ProjectCont1.Credentials = new SharePointOnlineCredentials(userName, securePassword);
Console.WriteLine("Se conecto a Project Server ");
}
/// <summary>
/// Get csom ProjectContext by letting user type in username and password
/// </summary>
/// <param name="url">pwa website url string</param>
/// <returns></returns>
private static csom.ProjectContext GetContext(string url)
{
csom.ProjectContext context = new csom.ProjectContext(url);
string userName, passWord;
Console.WriteLine("Please enter your username for PWA");
userName = Console.ReadLine();
Console.WriteLine("Please enter your password for PWA");
passWord = Console.ReadLine();
NetworkCredential netcred = new NetworkCredential(userName, passWord);
SharePointOnlineCredentials orgIDCredential = new SharePointOnlineCredentials(netcred.UserName, netcred.SecurePassword);
context.Credentials = orgIDCredential;
return context;
}
/// <summary>
/// Get csom ProjectContext by letting user type in username and password
/// </summary>
/// <param name="url">pwa website url string</param>
/// <returns></returns>
public csom.ProjectContext GetContext(string url)
{
csom.ProjectContext context = new csom.ProjectContext(url);
var userName = Environment.GetEnvironmentVariable("userProject", EnvironmentVariableTarget.Process);
var passWord = Environment.GetEnvironmentVariable("passProject", EnvironmentVariableTarget.Process);
//userName = "******";
//passWord = "******";
NetworkCredential netcred = new NetworkCredential(userName, passWord);
SharePointOnlineCredentials orgIDCredential = new SharePointOnlineCredentials(netcred.UserName, netcred.SecurePassword);
context.Credentials = orgIDCredential;
return(context);
}
/// <summary>
/// Get csom ProjectContext by letting user type in username and password
/// </summary>
/// <param name="url">pwa website url string</param>
/// <returns></returns>
private static csom.ProjectContext GetContext(string url)
{
csom.ProjectContext context = new csom.ProjectContext(url);
string userName, passWord;
Console.WriteLine("Please enter your username for PWA");
userName = Console.ReadLine();
Console.WriteLine("Please enter your password for PWA");
passWord = Console.ReadLine();
NetworkCredential netcred = new NetworkCredential(userName, passWord);
SharePointOnlineCredentials orgIDCredential = new SharePointOnlineCredentials(netcred.UserName, netcred.SecurePassword);
context.Credentials = orgIDCredential;
return(context);
}
public void ReadAndCreateProject(string projectName)
{
// Load csom context
Jobs jobs = new Jobs();
context = jobs.GetContext(pwaInstanceUrl);
// Retrieve publish project named "New Project"
// if you know the Guid of project, you can just call context.Projects.GetByGuid()
csom.PublishedProject project = jobs.GetProjectByName(projectName, context);
if (project == null)
{
Console.WriteLine("Failed to retrieve expected data, make sure you set up server data right. Press any key to continue....");
return;
}
csom.DraftProject draft = project.CheckOut();
// Retrieve project along with tasks & resources
context.Load(draft, p => p.StartDate,
p => p.Description);
context.Load(draft.Tasks, dt => dt.Where(t => t.Name == taskName));
context.Load(draft.Assignments, da => da.Where(a => a.Task.Name == taskName &&
a.Resource.Name == localResourceName));
context.Load(draft.ProjectResources, dp => dp.Where(r => r.Name == localResourceName));
context.ExecuteQuery();
// Make sure the data on server is right
if (draft.Tasks.Count != 1 || draft.Assignments.Count != 1 || draft.ProjectResources.Count != 1)
{
Console.WriteLine("Failed to retrieve expected data, make sure you set up server data right. Press any key to continue....");
Console.ReadLine();
return;
}
// Since we already filetered and validated that the TaskCollection, ProjectResourceCollection and AssignmentCollection
// contains just one filtered item each, we just get the first one.
csom.DraftTask task = draft.Tasks.First();
csom.DraftProjectResource resource = draft.ProjectResources.First();
csom.DraftAssignment assignment = draft.Assignments.First();
//
// Create a project
csom.PublishedProject copyProject = context.Projects.Add(new csom.ProjectCreationInformation()
{
Name = project.Name + "(copy)",
Start = project.StartDate,
Description = "Copy project from a Published one",
});
csom.JobState jobState = context.WaitForQueue(context.Projects.Update(), DEFAULTTIMEOUTSECONDS);
jobs.JobStateLog(jobState, "Creating project");
//
// Copy and Create a task in project
csom.DraftProject copyDraft = copyProject.CheckOut();
Guid taskId = Guid.NewGuid();
csom.Task copyTask = copyDraft.Tasks.Add(new csom.TaskCreationInformation()
{
Id = taskId,
Name = task.Name,
IsManual = task.IsManual,
Start = task.Start,
Duration = task.Duration
});
copyDraft.Update();
//
// Create a local resource and assign the task to him
Guid resourceId = Guid.NewGuid();
csom.ProjectResource copyResource = copyDraft.ProjectResources.Add(new csom.ProjectResourceCreationInformation()
{
Id = resourceId,
Name = resource.Name
});
copyDraft.Update();
csom.DraftAssignment copyAssignment = copyDraft.Assignments.Add(new csom.AssignmentCreationInformation()
{
ResourceId = resourceId,
TaskId = taskId
});
copyDraft.Update();
jobState = context.WaitForQueue(copyDraft.Publish(true), DEFAULTTIMEOUTSECONDS);
jobs.JobStateLog(jobState, "Creating task and assgin to a local resource");
}
//private static string projectCFName = "Piloto Repsol - Pruebas";
//private static string resourceCFName = "Recurso Piloto Repsol - Pruebas";
//private static string taskCFName = "Task - Pruebas";
/// <summary>
/// Create a new project with one local resource, one enterprise resource, one task and one assignment
/// </summary>
public void CreateProjectWithTaskAndAssignment(string projectName)
{
//
// Load csom context
Jobs jobs = new Jobs();
context = jobs.GetContext(pwaInstanceUrl);
//
// Create a project
csom.PublishedProject project = context.Projects.Add(new csom.ProjectCreationInformation()
{
Name = projectName,
Start = DateTime.Today,
Description = "Created project from Azure Function"
});
csom.JobState jobState = context.WaitForQueue(context.Projects.Update(), DEFAULTTIMEOUTSECONDS);
jobs.JobStateLog(jobState, "Creating project");
//
// Create a task in project
context.Load(project, p => p,
p => p.StartDate); //load startdate of project
context.ExecuteQuery();
csom.DraftProject draft = project.CheckOut();
Guid taskId = Guid.NewGuid();
csom.Task task = draft.Tasks.Add(new csom.TaskCreationInformation()
{
Id = taskId,
Name = taskName,
IsManual = false,
Start = project.StartDate.AddDays(1),
Duration = "3d"
});
draft.Update();
//
// Create a local resource and assign the task to him
Guid resourceId = Guid.NewGuid();
csom.ProjectResource resource = draft.ProjectResources.Add(new csom.ProjectResourceCreationInformation()
{
Id = resourceId,
Name = localResourceName
});
draft.Update();
csom.DraftAssignment assignment = draft.Assignments.Add(new csom.AssignmentCreationInformation()
{
ResourceId = resourceId,
TaskId = taskId
});
draft.Update();
jobState = context.WaitForQueue(draft.Publish(true), DEFAULTTIMEOUTSECONDS); // draft.Publish(true) means publish and check in
jobs.JobStateLog(jobState, "Creating task and assgin to a local resource");
}
