static void Main(string[] args)
{
#region Webservice use
//var visualSitecoreService = new SitecoreWS.VisualSitecoreServiceSoapClient();
//string database = "master";
//SitecoreWS.Credentials credentials = new SitecoreWS.Credentials();
//credentials.UserName = @"sitecore\admin";
//credentials.Password = "******";
//string homeItem = "{641783AA-0EF2-4117-9503-C5CEA36E32F3}";
//string homeItem2 = "{180A9978-A7F5-4AF3-AEA3-7E4062177DAA}";
////string parentItem = "{C5384188-D4B4-4C09-A053-094271353190}";
//var children = visualSitecoreService.GetChildren(homeItem2, database, credentials);
//XmlDocument xmlDoc = new XmlDocument();
//xmlDoc.LoadXml(children.ToString());
//string xpath = "sitecore/item/@id";
//var nodes = xmlDoc.SelectNodes(xpath);
//foreach (XmlNode childrenNode in nodes)
//{
// //childrenNode.Value
// var item = visualSitecoreService.GetItemFields(childrenNode.Value, "en", "1", true, database, credentials);
// //var getItem = sitecoreService.GetItemFields(getChildren.ChildNodes[i].Attributes[0].Value, "en", "1", true, database, myCred);
//}
#endregion
#region fetch Core database installed pkg info
var visualSitecoreService = new SitecoreWS.VisualSitecoreServiceSoapClient();
string database = "core";
SitecoreWS.Credentials credentials = new SitecoreWS.Credentials();
credentials.UserName = @"sitecore\admin";
credentials.Password = "******";
string homeItem = "/sitecore/system/Packages/Installation history";
//string homeItem2 = "{180A9978-A7F5-4AF3-AEA3-7E4062177DAA}";
//string parentItem = "{C5384188-D4B4-4C09-A053-094271353190}";
var children = visualSitecoreService.GetChildren(homeItem, database, credentials);
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(children.ToString());
XmlDocument xmlGrandChildDoc = new XmlDocument();
string xpath = "sitecore/item/@id";
var nodes = xmlDoc.SelectNodes(xpath);
foreach (XmlNode childrenNode in nodes)
{
var grandChildNode = visualSitecoreService.GetChildren(childrenNode.Value, database, credentials);
xmlGrandChildDoc.LoadXml(grandChildNode.ToString());
var grandChildNodes = xmlGrandChildDoc.SelectNodes(xpath);
foreach (XmlNode grandChildrenNode in grandChildNodes)
{
var item = visualSitecoreService.GetItemFields(grandChildrenNode.Value, "en", "1", true, database, credentials);
//field[@title='Package name']
//field[@title='Package version']
//var getItem = sitecoreService.GetItemFields(getChildren.ChildNodes[i].Attributes[0].Value, "en", "1", true, database, myCred);
}
}
#endregion
}
// GET: WebService
public ActionResult Index()
{
var visualSitecoreService = new SitecoreWS.VisualSitecoreServiceSoapClient();
string database = "master";
SitecoreWS.Credentials credentials = new SitecoreWS.Credentials();
credentials.UserName = @"sitecore\admin";
credentials.Password = "******";
string homeItem = "{641783AA-0EF2-4117-9503-C5CEA36E32F3}";
string homeItem2 = "{180A9978-A7F5-4AF3-AEA3-7E4062177DAA}";
//string parentItem = "{C5384188-D4B4-4C09-A053-094271353190}";
var children = visualSitecoreService.GetChildren(homeItem2, database, credentials);
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(children.ToString());
string xpath = "sitecore/item/@id";
var nodes = xmlDoc.SelectNodes(xpath);
foreach (XmlNode childrenNode in nodes)
{
//childrenNode.Value
var item = visualSitecoreService.GetItemFields(childrenNode.Value, "en", "1", true, database, credentials);
//var getItem = sitecoreService.GetItemFields(getChildren.ChildNodes[i].Attributes[0].Value, "en", "1", true, database, myCred);
}
using (XmlReader reader = XmlReader.Create((new StringReader(children.ToString()))))
{
XDocument loaded = XDocument.Load(reader);
var q = from c in loaded.Descendants("id")
select (string)c.Value;
foreach (string name in q)
Console.WriteLine("Item name = {0}", name);
}
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart")
.SetXAxis(new XAxis
{
Categories = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }
})
.SetSeries(new Series
{
Data = new Data(new object[] { 29.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4 })
});
return View(chart);
//string parentId = "{37F01BDF-AAF4-4C0C-87A0-CD26220F783D}";
//string templateId = "{1D7ADB59-3AB0-4131-93AB-AADE26297D65}";
//while (true)
//{
// Console.WriteLine("Sitecore Terminal Web Service Integration");
// Console.WriteLine("=========================================");
// var children = visualSitecoreService.GetChildren(parentId, database, credentials);
// using (System.Xml.XmlReader reader =
// XmlReader.Create((new System.IO.StringReader(children.ToString()))))
// {
// XDocument loaded = XDocument.Load(reader);
// var q = from c in loaded.Descendants("item")
// select (string)c.Value;
// Console.WriteLine("Number of added items in Sitecore = " + q.Count().ToString() + "" + Environment.NewLine);
// foreach (string name in q)
// Console.WriteLine("Item name = {0}", name);
// Console.WriteLine(Environment.NewLine);
// }
// Console.WriteLine("=========================================" +
// Environment.NewLine);
// Console.WriteLine("Enter a name for the new Item:" +
// Environment.NewLine);
// string itemName = Console.ReadLine();
// var result = visualSitecoreService.AddFromTemplate(parentId, templateId, itemName, database, credentials);
// Console.WriteLine("Item '" + itemName + "' is added.");
// Console.WriteLine("Press key to continue");
// Console.ReadKey();
// Console.Clear();
// return View();
//}
//}
}
