protected void Page_Load(object sender, EventArgs e) { string connStr = "Data Source=.\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=SSPI;"; using (SqlConnection conn = new SqlConnection(connStr)) { SqlCommand command = new SqlCommand("select * from customers", conn); conn.Open(); DataSet ds = new DataSet(); ds.DataSetName = "Customers"; ds.Load(command.ExecuteReader(), LoadOption.OverwriteChanges, "Customer"); //Response.ContentType = "text/xml"; //ds.WriteXml(Response.OutputStream); //Added in Listing 13-15 XmlDataDocument doc = new XmlDataDocument(ds); doc.DataSet.EnforceConstraints = false; XmlNode node = doc.SelectSingleNode(@"//Customer[CustomerID = 'ANATR']/ContactTitle"); node.InnerText = "Boss"; doc.DataSet.EnforceConstraints = true; DataRow dr = doc.GetRowFromElement((XmlElement)node.ParentNode); Response.Write(dr["ContactName"].ToString() + " is the "); Response.Write(dr["ContactTitle"].ToString()); } }
public void AddLink(string title, string uri) { XmlDocument doc = new XmlDataDocument(); doc.Load("RssLinks.xml"); XmlNode rootNode = doc.SelectSingleNode("links"); XmlNode linkNode = doc.CreateElement("link"); XmlNode titleNode = doc.CreateElement("title"); XmlText titleText = doc.CreateTextNode(title); titleNode.AppendChild(titleText); XmlNode uriNode = doc.CreateElement("uri"); XmlText uriText = doc.CreateTextNode(uri); uriNode.AppendChild(uriText); XmlNode defaultshowNode = doc.CreateElement("defaultshow"); XmlText defaultshowText = doc.CreateTextNode("false"); defaultshowNode.AppendChild(defaultshowText); linkNode.AppendChild(titleNode); linkNode.AppendChild(uriNode); linkNode.AppendChild(defaultshowNode); rootNode.AppendChild(linkNode); doc.Save("RssLinks.xml"); }
public void loaddata() { XmlDataDocument xml = new XmlDataDocument(); xml.Load(Server.MapPath("~/" + "ad.xml")); XmlNodeList nodes = xml.SelectSingleNode("ttt").ChildNodes; DataTable dt = new DataTable(); dt.Columns.Add("index", typeof(string)); dt.Columns.Add("src", typeof(string)); dt.Columns.Add("href", typeof(string)); dt.Columns.Add("target", typeof(string)); foreach (XmlNode node in nodes) { DataRow row = dt.NewRow(); row["href"] = node.Attributes["href"].Value; row["src"] = node.Attributes["src"].Value; dt.Rows.Add(row); } DataList4.DataSource = dt; DataList4.DataBind(); }
static void Main(string[] args) { string strConn = "Data Source=localhost;Initial Catalog=booksourcedb;Integrated Security=True"; string strSql = "SELECT * FROM book"; SqlDataAdapter dataAdapter = new SqlDataAdapter(strSql, strConn); DataSet dataSet = new DataSet("booklist"); dataAdapter.Fill(dataSet, "book"); XmlDataDocument xdd = new XmlDataDocument(dataSet); string xpath = "/booklist/book[bid='b2']"; XmlElement eBook = (XmlElement)xdd.SelectSingleNode(xpath); Console.WriteLine("bid = " + eBook.ChildNodes[0].InnerText); Console.WriteLine("kind = " + eBook.ChildNodes[1].InnerText); Console.WriteLine("title = " + eBook.ChildNodes[2].InnerText); Console.WriteLine("publisher = " + eBook.ChildNodes[3].InnerText); Console.WriteLine("price = " + eBook.ChildNodes[4].InnerText); }
private void AddWebConfigNodes(string xPath, ref XmlDataDocument xmlDoc, ref WebConfigModifications webConfigMods, ref SPWebApplication webApp) { foreach (XmlNode node in xmlDoc.SelectSingleNode(xPath)) { if (node.NodeType != XmlNodeType.Comment) { webConfigMods.AddWebConfigNode(webApp, xPath, node, node.Attributes); } } }
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; } } }
/// <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); } }
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 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; }
public System.Collections.ArrayList getCaptureTagsRaw(string mode) { System.Collections.ArrayList tags = new System.Collections.ArrayList(); try { StringBuilder sbReq = new StringBuilder(); sbReq.Append(String.Format("{0}API?command=getCaptureTagsRaw&mode={1}&session_id={2}", httpUri.AbsoluteUri, mode, 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/tagEPC"); if (node != null) { //<Ack> TAG tag; while (node != null) { tag = new TAG(); foreach (XmlAttribute att in node.Attributes) { if (att.Name.Equals("capturepoint_id", StringComparison.OrdinalIgnoreCase)) { tag.Antenna = att.InnerXml; } else if (att.Name.Equals("capturepoint_name", StringComparison.OrdinalIgnoreCase)) { tag.CapturePointId = att.InnerXml; } 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)) { string s = att.InnerXml; if (s.Length > 1) { tag.Index = s.Substring(1); tag.session = s.Substring(0, 1); } } else if (att.Name.Equals("rssi", StringComparison.OrdinalIgnoreCase)) { tag.RSSI = double.Parse(att.InnerXml); } else if (att.Name.Equals("tag_id", StringComparison.OrdinalIgnoreCase)) { tag.TagOrigId = att.InnerXml; } else if (att.Name.Equals("time", StringComparison.OrdinalIgnoreCase)) { int.TryParse(att.InnerXml, out tag.Time); } else if (att.Name.Equals("event_id", StringComparison.OrdinalIgnoreCase)) { tag.EventId = att.InnerXml; } else if (att.Name.Equals("reader_ip", StringComparison.OrdinalIgnoreCase)) { tag.ServerIp = att.InnerXml; } } tag.ApiTimeStampUTC = DateTime.UtcNow; tag.ServerIp = httpUri.Host; 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; }
private void Populate_ViewCalendar(EkContentCol contentdata) { System.Web.UI.WebControls.BoundColumn colBound = new System.Web.UI.WebControls.BoundColumn(); string strTag; string strtag1; string imageDirection = string.Empty; if (Request.QueryString["orderbydirection"] == null) direction = "desc"; else if (Request.QueryString["orderbydirection"] == "desc") { imageDirection = " <img src=\"" + _ContentApi.ApplicationPath + "images/ui/icons/arrowHeadDownGrey.png\" \" />"; direction = "asc"; } else if (Request.QueryString["orderbydirection"] == "asc") { imageDirection = " <img src=\"" + _ContentApi.ApplicationPath + "images/ui/icons/arrowHeadUpGrey.png\" \" />"; direction = "desc"; } strTag = "<a href=\"content.aspx?LangType=" + _ContentLanguage + "&action=" + _PageAction + "&orderbydirection=" + direction + "&orderby="; strtag1 = "&id=" + _Id + (_ContentTypeQuerystringParam != "" ? "&" + _ContentTypeUrlParam + "=" + _ContentTypeQuerystringParam : "") + "\" title=\"" + _MessageHelper.GetMessage("click to sort msg") + "\">"; colBound.DataField = "TITLE"; if (!string.IsNullOrEmpty(Request.QueryString["orderby"]) && Request.QueryString["orderby"].ToString().ToLower() == "title") colBound.HeaderText = strTag + "Title" + strtag1 + _MessageHelper.GetMessage("generic title") + imageDirection + "</a> "; else colBound.HeaderText = strTag + "Title" + strtag1 + _MessageHelper.GetMessage("generic title") + "</a>"; colBound.HeaderStyle.CssClass = "title-header"; colBound.ItemStyle.CssClass = "left"; FolderDataGrid.Columns.Add(colBound); colBound = new System.Web.UI.WebControls.BoundColumn(); colBound.DataField = "FIRSTOCCURENCE"; colBound.HeaderText = _MessageHelper.GetMessage("webcalendar first occurence"); colBound.HeaderStyle.CssClass = "title-header"; colBound.ItemStyle.CssClass = "left"; FolderDataGrid.Columns.Add(colBound); colBound = new System.Web.UI.WebControls.BoundColumn(); colBound.DataField = "TYPE"; colBound.HeaderText = _MessageHelper.GetMessage("lbl event type"); colBound.HeaderStyle.CssClass = "title-header"; colBound.ItemStyle.CssClass = "left"; FolderDataGrid.Columns.Add(colBound); colBound = new System.Web.UI.WebControls.BoundColumn(); colBound.DataField = "LANGUAGE"; if (!string.IsNullOrEmpty(Request.QueryString["orderby"]) && Request.QueryString["orderby"].ToString().ToLower() == "language") colBound.HeaderText = strTag + "language" + strtag1 + _MessageHelper.GetMessage("generic language") + imageDirection + "</a>"; else colBound.HeaderText = strTag + "language" + strtag1 + _MessageHelper.GetMessage("generic language") + "</a>"; colBound.HeaderStyle.CssClass = "title-header center"; colBound.ItemStyle.CssClass = "center"; FolderDataGrid.Columns.Add(colBound); colBound = new System.Web.UI.WebControls.BoundColumn(); colBound.DataField = "ID"; if (!string.IsNullOrEmpty(Request.QueryString["orderby"]) && Request.QueryString["orderby"].ToString().ToLower() == "id") colBound.HeaderText = strTag + "ID" + strtag1 + _MessageHelper.GetMessage("generic ID") + imageDirection + "</a>"; else colBound.HeaderText = strTag + "ID" + strtag1 + _MessageHelper.GetMessage("generic ID") + "</a>"; colBound.HeaderStyle.CssClass = "title-header center"; colBound.ItemStyle.CssClass = "center"; FolderDataGrid.Columns.Add(colBound); colBound = new System.Web.UI.WebControls.BoundColumn(); colBound.DataField = "STATUS"; if (!string.IsNullOrEmpty(Request.QueryString["orderby"]) && Request.QueryString["orderby"].ToString().ToLower() == "status") colBound.HeaderText = strTag + "status" + strtag1 + _MessageHelper.GetMessage("generic Status") + imageDirection + "</a>"; else colBound.HeaderText = strTag + "status" + strtag1 + _MessageHelper.GetMessage("generic Status") + "</a>"; colBound.HeaderStyle.CssClass = "title-header center"; colBound.ItemStyle.CssClass = "center"; FolderDataGrid.Columns.Add(colBound); colBound = new System.Web.UI.WebControls.BoundColumn(); colBound.DataField = "DATEMODIFIED"; if (!string.IsNullOrEmpty(Request.QueryString["orderby"]) && Request.QueryString["orderby"].ToString().ToLower() == "datemodified") colBound.HeaderText = strTag + "DateModified" + strtag1 + _MessageHelper.GetMessage("generic Date Modified") + imageDirection + "</a>"; else colBound.HeaderText = strTag + "DateModified" + strtag1 + _MessageHelper.GetMessage("generic Date Modified") + "</a>"; colBound.HeaderStyle.CssClass = "title-header"; colBound.ItemStyle.CssClass = "left"; FolderDataGrid.Columns.Add(colBound); colBound = new System.Web.UI.WebControls.BoundColumn(); colBound.DataField = "EDITORNAME"; if (!string.IsNullOrEmpty(Request.QueryString["orderby"]) && Request.QueryString["orderby"].ToString().ToLower() == "editor") colBound.HeaderText = strTag + "editor" + strtag1 + _MessageHelper.GetMessage("generic Last Editor") + imageDirection + "</a>"; else colBound.HeaderText = strTag + "editor" + strtag1 + _MessageHelper.GetMessage("generic Last Editor") + "</a>"; colBound.HeaderStyle.CssClass = "title-header"; colBound.ItemStyle.CssClass = "left"; FolderDataGrid.Columns.Add(colBound); DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add(new DataColumn("TITLE", typeof(string))); dt.Columns.Add(new DataColumn("FIRSTOCCURENCE", typeof(string))); dt.Columns.Add(new DataColumn("TYPE", typeof(string))); dt.Columns.Add(new DataColumn("LANGUAGE", typeof(string))); dt.Columns.Add(new DataColumn("ID", typeof(long))); dt.Columns.Add(new DataColumn("STATUS", typeof(string))); dt.Columns.Add(new DataColumn("DATEMODIFIED", typeof(string))); dt.Columns.Add(new DataColumn("EDITORNAME", typeof(string))); string ViewUrl = ""; int i; for (i = 0; i <= contentdata.Count - 1; i++) { dr = dt.NewRow(); //dmsMenuGuid is created to uniquely identify menu element component in the DOM, //just in case there is more than one menu that contains the same contentId & language //This case is known to apply in non-Workarea implementations of the DmsMenu but is //implemented for ALL DmsMenus, including the Workarea string dmsMenuGuid; dmsMenuGuid = (string)(System.Guid.NewGuid().ToString()); string makeUnique = (string)(contentdata.get_Item(i).Id + contentdata.get_Item(i).Language + dmsMenuGuid); string contentStatus = contentdata.get_Item(i).ContentStatus; //If (contentdata.get_Item(i).ContentStatus = "A") Then dr[0] = "<div class=\"ektron dmsWrapper\""; dr[0] = dr[0] + " id=\"dmsWrapper" + makeUnique + "\">"; dr[0] = dr[0] + "<p class=\"dmsItemWrapper\""; dr[0] = dr[0] + " id=\"dmsItemWrapper" + makeUnique + "\""; dr[0] = dr[0] + " title=\"View Menu\""; dr[0] = dr[0] + " style=\"overflow:visible;\""; dr[0] = dr[0] + ">"; dr[0] = dr[0] + "<input type=\"hidden\" value=\'{\"id\":" + contentdata.get_Item(i).Id + ","; dr[0] = dr[0] + "\"parentId\":" + contentdata.get_Item(i).FolderId + ","; dr[0] = dr[0] + "\"languageId\":" + contentdata.get_Item(i).Language + ","; dr[0] = dr[0] + "\"status\":\"" + contentStatus + "\","; dr[0] = dr[0] + "\"guid\":\"" + dmsMenuGuid + "\","; dr[0] = dr[0] + "\"communityDocumentsMenu\":\"\","; dr[0] = dr[0] + "\"contentType\":" + Convert.ToInt32(contentdata.get_Item(i).ContentType) + ","; dr[0] = dr[0] + "\"dmsSubtype\":\"\"}\'"; dr[0] = dr[0] + " id=\"dmsContentInfo" + makeUnique + "\" />"; dr[0] = dr[0] + "<img src=\"" + _ContentApi.ApplicationPath + "images/ui/icons/calendarViewDay.png\" onclick=\"event.cancelBubble=true;\" />"; dr[0] = dr[0] + "<a"; dr[0] = dr[0] + " id=\"dmsViewItemAnchor" + makeUnique + "\""; dr[0] = dr[0] + " class=\"dmsViewItemAnchor\""; dr[0] = dr[0] + " onclick=\"event.cancelBubble=true;\""; if (contentdata.get_Item(i).ContentStatus == "A") { ViewUrl = (string)("content.aspx?action=View&folder_id=" + _Id + "&id=" + contentdata.get_Item(i).Id + "&LangType=" + contentdata.get_Item(i).Language + "&callerpage=content.aspx&origurl=" + EkFunctions.UrlEncode(Request.ServerVariables["QUERY_STRING"])); } else { ViewUrl = (string)("content.aspx?action=ViewStaged&folder_id=" + _Id + "&id=" + contentdata.get_Item(i).Id + "&LangType=" + contentdata.get_Item(i).Language + "&callerpage=content.aspx&origurl=" + EkFunctions.UrlEncode(Request.ServerVariables["QUERY_STRING"])); } dr[0] = dr[0] + " href=\"" + ViewUrl + "\""; dr[0] = dr[0] + " title=\"View " + contentdata.get_Item(i).Title + "\""; dr[0] = dr[0] + ">"; dr[0] = dr[0] + contentdata.get_Item(i).Title; dr[0] = dr[0] + "</a>"; dr[0] = dr[0] + "</p>"; dr[0] = dr[0] + "</div>"; System.Xml.XmlDataDocument xd = new System.Xml.XmlDataDocument(); try { xd.LoadXml(contentdata.get_Item(i).Html); System.Xml.XmlNode UTCstartDTXn = xd.SelectSingleNode("/root/StartTime"); if (UTCstartDTXn != null) { System.Xml.XmlNode alldayXn = xd.SelectSingleNode("/root/IsAllDay"); bool alldayBool = false; DateTime UTCstartDT = new DateTime(); System.Globalization.CultureInfo ENci = new System.Globalization.CultureInfo(1033); System.Globalization.CultureInfo userCi = EkFunctions.GetCultureInfo(_ContentApi.RequestInformationRef.UserCulture.ToString()); Ektron.Cms.Common.Calendar.TimeZoneInfo userTzi; UTCstartDT = DateTime.ParseExact(UTCstartDTXn.InnerText, "s", ENci.DateTimeFormat); userTzi = Ektron.Cms.Common.Calendar.TimeZoneInfo.GetTimeZoneInfo(_ContentApi.RequestInformationRef.UserTimeZone); DateTime LocalstartDT = userTzi.ConvertUtcToTimeZone(UTCstartDT); bool.TryParse(alldayXn.InnerText, out alldayBool); if (!(LocalstartDT.Hour == 0 && LocalstartDT.Minute == 0) && !alldayBool) { if (userCi.DateTimeFormat.PMDesignator == string.Empty) //no ampm designator { dr[1] = LocalstartDT.ToString("ddd, MMM d yyyy hh:mm", userCi.DateTimeFormat) + " (" + userTzi.StandardName + ")"; //first occurence } else { dr[1] = LocalstartDT.ToString("ddd, MMM d yyyy h:mm tt", userCi.DateTimeFormat) + " (" + userTzi.StandardName + ")"; //first occurence } } else if (alldayBool) { dr[1] = UTCstartDT.ToString("ddd, MMM d yyyy", userCi.DateTimeFormat); //first occurence } else { dr[1] = LocalstartDT.ToString("ddd, MMM d yyyy", userCi.DateTimeFormat) + " (" + userTzi.StandardName + ")"; //first occurence } } System.Xml.XmlNode isvarianceXn = xd.SelectSingleNode("/root/IsVariance"); System.Xml.XmlNode isCancelledXn = xd.SelectSingleNode("/root/IsCancelled"); if (isvarianceXn != null) { bool isvariance = bool.Parse(isvarianceXn.InnerText); bool isCancelled = bool.Parse(isCancelledXn.InnerText); if (isvariance && isCancelled) { dr[2] = "Variance - Cancelled occurence"; } else if (isvariance && !isCancelled) { dr[2] = "Variance - Extra occurence"; } else { dr[2] = "Original"; } } } catch { dr[1] = "Start Time could not be extracted."; } string LanguageDescription = Ektron.Cms.API.JS.Escape(contentdata.get_Item(i).LanguageDescription); dr[3] = "<a href=\"#ShowTip" + contentdata.get_Item(i).LanguageDescription + "\" onmouseover=\"ddrivetip(\'" + LanguageDescription + "\',\'ADC5EF\', 100);\" onmouseout=\"hideddrivetip()\" style=\"text-decoration:none;\">" + "<img src=\'" + _LocalizationApi.GetFlagUrlByLanguageID(contentdata.get_Item(i).Language) + "\' />" + "</a>"; dr[4] = contentdata.get_Item(i).Id; dr[5] = _StyleHelper.StatusWithToolTip(contentStatus); dr[6] = contentdata.get_Item(i).DateModified.ToString(); dr[7] = contentdata.get_Item(i).LastEditorLname + ", " + contentdata.get_Item(i).LastEditorFname; dt.Rows.Add(dr); } DataView dv = new DataView(dt); FolderDataGrid.DataSource = dv; FolderDataGrid.DataBind(); // _PagingTotalPagesNumber = 1 }
/// <summary> /// /// </summary> /// <param name="stationSource"></param> /// <returns></returns> public Xdgk.Communi.Station Create(object stationSource) { if (stationSource == null) { throw new ArgumentNullException("stationSource"); } DataRow stationDR = stationSource as DataRow; if (stationDR == null) { string msg = string.Format("stationSource is not a data row"); throw new ArgumentException(msg); } int stationID = (int)stationDR["StationID"]; string stationName = stationDR["Name"].ToString(); string xml = stationDR["CommuniTypeContent"].ToString().Trim(); if (xml.Length == 0) { // TODO: 2010-09-17 // log error info // //continue; } 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; return station; }