Example #1
0
        public ProjectWorkspaceSynch(Guid projectSiteGuid, string webUrl, Guid projectGuid, string username)
        {
            try
            {
                _username = username;

                mySite = new SPSite(projectSiteGuid);
                mySite.AllowUnsafeUpdates = true;

                cn = new SqlConnection(EPMLiveCore.CoreFunctions.getConnectionString(mySite.WebApplication.Id));
                cn.Open();

                mySiteToPublish = new SPSite(webUrl);
                myWebToPublish  = mySiteToPublish.OpenWeb();
                myWebToPublish.AllowUnsafeUpdates = true;

                pCf     = new WebSvcCustomFields.CustomFields();
                pCf.Url = mySite.Url + "/_vti_bin/psi/customfields.asmx";
                pCf.UseDefaultCredentials = true;

                psiLookupTable     = new WebSvcLookupTables.LookupTable();
                psiLookupTable.Url = mySite.Url + "/_vti_bin/psi/lookuptable.asmx";
                psiLookupTable.UseDefaultCredentials = true;

                psiProject     = new WebSvcProject.Project();
                psiProject.Url = mySite.Url + "/_vti_bin/psi/project.asmx";
                psiProject.UseDefaultCredentials = true;

                psiResource     = new WebSvcResource.Resource();
                psiResource.Url = mySite.Url + "/_vti_bin/psi/resource.asmx";
                psiResource.UseDefaultCredentials = true;

                projectUid = projectGuid;
            }
            catch (Exception ex)
            {
                myLog.WriteEntry("Error Loading Workspace Synch: " + ex.Message + ex.StackTrace, EventLogEntryType.Error, 401);
            }
        }
Example #2
0
        private Guid getProjectOwner(string url, Guid projectuid)
        {
            try
            {
                WebSvcProject.Project pService = new WebSvcProject.Project();
                pService.Url = url + "/_vti_bin/psi/project.asmx";
                pService.UseDefaultCredentials = true;

                WebSvcProject.ProjectDataSet pDs = new WebSvcProject.ProjectDataSet();
                SPSecurity.RunWithElevatedPrivileges(delegate()
                {
                    pDs = pService.ReadProject(projectuid, WebSvcProject.DataStoreEnum.PublishedStore);
                });

                return(pDs.Project[0].ProjectOwnerID);
            }
            catch (Exception ex)
            {
                string logEntry = "Error: " + ex.Message;
                ErrorTrap(3002, logEntry);
            }
            return(new Guid());
        }
Example #3
0
        protected void PopulateListbox(WebSvcProject.Project project)
        {
            SPSecurity.RunWithElevatedPrivileges(delegate()
            {
                try
                {
                    WebSvcProject.ProjectDataSet readTemplateDs = project.ReadProjectList();

                    // Create <Blank Project> item
                    ListItem newItem = new ListItem("<Blank Project>", Guid.Empty.ToString());
                    ListBox1.Items.Add(newItem);

                    foreach (WebSvcProject.ProjectDataSet.ProjectRow row in readTemplateDs.Project)
                    {
                        WebSvcProject.ProjectDataSet dsproject = project.ReadProject(row.PROJ_UID, WebSvcProject.DataStoreEnum.WorkingStore);
                        if (dsproject != null && dsproject.Project[0].PROJ_TYPE == (int)PSLibrary.Project.ProjectType.Template)
                        {
                            newItem = new ListItem(dsproject.Project[0].PROJ_NAME, dsproject.Project[0].PROJ_UID.ToString());
                            ListBox1.Items.Add(newItem);
                        }
                    }
                }
                catch (Exception ex)
                {
                    lblError.Visible = true;
                    if (ex.Message.Contains("The request failed with an empty response"))
                    {
                        lblError.Text = "Error: This site is not configured for use with Project Server.";
                    }
                    else
                    {
                        lblError.Text = "Error: " + ex.Message;
                    }
                }
            });
        }
