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; }