private string getResourceUsername(string url, Guid RES_GUID) { try { WebSvcResource.Resource pResource = new WebSvcResource.Resource(); pResource.Url = url + "/_vti_bin/psi/resource.asmx"; pResource.UseDefaultCredentials = true; WebSvcResource.ResourceDataSet rDs = new WebSvcResource.ResourceDataSet(); SPSecurity.RunWithElevatedPrivileges(delegate() { rDs = pResource.ReadResource(RES_GUID); }); if (rDs.Resources.Count > 0) { if (rDs.Resources[0].RES_IS_WINDOWS_USER) { return(rDs.Resources[0].WRES_ACCOUNT); } } } catch (Exception ex) { string logEntry = "Error: " + ex.Message; ErrorTrap(3003, logEntry); } return(""); }
public ResourceSyncher(Guid siteId) { siteGuid = siteId; SPSecurity.RunWithElevatedPrivileges(delegate() { using (SPSite site = new SPSite(siteGuid)) { pCf = new WebSvcCustomFields.CustomFields(); pCf.Url = site.Url + "/_vti_bin/psi/customfields.asmx"; pCf.UseDefaultCredentials = true; cfDs = new WebSvcCustomFields.CustomFieldDataSet(); cfDs = pCf.ReadCustomFieldsByEntity(resEntity); psiLookupTable = new WebSvcLookupTables.LookupTable(); psiLookupTable.Url = site.Url + "/_vti_bin/psi/lookuptable.asmx"; psiLookupTable.UseDefaultCredentials = true; pResource = new WebSvcResource.Resource(); pResource.Url = site.Url + "/_vti_bin/psi/resource.asmx"; pResource.UseDefaultCredentials = true; //SPSecurity.RunWithElevatedPrivileges(delegate() //{ cn = new SqlConnection(EPMLiveCore.CoreFunctions.getConnectionString(site.WebApplication.Id)); cn.Open(); //}); } }); }
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); } }
public static Guid GetResourceGuidByWindowsAccount(string ls_name) { string errLoc = ""; try { WebSvcResource.Resource res = new WebSvcResource.Resource(); WebSvcResource.ResourceDataSet lo_resDS = new WebSvcResource.ResourceDataSet(); res.Credentials = System.Net.CredentialCache.DefaultCredentials; string nameColumn = lo_resDS.Resources.WRES_ACCOUNTColumn.ColumnName; string resUID = lo_resDS.Resources.RES_UIDColumn.ColumnName; PSLibrary.Filter.FieldOperationType equal = PSLibrary.Filter.FieldOperationType.Equal; PSLibrary.Filter lo_filter = new PSLibrary.Filter(); lo_filter.FilterTableName = lo_resDS.Resources.TableName; lo_filter.Fields.Add(new PSLibrary.Filter.Field(resUID)); lo_filter.Criteria = new PSLibrary.Filter.FieldOperator(equal, nameColumn, ls_name); errLoc = "ReadResources()"; lo_resDS = res.ReadResources(lo_filter.GetXml(), false); errLoc = "Returning Guid"; return((Guid)lo_resDS.Tables[lo_resDS.Resources.TableName].Rows[0][0]); } catch (Exception ex) { Trace.WriteLine(ex.ToString()); using (var myLog = new EventLog("EPM Live", ".", "EPM Live Helper")) { myLog.WriteEntry($"Error at GetResourceGuidByWindowsAccount: {ex.Message}{ex.StackTrace}", EventLogEntryType.Error, 401); return(new Guid()); } } }