protected void btnSave_OnClick(object sender, System.EventArgs e)
    {
        int parent_topic_id = Convert.ToInt32(ddlHelpCategories.SelectedValue);
        double last_num_order = Convert.ToDouble(qHlp_HelpTopic.GetLastTopicOrderInCategory(parent_topic_id));
        double next_num_order;
        if (last_num_order > 0)
            next_num_order = last_num_order + .1;
        else
        {
            qHlp_HelpTopic category = new qHlp_HelpTopic(parent_topic_id);
            next_num_order = category.TopicOrder + .1;
        }

        qHlp_HelpTopic new_topic = new qHlp_HelpTopic();
        new_topic.Title = txtTitle.Text;
        new_topic.ParentTopicID = parent_topic_id;
        new_topic.TopicOrder = next_num_order;
        new_topic.ScopeID = Convert.ToInt32(Context.Items["ScopeID"]);
        new_topic.Available = "Yes";
        new_topic.CreatedBy = Convert.ToInt32(Context.Items["UserID"]);
        new_topic.Created = DateTime.Now;
        new_topic.LastModifiedBy = Convert.ToInt32(Context.Items["UserID"]);
        new_topic.LastModified = DateTime.Now;
        new_topic.MarkAsDelete = 0;
        if (chkIsSystem.Checked)
            new_topic.IsSystemHelp = true;
        new_topic.Insert();

        Response.Redirect("~/qHlp/help-viewer.aspx?topic=" + new_topic.Title + "&mode=edit");
    }
        public static qHlp_HelpTopic GetHelpTopicByTitle(string title)
        {
            var topic = new qHlp_HelpTopic();

            topic.container.Select(new DbQuery
            {
                Where      = "Available = 'Yes' AND MarkAsDelete = 0 AND Title = @Title",
                Parameters = new SqlQueryParameter[] { new SqlQueryParameter("@Title", title) }
            });

            return(topic);
        }
        public static qHlp_HelpTopic GetHelpTopicByTitle(string title)
        {
            var topic = new qHlp_HelpTopic();

            topic.container.Select(new DbQuery
            {
                Where = "Available = 'Yes' AND MarkAsDelete = 0 AND Title = @Title",
                Parameters = new SqlQueryParameter[] { new SqlQueryParameter("@Title", title) }
            });

            return topic;
        }