Example #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            // Grab ItemId from querystring
            itemId = Convert.ToInt32(Request["ID"]);

            if (!IsPostBack)
            {
                using (SPWeb spWeb = SPContext.Current.Web)
                {
                    SPList list = spWeb.Lists[new Guid(Request["ListId"])];
                    spWeb.AllowUnsafeUpdates = true;
                    if (!list.Fields.ContainsField("projectguid"))
                    {
                        list.Fields.Add("projectguid", SPFieldType.Text, false);
                        SPField field = list.Fields["projectguid"];
                        field.Hidden = true;
                        field.Update();
                        list.Update();
                    }
                    // Find the item by ID
                    SPListItem item;
                    try
                    {
                        item = list.Items.GetItemById(itemId);
                    }
                    catch
                    {
                        return;
                    }

                    // Get the Project Name
                    ViewState["projectName"] = item.Title;
                    projectName = item.Title;
                    // Get the Site URL
                    ViewState["siteURL"] = GetPWAURL();
                    pwaUrl = ViewState["siteURL"].ToString();

                    // Create instance of Project
                    WebSvcProject.Project project = new WebSvcProject.Project();
                    project.Url = ViewState["siteURL"] + "/_vti_bin/psi/project.asmx";
                    project.UseDefaultCredentials = true;

                    if (item["projectguid"] != null && item["projectguid"].ToString().Length > 0)
                    {
                        Guid projectGuid = new Guid(item["projectguid"].ToString());

                        try
                        {
                            WebSvcProject.ProjectDataSet projectDs = new WebSvcProject.ProjectDataSet();
                            // Read project from PS using project GUID
                            SPSecurity.RunWithElevatedPrivileges(delegate()
                            {
                                projectDs = project.ReadProject(projectGuid, WebSvcProject.DataStoreEnum.WorkingStore);
                            });
                            // Does it exist?
                            if (projectDs != null && projectDs.Tables.Count > 0)
                            {
                                string url    = pwaUrl + "/Project%20Detail%20Pages/Schedule.aspx?ProjUid=" + projectGuid + "&isDlg=1";
                                string source = Request["source"];
                                if (source != null && source != "")
                                {
                                    if (url.Contains("?"))
                                    {
                                        url += "&source=" + source;
                                    }
                                    else
                                    {
                                        url += "?source=" + source;
                                    }
                                }
                                Response.Redirect(url);
                            }
                            else
                            {
                                pnlNewProject.Visible = true;
                                PopulateListbox(project);
                            }
                            lblError.Visible = false;
                        }
                        catch (WebException wEx)
                        {
                            lblError.Visible = true;
                            if (wEx.Message.Contains("Object moved"))
                            {
                                lblError.Text = "Error: This site is not configured for use with Project Server.";
                            }
                            else
                            {
                                lblError.Text = "Error: " + wEx.Message;
                            }
                        }
                        catch (Exception ex)
                        {
                            lblError.Visible = true;
                            if (ex.Message.Contains("The request failed with an empty response"))
                            {
                                lblError.Text = "Error: This site is not configured for use with Project Server.";
                            }
                            else
                            {
                                lblError.Text = "Error: " + ex.Message;
                            }
                        }
                    }
                    else
                    {
                        pnlNewProject.Visible = true;
                        PopulateListbox(project);
                    }
                }
            }
        }
