private void LoadAllMessageTemplates() { this.tvMessageTemplates.Nodes.Clear(); DataTable dtMessageCategories = MessageTemplateCategoryDAL.GetAllMessageTemplateCategories(); DataTable dtMessageTemplates = MessageTemplateDAL.GetAllMessageTemplates(); foreach (DataRow drCategory in dtMessageCategories.Rows) { int categoryId = StringUtil.GetSafeInt(drCategory["CategoryId"]); String categoryName = StringUtil.GetSafeString(drCategory["CategoryName"]); MessageTemplateCategoryType catType = new MessageTemplateCategoryType(); TreeNode catNode = new TreeNode(); catNode.Tag = catType; catNode.Text = categoryName; catNode.Name = categoryId.ToString(); this.tvMessageTemplates.Nodes.Add(catNode); } foreach (DataRow drMessageTemplate in dtMessageTemplates.Rows) { int templateId = StringUtil.GetSafeInt(drMessageTemplate["TemplateId"]); int categoryId = StringUtil.GetSafeInt(drMessageTemplate["TemplateCategoryId"]); String templateName = StringUtil.GetSafeString(drMessageTemplate["TemplateName"]); String templateContent = StringUtil.GetSafeString(drMessageTemplate["TemplateContent"]); MessageTemplateType templateType = new MessageTemplateType(); templateType.TemplateId = templateId; templateType.TemplateCategoryId = categoryId; templateType.TemplateName = templateName; templateType.TemplateContent = templateContent; TreeNode msgNode = new TreeNode(); msgNode.Tag = templateType; msgNode.Text = templateName; TreeNode[] catNodes = this.tvMessageTemplates.Nodes.Find(categoryId.ToString(), false); if (catNodes.Length > 0) { catNodes[0].Nodes.Add(msgNode); } } this.tvMessageTemplates.ExpandAll(); }
// Load all message template categories. private void LoadAllMessageTemplateCategories() { DataTable dtCategories = MessageTemplateCategoryDAL.GetAllMessageTemplateCategories(); this.treeViewMessageTemplate.Nodes.Clear(); foreach (DataRow dr in dtCategories.Rows) { int categoryId = StringUtil.GetSafeInt(dr["CategoryId"]); String categoryName = StringUtil.GetSafeString(dr["CategoryName"]); MessageTemplateCategoryType categoryType = new MessageTemplateCategoryType(); categoryType.CategoryId = categoryId; categoryType.CategoryName = categoryName; TreeNode newNode = new TreeNode(); newNode.Tag = categoryType; newNode.Text = categoryName; newNode.Name = categoryId.ToString(); this.treeViewMessageTemplate.Nodes.Add(newNode); } }