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());
}
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;
}
}
});
}
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);
}
}
}
}
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>");
}
});
}
public void processResources()
{
try
{
using (var sqlCommand = new SqlCommand("select pubtype from publishercheck where projectguid=@projectguid", cn))
{
sqlCommand.Parameters.AddWithValue("@projectguid", projectUid);
using (var dataReader = sqlCommand.ExecuteReader())
{
if (dataReader.Read())
{
var pubType = dataReader.GetInt32(0);
dataReader.Close();
try
{
var members = myWebToPublish.AssociatedMemberGroup;
var visitors = myWebToPublish.AssociatedVisitorGroup;
var projectDataSet = new ProjectDataSet();
SPSecurity.RunWithElevatedPrivileges(
delegate { projectDataSet = psiProject.ReadProject(projectUid, DataStoreEnum.PublishedStore); });
const int PubType3 = 3;
if (pubType == PubType3)
{
foreach (ProjectDataSet.TaskRow tr in projectDataSet.Task)
{
var userId = getResourceIdForTask(tr.TASK_UID, projectDataSet);
if (userId != 0)
{
members.AddUser(myWebToPublish.AllUsers.GetByID(userId));
}
}
}
else
{
foreach (ProjectDataSet.ProjectResourceRow projectResourceRow in projectDataSet.ProjectResource)
{
try
{
if (!projectResourceRow.IsWRES_ACCOUNTNull())
{
var email = string.Empty;
try
{
email = projectResourceRow.WRES_EMAIL;
}
catch (Exception ex)
{
Trace.TraceError("Exception Suppressed {0}", ex);
}
if (projectResourceRow.RES_WORK == 0)
{
visitors.AddUser(projectResourceRow.WRES_ACCOUNT, email, projectResourceRow.RES_NAME, string.Empty);
}
else
{
members.AddUser(projectResourceRow.WRES_ACCOUNT, email, projectResourceRow.RES_NAME, string.Empty);
}
}
}
catch (Exception ex)
{
Trace.TraceError("Exception Suppressed {0}", ex);
}
}
}
members.Update();
visitors.Update();
}
catch (Exception ex)
{
myLog.WriteEntry("Error Processing Resources2: " + ex.Message + ex.StackTrace, EventLogEntryType.Error, 330);
}
}
else
{
dataReader.Close();
}
}
}
}
catch (Exception ex)
{
myLog.WriteEntry("Error Processing Resources: " + ex.Message + ex.StackTrace, EventLogEntryType.Error, 330);
}
}