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