protected void LoadSystemNofitication() { DataTable dt = new DataTable(); dt = WTSNews.GetNews(newsId: 0, sysNotification: 1); if (dt != null && dt.Rows.Count > 0) { StringBuilder summarytable = new StringBuilder(); summarytable.AppendFormat("<table cellspacing='0' cellpadding='0' width='98%'>"); summarytable.AppendFormat("<tr class='gridHeader'><td style='padding-right: 10px'>Date(s)</td><td>Title</td></tr>"); foreach (DataRow dr in dt.Rows) { summarytable.AppendFormat("<tr class='gridBody' style='cursor:pointer'>"); for (int x = 0; x <= dt.Columns.Count - 1; x++) { //'value field summarytable.AppendFormat("<td style='color:black'>"); summarytable.AppendFormat(dr[x].ToString()); summarytable.AppendFormat("</td>"); } summarytable.AppendFormat("</tr>"); } summarytable.AppendFormat("</table>"); divSystemNoteInfo.InnerHtml = summarytable.ToString(); showSysNotification = true; } }
protected void LoadNewsItems() { DataTable dtNewsOverview = null; dtNewsOverview = WTSNews.GetNews(); HttpContext.Current.Session["dtNewsOverview"] = dtNewsOverview; Page.ClientScript.RegisterArrayDeclaration("DCC", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None)); InitializeColumnData(ref dtNewsOverview); dtNewsOverview.AcceptChanges(); if (dtNewsOverview != null) { DCC = dtNewsOverview.Columns; } gridNewsOverview.DataSource = (DataTable)Session["dtNewsOverview"]; gridNewsOverview.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { ReadQueryString(); InitializeEvents(); InitializeControls(); //If _newsID != -1 then we are editing a news entry if (_newsID != -1) { //Gather Datatable with NewsID DataTable dt = new DataTable(); dt = WTSNews.GetNews(newsId: _newsID); if (dt.Rows.Count > 0) { Dictionary <string, object> SeverAttributes = new Dictionary <string, object>(); //Set Control Values //SeverAttributes.Add("txtArticleTitle", HttpUtility.UrlDecodeToBytes(dt.Rows[1]["Summary"].ToString())); SeverAttributes.Add("txtArticleTitle", Server.HtmlEncode(dt.Rows[1]["Summary"].ToString())); SeverAttributes.Add("textNewsBody", Server.HtmlEncode(dt.Rows[1]["Detail"].ToString())); // SeverAttributes.Add("textNewsBody1", HttpUtility.UrlEncodeToBytes(dt.Rows[1]["Detail"].ToString())); //SeverAttributes.Add("textNewsBody2", Server.HtmlEncode(dt.Rows[1]["Detail"].ToString())); //SeverAttributes.Add("textNewsBody3", Server.UrlEncode(dt.Rows[1]["Detail"].ToString())); //SeverAttributes.Add("fileUpload", Server.HtmlEncode(dt.Rows[1]["FileName"].ToString())); SeverAttributes.Add("ddlNotificationType", dt.Rows[1]["NewsType"].ToString()); SeverAttributes.Add("txtDateStart", dt.Rows[1]["Start_Date"].ToString()); SeverAttributes.Add("txtDateEnd", dt.Rows[1]["End_Date"].ToString()); if (dt.Rows[1]["Bln_Active"].ToString() == "1") { SeverAttributes.Add("Bln_Active", "true"); } else { SeverAttributes.Add("Bln_Active", "false"); } JsonSeverAttributes = JsonConvert.SerializeObject(SeverAttributes); } //loadAttachments(); } }