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");
}
}
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 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;
}
public static void OnDeleted(BSTerm bsTerm, EventArgs e)
{
if (Deleted != null)
{
Deleted(bsTerm, e);
}
}
public static void OnDeleting(BSTerm bsTerm, CancelEventArgs e)
{
if (Deleting != null)
{
Deleting(bsTerm, e);
}
}
public static void OnSaved(BSTerm bsTerm, EventArgs e)
{
if (Saved != null)
{
Saved(bsTerm, e);
}
}
public static void OnSaving(BSTerm bsTerm, CancelEventArgs e)
{
if (Saving != null)
{
Saving(bsTerm, e);
}
}
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;
}
