protected void gvItems_DataBinding(object sender, EventArgs e) { string type = Request["type"]; TermTypes termType = TermTypes.Category; if (!String.IsNullOrEmpty(type)) { termType = BSTerm.GetTermType(type); } List <BSTerm> categories = BSTerm.GetTermsBySubID(termType, 0); List <string> lstNames = new List <string>(); for (int i = 0; i < categories.Count; i++) { string strParents = string.Empty; BSTerm category = categories[i]; while (category.SubID != 0) { BSTerm subCategory = BSTerm.GetTerm(category.SubID); strParents = subCategory.Name + " > " + strParents; } lstNames.Add(strParents + category.Name); } ((GridView)sender).DataSource = categories; if (!IsPostBack) { ddlParentCategory.Items.Insert(0, new ListItem(Language.Admin["None"], "0")); } }
private void SaveTags(int iPostID) { string[] strTags = txtPostTags.Text.Split(','); for (int i = 0; i < strTags.Length; i++) { if (strTags[i].Trim() != "") { string code = BSHelper.CreateCode(strTags[i].Trim()); string name = strTags[i].Trim(); BSTerm bsTerm = BSTerm.GetTerm(code, TermTypes.Tag); if (bsTerm == null) { bsTerm = new BSTerm(); bsTerm.Name = name; bsTerm.Code = code; bsTerm.Type = TermTypes.Tag; bsTerm.Save(); } bsTerm.Objects.Add(iPostID); bsTerm.Save(); } } }
public void LoadData(int ObjectID) { if (!Page.IsPostBack) { List <BSTerm> terms = BSTerm.GetTerms(TermType); if (terms.Count > 0) { cblCats.DataSource = terms; cblCats.DataMember = "TermID"; cblCats.DataTextField = "Name"; cblCats.DataValueField = "TermID"; cblCats.DataBind(); } else { LiteralControl lC = new LiteralControl(); lC.Text = Language.Admin["CategoryNotFound"] + "<br><br><a href=\"Categories.aspx?#Add\">" + Language.Admin["AddNewCategory"] + "</a>"; divCats.Controls.Add(lC); } if (ObjectID != 0) { List <BSTerm> objectTerms = BSTerm.GetTermsByObjectID(ObjectID, TermType); foreach (BSTerm objectTerm in objectTerms) { if (cblCats.Items.FindByValue(objectTerm.TermID.ToString()) != null) { cblCats.Items.FindByValue(objectTerm.TermID.ToString()).Selected = true; } } } } }
public static void OnDeleting(BSTerm bsTerm, CancelEventArgs e) { if (Deleting != null) { Deleting(bsTerm, e); } }
public static List <BSTerm> GetTerms(TermTypes termType, int iTermCount) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { string top = iTermCount == 0 ? String.Empty : "TOP " + iTermCount; if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Type]=@Type ORDER BY [Name] ASC", top)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms ORDER BY [Name] ASC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
private static void FillTerm(IDataReader dr, BSTerm bsTerm) { bsTerm.SubID = (int)dr["SubID"]; bsTerm.Name = (string)dr["Name"]; bsTerm.Code = (string)dr["Code"]; bsTerm.Description = dr["Description"].ToString(); string termType = (string)dr["Type"]; bsTerm.Type = GetTermType(termType); bsTerm.TermID = (int)dr["TermID"]; bsTerm.Objects = new List <int>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("TermID", bsTerm.TermID); dp.ExecuteReader("SELECT * FROM TermsTo WHERE [TermID]=@TermID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader drObjects = (IDataReader)dp.Return.Value) while (drObjects.Read()) { bsTerm.Objects.Add((int)drObjects["ObjectID"]); } } } }
public static List <BSTerm> GetTermsBySubID(TermTypes termType, int iSubID) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [Type]=@Type AND [SubID]=@SubID ORDER BY [Name] ASC"); } else { dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [SubID]=@SubID ORDER BY [Name] ASC"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
public static void OnSaving(BSTerm bsTerm, CancelEventArgs e) { if (Saving != null) { Saving(bsTerm, e); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (txtName.Text.Trim() != "") { string code = BSHelper.CreateCode(txtName.Text); BSTerm bsTerm = BSTerm.GetTerm(code, TermTypes.Tag); if (bsTerm == null) { bsTerm = new BSTerm(); bsTerm.Name = txtName.Text; bsTerm.Type = TermTypes.Tag; bsTerm.Code = code; } bsTerm.Save(); if (bsTerm.Save()) { MessageBox1.Message = Language.Admin["TagSaved"]; MessageBox1.Type = MessageBox.ShowType.Information; gvItems.DataBind(); txtName.Text = string.Empty; } else { MessageBox1.Message = "Error"; } } }
public void SaveTags(int ObjectID) { string strTags = txtTags.Value; Regex rex = new Regex("\\{(.*?)\\}"); BSTerm.RemoveTo(TermTypes.Tag, ObjectID); foreach (Match item in rex.Matches(strTags)) { Regex rx = new Regex("'(.*?)'"); string strText = rx.Matches(item.Value)[1].Value; string strValue = rx.Matches(item.Value)[0].Value; strText = strText.Substring(1, strText.Length - 2); strValue = strValue.Substring(1, strValue.Length - 2); string code = BSHelper.CreateCode(strText); BSTerm bsTerm = BSTerm.GetTerm(code, TermTypes.Tag); if (bsTerm == null) { bsTerm = new BSTerm(); bsTerm.Name = strText; bsTerm.Code = code; bsTerm.Type = TermTypes.Tag; bsTerm.Objects.Add(ObjectID); bsTerm.Save(); } else { bsTerm.Objects.Add(ObjectID); bsTerm.Save(); } } }
public static void OnSaved(BSTerm bsTerm, EventArgs e) { if (Saved != null) { Saved(bsTerm, e); } }
protected void btnSave_Click(object sender, EventArgs e) { string TermID = Request.QueryString["TermID"]; int iTermID = 0; int.TryParse(TermID, out iTermID); if (!String.IsNullOrEmpty(txtCatName.Text.Trim()) && iTermID > 0) { BSTerm bsTerm = BSTerm.GetTerm(iTermID); bsTerm.Name = txtCatName.Text; bsTerm.Description = txtCatDescription.Text; bsTerm.Code = BSHelper.CreateCode(txtCatName.Text); //term.SubID = int.Parse(ddlParentCategory.SelectedValue); if (bsTerm.Save()) { MessageBox1.Message = Language.Admin["CategorySaved"]; MessageBox1.Type = MessageBox.ShowType.Information; gvItems.DataBind(); txtName.Text = string.Empty; txtDescription.Text = string.Empty; } else { MessageBox1.Message = Language.Admin["CategoryError"]; } } else { Response.Redirect("Categories.aspx"); } }
public static List <BSTerm> GetTermsByObjectID(int objectId, TermTypes termType) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("ObjectID", objectId); if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] IN (SELECT TermID FROM TermsTo WHERE [ObjectID]=@ObjectID AND [Type]=@Type) ORDER BY Name"); } else { dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] IN (SELECT TermID FROM TermsTo WHERE [ObjectID]=@ObjectID) ORDER BY Name"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
private void SaveTags(int iPostID) { string[] strTags = txtPostTags.Text.Split(','); for (int i = 0; i < strTags.Length; i++) { if (strTags[i].Trim() != "") { string code = BSHelper.CreateCode(strTags[i].Trim()); string name = strTags[i].Trim(); BSTerm bsTerm = BSTerm.GetTerm(code, TermTypes.Tag); if (bsTerm== null) { bsTerm = new BSTerm(); bsTerm.Name = name; bsTerm.Code = code; bsTerm.Type = TermTypes.Tag; bsTerm.Save(); } bsTerm.Objects.Add(iPostID); bsTerm.Save(); } } }
protected void btnAdd_Click(object sender, EventArgs e) { if (txtName.Text.Trim() != "") { BSTerm bsTerm = new BSTerm(); bsTerm.Name = txtName.Text; bsTerm.Description = txtDescription.Text; bsTerm.Type = BSTerm.GetTermType(CategoryType); bsTerm.Code = BSHelper.CreateCode(bsTerm.Name); bsTerm.SubID = int.Parse(ddlParentCategory.SelectedValue); if (bsTerm.Save()) { MessageBox1.Message = Language.Admin["CategorySaved"]; MessageBox1.Type = MessageBox.ShowType.Information; gvItems.DataBind(); txtName.Text = string.Empty; txtDescription.Text = string.Empty; } else { MessageBox1.Message = Language.Admin["CategoryError"]; } } }
protected void btnDelete_Click(object sender, EventArgs e) { bool bRemoved = false; for (int i = 0; i < gvItems.Rows.Count; i++) { CheckBox cb = gvItems.Rows[i].FindControl("cb") as CheckBox; if (cb.Checked) { Literal literal = gvItems.Rows[i].FindControl("TermID") as Literal; if (literal != null) { int iTermID = 0; int.TryParse(literal.Text, out iTermID); BSTerm bsTerm = BSTerm.GetTerm(iTermID); if (bsTerm != null) { bRemoved = bsTerm.Remove(); } } } } if (bRemoved) { MessageBox1.Message = Language.Admin["TagDeleted"]; MessageBox1.Type = MessageBox.ShowType.Information; MessageBox1.Visible = true; gvItems.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { GenerateHeaderButtons(); if (!Page.IsPostBack) { HideAll(); int iTermID = 0; int.TryParse(Request["TermID"], out iTermID); if (iTermID != 0) { divEditTerm.Visible = true; divSideEditTerm.Visible = true; BSTerm bsTerm = BSTerm.GetTerm(iTermID); if (bsTerm != null) { txtCatName.Text = bsTerm.Name; } else { Response.Redirect("Links.aspx"); } } else { divPosts.Visible = true; divAddTerm.Visible = true; gvItems.DataBind(); } } }
protected void btnSave_Click(object sender, EventArgs e) { int iTermID = 0; int.TryParse(Request["TermID"], out iTermID); if (iTermID > 0) { BSTerm bsTerm = BSTerm.GetTerm(iTermID); bsTerm.Name = txtCatName.Text; bsTerm.Code = BSHelper.CreateCode(txtCatName.Text); if (bsTerm.Save()) { MessageBox1.Message = Language.Admin["TagSaved"]; MessageBox1.Type = MessageBox.ShowType.Information; gvItems.DataBind(); txtName.Text = string.Empty; } else { MessageBox1.Message = "Error"; } } else { Response.Redirect("Categories.aspx"); } }
public static void OnDeleted(BSTerm bsTerm, EventArgs e) { if (Deleted != null) { Deleted(bsTerm, e); } }
public void LoadTags(int ObjectID) { txtTags.Value = ""; List <BSTerm> terms = BSTerm.GetTermsByObjectID(ObjectID, TermTypes.Tag); foreach (BSTerm term in terms) { string strText = term.Name; string strValue = term.TermID.ToString(); txtTags.Value += "{value='" + strValue + "',text='" + strText + "'}"; sAutoComp.Items.Add(new ListItem(strText, strValue)); } }
public static BSTerm GetTerm(int iTermID, int iSubID, TermTypes type) { using (DataProcess dp = new DataProcess()) { if (iTermID > 0) { if (type == TermTypes.All) { dp.AddParameter("TermID", iTermID); dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] = @TermID"); } else { dp.AddParameter("TermID", iTermID); dp.AddParameter("Type", type.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] = @TermID AND [Type]=@Type"); } } else { if (type == TermTypes.All) { dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [SubID] = @SubID"); } else { dp.AddParameter("SubID", iSubID); dp.AddParameter("Type", type.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [SubID] = @SubID AND [Type]=@Type"); } } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); return(bsTerm); } } } } return(null); }
public void SaveData(int ObjectID) { using (DataProcess dp = new DataProcess()) { BSTerm.RemoveTo(TermTypes.Category, ObjectID); for (int i = 0; i < cblCats.Items.Count; i++) { if (cblCats.Items[i].Selected == true) { BSTerm bsTerm = BSTerm.GetTerm(Convert.ToInt32(cblCats.Items[i].Value)); bsTerm.Objects.Add(ObjectID); bsTerm.Save(); } } } }
public static List <BSPost> GetPostsByTerm(int termId, string code, TermTypes termType, PostTypes postType, PostStates postState) { List <BSPost> posts = new List <BSPost>(); using (DataProcess dp = new DataProcess()) { BSTerm bsTerm = null; bsTerm = termId != 0 ? BSTerm.GetTerm(termId) : BSTerm.GetTerm(code, termType); if (bsTerm != null) { dp.AddParameter("TermID", bsTerm.TermID); if (postState != PostStates.All) { dp.AddParameter("State", (short)postState); dp.ExecuteReader("SELECT * FROM Posts WHERE [PostID] IN (SELECT [ObjectID] FROM TermsTo WHERE [TermID]=@TermID) AND [State]=@State ORDER By [CreateDate] DESC"); } else { dp.ExecuteReader("SELECT * FROM Posts WHERE [PostID] IN (SELECT [ObjectID] FROM TermsTo WHERE [TermID]=@TermID) AND [Type]=@Type ORDER By [CreateDate] DESC"); } } else { return(posts); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSPost bsPost = new BSPost(); FillPost(dr, bsPost); posts.Add(bsPost); } } } } return(posts); }
protected void btnDelete_Click(object sender, EventArgs e) { bool bSomeOne = false; bool bCategoriesRemoved = false; for (int i = 0; i < gvItems.Rows.Count; i++) { CheckBox cb = gvItems.Rows[i].FindControl("cb") as CheckBox; if (cb.Checked) { string TermID = (gvItems.Rows[i].FindControl("TermID") as Literal).Text; int iTermID = int.Parse(TermID); List <BSTerm> categories = BSTerm.GetTermsBySubID(TermTypes.Category, iTermID); if (categories.Count == 0) { BSTerm bsTerm = BSTerm.GetTerm(iTermID); if (bsTerm != null) { bsTerm.Remove(); } bCategoriesRemoved = true; } else { bSomeOne = true; } } } if (bSomeOne) { MessageBox1.Message = Language.Admin["CategoryHaveSub"]; MessageBox1.Type = MessageBox.ShowType.Information; } else if (bCategoriesRemoved) { MessageBox1.Message = Language.Admin["CategoryDeleted"]; MessageBox1.Type = MessageBox.ShowType.Information; MessageBox1.Visible = true; gvItems.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { GenerateHeaderButtons(); if (!Page.IsPostBack) { HideAll(); ddlParentCategory.DataTextField = "Name"; ddlParentCategory.DataValueField = "TermID"; ddlParentCategory.DataSource = BSTerm.GetTerms(TermTypes.Category); ddlParentCategory.DataBind(); string TermID = Request.QueryString["TermID"]; int iTermID = 0; int.TryParse(TermID, out iTermID); if (iTermID > 0) { divEditTerm.Visible = true; divSideEditTerm.Visible = true; BSTerm bsTerm = BSTerm.GetTerm(iTermID); if (bsTerm != null) { txtCatName.Text = bsTerm.Name; txtCatDescription.Text = bsTerm.Description; } else { Response.Redirect("Links.aspx"); } } else { divPosts.Visible = true; divAddTerm.Visible = true; gvItems.DataBind(); } } }
public static List <BSTerm> GetTermsByContainsName(string name, TermTypes termType, int iTermCount) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { string top = iTermCount == 0 ? String.Empty : "TOP " + iTermCount; if (termType != TermTypes.All) { string type = termType == TermTypes.Category ? "category" : "tag"; dp.AddParameter("Type", type); dp.AddParameter("Name", name); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Type]=@Type AND [Name] LIKE '%' + @Name + '%' ORDER BY [Name] ASC", top)); } else { dp.AddParameter("Name", name); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Name] LIKE '%' + @Name + '%' ORDER BY [Name] ASC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
public static BSTerm GetTerm(string code, TermTypes type) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Code", code); dp.AddParameter("Type", type.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [Code] = @Code AND [Type]=@Type"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); return(bsTerm); } } } } return(null); }
protected void btnAdd_Click(object sender, EventArgs e) { if (txtName.Text.Trim() != "") { BSTerm bsTerm = new BSTerm(); bsTerm.Name = txtName.Text; bsTerm.Description = txtDescription.Text; bsTerm.Type = BSTerm.GetTermType(CategoryType); bsTerm.Code = BSHelper.CreateCode(bsTerm.Name); bsTerm.SubID = int.Parse(ddlParentCategory.SelectedValue); if (bsTerm.Save()) { MessageBox1.Message = Language.Admin["CategorySaved"]; MessageBox1.Type = MessageBox.ShowType.Information; gvItems.DataBind(); txtName.Text = string.Empty; txtDescription.Text = string.Empty; } else MessageBox1.Message = Language.Admin["CategoryError"]; } }
public List <BSTerm> GetTags() { return(BSTerm.GetTermsByObjectID(PostID, TermTypes.Tag)); }
public static List<BSTerm> GetTermsByObjectID(int objectId, TermTypes termType) { List<BSTerm> terms = new List<BSTerm>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("ObjectID", objectId); if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] IN (SELECT TermID FROM TermsTo WHERE [ObjectID]=@ObjectID AND [Type]=@Type) ORDER BY Name"); } else { dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] IN (SELECT TermID FROM TermsTo WHERE [ObjectID]=@ObjectID) ORDER BY Name"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return terms; }
public static List<BSTerm> GetTermsBySubID(TermTypes termType, int iSubID) { List<BSTerm> terms = new List<BSTerm>(); using (DataProcess dp = new DataProcess()) { if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [Type]=@Type AND [SubID]=@SubID ORDER BY [Name] ASC"); } else { dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [SubID]=@SubID ORDER BY [Name] ASC"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return terms; }
private static void FillTerm(IDataReader dr, BSTerm bsTerm) { bsTerm.SubID = (int)dr["SubID"]; bsTerm.Name = (string)dr["Name"]; bsTerm.Code = (string)dr["Code"]; bsTerm.Description = dr["Description"].ToString(); string termType = (string)dr["Type"]; bsTerm.Type = GetTermType(termType); bsTerm.TermID = (int)dr["TermID"]; bsTerm.Objects = new List<int>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("TermID", bsTerm.TermID); dp.ExecuteReader("SELECT * FROM TermsTo WHERE [TermID]=@TermID"); if (dp.Return.Status == DataProcessState.Success) using (IDataReader drObjects = (IDataReader)dp.Return.Value) while (drObjects.Read()) bsTerm.Objects.Add((int)drObjects["ObjectID"]); } }
public List <BSTerm> GetCategories() { return(BSTerm.GetTermsByObjectID(PostID, TermTypes.Category)); }
public string GetTagsWithComma() { string html = BSTerm.GetTermsByFormat(TermTypes.Tag, PostID, 0, "{1},"); return(html.Substring(0, html.Length - 1)); }
public static List<BSTerm> GetTermsByContainsName(string name, TermTypes termType, int iTermCount) { List<BSTerm> terms = new List<BSTerm>(); using (DataProcess dp = new DataProcess()) { string top = iTermCount == 0 ? String.Empty : "TOP " + iTermCount; if (termType != TermTypes.All) { string type = termType == TermTypes.Category ? "category" : "tag"; dp.AddParameter("Type", type); dp.AddParameter("Name", name); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Type]=@Type AND [Name] LIKE '%' + @Name + '%' ORDER BY [Name] ASC", top)); } else { dp.AddParameter("Name", name); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Name] LIKE '%' + @Name + '%' ORDER BY [Name] ASC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return terms; }
public string GetTagsHtml(string format) { return(BSTerm.GetTermsByFormat(TermTypes.Tag, PostID, 0, format)); }
public static BSTerm GetTerm(string code, TermTypes type) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Code", code); dp.AddParameter("Type", type.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [Code] = @Code AND [Type]=@Type"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); return bsTerm; } } } } return null; }
public static BSTerm GetTerm(int iTermID, int iSubID, TermTypes type) { using (DataProcess dp = new DataProcess()) { if (iTermID > 0) { if (type == TermTypes.All) { dp.AddParameter("TermID", iTermID); dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] = @TermID"); } else { dp.AddParameter("TermID", iTermID); dp.AddParameter("Type", type.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] = @TermID AND [Type]=@Type"); } } else { if (type == TermTypes.All) { dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [SubID] = @SubID"); } else { dp.AddParameter("SubID", iSubID); dp.AddParameter("Type", type.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [SubID] = @SubID AND [Type]=@Type"); } } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); return bsTerm; } } } } return null; }
public static List<BSTerm> GetTerms(TermTypes termType, int iTermCount) { List<BSTerm> terms = new List<BSTerm>(); using (DataProcess dp = new DataProcess()) { string top = iTermCount == 0 ? String.Empty : "TOP " + iTermCount; if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Type]=@Type ORDER BY [Name] ASC", top)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms ORDER BY [Name] ASC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return terms; }