public void SimpleLoad () { string xml001 = "<root/>"; XmlDataDocument doc = new XmlDataDocument (); DataSet ds = new DataSet (); ds.InferXmlSchema (new StringReader (xml001), null); doc.LoadXml (xml001); string xml002 = "<root><child/></root>"; doc = new XmlDataDocument (); ds = new DataSet (); ds.InferXmlSchema (new StringReader (xml002), null); doc.LoadXml (xml002); string xml003 = "<root><col1>test</col1><col1></col1></root>"; doc = new XmlDataDocument (); ds = new DataSet (); ds.InferXmlSchema (new StringReader (xml003), null); doc.LoadXml (xml003); string xml004 = "<set><tab1><col1>test</col1><col1>test2</col1></tab1><tab2><col2>test3</col2><col2>test4</col2></tab2></set>"; doc = new XmlDataDocument (); ds = new DataSet (); ds.InferXmlSchema (new StringReader (xml004), null); doc.LoadXml (xml004); }
public void TestMultipleLoadError () { DataSet ds = new DataSet (); ds.ReadXml (new XmlTextReader (xml, XmlNodeType.Document, null)); // If there is already data element, Load() fails. XmlDataDocument doc = new XmlDataDocument (ds); doc.LoadXml (xml); }
public void TestMultipleLoadNoError () { DataSet ds = new DataSet (); DataTable dt = new DataTable (); dt.Columns.Add ("col1"); ds.Tables.Add (dt); XmlDataDocument doc = new XmlDataDocument (ds); doc.LoadXml (xml); }
public void TestMultipleLoadError() { Assert.Throws<InvalidOperationException>(() => { var ds = new DataSet(); ds.ReadXml(new XmlTextReader(_xml, XmlNodeType.Document, null)); // If there is already data element, Load() fails. XmlDataDocument doc = new XmlDataDocument(ds); doc.LoadXml(_xml); }); }
/// <summary> /// Busca Retorno do Web Service SCAN /// </summary> /// <returns></returns> public string buscaRetornoSCAN(string UF_Empresa) { string sCabec = NfeCabecMsg(); string sDados = consultaNFe(); AssinaNFeXml bc = new AssinaNFeXml(); string xret = string.Empty; try { if (_tpamb == 2) { HLP.WebService.v2_SCAN_Homologacao_NFeConsulta.NfeConsulta2 ws2 = new HLP.WebService.v2_SCAN_Homologacao_NFeConsulta.NfeConsulta2(); HLP.WebService.v2_SCAN_Homologacao_NFeConsulta.nfeCabecMsg cabec = new HLP.WebService.v2_SCAN_Homologacao_NFeConsulta.nfeCabecMsg(); cabec.versaoDados = _versaodados; belUF objUf = new belUF(); cabec.cUF = objUf.RetornaCUF(UF_Empresa); ws2.nfeCabecMsgValue = cabec; ws2.ClientCertificates.Add(bc.BuscaNome("")); XmlDataDocument xmlConsulta = new XmlDataDocument(); xmlConsulta.LoadXml(sDados); XmlNode xNodeConsulta = xmlConsulta.DocumentElement; xret = ws2.nfeConsultaNF2(xNodeConsulta).OuterXml; } else { HLP.WebService.v2_SCAN_Producao_NFeConsulta.NfeConsulta2 ws2 = new HLP.WebService.v2_SCAN_Producao_NFeConsulta.NfeConsulta2(); HLP.WebService.v2_SCAN_Producao_NFeConsulta.nfeCabecMsg cabec = new HLP.WebService.v2_SCAN_Producao_NFeConsulta.nfeCabecMsg(); cabec.versaoDados = _versaodados; belUF objUf = new belUF(); cabec.cUF = objUf.RetornaCUF(UF_Empresa); ws2.nfeCabecMsgValue = cabec; ws2.ClientCertificates.Add(bc.BuscaNome("")); XmlDataDocument xmlConsulta = new XmlDataDocument(); xmlConsulta.LoadXml(sDados); XmlNode xNodeConsulta = xmlConsulta.DocumentElement; xret = ws2.nfeConsultaNF2(xNodeConsulta).OuterXml; } return xret; } catch (Exception) { throw; } }
public override List<BankTransfer> GetBankTransfers() { BankFileOperation = new SieradzFileOperation(); #pragma warning disable 618 XmlDocument xmlFile= new XmlDataDocument(); #pragma warning restore 618 List<BankTransfer> mBankTransferList = new List<BankTransfer>(); xmlFile.LoadXml(BankFileOperation.GetFileContent(SieradzBankFilesPathHolder.TransferFilesPath + @"mBankTransfers.xml")); foreach (var childNode in xmlFile.DocumentElement.ChildNodes) { mBankTransferList.Add(GetTransferEntry(xmlFile.GetElementsByTagName((string) childNode.GetType().GetProperty("Name").GetValue(childNode)).Item(0).OuterXml)); } return mBankTransferList; }
public rainfallImportXML(String StationsFile, String ReadingsFile, ref Dictionary<string, List<StationReading>> precip) { Stations = new XmlDataDocument(); Readings = new XmlDataDocument(); dStations = new Dictionary<string, Station>(); dReadings = new List<Reading>(); dStationReadings = new Dictionary<string, StationReading>(); StreamReader sr = new StreamReader(StationsFile); String xmlStr = sr.ReadToEnd(); Stations.LoadXml(xmlStr); sr = new StreamReader(ReadingsFile); xmlStr = sr.ReadToEnd(); Readings.LoadXml(xmlStr); XmlNodeList root = Stations.GetElementsByTagName("site"); foreach (XmlNode n in root) { dStations.Add(n.ChildNodes[1].InnerXml, new Station(n.ChildNodes[1].InnerXml, Double.Parse(n.ChildNodes[3].InnerXml), Double.Parse(n.ChildNodes[4].InnerXml), n.ChildNodes[2].InnerXml)); } root = Readings.GetElementsByTagName("element"); foreach (XmlNode n in root) { dReadings.Add(new Reading(n.Attributes.GetNamedItem("station_id").Value, n.Attributes.GetNamedItem("date").Value, n.Attributes.GetNamedItem("precip_interval").Value, Double.Parse(n.Attributes.GetNamedItem("value").Value))); } Station curStation; foreach (Reading r in dReadings) { if (precip.ContainsKey(r.DataTime)) { curStation = dStations[r.StationID]; precip[r.DataTime].Add(new StationReading(curStation.Lat, curStation.Lon, r.Date, r.DataTime, r.Value)); } else { List<StationReading> lsr = new List<StationReading>(); curStation = dStations[r.StationID]; lsr.Add(new StationReading(curStation.Lat, curStation.Lon, r.Date, r.DataTime, r.Value)); precip.Add(r.DataTime, lsr); } } }
protected override BankTransfer GetTransferEntry(string entry) { SieradzBankTransfer mBankTransfer = new SieradzBankTransfer(); #pragma warning disable 618 XmlDocument xmlNode = new XmlDataDocument(); #pragma warning restore 618 string datePattern = "d.m.yyyy"; DateTime currentDate = DateTime.Now; var bankDictionary = SieradzBankTransfersUtils.Instance; xmlNode.LoadXml(entry); //TODO it's possible to reduce that sphagetti? // IT FCKIN IS! @UCTT mBankTransfer.TransferInfo.Amount = xmlNode.GetElementsByTagName("Amount").Item(0).InnerText; mBankTransfer.TransferInfo.DestinationAccountNumber = xmlNode.GetElementsByTagName("DestinationAccountNumber").Item(0).InnerText; mBankTransfer.TransferInfo.DestinationPersonName = xmlNode.GetElementsByTagName("DestinationPersonName").Item(0).InnerText; mBankTransfer.TransferInfo.SourceAccountNumber = xmlNode.GetElementsByTagName("SourceAccountNumber").Item(0).InnerText; mBankTransfer.TransferInfo.TransferDate = currentDate.ToString(datePattern); mBankTransfer.TransferInfo.TransferTitle = xmlNode.GetElementsByTagName("TransferTitle").Item(0).InnerText; mBankTransfer.SourceBank = bankDictionary.GetBankName(mBankTransfer.TransferInfo.SourceAccountNumber.Substring(2, 4)); mBankTransfer.DestinationBank = bankDictionary.GetBankName(mBankTransfer.TransferInfo.DestinationAccountNumber.Substring(2, 4)); return mBankTransfer; }
public NavigationSearchData(string xmltag) { Id = ""; FieldId = ""; Action = ""; SqlOperator = ""; SearchFrom = ""; SearchTo = ""; SqlType = ""; SearchField = ""; SqlField = ""; ControlType = ""; Static = ""; Dependency = ""; if (xmltag.Trim().StartsWith("<tag")) { var xdoc = new XmlDataDocument(); xdoc.LoadXml(xmltag); var nodtag = xdoc.SelectSingleNode("tag"); if (nodtag != null) { if (nodtag.Attributes["search"] != null) { SearchField = nodtag.Attributes["search"].Value; var s = SearchField.Split('/'); FieldId = s[s.Count() - 1]; ControlType = s[s.Count() - 2]; } if (nodtag.Attributes["id"] != null) Id = nodtag.Attributes["id"].Value; if (nodtag.Attributes["action"] != null) Action = nodtag.Attributes["action"].Value; if (nodtag.Attributes["sqloperator"] != null) SqlOperator = nodtag.Attributes["sqloperator"].Value; if (nodtag.Attributes["searchfrom"] != null) SearchFrom = nodtag.Attributes["searchfrom"].Value; if (nodtag.Attributes["searchto"] != null) SearchTo = nodtag.Attributes["searchto"].Value; if (nodtag.Attributes["sqltype"] != null) SqlType = nodtag.Attributes["sqltype"].Value; if (nodtag.Attributes["sqlfield"] != null) SqlField = nodtag.Attributes["sqlfield"].Value; if (nodtag.Attributes["static"] != null) Static = nodtag.Attributes["static"].Value; if (nodtag.Attributes["dependency"] != null) Dependency = nodtag.Attributes["dependency"].Value; } } }
private bool CheckWebPartOrAppPartPresenceInSite(ClientContext clientContext, string targetWebPartXmlFileName, string targetWebPartXmlFilePath) { bool isWebPartInSite = false; webParts targetWebPart = null; string webPartPropertiesXml = string.Empty; string webPartType = string.Empty; clientContext.Load(clientContext.Web); clientContext.ExecuteQuery(); ExceptionCsv.WebUrl = clientContext.Web.Url; string exceptionCommentsInfo1 = string.Empty; try { //Prepare Exception Comments exceptionCommentsInfo1 = "Web Url: " + clientContext.Web.Url + ", Target Web Part File Name: " + targetWebPartXmlFileName + " , Target WebPart Xml File Path: " + targetWebPartXmlFilePath; using (System.IO.FileStream fs = new System.IO.FileStream(targetWebPartXmlFilePath, System.IO.FileMode.Open, System.IO.FileAccess.Read)) { System.IO.StreamReader reader = new System.IO.StreamReader(fs); webPartPropertiesXml = reader.ReadToEnd(); } Logger.AddMessageToTraceLogFile(Constants.Logging, "[CheckWebPartOrAppPartPresenceInSite] Checking for web part schema version"); Console.WriteLine("[CheckWebPartOrAppPartPresenceInSite] Checking for web part schema version"); if (webPartPropertiesXml.Contains("WebPart/v2")) { Logger.AddMessageToTraceLogFile(Constants.Logging, "[CheckWebPartOrAppPartPresenceInSite] Web part schema version is V2"); Console.WriteLine("[CheckWebPartOrAppPartPresenceInSite] Web part schema version is V2"); XmlDataDocument xmldoc = new XmlDataDocument(); xmldoc.LoadXml(webPartPropertiesXml); webPartType = GetWebPartShortTypeName(xmldoc.DocumentElement.GetElementsByTagName("TypeName").Item(0).FirstChild.Value); Logger.AddMessageToTraceLogFile(Constants.Logging, "[CheckWebPartOrAppPartPresenceInSite] Web part Type: " + webPartType); Console.WriteLine("[CheckWebPartOrAppPartPresenceInSite] Web part Type: " + webPartType); xmldoc = null; } else { Logger.AddMessageToTraceLogFile(Constants.Logging, "[CheckWebPartOrAppPartPresenceInSite] Web part schema version is V3"); Console.WriteLine("[CheckWebPartOrAppPartPresenceInSite] Web part schema version is V3"); using (System.IO.FileStream fs = new System.IO.FileStream(targetWebPartXmlFilePath, System.IO.FileMode.Open, System.IO.FileAccess.Read)) { XmlReader reader = new XmlTextReader(fs); XmlSerializer serializer = new XmlSerializer(typeof(webParts)); targetWebPart = (webParts)serializer.Deserialize(reader); if (targetWebPart != null) { webPartType = GetWebPartShortTypeName(targetWebPart.webPart.metaData.type.name); Logger.AddMessageToTraceLogFile(Constants.Logging, "[CheckWebPartOrAppPartPresenceInSite] Web part Type: " + webPartType); Console.WriteLine("[CheckWebPartOrAppPartPresenceInSite] Web part Type: " + webPartType); } } } if (webPartType.Equals("ClientWebPart", StringComparison.CurrentCultureIgnoreCase)) { foreach (var item in targetWebPart.webPart.data.properties) { if (item.name.Equals("FeatureId", StringComparison.CurrentCultureIgnoreCase)) { Guid featureID = new Guid(item.Value); isWebPartInSite = IsFeatureOnWeb(featureID,clientContext); break; } } } else { Web web = clientContext.Site.RootWeb; clientContext.Load(web, w => w.Url); clientContext.ExecuteQuery(); List list = web.Lists.GetByTitle("Web Part Gallery"); CamlQuery camlQuery = CamlQuery.CreateAllItemsQuery(1000); Microsoft.SharePoint.Client.ListItemCollection items = list.GetItems(camlQuery); clientContext.Load(items); clientContext.ExecuteQuery(); foreach (ListItem item in items) { if (item["FileLeafRef"].ToString().Equals(targetWebPartXmlFileName, StringComparison.CurrentCultureIgnoreCase)) { isWebPartInSite = true; break; } } } } catch (Exception ex) { ExceptionCsv.WriteException(ExceptionCsv.WebApplication, ExceptionCsv.SiteCollection, ExceptionCsv.WebUrl, "Web Part", ex.Message, ex.ToString(), "CheckWebPartOrAppPartPresenceInSite", ex.GetType().ToString(), exceptionCommentsInfo1); Logger.AddMessageToTraceLogFile(Constants.Logging, "[EXCEPTION][CheckWebPartOrAppPartPresenceInSite] Exception Message: " + ex.Message + ", Exception Comment: " + exceptionCommentsInfo1); Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("[EXCEPTION][CheckWebPartOrAppPartPresenceInSite] Exception Message: " + ex.Message); Console.ForegroundColor = ConsoleColor.Gray; return isWebPartInSite; } return isWebPartInSite; }
public void GetWebPartUsage_DefaultPages(string webPartType, ClientContext clientContext, string outPutDirectory) { ExceptionCsv.WebUrl = clientContext.Web.Url; string exceptionCommentsInfo1 = string.Empty; string webPartUsageFileName = outPutDirectory + "\\" + Constants.WEBPART_USAGE_ENTITY_FILENAME; try { string webUrl = clientContext.Web.Url; Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage_DefaultPages] Finding WebPartUsage details for Web Part: " + webPartType + " in Web: " + webUrl); Console.WriteLine("[GetWebPartUsage_DefaultPages] Finding WebPartUsage details for Web Part: " + webPartType + " in Web: " + webUrl); WebPartUsageEntity webPartUsageEntity = null; List<WebPartUsageEntity> webPartUsage = new List<WebPartUsageEntity>(); if (clientContext != null) { clientContext.Load(clientContext.Web.RootFolder.Files); clientContext.ExecuteQuery(); foreach (Microsoft.SharePoint.Client.File page in clientContext.Web.RootFolder.Files) { exceptionCommentsInfo1 = "Web Url: " + clientContext.Web.Url + ", Web Part Type: " + webPartType + ", PageTitle: " + page.ServerRelativeUrl; if (Path.GetExtension(page.ServerRelativeUrl).Equals(".aspx", StringComparison.CurrentCultureIgnoreCase)) { String pageUrl = page.ServerRelativeUrl; Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage_DefaultPages] Checking for the Web Part on the Page: " + page.Name); Console.WriteLine("[GetWebPartUsage_DefaultPages] Checking for the Web Part on the Page:" + page.Name); // Requires Full Control permissions on the Web LimitedWebPartManager webPartManager = page.GetLimitedWebPartManager(PersonalizationScope.Shared); clientContext.Load(webPartManager, wpm => wpm.WebParts, wpm => wpm.WebParts.Include( wp => wp.WebPart.Hidden, wp => wp.WebPart.IsClosed, wp => wp.WebPart.Properties, wp => wp.WebPart.Subtitle, wp => wp.WebPart.Title, wp => wp.WebPart.TitleUrl, wp => wp.WebPart.ZoneIndex)); clientContext.ExecuteQuery(); foreach (WebPartDefinition webPartDefinition in webPartManager.WebParts) { Microsoft.SharePoint.Client.WebParts.WebPart webPart = webPartDefinition.WebPart; string webPartPropertiesXml = GetWebPartPropertiesServiceCall(clientContext, webPartDefinition.Id.ToString(), pageUrl); string WebPartTypeName = string.Empty; if (webPartPropertiesXml.Contains("WebPart/v2")) { XmlDataDocument xmldoc = new XmlDataDocument(); xmldoc.LoadXml(webPartPropertiesXml); WebPartTypeName = xmldoc.DocumentElement.GetElementsByTagName("TypeName").Item(0).FirstChild.Value; xmldoc = null; } else { webParts webPartProp = null; byte[] byteArray = Encoding.UTF8.GetBytes(webPartPropertiesXml); using (MemoryStream stream = new MemoryStream(byteArray)) { StreamReader streamReader = new StreamReader(stream); System.Xml.XmlReader reader = new XmlTextReader(streamReader); XmlSerializer serializer = new XmlSerializer(typeof(webParts)); webPartProp = (webParts)serializer.Deserialize(reader); WebPartTypeName = webPartProp.webPart.metaData.type.name; stream.Flush(); } byteArray = null; } string actualWebPartType = GetWebPartShortTypeName(WebPartTypeName); // only modify if we find the old web part if (actualWebPartType.Equals(webPartType)) { Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage_DefaultPages] Found WebPart: " + webPartType + " in Page: " + page.Name + ", " + page.ServerRelativeUrl); Console.WriteLine("[GetWebPartUsage_DefaultPages] Found WebPart: " + webPartType + " in Page: " + page.Name + ", " + page.ServerRelativeUrl); webPartUsageEntity = new WebPartUsageEntity(); webPartUsageEntity.PageUrl = pageUrl; webPartUsageEntity.WebPartID = webPartDefinition.Id.ToString(); webPartUsageEntity.WebURL = webUrl; webPartUsageEntity.WebPartTitle = webPart.Title; webPartUsageEntity.ZoneIndex = webPart.ZoneIndex.ToString(); webPartUsageEntity.WebPartType = actualWebPartType; FileUtility.WriteCsVintoFile(webPartUsageFileName, webPartUsageEntity, ref headerWebPart); } } } } } Console.WriteLine("[GetWebPartUsage_DefaultPages] Default Pages WebPart Usage is exported to the file " + webPartUsageFileName); Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage_DefaultPages] Default Pages WebPart Usage is exported to the file " + webPartUsageFileName); Logger.AddMessageToTraceLogFile(Constants.Logging, "[END][GetWebPartUsage_DefaultPages]"); Console.WriteLine("[END][GetWebPartUsage_DefaultPages]"); } catch (Exception ex) { ExceptionCsv.WriteException(ExceptionCsv.WebApplication, ExceptionCsv.SiteCollection, ExceptionCsv.WebUrl, "Web Part", ex.Message, ex.ToString(), "GetWebPartUsage_DefaultPages", ex.GetType().ToString(), exceptionCommentsInfo1); Logger.AddMessageToTraceLogFile(Constants.Logging, "[EXCEPTION][GetWebPartUsage_DefaultPages] Exception Message: " + ex.Message + ", Exception Comment: " + exceptionCommentsInfo1); Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("[EXCEPTION][GetWebPartUsage_DefaultPages] Exception Message: " + ex.Message); Console.ForegroundColor = ConsoleColor.Gray; } }
public void GetWebPartUsage(string webPartType, ClientContext clientContext,string outPutDirectory) { ExceptionCsv.WebUrl = clientContext.Web.Url; string exceptionCommentsInfo1 = string.Empty; string webPartUsageFileName = outPutDirectory + "\\" + Constants.WEBPART_USAGE_ENTITY_FILENAME; try { //Initialized Exception and Logger. WebPart_Initialization(outPutDirectory); string webUrl = clientContext.Web.Url; Logger.AddMessageToTraceLogFile(Constants.Logging, "############## Web Part Trasnformation Utility Execution Started ##############"); Console.WriteLine("############## Web Part Trasnformation Utility Execution Started ##############"); Logger.AddMessageToTraceLogFile(Constants.Logging, "[DATE TIME] " + Logger.CurrentDateTime()); Console.WriteLine("[DATE TIME] " + Logger.CurrentDateTime()); Logger.AddMessageToTraceLogFile(Constants.Logging, "[START][GetWebPartUsage]"); Console.WriteLine("[START][GetWebPartUsage]"); Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage] Initiated Logger and Exception Class. Logger and Exception file will be available at path: " + outPutDirectory); Console.WriteLine("[GetWebPartUsage] Initiated Logger and Exception Class. Logger and Exception file will be available at path: " + outPutDirectory); Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage] Finding WebPartUsage details for Web Part: " + webPartType + " in Web: " + webUrl); Console.WriteLine("[GetWebPartUsage] Finding WebPartUsage details for Web Part: " + webPartType + " in Web: " + webUrl); WebPartUsageEntity webPartUsageEntity = null; List<WebPartUsageEntity> webPartUsage = new List<WebPartUsageEntity>(); //Prepare Exception Comments exceptionCommentsInfo1 = "Web Url: " + clientContext.Web.Url + ", Web Part Type: " + webPartType; if (clientContext != null) { List list = GetPageList(ref clientContext); if (list != null) { var items = list.GetItems(CamlQuery.CreateAllItemsQuery()); //make sure to include the File on each Item fetched clientContext.Load(items, i => i.Include( item => item.File, item => item["EncodedAbsUrl"])); clientContext.ExecuteQuery(); // Iterate through all available pages in the pages list foreach (var item in items) { Microsoft.SharePoint.Client.File page = item.File; String pageUrl = page.ServerRelativeUrl;// item.FieldValues["EncodedAbsUrl"].ToString(); Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage] Checking for the Web Part on the Page: " + page.Name); Console.WriteLine("[GetWebPartUsage] Checking for the Web Part on the Page:" + page.Name); // Requires Full Control permissions on the Web LimitedWebPartManager webPartManager = page.GetLimitedWebPartManager(PersonalizationScope.Shared); clientContext.Load(webPartManager, wpm => wpm.WebParts, wpm => wpm.WebParts.Include( wp => wp.WebPart.Hidden, wp => wp.WebPart.IsClosed, wp => wp.WebPart.Properties, wp => wp.WebPart.Subtitle, wp => wp.WebPart.Title, wp => wp.WebPart.TitleUrl, wp => wp.WebPart.ZoneIndex)); clientContext.ExecuteQuery(); foreach (WebPartDefinition webPartDefinition in webPartManager.WebParts) { Microsoft.SharePoint.Client.WebParts.WebPart webPart = webPartDefinition.WebPart; string webPartPropertiesXml = GetWebPartPropertiesServiceCall(clientContext, webPartDefinition.Id.ToString(), pageUrl); string WebPartTypeName = string.Empty; if (webPartPropertiesXml.Contains("WebPart/v2")) { XmlDataDocument xmldoc = new XmlDataDocument(); xmldoc.LoadXml(webPartPropertiesXml); WebPartTypeName = xmldoc.DocumentElement.GetElementsByTagName("TypeName").Item(0).FirstChild.Value; xmldoc = null; } else { webParts webPartProp = null; byte[] byteArray = Encoding.UTF8.GetBytes(webPartPropertiesXml); using (MemoryStream stream = new MemoryStream(byteArray)) { StreamReader streamReader = new StreamReader(stream); System.Xml.XmlReader reader = new XmlTextReader(streamReader); XmlSerializer serializer = new XmlSerializer(typeof(webParts)); webPartProp = (webParts)serializer.Deserialize(reader); WebPartTypeName = webPartProp.webPart.metaData.type.name; stream.Flush(); } byteArray = null; } string actualWebPartType = GetWebPartShortTypeName(WebPartTypeName); // only modify if we find the old web part if (actualWebPartType.Equals(webPartType)) { Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage] Found WebPart: " + webPartType + " in Page: " + page.Name); Console.WriteLine("[GetWebPartUsage] Found WebPart: " + webPartType + " in Page: " + page.Name); webPartUsageEntity = new WebPartUsageEntity(); webPartUsageEntity.PageUrl = pageUrl; webPartUsageEntity.WebPartID = webPartDefinition.Id.ToString(); webPartUsageEntity.WebURL = webUrl; webPartUsageEntity.WebPartTitle = webPart.Title; webPartUsageEntity.ZoneIndex = webPart.ZoneIndex.ToString(); webPartUsageEntity.WebPartType = actualWebPartType; FileUtility.WriteCsVintoFile(webPartUsageFileName, webPartUsageEntity, ref headerWebPart); } } } } } //Default Pages GetWebPartUsage_DefaultPages(webPartType, clientContext, outPutDirectory); //Default Pages Console.WriteLine("[GetWebPartUsage] WebPart Usage is exported to the file " + webPartUsageFileName); Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartUsage] WebPart Usage is exported to the file " + webPartUsageFileName); Logger.AddMessageToTraceLogFile(Constants.Logging, "[END][GetWebPartUsage]"); Console.WriteLine("[END][GetWebPartUsage]"); Logger.AddMessageToTraceLogFile(Constants.Logging, "############## Web Part Trasnformation Utility Execution Completed for Web ##############"); Console.WriteLine("############## Web Part Trasnformation Utility Execution Completed for Web ##############"); } catch (Exception ex) { ExceptionCsv.WriteException(ExceptionCsv.WebApplication, ExceptionCsv.SiteCollection, ExceptionCsv.WebUrl, "Web Part", ex.Message, ex.ToString(), "GetWebPartUsage", ex.GetType().ToString(), exceptionCommentsInfo1); Logger.AddMessageToTraceLogFile(Constants.Logging, "[EXCEPTION][GetWebPartUsage] Exception Message: " + ex.Message + ", Exception Comment: " + exceptionCommentsInfo1); Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("[EXCEPTION][GetWebPartUsage] Exception Message: " + ex.Message); Console.ForegroundColor = ConsoleColor.Gray; } }
public void CreateFragmentBefore(string xmlFragment, string xPathBefore) { XmlDataDocument newDoc = new XmlDataDocument(); newDoc.LoadXml(xmlFragment); XmlNode newNode = _document.CreateDocumentFragment(); newNode.InnerXml = xmlFragment; XmlNode beforeNode = _document.SelectSingleNode(xPathBefore); if (_document.DocumentElement != null) { _document.DocumentElement.InsertBefore(newNode, beforeNode); _document.Save(XmlFilePath); } }
public System.Collections.ArrayList listUsers() { System.Collections.ArrayList list = new System.Collections.ArrayList(); string cmd = "listUsers"; ErrorCode = ERR_CODE_UNKNOWN_RESPONSE; ErrorMsg = ERR_MSG_UNKNOWN_RESPONSE; //default error message try { StringBuilder sbReq = new StringBuilder(); sbReq.Append(String.Format("{0}API?command={1}&session_id={2}", httpUri.AbsoluteUri, cmd, SessionId)); string resp = sendHTTPRequest(sbReq.ToString()); if (resp == null) return null; XmlDataDocument doc = new XmlDataDocument(); doc.LoadXml(resp); XmlElement element = doc.DocumentElement; if (element.Name == "CSL") { XmlNode node = doc.SelectSingleNode("CSL/Command"); if (node != null) { if (node.InnerXml.Equals("listUsers", StringComparison.OrdinalIgnoreCase)) { node = doc.SelectSingleNode("CSL/Account"); if (node != null) { while (node != null) { USER_INFO info = new USER_INFO(); XmlAttributeCollection atts = node.Attributes; info.username = atts.GetNamedItem("username").Value; //info.password = atts.GetNamedItem("password").Value; info.desc = atts.GetNamedItem("desc").Value; info.level = int.Parse(atts.GetNamedItem("level").Value); list.Add(info); node = node.NextSibling; } ErrorCode = ERR_CODE_NO_ERROR; ErrorMsg = ""; return list; } node = doc.SelectSingleNode("CSL/Error"); if (node != null) { //<Error> foreach (XmlAttribute att in node.Attributes) { if (att.Name.Equals("msg", StringComparison.OrdinalIgnoreCase)) { ErrorMsg = att.InnerXml.Substring(6).Trim(); } else if (att.Name.Equals("code", StringComparison.OrdinalIgnoreCase)) { Int32.TryParse(att.InnerXml, out ErrorCode); } } return null; } } } } } catch (WebException wex) { ErrorMsg = wex.Message; return null; } ErrorMsg = ERR_MSG_UNKNOWN_RESPONSE; return null; }
public void TestCreateElementAndRow () { DataSet ds = new DataSet ("set"); DataTable dt = new DataTable ("tab1"); dt.Columns.Add ("col1"); dt.Columns.Add ("col2"); ds.Tables.Add (dt); DataTable dt2 = new DataTable ("child"); dt2.Columns.Add ("ref"); dt2.Columns.Add ("val"); ds.Tables.Add (dt2); DataRelation rel = new DataRelation ("rel", dt.Columns [0], dt2.Columns [0]); rel.Nested = true; ds.Relations.Add (rel); XmlDataDocument doc = new XmlDataDocument (ds); doc.LoadXml ("<set><tab1><col1>1</col1><col2/><child><ref>1</ref><val>aaa</val></child></tab1></set>"); AssertEquals (1, ds.Tables [0].Rows.Count); AssertEquals (1, ds.Tables [1].Rows.Count); // document element - no mapped row XmlElement el = doc.DocumentElement; AssertNull (doc.GetRowFromElement (el)); // tab1 element - has mapped row el = el.FirstChild as XmlElement; DataRow row = doc.GetRowFromElement (el); AssertNotNull (row); AssertEquals (DataRowState.Added, row.RowState); // col1 - it is column. no mapped row el = el.FirstChild as XmlElement; row = doc.GetRowFromElement (el); AssertNull (row); // col2 - it is column. np mapped row el = el.NextSibling as XmlElement; row = doc.GetRowFromElement (el); AssertNull (row); // child - has mapped row el = el.NextSibling as XmlElement; row = doc.GetRowFromElement (el); AssertNotNull (row); AssertEquals (DataRowState.Added, row.RowState); // created (detached) table 1 element (used later) el = doc.CreateElement ("tab1"); row = doc.GetRowFromElement (el); AssertEquals (DataRowState.Detached, row.RowState); AssertEquals (1, dt.Rows.Count); // not added yet // adding a node before setting EnforceConstraints // raises an error try { doc.DocumentElement.AppendChild (el); Fail ("Invalid Operation should occur; EnforceConstraints prevents addition."); } catch (InvalidOperationException) { } // try again... ds.EnforceConstraints = false; AssertEquals (1, dt.Rows.Count); // not added yet doc.DocumentElement.AppendChild (el); AssertEquals (2, dt.Rows.Count); // added row = doc.GetRowFromElement (el); AssertEquals (DataRowState.Added, row.RowState); // changed // Irrelevant element XmlElement el2 = doc.CreateElement ("hoge"); row = doc.GetRowFromElement (el2); AssertNull (row); // created table 2 element (used later) el = doc.CreateElement ("child"); row = doc.GetRowFromElement (el); AssertEquals (DataRowState.Detached, row.RowState); // Adding it to irrelevant element performs no row state change. AssertEquals (1, dt2.Rows.Count); // not added yet el2.AppendChild (el); AssertEquals (1, dt2.Rows.Count); // still not added row = doc.GetRowFromElement (el); AssertEquals (DataRowState.Detached, row.RowState); // still detached here }
protected void Page_Load(object sender, System.EventArgs e) { if (Session["userid"] == null) { this.Response.Write("<script language=\"javascript\">"); this.Response.Write("alert('您未正常登录,请登录后再使用,谢谢!')"); this.Response.Write("</script>"); this.Response.Redirect("index.htm"); } SqlConnection CN = new SqlConnection(); string strsql = ""; string exectype = ""; //try //{ //初始化连接字符串 string strCn = DataAccRes.DefaultDataConnInfo.Value; CN.ConnectionString=strCn; CN.Open(); XmlDocument xmldoc = new XmlDocument(); //读取用户参数 StreamReader streamreader = new StreamReader(this.Request.InputStream, Encoding.UTF8); string strxml = streamreader.ReadToEnd(); if (string.IsNullOrEmpty(strxml)) return; xmldoc.LoadXml(strxml); if(xmldoc==null) return; XmlNodeList cmnodes = xmldoc.SelectNodes("//all/command"); XmlNodeList sqlnodes = xmldoc.SelectNodes("//all/sql"); XmlNodeList prnnodes = xmldoc.SelectNodes("//all/print"); XmlNodeList prnnames = xmldoc.SelectNodes("//all/printname"); if (cmnodes == null || sqlnodes == null) return; strsql = sqlnodes[0].InnerText; string prncmd = ""; string prnname = ""; if (prnnodes != null && prnnodes.Count>0) prncmd = prnnodes[0].InnerText; if (prnnames != null && prnnames.Count > 0) prnname = prnnames[0].InnerText; exectype = cmnodes[0].InnerText; string item = ""; if (exectype == "undefined") exectype = ""; if (exectype.IndexOf("item.") > -1) { item = exectype.Replace("item.", ""); if (Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.UnitHash.Contains(item)) { Response.Clear(); Response.ContentType = "text/xml; charset=gb2312"; Response.Expires = -1; XmlDataDocument outdoc = new XmlDataDocument(); outdoc.LoadXml(Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.UnitHash[item].ToString()); outdoc.Save(Response.OutputStream); //Response.End(); return; } } if (exectype == "cache") { Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.IsCache = true; Estar.Common.Tools.UnitItem.IsCache = true; string xmlstr = "<table>ok</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "nocache") { Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.IsCache = false; Estar.Common.Tools.UnitItem.IsCache = false; string xmlstr = "<table>ok</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "htmlfiles") { string[] files = Directory.GetFiles(System.Web.HttpContext.Current.Request.MapPath("html")); string strs = ""; for (int i = 0; i < files.Length; i++) { string s1 = files[i].ToLower(); FileInfo fileinfo = new FileInfo(s1); strs = strs + "," + fileinfo.Name; } strs = strs.Substring(1, strs.Length - 1); string xmlstr = "<table>"+strs+"</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "prnfiles") { string[] files = Directory.GetFiles(System.Web.HttpContext.Current.Request.MapPath("DataSource\\ExcelTemplate")); string strs = ""; for (int i = 0; i < files.Length; i++) { string s1 = files[i].ToLower(); FileInfo fileinfo = new FileInfo(s1); strs = strs + "," + fileinfo.Name; } strs = strs.Substring(1, strs.Length - 1); string xmlstr = "<table>" + strs + "</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "iconfiles") { string[] files = Directory.GetFiles(System.Web.HttpContext.Current.Request.MapPath("html\\Images")); string strs = ""; for (int i = 0; i < files.Length; i++) { string s1 = files[i].ToLower(); FileInfo fileinfo = new FileInfo(s1); strs = strs + "," + fileinfo.Name; } strs = strs.Substring(1, strs.Length - 1); string xmlstr = "<table>" + strs + "</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "1") { strsql = strsql.Replace("\r\n", " "); SqlCommand command = new SqlCommand(strsql, CN); command.ExecuteNonQuery(); if (CN.State == ConnectionState.Open) CN.Close(); string xmlstr = "<table>ok</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "xml") { strsql = sqlnodes[0].InnerXml; SqlCommand command = new SqlCommand(strsql, CN); command.ExecuteNonQuery(); if (CN.State == ConnectionState.Open) CN.Close(); string xmlstr = "<table>ok</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } DataSet ds = new DataSet(); SqlDataAdapter adp; if (strsql.ToLower().IndexOf("select ") < 0 && strsql.ToLower().IndexOf("exec ") < 0 && strsql.ToLower().IndexOf("execute ") < 0) { //按数据源方式 QueryDataRes query = new QueryDataRes(); NameObjectList paramlist = null; query.FillDataSet(strsql, paramlist, ds); if(ds.Tables!=null && ds.Tables.Count>0) ds.Tables[0].TableName = "table"; } else { adp = new SqlDataAdapter(strsql, CN); adp.Fill(ds,"table"); } if (prncmd == "prn") { string SourceFile = prnname; string TemplatePath = this.Server.MapPath(DataAccRes.AppSettings("TpFilePath")); //存放源文件的文件夹路径。 string SrcFile = TemplatePath + "\\" + SourceFile; //源文件名称 string DestFile = "print.XLS"; if (!File.Exists(SrcFile) == true) { if (!File.Exists(SrcFile) == true) { string strMSG = "打印模板 [" + SourceFile + "] 不存在,请联系系统管理员建立打印模板!"; this.Response.Write("<script language=\"javascript\">"); this.Response.Write("alert('" + strMSG + "')"); this.Response.Write("</script>"); return; } } DataTable tab = ds.Tables[0]; XmlDocument xmlPrintDoc = csPrintData.makeprint(null, null, SourceFile, DestFile, tab, tab, 0, this.Session["userid"].ToString(), null); //csPrintData.outXML2ExcelDown(xmlPrintDoc, SourceFile,null); //csPrintData.outXML2Excel(xmlPrintDoc, SourceFile); //System.Web.HttpContext.Current.Response.Write("<script language='javascript'>window.open('" + xmlPrintDoc + "')</script>"); return; } string colnames = ""; string datatypes = ""; string datalens = ""; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { colnames = colnames + "," + ds.Tables[0].Columns[i].ColumnName; datatypes = datatypes + "," + ds.Tables[0].Columns[i].DataType.ToString(); datalens = datalens + "," + ds.Tables[0].Columns[i].MaxLength.ToString(); } string tablename = ds.Tables[0].TableName; colnames = colnames.Substring(1, colnames.Length - 1); datatypes = datatypes.Substring(1, datatypes.Length - 1); datalens = datalens.Substring(1, datalens.Length - 1); DataTable tbl = ds.Tables.Add("xstructs"); DataColumn col0 = tbl.Columns.Add("name"); DataColumn col1 = tbl.Columns.Add("datatype"); DataColumn col2 = tbl.Columns.Add("len"); DataRow row = ds.Tables["xstructs"].NewRow(); row["name"] = colnames; row["datatype"] = datatypes.Replace("System.", ""); row["len"] = datalens; ds.Tables["xstructs"].Rows.Add(row); Response.Clear(); Response.ContentType = "text/xml; charset=gb2312"; Response.Expires = -1; XmlDataDocument outdoc1 = new XmlDataDocument(ds); outdoc1.Save(Response.OutputStream); if (item != "" && Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.IsCache == true) { Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.UnitHash.Add(item, outdoc1.InnerXml); } //Response.Write("<?xml version='1.0' encoding='GB2312'?>"); //Response.Write(ds.GetXml().ToString()); //Response.End(); if (CN.State == ConnectionState.Open) CN.Close(); //} //catch (Exception ex) //{ // if (CN.State == ConnectionState.Open) CN.Close(); // this.Response.Write(""); // NameValueCollection errInfo = new NameValueCollection(); // errInfo["数据源"] = strsql; // errInfo["操作类型"] = exectype; // ExceptionManager.Publish(ex, errInfo); //} //finally //{ }
public void UpdateTabaLayerDef(string QXml) { try { XmlDataDocument pXml = new XmlDataDocument(); QXml = QXml.Replace("Join1", "Join"); pXml.LoadXml(QXml); XmlNode pRule = pXml.GetElementsByTagName("VectorScaleRange")[0].Clone(); this.LayerDefXml.GetElementsByTagName("VectorLayerDefinition")[0].AppendChild(this.LayerDefXml.ImportNode(pRule, true)); this.LayerDefXmlString = this.LayerDefXml.OuterXml; this.layerDefContent = new MgByteSource(Encoding.UTF8.GetBytes(this.LayerDefXml.OuterXml), this.LayerDefXml.OuterXml.Length).GetReader(); } catch { } }
/// <summary> /// /// </summary> /// <param name="soft"></param> public override void Build(CommuniSoft soft) { System.Collections.Hashtable idStationMap = new System.Collections.Hashtable(); // build station // foreach (DataRow stationDR in _stationDataTable.Rows) { bool isStationDeleted = false; if (stationDR["Deleted"] != DBNull.Value) { isStationDeleted = Convert.ToBoolean(stationDR["Deleted"]); } if (!isStationDeleted) { string stationName = stationDR["Name"].ToString(); bool isExistStation = soft.HardwareManager.Stations.ExistName(stationName, null); if (!isExistStation) { string xml = stationDR["CommuniTypeContent"].ToString().Trim(); if (xml.Length == 0) { // TODO: 2010-09-17 // log error info // continue; } int stationID = (int)stationDR["StationID"]; XmlDataDocument doc = new XmlDataDocument(); doc.LoadXml(xml); XmlNode node = doc.SelectSingleNode("socketcommunitype"); CommuniType communiType = Xdgk.Communi.XmlBuilder.XmlSocketCommuniBuilder.Build(node); Station station = new Station(stationName, communiType); station.ID = stationID; idStationMap.Add(stationID, station); soft.HardwareManager.Stations.Add(station); } } } // build device // foreach (DataRow deviceDR in _deviceDataTable.Rows) { bool isDeviceDeleted = false; if (deviceDR["deleted"] != DBNull.Value) { isDeviceDeleted = Convert.ToBoolean(deviceDR["Deleted"]); } if (isDeviceDeleted) { continue; } int stationID = (int)deviceDR["StationID"]; int deviceID = (int)deviceDR["DeviceID"]; string deviceType = deviceDR["DeviceType"].ToString(); string addressString = deviceDR["Address"].ToString().Trim(); if (addressString.Length == 0) continue; int address = Convert.ToInt32(addressString); Station st = idStationMap[stationID] as Station; if (st == null) { continue; } //DeviceDefine dd = soft.DeviceDefineCollection.FindDeviceDefine(deviceType); DeviceDefine dd = soft.DeviceDefineManager.DeviceDefineCollection.FindDeviceDefine(deviceType); if (dd == null) { bool exist = soft.UnDefineDeviceType.Exist(deviceType); if (!exist) { soft.UnDefineDeviceType.Add(deviceType); string msg = string.Format(strings.UnDefineDeviceType, deviceType); NUnit.UiKit.UserMessage.Display(msg); } continue; } //Xdgk.Communi.Device device = new Device(dd, "", address); Xdgk.Communi.Device device = DeviceFactory.Create(dd, "", address); //Xdgk.Communi.Device device = new Device(deviceType, address); //string t = soft.OperaFactory.DeviceDefineCollection.GetDeviceText(deviceType); //device.Text = t; device.ID = deviceID; //Station st = soft.HardwareManager.GetStation(stationName); st.Devices.Add(device); } // // StationCollection rainStations = this.CreateRainStations(soft); foreach ( Station item in rainStations ) { soft.HardwareManager.Stations.Add(item); } }
private bool RequestDirectBill(string page, byte[] data, string billNo) { bool bolRequest = false; string strURL = string.Empty; // 다이렉트빌 주소 (http://test.directbill.co.kr:8080) string response = string.Empty; // 받는값 //string postData = string.Empty; // 전송데이터 string msg = string.Empty; // 받는메시지 string xSQL = string.Empty; SAPbobsCOM.Recordset oRS; try { // URL을 조회한다. //strURL = CFL.GetValue("SELECT U_DTIIP FROM [@KIS_VT0010M]"); // Prepare web request... HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(Info.URL_IP + page + "?"); myRequest.Method = "POST"; myRequest.ContentType = "application/x-www-form-urlencoded; charset=utf-8"; myRequest.ContentLength = data.Length; //Stream byte[] 방식 Stream newStream = myRequest.GetRequestStream(); newStream.Write(data, 0, data.Length); newStream.Close(); HttpWebResponse WebResp = (HttpWebResponse)myRequest.GetResponse(); Stream Answer = WebResp.GetResponseStream(); StreamReader _Answer = new StreamReader(Answer); response = _Answer.ReadToEnd(); // 리턴값 XML로 변환 XmlDataDocument retXml = new XmlDataDocument(); retXml.LoadXml(response.ToString()); if (retXml.GetElementsByTagName("RET").Item(0).InnerText == "OK") { XmlNodeList Nodes = retXml.GetElementsByTagName("COLUMN"); if (Nodes != null) { foreach (XmlNode anode in Nodes) { //신청번호 if (anode.Attributes.GetNamedItem("NAME").Value == "sinch_no") { //txtSinChNo.Text = anode.InnerText; //sinchNo = anode.InnerText; Info.ShinChongNo = anode.InnerText; } // 서비스키 else if (anode.Attributes.GetNamedItem("NAME").Value == "svc_key") { //txtSeviceNo.Text = anode.InnerText; //serviceKey = anode.InnerText; Info.ServiceKey = anode.InnerText; } // 전송하고 문서키를 받아서 Update 한다. else if (anode.Attributes.GetNamedItem("NAME").Value == "dockey") { //txtSeviceNo.Text = anode.InnerText; oRS = (SAPbobsCOM.Recordset)B1Connections.diCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); xSQL = " UPDATE [@KIS_SO0230T_HRD] SET U_DTINO = '" + anode.InnerText + "' , U_SANDSTAT = 'SY', U_TRANDATE = GETDATE() WHERE ISNULL(U_DTINO,'') = '' AND U_BILLNO = '" + billNo + "'"; oRS.DoQuery(xSQL); } } } bolRequest = true; } else { msg = retXml.GetElementsByTagName("MSG").Item(0).InnerText; B1Connections.theAppl.StatusBar.SetText("RequestDirectBill " + msg, SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Error); bolRequest = false; } return bolRequest; } catch (Exception) { throw; } }
public bool LoadConfig(string strConfigFilename) { try { m_xmlConfig = new XmlDataDocument(); m_xmlConfig.Load(strConfigFilename); //m_xmlConfig.Save(Console.Out); m_bInitialised = true; return true; } catch //(Exception ex1) { try { m_xmlConfig = new XmlDataDocument(); m_xmlConfig.LoadXml(SkeletonFile); SaveConfig(strConfigFilename); m_bInitialised = true; return true; } catch (Exception ex2) { Console.WriteLine(ex2.Message); m_bInitialised = false; return false; } } }
static internal Dictionary<ulong, object> ReadDataID() { string filePath = Path.Combine(Path.GetDirectoryName(typeof(GXDLT645Property).Assembly.Location), "DLTProperties.xml"); XmlDataDocument myXmlDocument = new XmlDataDocument(); if (!File.Exists(filePath)) { myXmlDocument.LoadXml(Gurux.DLT645.AddIn.Properties.Resources.DLTProperties); try { using (XmlTextWriter writer = new XmlTextWriter(filePath, Encoding.Default)) { myXmlDocument.Save(writer); writer.Close(); } } catch (System.IO.IOException) { //This is probably due to insufficient file access rights. } } else { myXmlDocument.Load(filePath); } Dictionary<ulong, object> items = new Dictionary<ulong, object>(); foreach (XmlNode parentNode in myXmlDocument.DocumentElement.ChildNodes) { if (parentNode.Name == "Properties") { GetProperties(items, parentNode); } else if (parentNode.Name == "Tables") { foreach (XmlNode table in parentNode.ChildNodes) { GXDLT645TableTemplate item = new GXDLT645TableTemplate(table.Attributes["Name"].Value); items.Add(Convert.ToUInt64(table.Attributes["ID"].Value, 16), item); foreach (XmlNode prop in parentNode.ChildNodes) { GetColumns(item, prop); } } } } return items; }
public void TestLoadXml () { XmlDataDocument doc = new XmlDataDocument (); doc.LoadXml ("<NewDataSet><TestTable><TestRow><TestColumn>1</TestColumn></TestRow></TestTable></NewDataSet>"); doc = new XmlDataDocument (); doc.LoadXml ("<test>value</test>"); }
// bug #54505 public void TypedDataDocument () { string xml = @"<top xmlns=""urn:test""> <foo> <s>first</s> <d>2004-02-14T10:37:03</d> </foo> <foo> <s>second</s> <d>2004-02-17T12:41:49</d> </foo> </top>"; string xmlschema = @"<xs:schema id=""webstore"" targetNamespace=""urn:test"" xmlns:xs=""http://www.w3.org/2001/XMLSchema""> <xs:element name=""top""> <xs:complexType> <xs:sequence maxOccurs=""unbounded""> <xs:element name=""foo""> <xs:complexType> <xs:sequence maxOccurs=""unbounded""> <xs:element name=""s"" type=""xs:string""/> <xs:element name=""d"" type=""xs:dateTime""/> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:schema>"; XmlDataDocument doc = new XmlDataDocument (); doc.DataSet.ReadXmlSchema (new StringReader (xmlschema)); doc.LoadXml (xml); DataTable foo = doc.DataSet.Tables ["foo"]; DataRow newRow = foo.NewRow (); newRow ["s"] = "new"; newRow ["d"] = DateTime.Now; foo.Rows.Add (newRow); doc.Save (new StringWriter ()); }
private XmlDataDocument buildXmlDoc(XmlDataDocument xmldata) { XmlDataDocument xmldoc = new XmlDataDocument(); //建立数据xml结构 //xmldoc.LoadXml("<XML><etpTemplate_" + this.workitem.TempId + "_xmlland><" + this.unitItem.UnitName + ">" + ((System.Xml.XmlDocument)(xmldata)).DocumentElement.InnerXml + "</" + this.unitItem.UnitName + "></etpTemplate_" + this.workitem.TempId + "_xmlland></XML>"); xmldoc.LoadXml("<XML><etpTemplate_" + this.workitem.TempId + "_xmlland>" + ((System.Xml.XmlDocument)(xmldata)).DocumentElement.InnerXml + "</etpTemplate_" + this.workitem.TempId + "_xmlland></XML>"); XmlAttribute xmlAtt = xmldoc.DocumentElement.Attributes.Append(xmldoc.CreateAttribute("id")); xmlAtt.Value = this.workitem.TempId; xmlAtt = xmldoc.DocumentElement.Attributes.Append(xmldoc.CreateAttribute("itemname")); xmlAtt.Value = this.workitem.ItemName; xmlAtt = xmldoc.DocumentElement.Attributes.Append(xmldoc.CreateAttribute("typexml")); xmlAtt.Value = "Data"; return xmldoc; }
public System.Collections.ArrayList getTagDataAllBanks() { System.Collections.ArrayList tags = new System.Collections.ArrayList(); try { StringBuilder sbReq = new StringBuilder(); sbReq.Append(String.Format("{0}API?command=getCaptureTagsRaw&mode=getAllBanks&session_id={1}", httpUri.AbsoluteUri, SessionId)); string resp = sendHTTPRequest(sbReq.ToString()); if (resp == null) return null; XmlDataDocument doc = new XmlDataDocument(); doc.LoadXml(resp); XmlElement element = doc.DocumentElement; if (element.Name == "CSL") { XmlNode node = doc.SelectSingleNode("CSL/Command"); if (node != null) { if (node.InnerXml.Equals("getcapturetagsraw", StringComparison.OrdinalIgnoreCase)) { node = doc.SelectSingleNode("CSL/TagList/tagAllBanks"); if (node != null) { //<Ack> TAG_MULTI_BANKS tag; while (node != null) { tag = new TAG_MULTI_BANKS(); foreach (XmlAttribute att in node.Attributes) { if (att.Name.Equals("capturepoint_id", StringComparison.OrdinalIgnoreCase)) { tag.CapturePointId = att.InnerXml.Trim(); } else if (att.Name.Equals("freq", StringComparison.OrdinalIgnoreCase)) { if (att.InnerXml != null) { double d; if (double.TryParse(att.InnerXml, out d)) { tag.Frequency = d * 0.05 + 860.0; } } } else if (att.Name.Equals("index", StringComparison.OrdinalIgnoreCase)) { tag.Index = att.InnerXml.Trim(); } else if (att.Name.Equals("rssi", StringComparison.OrdinalIgnoreCase)) { if (att.InnerXml != null) { double d; double.TryParse(att.InnerXml, out d); } } else if (att.Name.Equals("bank1", StringComparison.OrdinalIgnoreCase)) { tag.EPC = att.InnerXml.Trim().Substring(8); } else if (att.Name.Equals("bank2", StringComparison.OrdinalIgnoreCase)) { tag.TID = att.InnerXml.Trim(); } else if (att.Name.Equals("bank3", StringComparison.OrdinalIgnoreCase)) { tag.UserMemory = att.InnerXml.Trim(); } else if (att.Name.Equals("time", StringComparison.OrdinalIgnoreCase)) { int.TryParse(att.InnerXml, out tag.Time); } } tag.ApiTimeStampUTC = DateTime.UtcNow; tags.Add(tag); node = node.NextSibling; } ErrorCode = ERR_CODE_NO_ERROR; ErrorMsg = ""; return tags; } node = doc.SelectSingleNode("CSL/Error"); if (node != null) { //<Error> foreach (XmlAttribute att in node.Attributes) { if (att.Name.Equals("msg", StringComparison.OrdinalIgnoreCase)) { ErrorMsg = att.InnerXml.Substring(6).Trim(); } else if (att.Name.Equals("code", StringComparison.OrdinalIgnoreCase)) { Int32.TryParse(att.InnerXml, out ErrorCode); } } return null; } } } } } catch (WebException wex) { ErrorMsg = wex.Message; return null; } ErrorMsg = "Invalid isOnline response."; return null; }
// load background map from wms private void photoButton_Click(object sender, EventArgs e) { toolBuilder.addHeader("Background WMS", false); // textbox for wms-server TextBox server = toolBuilder.addTextboxWithCaption("WMS Server", "http://wms.geonorge.no/skwms1/wms.kartdata2"); // button for fetching available layers Button connectButton = toolBuilder.addButton("Get layers"); toolBuilder.addLabel("Layers"); // dropdown for available layers ComboBox wmsLayers = new ComboBox(); toolBuilder.addControl(wmsLayers); wmsLayers.DropDownStyle = ComboBoxStyle.DropDownList; // label for errors toolBuilder.addErrorLabel(); // label for loading selected layer from wms Button loadButton = toolBuilder.addButton("Load"); // button for clearing all loaded wms maps Button clearButton = toolBuilder.addButton("Clear"); connectButton.Click += (o, e2) => { // init progress bar progressLabel.Text = "Loading layers"; progressBar.Style = ProgressBarStyle.Marquee; XmlNodeList xmlnodes = null; // perform connection in worker thread BackgroundWorker bw = new BackgroundWorker(); bw.DoWork += (object wsender, DoWorkEventArgs we) => { // create url var par = "REQUEST=GetCapabilities&VERSION=1.1.1&service=WMS&format=text/xml"; if (!server.Text.EndsWith("?")) server.Text += "?"; var url = server.Text + par; var capab = ""; try { // get response from url var request = System.Net.WebRequest.Create(url); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { capab = new StreamReader(stream).ReadToEnd(); } } // handle errors catch (WebException ex) { if (ex.Status == WebExceptionStatus.ProtocolError) { var response = ex.Response as HttpWebResponse; if (response != null) { int errorNum = (int)response.StatusCode; if (errorNum == 504) { we.Result = "Server Timeout"; return; } we.Result = "Http Error " + errorNum; } } we.Result = "Server Error"; return; } catch (Exception ex) { we.Result = "Server Error"; return; } // parse response as xml document XmlDataDocument xmldoc = new XmlDataDocument(); xmldoc.LoadXml(capab); xmlnodes = xmldoc.GetElementsByTagName("Name"); }; bw.RunWorkerCompleted += (object wsender, RunWorkerCompletedEventArgs we) => { // add available layers to dropdown wmsLayers.Items.Clear(); if (xmlnodes != null) { foreach (XmlNode n in xmlnodes) if (n.ParentNode.Name == "Layer") wmsLayers.Items.Add(n.InnerText); if (wmsLayers.Items.Count > 0) wmsLayers.SelectedIndex = 0; toolBuilder.setError(""); } else toolBuilder.setError((string)we.Result); // reset progress bar progressLabel.Text = ""; progressBar.Style = ProgressBarStyle.Continuous; }; bw.RunWorkerAsync(); }; loadButton.Click += (o, e2) => { // create url request var d = CultureInfo.InvariantCulture; var b = ScreenManager.RealWindowsRect; var sb = ScreenManager.MapRealToScreen(b); var bbox = "BBOX=" + b.MinX.ToString(d) + "," + b.MinY.ToString(d) + "," + b.MaxX.ToString(d) + "," + b.MaxY.ToString(d) + "&WIDTH=" + sb.Width.ToString(d) + "&HEIGHT=" + sb.Height.ToString(d)+"&"; var srs = "SRS=EPSG:32633&"; var par = "STYLES=&FORMAT=image/png&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&"; if (wmsLayers.SelectedIndex == -1) { toolBuilder.setError("Select layer"); return; } var layerString = "LAYERS=" + wmsLayers.SelectedItem + "&"; if (!server.Text.EndsWith("?")) server.Text += "?"; var url = server.Text + layerString + par + srs + bbox; Photo p = null; // init progress bar progressLabel.Text = "Loading map"; progressBar.Style = ProgressBarStyle.Marquee; // peform loading in worker thread BackgroundWorker bw = new BackgroundWorker(); bw.DoWork += (object wsender, DoWorkEventArgs we) => { // try loading bitmap from url response try { var request = System.Net.WebRequest.Create(url); using (var response = request.GetResponse()) { using (var stream = response.GetResponseStream()) { p = new Photo(Bitmap.FromStream(stream), b); } } } // handle errors catch (WebException ex) { p = null; if (ex.Status == WebExceptionStatus.ProtocolError) { var response = ex.Response as HttpWebResponse; if (response != null) { int errorNum = (int)response.StatusCode; if(errorNum == 504) { we.Result = "Server Timeout"; return; } we.Result = "Http Error " + errorNum; } } we.Result = "Server Error"; return; } catch (Exception ex) { p = null; we.Result = "Server Error"; return; } }; bw.RunWorkerCompleted += (object wsender, RunWorkerCompletedEventArgs we) => { // update map if loading went ok if (p != null) { photos.Add(p); redraw(); toolBuilder.setError(""); } else toolBuilder.setError((string) we.Result); // reset progress bar progressLabel.Text = ""; progressBar.Style = ProgressBarStyle.Continuous; }; bw.RunWorkerAsync(); }; // clear loaded maps clearButton.Click += (o, e2) => { photos.Clear(); redraw(); }; toolBuilder.reset(); }
public void DecodeXml(string xml) { XmlDataDocument myXml = new XmlDataDocument(); Items.Clear(); myXml.LoadXml(xml); DecodeXML(myXml); }
public static void GetWebPartUsage(string webPartType, string webUrl, string outPutDirectory) { string exceptionCommentsInfo1 = string.Empty; ClientContext clientContext = null; bool headerWebPart = false; Web web = null; bool isfound = false; string webPartUsageFileName = outPutDirectory + "\\" + Constants.WEBPART_USAGE_ENTITY_FILENAME + timeStamp + Constants.CSVExtension; try { Logger.LogInfoMessage("[GetWebPartUsage] Finding WebPartUsage details for Web Part: " + webPartType + " in Web: " + webUrl); using (ClientContext userContext = Helper.CreateAuthenticatedUserContext(Program.AdminDomain, Program.AdminUsername, Program.AdminPassword, webUrl)) { web = userContext.Web; userContext.Load(web); userContext.ExecuteQuery(); clientContext = userContext; WebPartUsageEntity webPartUsageEntity = null; List<WebPartUsageEntity> webPartUsage = new List<WebPartUsageEntity>(); //Prepare Exception Comments exceptionCommentsInfo1 = "Web Url: " + clientContext.Web.Url + ", Web Part Type: " + webPartType; if (clientContext != null) { List list = AddWebPart.GetPageList(ref clientContext); if (list != null) { var items = list.GetItems(CamlQuery.CreateAllItemsQuery()); //make sure to include the File on each Item fetched clientContext.Load(items, i => i.Include( item => item.File, item => item["EncodedAbsUrl"])); clientContext.ExecuteQuery(); // Iterate through all available pages in the pages list foreach (var item in items) { try { Microsoft.SharePoint.Client.File page = item.File; String pageUrl = page.ServerRelativeUrl;// item.FieldValues["EncodedAbsUrl"].ToString(); Logger.LogInfoMessage("[GetWebPartUsage] Checking for the Web Part on the Page: " + page.Name); // Requires Full Control permissions on the Web LimitedWebPartManager webPartManager = page.GetLimitedWebPartManager(PersonalizationScope.Shared); clientContext.Load(webPartManager, wpm => wpm.WebParts, wpm => wpm.WebParts.Include( wp => wp.WebPart.Hidden, wp => wp.WebPart.IsClosed, wp => wp.WebPart.Properties, wp => wp.WebPart.Subtitle, wp => wp.WebPart.Title, wp => wp.WebPart.TitleUrl, wp => wp.WebPart.ZoneIndex)); clientContext.ExecuteQuery(); foreach (WebPartDefinition webPartDefinition in webPartManager.WebParts) { Microsoft.SharePoint.Client.WebParts.WebPart webPart = webPartDefinition.WebPart; string webPartPropertiesXml = GetWebPartPropertiesServiceCall(clientContext, webPartDefinition.Id.ToString(), pageUrl); string WebPartTypeName = string.Empty; if (webPartPropertiesXml.Contains("WebPart/v2")) { XmlDataDocument xmldoc = new XmlDataDocument(); xmldoc.LoadXml(webPartPropertiesXml); WebPartTypeName = xmldoc.DocumentElement.GetElementsByTagName("TypeName").Item(0).FirstChild.Value; xmldoc = null; } else { webParts webPartProp = null; byte[] byteArray = Encoding.UTF8.GetBytes(webPartPropertiesXml); using (MemoryStream stream = new MemoryStream(byteArray)) { StreamReader streamReader = new StreamReader(stream); System.Xml.XmlReader reader = new XmlTextReader(streamReader); XmlSerializer serializer = new XmlSerializer(typeof(webParts)); webPartProp = (webParts)serializer.Deserialize(reader); WebPartTypeName = webPartProp.webPart.metaData.type.name; stream.Flush(); } byteArray = null; } string actualWebPartType = AddWebPart.GetWebPartShortTypeName(WebPartTypeName); // only modify if we find the old web part if (actualWebPartType.Equals(webPartType, StringComparison.CurrentCultureIgnoreCase)) { Logger.LogInfoMessage("[GetWebPartUsage] Found WebPart: " + webPartType + " in Page: " + page.Name); webPartUsageEntity = new WebPartUsageEntity(); webPartUsageEntity.PageUrl = pageUrl; webPartUsageEntity.WebPartID = webPartDefinition.Id.ToString(); webPartUsageEntity.WebURL = webUrl; webPartUsageEntity.WebPartTitle = webPart.Title; webPartUsageEntity.ZoneIndex = webPart.ZoneIndex.ToString(); webPartUsageEntity.WebPartType = actualWebPartType; FileUtility.WriteCsVintoFile(webPartUsageFileName, webPartUsageEntity, ref headerWebPart); isfound = true; } } } catch (Exception ex) { ExceptionCsv.WriteException(Constants.NotApplicable, Constants.NotApplicable, webUrl, "WebPartUsage", ex.Message, ex.ToString(), "GetWebPartUsage()", ex.GetType().ToString(), exceptionCommentsInfo1); Logger.LogErrorMessage("[GetWebPartUsage] Exception Message: " + ex.Message + ", Exception Comment: " + exceptionCommentsInfo1); System.Console.ForegroundColor = System.ConsoleColor.Red; Logger.LogErrorMessage("[GetWebPartUsage] Exception Message: " + ex.Message); System.Console.ResetColor(); } } } } //Default Pages GetWebPartUsage_DefaultPages(webPartType, clientContext, outPutDirectory); //Default Pages if (isfound) Logger.LogSuccessMessage("[GetWebPartUsage] WebPart Usage is exported to the file " + webPartUsageFileName, true); } } catch (Exception ex) { ExceptionCsv.WriteException(Constants.NotApplicable, Constants.NotApplicable, webUrl, "WebPartUsage", ex.Message, ex.ToString(), "GetWebPartUsage()", ex.GetType().ToString(), exceptionCommentsInfo1); Logger.LogErrorMessage("[GetWebPartUsage] Exception Message: " + ex.Message + ", Exception Comment: " + exceptionCommentsInfo1); System.Console.ForegroundColor = System.ConsoleColor.Red; Logger.LogErrorMessage("[GetWebPartUsage] Exception Message: " + ex.Message); System.Console.ResetColor(); } }
public XmlDataDocument GetXML(bool useOuter) { try { logger.Debug("GetXML begin useOuter=" + useOuter.ToString()); if (this.m_DataSet != null) { // Use the XmlDataDocument to write your dataset instead of DataSet System.Xml.XmlDataDocument xmlDocument = new XmlDataDocument(); xmlDocument.LoadXml(this.m_DataSet.GetXml()); System.Xml.XmlDataDocument xmlDocument2 = new XmlDataDocument(); if (useOuter) { xmlDocument2.LoadXml(xmlDocument.InnerXml); if (xmlDocument2.DocumentElement.Name == "BOXES") { XmlNodeList boxList = xmlDocument2.GetElementsByTagName("BOX"); foreach (XmlNode boxNode in boxList) { for (int i = 0; i < 3; i++) { //XmlNode head = boxNode.SelectSingleNode("CONFIG_ID_NUMBER"); XmlNode head = boxNode.ChildNodes[77]; boxNode.RemoveChild(head); boxNode.InsertBefore(head, boxNode.SelectSingleNode("UDF_BOX")); } } } else if (xmlDocument2.DocumentElement.Name == "PALLETS") { XmlNodeList boxList = xmlDocument2.GetElementsByTagName("BOX"); if (boxList.Count>0) { foreach (XmlNode boxNode in boxList) { for (int i = 0; i < 3;i++) { //XmlNode head = boxNode.SelectSingleNode("CONFIG_ID_NUMBER"); Pallet B XmlNode head = boxNode.ChildNodes[2]; boxNode.RemoveChild(head); boxNode.InsertAfter(head, boxNode.LastChild); } } } } } else { //is packing list xmlDocument2.LoadXml(xmlDocument.ChildNodes[0].InnerXml); if (xmlDocument2.ChildNodes[0].Name == "PACK_ID") { XmlNodeList boxList = xmlDocument2.GetElementsByTagName("BOX"); foreach (XmlNode boxNode in boxList) { if (boxNode.ChildNodes.Count >= 6) { //if we have more than 5 child, more than 0 serial num //for (int i = 5; i < boxNode.ChildNodes.Count; i++) for (int i = 5; i < 6; i++) { //XmlNode head = boxNode.SelectSingleNode("UDF_BOX"); XmlNode serialNumNode = boxNode.ChildNodes[i]; boxNode.RemoveChild(serialNumNode); boxNode.InsertAfter(serialNumNode, boxNode.ChildNodes[0]); } //---------- for smart PC test 20100429------------------- /* for (int i = 1; i < 4; i++) { XmlNode serialNumNode = boxNode.ChildNodes[i]; boxNode.RemoveChild(serialNumNode); boxNode.InsertAfter(serialNumNode, boxNode.SelectSingleNode("SERIAL_NUM")); }*/ } } } else if (xmlDocument2.ChildNodes[0].Name == "TRUCK") { XmlNodeList boxList = xmlDocument2.GetElementsByTagName("BOXES"); if (boxList.Count > 0) { foreach (XmlNode boxNode in boxList) { for (int i = 0; i < 3; i++) { //XmlNode head = boxNode.SelectSingleNode("CONFIG_ID_NUMBER"); Pallet B XmlNode head = boxNode.ChildNodes[2]; boxNode.RemoveChild(head); boxNode.InsertAfter(head, boxNode.LastChild); } } } } } return xmlDocument2; } return null; } catch (Exception ex) { logger.Error("GetXML exception: " + ex.Message + Environment.NewLine + ex.StackTrace); #if DEBUG m_Nlogger.Info(string.Format("{0} \n\t {1}", "WriteXml", ex.Message)); #endif throw; } finally { logger.Debug("GetXML end useOuter=" + useOuter.ToString()); } return null; }
public void GetWebPartsByWeb(string WebUrl, string outPutDirectory, string SharePointOnline_OR_OnPremise = "N/A", string UserName = "******", string Password = "******", string Domain = "N/A") { ClientContext clientContext = new ClientContext(WebUrl); AuthenticationHelper ObjAuth = new AuthenticationHelper(); //SharePoint on-premises / SharePoint Online Dedicated => OP (On-Premises) if (SharePointOnline_OR_OnPremise.ToUpper().Equals(Constants.OnPremise.ToUpper())) { Logger.AddMessageToTraceLogFile(Constants.Logging, "[START][GetWebPartsByWeb] GetNetworkCredentialAuthenticatedContext for WebUrl: " + WebUrl); clientContext = ObjAuth.GetNetworkCredentialAuthenticatedContext(WebUrl, UserName, Password, Domain); Logger.AddMessageToTraceLogFile(Constants.Logging, "[END][GetWebPartsByWeb] GetNetworkCredentialAuthenticatedContext for WebUrl: " + WebUrl); } //SharePointOnline => OL (Online) else if (SharePointOnline_OR_OnPremise.ToUpper().Equals(Constants.Online.ToUpper())) { Logger.AddMessageToTraceLogFile(Constants.Logging, "[START][GetWebPartsByWeb] GetSharePointOnlineAuthenticatedContextTenant for WebUrl: " + WebUrl); clientContext = ObjAuth.GetSharePointOnlineAuthenticatedContextTenant(WebUrl, UserName, Password); Logger.AddMessageToTraceLogFile(Constants.Logging, "[END][GetWebPartsByWeb] GetSharePointOnlineAuthenticatedContextTenant for WebUrl: " + WebUrl); } if (clientContext != null) { clientContext.Load(clientContext.Web); clientContext.ExecuteQuery(); ExceptionCsv.WebUrl = clientContext.Web.Url; string exceptionCommentsInfo1 = string.Empty; string webPartInfoFileName = outPutDirectory + "\\" + "WebParts.csv"; try { //Initialized Exception and Logger. WebPart_Initialization(outPutDirectory); //Deleted the Web Part Usage File DeleteUsageFiles_WebPartHelper(outPutDirectory, "WebParts.csv"); string webUrl = clientContext.Web.Url; Logger.AddMessageToTraceLogFile(Constants.Logging, "############## Web Part Trasnformation Utility Execution Started ##############"); Console.WriteLine("############## Web Part Trasnformation Utility Execution Started ##############"); Logger.AddMessageToTraceLogFile(Constants.Logging, "[DATE TIME] " + Logger.CurrentDateTime()); Console.WriteLine("[DATE TIME] " + Logger.CurrentDateTime()); Logger.AddMessageToTraceLogFile(Constants.Logging, "[START][GetWebPartsByWeb]"); Console.WriteLine("[START][GetWebPartsByWeb]"); Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartsByWeb] Initiated Logger and Exception Class. Logger and Exception file will be available at path: " + outPutDirectory); Console.WriteLine("[GetWebPartsByWeb] Initiated Logger and Exception Class. Logger and Exception file will be available at path: " + outPutDirectory); WebPartInfo webPartInfo = null; List list = GetPageList(ref clientContext); if (list != null) { var items = list.GetItems(CamlQuery.CreateAllItemsQuery()); //make sure to include the File on each Item fetched clientContext.Load(items, i => i.Include( item => item.File, item => item["EncodedAbsUrl"])); clientContext.ExecuteQuery(); bool headerWebPart = false; // Iterate through all available pages in the pages list foreach (var item in items) { Microsoft.SharePoint.Client.File page = item.File; String pageUrl = page.ServerRelativeUrl;// item.FieldValues["EncodedAbsUrl"].ToString(); Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartsByWeb] Checking for the Web Part on the Page: " + page.Name); Console.WriteLine("[GetWebPartsByWeb] Checking for the Web Part on the Page:" + page.Name); // Requires Full Control permissions on the Web LimitedWebPartManager webPartManager = page.GetLimitedWebPartManager(PersonalizationScope.Shared); clientContext.Load(webPartManager, wpm => wpm.WebParts, wpm => wpm.WebParts.Include( wp => wp.WebPart.Hidden, wp => wp.WebPart.IsClosed, wp => wp.WebPart.Properties, wp => wp.WebPart.Subtitle, wp => wp.WebPart.Title, wp => wp.WebPart.TitleUrl, wp => wp.WebPart.ZoneIndex)); clientContext.ExecuteQuery(); foreach (WebPartDefinition webPartDefinition in webPartManager.WebParts) { Microsoft.SharePoint.Client.WebParts.WebPart webPart = webPartDefinition.WebPart; //Prepare Exception Comments exceptionCommentsInfo1 = "Web Url: " + clientContext.Web.Url + ", Web Part Type: " + webPart.GetType().Name; Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartsByWeb] Found WebPart details for Web Part: " + webPart.Title + " in Web: " + webUrl); Console.WriteLine("[GetWebPartsByWeb] Found WebPart details for Web Part: " + webPart.Title + " in Web: " + webUrl); webPartInfo = new WebPartInfo(); webPartInfo.PageUrl = pageUrl; webPartInfo.WebPartID = webPartDefinition.Id.ToString(); webPartInfo.WebURL = webUrl; webPartInfo.WebPartTitle = webPart.Title; webPartInfo.ZoneIndex = webPart.ZoneIndex.ToString(); webPartInfo.WebPartTitle = webPart.Title; string webPartPropertiesXml = GetWebPartPropertiesServiceCall(clientContext, webPartDefinition.Id.ToString(), pageUrl); string WebPartTypeName = string.Empty; if (webPartPropertiesXml.Contains("WebPart/v2")) { XmlDataDocument xmldoc = new XmlDataDocument(); xmldoc.LoadXml(webPartPropertiesXml); WebPartTypeName = xmldoc.DocumentElement.GetElementsByTagName("TypeName").Item(0).FirstChild.Value; xmldoc = null; } else { webParts webPartProp = null; byte[] byteArray = Encoding.UTF8.GetBytes(webPartPropertiesXml); using (MemoryStream stream = new MemoryStream(byteArray)) { StreamReader streamReader = new StreamReader(stream); System.Xml.XmlReader reader = new XmlTextReader(streamReader); XmlSerializer serializer = new XmlSerializer(typeof(webParts)); webPartProp = (webParts)serializer.Deserialize(reader); WebPartTypeName = webPartProp.webPart.metaData.type.name; stream.Flush(); } byteArray = null; } string actualWebPartType = GetWebPartShortTypeName(WebPartTypeName); webPartInfo.WebPartTypeFullName = actualWebPartType; webPartInfo.IsClosed = webPart.IsClosed; webPartInfo.IsVisible = webPart.GetType().IsVisible; FileUtility.WriteCsVintoFile(webPartInfoFileName, webPartInfo, ref headerWebPart); } } } Console.WriteLine("[GetWebPartsByWeb] WebPart Usage is exported to the file " + webPartInfoFileName); Logger.AddMessageToTraceLogFile(Constants.Logging, "[GetWebPartsByWeb] WebPart Usage is exported to the file " + webPartInfoFileName); Logger.AddMessageToTraceLogFile(Constants.Logging, "[END][GetWebPartsByWeb]"); Console.WriteLine("[END][GetWebPartsByWeb]"); Logger.AddMessageToTraceLogFile(Constants.Logging, "############## Web Part Trasnformation Utility Execution Completed for Web ##############"); Console.WriteLine("############## Web Part Trasnformation Utility Execution Completed for Web ##############"); } catch (Exception ex) { ExceptionCsv.WriteException(ExceptionCsv.WebApplication, ExceptionCsv.SiteCollection, ExceptionCsv.WebUrl, "Web Part", ex.Message, ex.ToString(), "GetWebPartsByWeb", ex.GetType().ToString(), exceptionCommentsInfo1); Logger.AddMessageToTraceLogFile(Constants.Logging, "[EXCEPTION][GetWebPartsByWeb] Exception Message: " + ex.Message + ", Exception Comment: " + exceptionCommentsInfo1); Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("[EXCEPTION][GetWebPartsByWeb] Exception Message: " + ex.Message); Console.ForegroundColor = ConsoleColor.Gray; } } }