protected bool OneCategorySelected(ref Telerik.Web.UI.RadTreeView treeView)
{
List<Telerik.Web.UI.RadTreeNode> list = (List<Telerik.Web.UI.RadTreeNode>)treeView.GetAllNodes();
foreach (Telerik.Web.UI.RadTreeNode node in list)
{
if (node.Checked)
return true;
}
return false;
}
protected void GetCheckedCategories(ref Telerik.Web.UI.RadTreeView CategoryTree, string ID)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
List<Telerik.Web.UI.RadTreeNode> list = (List<Telerik.Web.UI.RadTreeNode>)CategoryTree.GetAllNodes();
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
string tagsize = "22";
foreach (Telerik.Web.UI.RadTreeNode node in list)
{
if (node.Checked)
{
if (node.ParentNode != null)
{
tagsize = "16";
}
else
{
tagsize = "22";
}
dat.Execute("INSERT INTO Ad_Category_Mapping (CategoryID, AdID, tagSize) VALUES("
+ node.Value + ", " + ID + ", "+tagsize+")");
}
//foreach (Telerik.Web.UI.RadTreeNode node1 in node.Nodes)
//{
// if (node1.Checked)
// {
// dat.Execute("INSERT INTO Ad_Category_Mapping (CategoryID, AdID, tagSize) VALUES("
// + node1.Value + ", " + ID + ", 16)");
// }
//}
}
}
protected void GetCheckedCategories(ref Telerik.Web.UI.RadTreeView CategoryTree, string ID)
{
List<Telerik.Web.UI.RadTreeNode> list = (List<Telerik.Web.UI.RadTreeNode>)CategoryTree.GetAllNodes();
HttpCookie cookie = Request.Cookies["BrowserDate"];
DateTime isn = DateTime.Now;
if (!DateTime.TryParse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"), out isn))
isn = DateTime.Now;
DateTime isNow = isn;
Data dat = new Data(isn); string tagsize = "22";
foreach (Telerik.Web.UI.RadTreeNode node in list)
{
if (node.Checked)
{
if (node.ParentNode != null)
{
tagsize = "16";
}
else
{
tagsize = "22";
}
dat.Execute("INSERT INTO Ad_Category_Mapping (CategoryID, AdID, tagSize) VALUES("
+ node.Value + ", " + ID + ", "+tagsize+")");
}
}
}
protected void GetCategoriesFromTree(ref Telerik.Web.UI.RadTreeView CategoryTree, bool isAd, ref bool resetAds)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
string categories = "";
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
List<Telerik.Web.UI.RadTreeNode> list = (List<Telerik.Web.UI.RadTreeNode>)CategoryTree.GetAllNodes();
foreach (Telerik.Web.UI.RadTreeNode node in list)
{
DataView dv = dat.GetDataDV("SELECT * FROM UserCategories WHERE CategoryID=" + node.Value +
" AND UserID=" + Session["User"].ToString());
if (node.Checked)
{
if (isAd)
{
dat.Execute("INSERT INTO UserCategories (CategoryID, UserID) VALUES("
+ node.Value + "," + Session["User"].ToString() + ")");
if (dv.Count == 0)
resetAds = true;
}
else
{
dat.Execute("INSERT INTO UserEventCategories (CategoryID, UserID) VALUES("
+ node.Value + "," + Session["User"].ToString() + ")");
}
}
else
{
if (isAd)
{
if (dv.Count != 0)
resetAds = true;
}
}
}
}
protected void SaveSearchCategories(string ID, ref Telerik.Web.UI.RadTreeView CategoryTree)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
List<Telerik.Web.UI.RadTreeNode> list = (List<Telerik.Web.UI.RadTreeNode>)CategoryTree.GetAllNodes();
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
foreach(Telerik.Web.UI.RadTreeNode node in list)
{
if (node.Checked)
{
//SELECT [ID],[SearchID],[CategoryID] from [HippoHappenings].[dbo].[SavedAdSearches_Categories]
dat.Execute("INSERT INTO SavedAdSearches_Categories (SearchID, CategoryID) VALUES("+ID+", "+node.Value+")");
}
}
}
public void returnCategoryIDString(Telerik.Web.UI.RadTreeView CategoryTree, ref string categories)
{
List<Telerik.Web.UI.RadTreeNode> list = (List<Telerik.Web.UI.RadTreeNode>)CategoryTree.GetAllNodes();
foreach (Telerik.Web.UI.RadTreeNode node in list)
{
if (node.Checked)
{
categories += node.Value + ";";
if (node.ParentNode != null)
{
categories += node.ParentNode.Value + ";";
if (node.ParentNode.ParentNode != null)
categories += node.ParentNode.ParentNode.Value + ";";
}
}
}
}
