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;
}
}
}