Example #5
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            SPSecurity.RunWithElevatedPrivileges(delegate()
            {
                try
                {
                    // Get the template Guid from the selected item in the list
                    Guid templateGuid = new Guid(ListBox1.SelectedValue);

                    SPWeb spWeb = SPContext.Current.Web;
                    {
                        // Create instance of Project
                        WebSvcProject.Project project = new WebSvcProject.Project();
                        project.Url = ViewState["siteURL"] + "/_vti_bin/psi/project.asmx";
                        project.UseDefaultCredentials = true;

                        // Guid for new project
                        Guid newProjectGuid = Guid.NewGuid();

                        if (templateGuid == Guid.Empty)
                        {
                            WebSvcProject.ProjectDataSet dsProjectDataSet      = new WebSvcProject.ProjectDataSet();
                            WebSvcProject.ProjectDataSet.ProjectRow projectRow = dsProjectDataSet.Project.NewProjectRow();
                            projectRow.PROJ_UID             = newProjectGuid;
                            projectRow.PROJ_NAME            = ViewState["projectName"].ToString();
                            projectRow.PROJ_INFO_START_DATE = System.DateTime.Now;
                            projectRow.PROJ_TYPE            = 0; //0 is for project and 1 is for template
                            dsProjectDataSet.Project.AddProjectRow(projectRow);

                            //create a project
                            Guid job = Guid.NewGuid();
                            project.QueueCreateProject(job, dsProjectDataSet, false);
                            WaitForQueue(job);

                            job = Guid.NewGuid();
                            project.QueuePublish(job, newProjectGuid, true, spWeb.Url);
                            WaitForQueue(job);
                        }
                        else
                        {
                            SPSecurity.RunWithElevatedPrivileges(delegate()
                            {
                                Guid owner     = getResourceUid();
                                newProjectGuid = project.CreateProjectFromTemplate(templateGuid, ViewState["projectName"].ToString());

                                WebSvcProject.ProjectDataSet templateProject;
                                Guid jobGuid     = Guid.NewGuid();
                                Guid sessionGuid = Guid.NewGuid();

                                project.CheckOutProject(newProjectGuid, sessionGuid, "");
                                templateProject = project.ReadProject(newProjectGuid, WebSvcProject.DataStoreEnum.WorkingStore);
                                WebSvcProject.ProjectDataSet temp = ((WebSvcProject.ProjectDataSet)(templateProject.Copy()));


                                temp.Tables[temp.Project.TableName].Rows[0][temp.Project.ProjectOwnerIDColumn] = owner;
                                WebSvcProject.ProjectDataSet updateProjectDataSet = new WebSvcProject.ProjectDataSet();
                                updateProjectDataSet.Project.Merge(temp.Tables[temp.Project.TableName], true);
                                updateProjectDataSet = ((WebSvcProject.ProjectDataSet)updateProjectDataSet.GetChanges(DataRowState.Modified));

                                project.QueueUpdateProject(jobGuid, sessionGuid, updateProjectDataSet, false);
                                WaitForQueue(jobGuid);

                                jobGuid = Guid.NewGuid();
                                project.QueueCheckInProject(jobGuid, newProjectGuid, true, sessionGuid, "");
                                WaitForQueue(jobGuid);
                            });
                        }

                        SPList list = spWeb.Lists["Project Center"];
                        spWeb.AllowUnsafeUpdates = true;
                        // Find the item by ID
                        SPListItem item = list.Items.GetItemById(itemId);
                        // Set the new project Guid in the List
                        item["projectguid"] = newProjectGuid;
                        item.SystemUpdate();
                        pwaUrl      = ViewState["siteURL"].ToString();
                        projectName = item.Title;
                        // Add record to PublisherCheck Table
                        InsertRowIntoPublisherCheck(newProjectGuid);

                        pnlOpenProject.Visible = true;
                        pnlNewProject.Visible  = false;

                        string url    = pwaUrl + "/Project%20Detail%20Pages/Schedule.aspx?ProjUid=" + newProjectGuid + "&isDlg=1";
                        string source = Request["source"];
                        if (source != null && source != "")
                        {
                            if (url.Contains("?"))
                            {
                                url += "&source=" + source;
                            }
                            else
                            {
                                url += "?source=" + source;
                            }
                        }
                        Response.Redirect(url);
                    }
                }
                catch (SoapException ex)
                {
                    PSLibrary.PSClientError error  = new PSLibrary.PSClientError(ex);
                    PSLibrary.PSErrorInfo[] errors = error.GetAllErrors();
                    string errMess = "Error: ";
                    for (int i = 0; i < errors.Length; i++)
                    {
                        errMess += ex.Message.ToString() + "  ";
                        errMess += "PSCLientError Output: ";
                        errMess += errors[i].ErrId.ToString() + "  ";

                        for (int j = 0; j < errors[i].ErrorAttributes.Length; j++)
                        {
                            errMess += "  " + errors[i].ErrorAttributeNames()[j] + ": " + errors[i].ErrorAttributes[j];
                        }
                    }
                    lblError.Text = errMess;
                }
                catch (WebException ex)
                {
                    string errMess = ex.Message.ToString() +
                                     "\n\nLog on, or check the Project Server Queuing Service";
                    ClientScript.RegisterClientScriptBlock(this.GetType(), "Error", "<script language='javascript'>alert('" + errMess + "');</script>");
                }
                catch (Exception ex)
                {
                    ClientScript.RegisterClientScriptBlock(this.GetType(), "Error", "<script language='javascript'>alert('" + ex.Message + "');</script>");
                }
            });
        }