private void ListGetListInXml(bool inJSON)
{
// link to web service documentation
// http://msdn.microsoft.com/en-us/library/lists.lists.getlist%28v=office.12%29.aspx
XmlNode data = null;
var listName = _dataManager.GetPropVal("ListName");
using (var listSvc = new WorkEngineSolutionStoreListSvc.Lists())
{
// TODO: write a function to get user name and password
listSvc.Credentials = new NetworkCredential("Solution1", @"J@(Djkhldk2", "EPM");
listSvc.Url = CoreFunctions.getFarmSetting("WorkEngineStore") + "_vti_bin/Lists.asmx";
try
{
ServicePointManager.ServerCertificateValidationCallback =
((sender, certificate, chain, sslPolicyErrors) => true);
data = listSvc.GetList(listName);
}
catch (Exception ex)
{
WriteLine(ex);
Response.Write($"{{ error : \"{ex.Message}\" }}");
return;
}
}
Response.Write(!inJSON
? HttpUtility.HtmlEncode(data.OuterXml)
: HttpUtility.HtmlEncode(JSONUtil.ConvertXmlToJson(XmlDataSimplifier.SimplifySPGetListXml(data), string.Empty)));
}
private bool TryGetListItemsInXml(out XmlNode data)
{
// link to web service documentation
// http://msdn.microsoft.com/en-us/library/lists.lists.getlistitems%28v=office.12%29.aspx
data = null;
var listName = _dataManager.GetPropVal("ListName");
var viewName = _dataManager.GetPropVal("ViewName");
var xmlDoc = new XmlDocument();
// create query param
const string queryNodeName = "Query";
var nodeQuery = xmlDoc.CreateNode(XmlNodeType.Element, queryNodeName, string.Empty);
nodeQuery.InnerXml = _dataManager.GetPropVal(queryNodeName);
// create view fields param
const string viewFieldsName = "ViewFields";
var nodeViewFields = xmlDoc.CreateNode(XmlNodeType.Element, viewFieldsName, string.Empty);
nodeViewFields.InnerXml = _dataManager.GetPropVal(viewFieldsName);
var rowLimit = _dataManager.GetPropVal("RowLimit");
// create query options param
const string queryOptionsName = "QueryOptions";
var nodeQueryOptions = xmlDoc.CreateNode(XmlNodeType.Element, queryOptionsName, string.Empty);
var queryOptions = _dataManager.GetPropVal(queryOptionsName);
queryOptions = !string.IsNullOrWhiteSpace(queryOptions) ? queryOptions.Replace(@"\\", @"\") : string.Empty;
nodeQueryOptions.InnerXml = !string.IsNullOrWhiteSpace(queryOptions)
? queryOptions
: "<Folder>Solutions/" + CoreFunctions.GetAssemblyVersion() + "</Folder>";
var webId = _dataManager.GetPropVal("WebID");
using (var listSvc = new WorkEngineSolutionStoreListSvc.Lists())
{
// TODO: write a function to get user name and password
listSvc.Credentials = new NetworkCredential("Solution1", @"J@(Djkhldk2", "EPM");
listSvc.Url = CoreFunctions.getFarmSetting("WorkEngineStore") + "_vti_bin/Lists.asmx";
try
{
ServicePointManager.ServerCertificateValidationCallback =
((sender, certificate, chain, sslPolicyErrors) => true);
data = listSvc.GetListItems(listName, null, nodeQuery, null, rowLimit, nodeQueryOptions, null);
}
catch (Exception ex)
{
WriteLine(ex);
Response.Write($"{{ error : \"{ex.Message}\" }}");
return(false);
}
}
return(true);
}
private void PullMoreInfoFromOnline()
{
System.Xml.XmlNode data = null;
XmlDocument xDoc = new XmlDocument();
// create query param
XmlNode ndQuery = xDoc.CreateNode(XmlNodeType.Element, "Query", "");
if (_solutionType.Equals("sitecollection", StringComparison.CurrentCultureIgnoreCase))
{
ndQuery.InnerXml = "<Where><Eq><FieldRef Name=\"SolutionType\" /><Value Type=\"Choice\">SiteCollection</Value></Eq></Where><OrderBy><FieldRef Name=\"Title\" Ascending=\"True\" /></OrderBy>";
}
else
{
if (_templateType.ToLower() == "template")
{
_templateType = "project";
}
//ndQuery.InnerXml = "<Where><And><Eq><FieldRef Name=\"Visible\" /><Value Type=\"Boolean\">1</Value></Eq><Eq><FieldRef Name=\"SolutionType\" /><Value Type=\"Choice\">" + _solutionType + "</Value></Eq></And></Where><OrderBy><FieldRef Name=\"Title\" Ascending=\"True\" /></OrderBy>";
ndQuery.InnerXml = "<Where><And><Eq><FieldRef Name=\"Visible\" /><Value Type=\"Boolean\">1</Value></Eq><And><Eq><FieldRef Name=\"SolutionType\" /><Value Type=\"Choice\">" + _solutionType + "</Value></Eq><Eq><FieldRef Name=\"TemplateType\" /><Value Type=\"MultiChoice\">" + _templateType + "</Value></Eq></And></And></Where><OrderBy><FieldRef Name=\"Title\" Ascending=\"True\" /></OrderBy>";
}
// create query options param
XmlNode ndQueryOptions = xDoc.CreateNode(XmlNodeType.Element, "QueryOptions", "");
//ndQueryOptions.InnerXml = "<queryOptions xmlns:SOAPSDK9=\"http://schemas.microsoft.com/sharepoint/soap/\" ><QueryOptions/></queryOptions>";
ndQueryOptions.InnerXml = "<Folder>Solutions/" + CoreFunctions.GetAssemblyVersion() + "</Folder>";
using (var listSvc = new WorkEngineSolutionStoreListSvc.Lists())
{
// TODO: write a function to get user name and password
listSvc.Credentials = new NetworkCredential("Solution1", @"J@(Djkhldk2", "EPM");
//listSvc.Url = EPMLiveCore.CoreFunctions.getFarmSetting("WorkEngineStore") + "/_vti_bin/Lists.asmx";
listSvc.Url = EPMLiveCore.CoreFunctions.getFarmSetting("WorkEngineStore") + "_vti_bin/Lists.asmx";
data = listSvc.GetListItems("Solutions", null, ndQuery, null, "10000", ndQueryOptions, null);
}
XmlDocument dataXml = new XmlDocument();
dataXml.LoadXml(data.OuterXml);
foreach (XmlNode nd in data.FirstChild.NextSibling.ChildNodes)
{
if (nd.NodeType.Equals(XmlNodeType.Element) &&
nd.Attributes["ows_ID"] != null &&
Convert.ToInt32(nd.Attributes["ows_ID"].Value) == _tempId &&
nd.Attributes["ows_MetaInfo"] != null &&
!string.IsNullOrEmpty(nd.Attributes["ows_MetaInfo"].Value))
{
string[] metaInfos = nd.Attributes["ows_MetaInfo"].Value.Split('\n');
foreach (string info in metaInfos)
{
string header = info.Split('|')[0];
if (header == "MoreInfo:SW")
{
pnlContent.Controls.Add(new LiteralControl(HttpUtility.HtmlDecode(info.Split('|')[1]
.Replace("\r", "")
.Replace("\n", "")
//.Replace("\"", "\\\"")
.Replace("\r\n", "")
.Replace("\\r\\n", "")
.Replace(@"/MoreInfoImages/", @"https://store.workengine.com/MoreInfoImages/")
)));
break;
}
}
break;
}
}
//IEnumerable<XElement> temps = dataXml.Root.Descendants("
}
