// Load all message templates.
private void LoadAllMessageTemplates()
{
DataTable dtTemplates = MessageTemplateDAL.GetAllMessageTemplates();
foreach (DataRow dr in dtTemplates.Rows)
{
int templateId = StringUtil.GetSafeInt(dr["TemplateId"]);
int templateCategoryId = StringUtil.GetSafeInt(dr["TemplateCategoryId"]);
String templateName = StringUtil.GetSafeString(dr["TemplateName"]);
String templateContent = StringUtil.GetSafeString(dr["TemplateContent"]);
MessageTemplateType templateType = new MessageTemplateType();
templateType.TemplateId = templateId;
templateType.TemplateName = templateName;
templateType.TemplateCategoryId = templateCategoryId;
templateType.TemplateContent = templateContent;
TreeNode newNode = new TreeNode();
newNode.Tag = templateType;
newNode.Text = templateName;
newNode.Name = templateId.ToString();
// Find the category node.
TreeNode[] categoryNodes = treeViewMessageTemplate.Nodes.Find(templateCategoryId.ToString(), false);
if (categoryNodes.Length == 1)
{
categoryNodes[0].Nodes.Add(newNode);
categoryNodes[0].ExpandAll();
}
}
}
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();
}