4PM Task2 successful version(20110318)

Category.aspx

<%@ Page Language="C#" AutoEventWireup="true" Codebehind="Category.aspx.cs" Title="GlobalWebProduct Category" Inherits="_4cm_ie.Admin.Category" MasterPageFile="~/Admin/Admin.Master" EnableEventValidation="false" Trace="false" %><%@ Register Assembly="GWProductWebView" Namespace="GlobalWebProduct.WebView" TagPrefix="cc2" %><%@ Register Assembly="GWProductWebView" Namespace="GWProductWebView.WebView" TagPrefix="cc1" %><asp:Content ID="Content3" runat="server" ContentPlaceHolderID="ContentPlaceHolderSubMenu"> <h2>Category Management</h2></asp:Content><asp:Content ID="Content2" runat="server" ContentPlaceHolderID="ContentPlaceHolderTitle"> <asp:UpdatePanel ID="UpdatePanelCategory" runat="server" UpdateMode="Conditional"> <ContentTemplate> <table style="position: relative; left: 10px; top: 0px;"> <tr> <td colspan="2"> <asp:Panel ID="PanelPagingProduct" Visible="false" runat="server" CssClass="Pager" Width="300px"> </asp:Panel></td> </tr> </table> <br /> <div style="margin-bottom:20px;" mce_style="margin-bottom:20px;"> <table class="CategoryContentTable" style="width: 955px"> <tr> <td style="width:120px; height:50px; text-align: right;" colspan="4" class="CategoryFooter"> <div style="width: 710px;height:50px; float:left;"> <div style="width: 200px;height:50px; float:left;"> </div> <div style="width: 510px;height:50px; float:left;">   <asp:LinkButton ID="btn_edit" CssClass="LinkBtn" runat="server" OnClick="btn_edit_Click" Text="Edit" /> <asp:LinkButton ID="btn_update" runat="server" CssClass="LinkBtn" OnClick="btn_update_Click" Text="Update" Visible="False" />   <asp:LinkButton ID="btn_delete" CssClass="LinkBtn" runat="server" OnClick="btn_delete_Click" Text="Delete" /> <asp:LinkButton ID="btn_cancel" CssClass="LinkBtn" runat="server" OnClick="btn_cancel_Click" Text="Cancel" Visible="False" />   <asp:LinkButton ID="btn_add" CssClass="LinkBtn" runat="server" OnClick="btn_add_Click" Text="Add" /><br /> <br /> <asp:Label ID="lbl_error" CssClass="lblError" runat="server" Visible="false" /> </div> </div> </td> </tr> <tr> <td style="width: 388px;" class="CategoryProductTemplateTable"> <%-- --------------------------- CATEGORY TREEVIEW CONTAINER --------------------------- --%> <div class="TreeView" style="margin-left:0px; width: 371px;"> <asp:TreeView ID="TreeViewCategories" CssClass="TreeViewDis" runat="server" OnSelectedNodeChanged="TreeViewCategories_selectedChanged" ShowLines="True"> </asp:TreeView> </div> </td> <td colspan="3" style="vertical-align:top;padding-left:20px; width: 538px;"> <%-- ---------------------- CATEGORY DETAILS PANEL ---------------------- --%> <asp:Panel ID="PanelCatView" Visible="true" runat="server" Width="540px"> <p class="para01"> Click on the left panel to select a category </p> <cc2:CategoryView ID="CategoryView1" runat="server" AutoGenerateRows="False" CssClass="CategoryView"> <Fields> <asp:BoundField DataField="categoryID" HeaderText="categoryID" SortExpression="categoryID" Visible="False" ItemStyle-CssClass="CategoryTextBox" /> <asp:BoundField DataField="companyID" HeaderText="companyID" SortExpression="companyID" Visible="False" ItemStyle-CssClass="CategoryTextBox" /> <asp:BoundField DataField="name" HeaderText="Name" SortExpression="name" ItemStyle-CssClass="CategoryTextBox" /> <asp:BoundField DataField="parent" HeaderText="Parent category" SortExpression="parentID" ItemStyle-CssClass="CategoryTextBox" /> <asp:BoundField DataField="description" HeaderText="Description" SortExpression="description" ItemStyle-CssClass="CategoryTextBox" /> <asp:ImageField DataImageUrlField="Path" HeaderText="Image" ItemStyle-CssClass="CategoryTextBox" /> <asp:BoundField DataField="Lock" HeaderText="Permanent Category" SortExpression="Lock" ItemStyle-CssClass="CategoryTextBox" /> </Fields> <FieldHeaderStyle CssClass="CategoryHeader" /> </cc2:CategoryView> </asp:Panel> <%-- ---------------------------------- FORM USED TO CREATE NEW CATEGORIES ---------------------------------- --%> <asp:Panel ID="PanelCatAdd" runat="server" Visible="false"> <table class="CategoryView"> <tr> <td class="CategoryHeader">Name</td> <td class="CategoryTextBox"> <asp:TextBox Width="398px" ID="tbNameAdd" runat="server"></asp:TextBox></td> </tr> <tr> <td class="CategoryHeader">Parent category</td> <td class="CategoryTextBox"> <cc1:CategoryList ID="CategoryListAdd" Visible="false" Width="300px" runat="server"></cc1:CategoryList> <asp:Label ID="lblAddParentCategory" Width="300px" Enabled="true" runat="server"></asp:Label><br /> <asp:Label ID="lblAddParentInfo" runat="server" CssClass="infoLabel">Select a parent from the left tree view <b>OR</b> set parent to </asp:Label> <asp:Button ID="BtnAddParentReset" Text="none" CssClass="infoButton" ToolTip="Click here to set the parent category to none" runat="server" OnClick="btnAddParentReset_Click" Width="35px" Height="16px" /> </td> </tr> <tr> <td class="CategoryHeader">Description</td> <td class="CategoryTextBox"><asp:TextBox Width="397px" ID="tbDescriptionAdd" runat="server"></asp:TextBox></td> </tr> <tr> <td class="CategoryHeader">Image</td> <td class="CategoryTextBox"> <!-- <asp:FileUpload ID="FileUpCatAdd" Enabled="true" runat="server" /><br /> Put in comment by JP 25/01/2011 currently note working and not used by custumers <asp:LinkButton ID="lbCatAdd" CssClass="LinkBtn" runat="server" Text="Upload" OnClick="UploadImage"></asp:LinkButton> --> </td> </tr> <tr> <td class="CategoryHeader">Permanent Category</td> <td class="CategoryTextBox"><asp:CheckBox ID="cbCatLockAdd" runat="server" OnCheckedChanged="LockChanged" /></td> </tr> </table> </asp:Panel> <%-- ------------------------------------- FORM USED TO EDIT EXISTING CATEGORIES ------------------------------------- --%> <asp:Panel ID="PanelCatEdit" Visible="false" runat="server"> <table class="CategoryView"> <tr> <td class="CategoryHeader">Name</td> <td class="CategoryTextBox"> <asp:TextBox Width="399px" ID="tbCategoryIDEdit" runat="server" Visible="false"></asp:TextBox> <asp:TextBox Width="400px" ID="tbFileServerIDEdit" runat="server" Visible="false"></asp:TextBox> <asp:TextBox Width="397px" ID="tbNameEdit" runat="server"></asp:TextBox> </td> </tr> <tr> <td class="CategoryHeader">Parent category</td> <td class="CategoryTextBox"> <cc1:CategoryList ID="CategoryListEdit" Visible="false" Width="300px" runat="server"></cc1:CategoryList> <asp:Label ID="lblEditParentCategory" Width="300px" Enabled="true" runat="server"></asp:Label> <asp:Label ID="warning" runat="server" Text="" ForeColor="Red" ></asp:Label> <br /> <asp:Label ID="lblEditParentInfo" runat="server" CssClass="infoLabel">Select the parent in the left tree view <b>OR</b> set parent to </asp:Label> <asp:Button ID="BtnEditParentReset" Text="none" CssClass="infoButton" ToolTip="Click here to set the parent category to none" runat="server" onclick="bntEditParentReset_Click" Height="16px" Width="37px"/> </td> </tr> <tr> <td class="CategoryHeader">Description</td> <td class="CategoryTextBox"><asp:TextBox Width="400px" ID="tbDescEdit" runat="server"></asp:TextBox></td> </tr> <tr> <td class="CategoryHeader">Image</td> <td class="CategoryTextBox"> <asp:Label ID="tbImageEdit" runat="server" Visible="false"></asp:Label> <asp:Image ID="imgCatEdit" runat="server" /> <asp:FileUpload ID="FileUploadEdit" Enabled="true" runat="server" /><br /> <asp:LinkButton ID="lbUploadEdit" CssClass="LinkBtn02" runat="server" Text="Change image" OnClick="UploadImage"></asp:LinkButton> <asp:HiddenField ID="agent" runat="server" /> </td> </tr> <tr> <td class="CategoryHeader">Permanent Category</td> <td class="CategoryTextBox"><asp:CheckBox ID="cbCatLockEdit" runat="server" OnCheckedChanged="LockChanged" /></td> </tr> </table> </asp:Panel> </td> </tr> </table> </div> <div> <asp:Panel ID="CatProductPagePanel" Visible="true" runat="server" CssClass="PagingPanel"></asp:Panel> <br /> <br /> <cc1:CategoryProductDataList ID="CatProductDataList" runat="server" CssClass="CategoryProductDataList" style="border-spacing:0" mce_style="border-spacing:0"></cc1:CategoryProductDataList> </div> </ContentTemplate> <Triggers> <asp:PostBackTrigger ControlID="lbCatAdd" /> <asp:PostBackTrigger ControlID="lbUploadEdit" /> <asp:PostBackTrigger ControlID="btn_add" /> <asp:PostBackTrigger ControlID="btn_edit" /> <asp:PostBackTrigger ControlID="btn_delete" /> <asp:PostBackTrigger ControlID="btn_update" /> <asp:PostBackTrigger ControlID="btn_cancel" /> </Triggers> </asp:UpdatePanel> </asp:Content>

 

Category.aspx.cs

using System;using System.Collections.Generic;using System.Reflection;using System.Web.UI;using System.Web.UI.WebControls;using GlobalWebProduct.Database;using GlobalWebProduct.Other;using GlobalWebProduct.WebController;using GlobalWebProduct.WebView;using GWProductWebView.Code;using GWProductWebView.WebView;namespace _4cm_ie.Admin{ public partial class Category : System.Web.UI.Page { private const String _ADDMODE = "add"; private const String _EDITMODE = "edit"; private const String _DEFAULTMODE = "default"; //private CategoryList SearchCategoryList; public int selectedId = -1; /// <summary> /// Deleting popup /// </summary> public MessageBox msgBox; /// <summary> /// Page load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { FileServerAPI.Database.Database.init(Const.ImageSmartFSID, Const.ImageSmartAccessCode); Database.init(); if (IsPostBack) { if (!SessionRestorePageVariables(this) || Session.IsNewSession) { Response.Redirect(this.Request.RawUrl); } } if (!IsPostBack) msgBox = new MessageBox(); InitMessageBox(msgBox); if (Session["Mode"] == null) Session.Add("Mode", _DEFAULTMODE); if (FileUploadEdit.HasFile) Session.Add("FileUpEdit", FileUploadEdit.PostedFile); setButtonValue(true, true, true, false, false); CategoryView1.OnLoad(IsPostBack, (int)Session["CompanyID"]); //SearchCategoryList = new CategoryList((int)Session["CompanyID"]); //SearchCategoryList.ID = "CategoryList1"; //Place.Controls.Add(SearchCategoryList); CategoryListEdit.CompanyID = (int)Session["CompanyID"]; CategoryListEdit.ShowAll = false; CategoryListEdit.ShowNone = true; CategoryListAdd.CompanyID = (int)Session["CompanyID"]; CategoryListAdd.ShowAll = false; CategoryListAdd.ShowNone = true; CatProductDataList.PAGE_SIZE = 50; CatProductDataList.PagingPanel = CatProductPagePanel; CategoryView1.CatProdDataList = CatProductDataList; #region "Parent ID" if (IsPostBack) { if (Session["ParentAdd"] == null) { if (!CategoryListAdd.SelectedItem.Text.Equals("None")) Session.Add("ParentAdd", CategoryListAdd.SelectedItem.Value); else Session.Add("ParentAdd", CategoryListAdd.SelectedItem.Text); } else { if (!CategoryListAdd.SelectedItem.Text.Equals("None")) Session["ParentAdd"] = CategoryListAdd.SelectedItem.Value; else Session["ParentAdd"] = CategoryListAdd.SelectedItem.Text; } if (Session["ParentEdit"] == null) { if (!CategoryListEdit.SelectedItem.Text.Equals("None")) Session.Add("ParentEdit", CategoryListEdit.SelectedItem.Value); else Session.Add("ParentEdit", CategoryListEdit.SelectedItem.Text); } else { if (!CategoryListEdit.SelectedItem.Text.Equals("None")) Session["ParentEdit"] = CategoryListEdit.SelectedItem.Value; else Session["ParentEdit"] = CategoryListEdit.SelectedItem.Text; } } #endregion //CategoryView1.PageIndexChanged += new EventHandler(CategoryView_PageIndexChanged); // Will allow the page to be posted back when one item will be selected //SearchCategoryList.AutoPostBack = true; //SearchCategoryList.SelectedIndex = 1; //SearchCategoryList.ShowNone = true; //SearchCategoryList.ShowAll = false; //SearchCategoryList.SelectedIndexChanged += new EventHandler(SearchCategoryList_SelectedIndexChanged); #region "TreeviewLoad" if (!IsPostBack) { int idWebsite = 1; idWebsite = (int)Session["CompanyID"]; CompanyView.treeViewFill(TreeViewCategories, idWebsite); // Bug fix : makes the first click work when you just load the category page // Actually selects the first node of the treeview and fires the selectedindexchanged // event for this treeview if (TreeViewCategories.Nodes.Count > 0) { TreeViewCategories.Nodes[0].Selected = true; TreeViewCategories_selectedChanged(this, new EventArgs()); } } #endregion } //void CategoryView_PageIndexChanged(object sender, EventArgs e) //{ // try // { // String newCateg = Convert.ToString(Session["_CategoryCV"]); // SearchCategoryList.SelectedValue = newCateg; // } // catch (Exception ex) { } //} void CategoryView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e) { CatProductDataList.DataBind(); } /// <summary> /// Method launched on search category dropdown list index changed /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //protected void SearchCategoryList_SelectedIndexChanged(object sender, EventArgs e) //{ // String res = SearchCategoryList.SelectedItem.Text; // if (Session["categoryFindIndex"] == null) // Session.Add("categoryFindIndex", res); // else // Session["categoryFindIndex"] = res; // int selectedPageIndex = ((List<CategoryView.Data>)CategoryView1.DataSource).FindIndex(FindIndexCatName); // int selectedCategID = Convert.ToInt32(SearchCategoryList.SelectedItem.Value); // CategoryView1.PageIndex = selectedPageIndex; // CategoryView1.DataBind(); // Session["_CategoryCV"] = selectedCategID; // CategoryView1.CatProdDataList.CategoryID = selectedCategID; // CategoryView1.CatProdDataList.Refresh(new DetailsViewPageEventArgs(selectedPageIndex)); //} /// <summary> /// Performed whe the page is unload /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Unload(object sender, EventArgs e) { SaveSessionVariable(); } /// <summary> /// Restore the public variable of the page /// </summary> /// <param name="thisPage"></param> /// <returns></returns> protected bool SessionRestorePageVariables(Page thisPage) { try { foreach (FieldInfo field in thisPage.GetType().GetFields()) { field.SetValue(thisPage, thisPage.Session[field.Name]); } return true; } catch (Exception) { return false; } } /// <summary> /// Save the public variable in session variable /// </summary> protected void SaveSessionVariable() { foreach (FieldInfo field in this.GetType().GetFields()) { this.Session[field.Name] = field.GetValue(this); } } /// <summary> /// Initialize the deleting popup /// </summary> /// <param name="msgBx"></param> protected void InitMessageBox(MessageBox msgBx) { msgBx.EnableButton1("Yes", new System.EventHandler(btn_deleteValid_Click)); msgBx.EnableButton2("No", new System.EventHandler(btn_deleteRefuse_Click)); msgBx.RegisterInPage(this.UpdatePanelCategory.ContentTemplateContainer); } /// <summary> /// Method launch on EditButton click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_edit_Click(object sender, EventArgs e) { lblEditParentCategory.ForeColor = System.Drawing.Color.Black; //init font-color if (((List<CategoryView.Data>)(CategoryView1.DataSource)).Count != 0) { Session["Mode"] = _EDITMODE; if (Session["FileServerID"] != null) Session.Remove("FileServerID"); setButtonValue(false, false, false, true, true); PanelCatAdd.Visible = false; PanelCatEdit.Visible = true; PanelCatView.Visible = false; //Place.Visible = false; //TreeViewCategories.Enabled = false; CategoryView.Data tmp = ((List<CategoryView.Data>)(CategoryView1.DataSource))[CategoryView1.DataItemIndex]; ((List<GlobalWebProduct.Models.Category>)CategoryListEdit.DataSource).RemoveAll(RetrieveByCategoryID); CategoryListEdit.DataBind(); tbNameEdit.Text = tmp.name.Trim(); tbCategoryIDEdit.Text = tmp.categoryID.ToString(); tbDescEdit.Text = tmp.description; tbImageEdit.Text = tmp.image; tbFileServerIDEdit.Text = tmp.FileServerID.ToString(); cbCatLockEdit.Checked = tmp.Lock; imgCatEdit.ImageUrl = tmp.Path; if (!tmp.parent.Equals("")) { CategoryListEdit.SelectedIndex = CategoryListEdit.Items.IndexOf(CategoryListEdit.Items.FindByText(tmp.parent)); // TreeViewCategories.SelectedNode.Value = tmp.ParentID.ToString(); lblEditParentCategory.Text = tmp.parent; } else { CategoryListEdit.SelectedIndex = CategoryListEdit.Items.IndexOf(CategoryListEdit.Items.FindByText("None")); lblEditParentCategory.Text = "None"; lblEditParentCategory.ForeColor = System.Drawing.Color.Gray; lblEditParentCategory.Font.Italic = true; } CatProductDataList.Visible = false; } String parentss = Convert.ToString(TreeViewCategories.SelectedNode.Value); // get the selected node's value agent.Value = parentss; // save this value in a hiddenfield for calling in TreeViewCategories_selectedChanged method } /// <summary> /// Method launch on UpdateButton click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_update_Click(object sender, EventArgs e) { if (lblEditParentCategory.Text == "None") lblEditParentCategory.Text = ""; int fileID; if (Session["FileServerID"] == null) fileID = -1; else fileID = (int)Session["FileServerID"]; int catid; if (Session["Mode"].Equals(_EDITMODE)) catid = int.Parse(tbCategoryIDEdit.Text); else catid = 0; int? parentid = null; if (!lblEditParentCategory.Text.Equals("") && Session["Mode"].Equals(_EDITMODE)) parentid = Convert.ToInt32(TreeViewCategories.SelectedNode.Value); if (!lblAddParentCategory.Text.Equals("") && Session["Mode"].Equals(_ADDMODE)) parentid = Convert.ToInt32(TreeViewCategories.SelectedNode.Value); String name = ""; String description = ""; bool _lock = false; if (Session["Mode"].Equals(_EDITMODE)) { name = tbNameEdit.Text.Trim(); description = tbDescEdit.Text; _lock = cbCatLockEdit.Checked; } if (Session["Mode"].Equals(_ADDMODE)) { name = tbNameAdd.Text.Trim(); description = tbDescriptionAdd.Text; _lock = cbCatLockAdd.Checked; } // Delete special characters for url encode if (veriForm() == true) { name = FormatName(name); CategoryController.UpdateCategory(catid, parentid, (int)Session["CompanyID"], name, description, fileID, _lock); if (Session["Mode"].Equals(_ADDMODE)) { tbDescriptionAdd.Text = ""; tbNameAdd.Text = ""; cbCatLockAdd.Checked = false; CategoryListAdd.Refresh(e); } setButtonValue(true, true, true, false, false); PanelCatAdd.Visible = false; PanelCatEdit.Visible = false; PanelCatView.Visible = true; //Place.Visible = true; CatProductDataList.Visible = true; TreeViewCategories.Nodes.Clear(); CompanyView.treeViewFill(TreeViewCategories, (int)Session["CompanyID"]); TreeViewCategories.ExpandAll(); Session["Mode"] = _DEFAULTMODE; CategoryView1.DataBind(); //SearchCategoryList.DataBind(); //Literal1.Text = GetLiteral(); //SearchCategoryList.Refresh(e); CategoryView1.OnLoad(false, (int)Session["CompanyID"]); if (lbl_error.Visible.Equals(true)) lbl_error.Visible = false; if (Session["Mode"].Equals(_ADDMODE)) CategoryView1.PageIndex = CategoryView1.PageCount; } } /// <summary> /// Method that check if the form is correctly filled in /// </summary> protected bool veriForm() { bool r = true; if (Session["Mode"].Equals(_ADDMODE) && tbNameAdd.Text.Equals("")) { lbl_error.Text = "Please enter a category name !"; lbl_error.Visible = true; r=false; } if (Session["Mode"].Equals(_EDITMODE)) { GlobalWebProduct.Models.Category cat; GlobalWebProduct.Models.Category catParent; if (!selectedId.Equals("")) { cat = GlobalWebProduct.Models.Category.getFromId(int.Parse(tbCategoryIDEdit.Text)); catParent = GlobalWebProduct.Models.Category.getFromId(Convert.ToInt32( TreeViewCategories.SelectedNode.Value)); if (catParent.ParentID.Equals(cat.CategoryID)) { lbl_error.Text = "Please enter a valid parent !"; lbl_error.Visible = true; r = false; } } if (tbNameEdit.Text.Equals("")) { lbl_error.Text = "Please enter a category name !"; lbl_error.Visible = true; r = false; } } setButtonValue(false, false, false, true, true); return r; } /// <summary> /// Method launch on CancelButton click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_cancel_Click(object sender, EventArgs e) { setButtonValue(true, true, true, false, false); PanelCatAdd.Visible = false; PanelCatEdit.Visible = false; PanelCatView.Visible = true; //Place.Visible = true; CatProductDataList.Visible = true; lbl_error.Visible = false; warning.Visible = false; Session["Mode"] = _DEFAULTMODE; } /// <summary> /// Method launch on DeleteButton click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_delete_Click(object sender, EventArgs e) { if (((List<CategoryView.Data>)(CategoryView1.DataSource)).Count != 0) { msgBox.Title = "Delete Category?"; CategoryView.Data tmp = ((List<CategoryView.Data>)(CategoryView1.DataSource))[CategoryView1.DataItemIndex]; if (tmp.Lock) { msgBox.Message = "Deleting a permanent category may provoke errors/nin your website. Continue?"; } else { msgBox.Message = "You're deleting data. The category will be deleted, and its subcategories and products too. Continue?"; } msgBox.Show(); } } /// <summary> /// Method launch on btn_deleteValid click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_deleteValid_Click(object sender, EventArgs e) { CategoryView.Data tmp = ((List<CategoryView.Data>)(CategoryView1.DataSource))[CategoryView1.DataItemIndex]; CategoryController.DeleteCategory(tmp.categoryID); msgBox.Close(); CategoryView1.DataBind(); //SearchCategoryList.DataBind(); //SearchCategoryList.Refresh(e); CategoryView1.OnLoad(false, (int)Session["CompanyID"]); //TreeViewCategories.Enabled = true; TreeViewCategories.Nodes.Clear(); CompanyView.treeViewFill(TreeViewCategories, (int)Session["CompanyID"]); TreeViewCategories.ExpandAll(); } /// <summary> /// Method launch on btn_deleteRefuse click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_deleteRefuse_Click(object sender, EventArgs e) { msgBox.Close(); } /// <summary> /// Method launch on AddButton click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_add_Click(object sender, EventArgs e) { Session["Mode"] = _ADDMODE; PanelCatAdd.Visible = true; PanelCatView.Visible = false; CategoryListAdd.ShowAll = false; //Place.Visible = false; CatProductDataList.Visible = false; setButtonValue(false, false, false, true, true); lblAddParentCategory.Text = ""; } /// <summary> /// Set the "Visible" attribut of the buttons /// </summary> /// <param name="edit"></param> /// <param name="delete"></param> /// <param name="add"></param> /// <param name="update"></param> /// <param name="cancel"></param> protected void setButtonValue(bool edit, bool delete, bool add, bool update, bool cancel) { btn_edit.Visible = edit; btn_add.Visible = add; btn_delete.Visible = delete; btn_update.Visible = update; btn_cancel.Visible = cancel; } /// <summary> /// Predicate used to find index /// </summary> /// <param name="c"></param> /// <returns></returns> protected bool FindIndexCatName(CategoryView.Data c) { return c.name.Equals((Page.Session["categoryFindIndex"]).ToString()); } /// <summary> /// Perform action when checkbox lock change /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LockChanged(object sender, EventArgs e) { System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)sender; if (!cb.Checked) { /*Later replace by MessageBox DialogResult dr = MessageBox.Show("If you unlock a category, /n errors can appear on your website./n Do you want to continue?", "Unlock confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2); if (dr != DialogResult.Yes) cb.Checked = true;*/ } } /// <summary> /// Upload function /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void UploadImage(object sender, EventArgs e) { LinkButton send = (LinkButton)sender; if (send.ID == "lbCatAdd") { if (FileUpCatAdd.HasFile) { FileServerAPI.File.File f = new FileServerAPI.File.File(FileUpCatAdd.PostedFile); Session.Add("FileServerID", f.Id); } else Session.Add("FileServerID", -1); } else if (send.ID == "lbUploadEdit") { if (!tbFileServerIDEdit.Text.Equals("-1")) { int catid = int.Parse(tbCategoryIDEdit.Text); FileServerAPI.File.File deleteF = new FileServerAPI.File.File(int.Parse(tbFileServerIDEdit.Text)); deleteF.delete(); GlobalWebProduct.Models.Category tmpc = GlobalWebProduct.Models.Category.getFromId(catid); tmpc.FileServerID = -1; tmpc.update(); } if (FileUploadEdit.HasFile) { Session.Add("FileServerID", FileUploadEdit.PostedFile.Upload()); } else Session.Add("FileServerID", -1); } setButtonValue(false, false, false, true, true); } private bool RetrieveByCategoryID(GlobalWebProduct.Models.Category c) { CategoryView.Data tmp = ((List<CategoryView.Data>)(CategoryView1.DataSource))[CategoryView1.DataItemIndex]; if (c.CategoryID.Equals(tmp.categoryID)) return true; else return false; } /***************************************************************/ protected void TreeViewCategories_selectedChanged(Object sender, EventArgs e) { selectedId = Convert.ToInt32(TreeViewCategories.SelectedNode.Value); String res = CompanyView.GetCategoryName(selectedId); if (CategoryView1.Visible != false) // if loop is used to before edit select { lblAddParentCategory.Text = res; lblEditParentCategory.Text = res; if (Session["categoryFindIndex"] == null) Session.Add("categoryFindIndex", res); else Session["categoryFindIndex"] = res; int selectedPageIndex = ((List<CategoryView.Data>)CategoryView1.DataSource).FindIndex(FindIndexCatName); int selectedCategID = selectedId; CategoryView1.PageIndex = selectedPageIndex; CategoryView1.DataBind(); Session["_CategoryCV"] = selectedCategID; CategoryView1.CatProdDataList.CategoryID = selectedCategID; CategoryView1.CatProdDataList.Refresh(new DetailsViewPageEventArgs(selectedPageIndex)); } else //else loop is used to after edit select { // CatProductDataList is used as a flag because the wrong buttons appears when the treeview is clicked if (!CatProductDataList.Visible) setButtonValue(false, false, false, true, true); lblEditParentCategory.Visible = true; warning.Visible = true; warning.Text = ""; String newparent = Convert.ToString(TreeViewCategories.SelectedNode.Value); //change a new parent from treeview string strString = TreeViewCategories.SelectedNode.ValuePath; //get selectednode's value path as "1/2/3" format string[] strArray; // declear a array strArray = strString.Split('/'); // cut value path to some substring and save into array int count = strArray.Length; // get the the count of substring lblEditParentCategory.Text = Convert.ToString(TreeViewCategories.SelectedNode.Text); String editvalue = Convert.ToString(agent.Value); // get the need edit node's value for (int i = 0; i < count; i++) { if (editvalue == strArray[i]) //compare with old node and new node's parent, if new node's parent have old node, can not be choosed { lblEditParentCategory.Visible = false; warning.Text = "Error!!! Can not choose this one as the parent!!!"; setButtonValue(false, false, false, false, true); // Hide update button } } } } /// <summary> /// Function to format a String, deleting special characters /// </summary> /// <param name="name"></param> protected String FormatName(String name) { // Deleting left and right spaces name = name.Trim(); // Replacing special characters in the name (to avoid url rewriting problems) //name = name.Replace("&", "and"); name = name.Replace("/", "-"); name = name.Replace("/"", ""); // Deleting dots at the end of the name (to avoid conflicts with .aspx extensions) while (name.LastIndexOf('.') == name.Length - 1) { name = name.Substring(0, name.LastIndexOf('.')); } return name; } protected void btnAddParentReset_Click(object sender, EventArgs e) { setButtonValue(false, false, false, true, true); lblAddParentCategory.Text = ""; } protected void bntEditParentReset_Click(object sender, EventArgs e) { setButtonValue(false, false, false, true, true); lblEditParentCategory.Text = "None"; lblEditParentCategory.ForeColor = System.Drawing.Color.Gray; lblEditParentCategory.Font.Italic = true; warning.Visible = false; //set warning lable as false } }}

 

 

webconfig中的 关于数据的信息

 

<add name="GlobalWebProduct.Properties.Settings.ImageSmartConnectionString" connectionString="Data Source=sql.4pm.ie;Initial Catalog=ImageSmart;Persist Security Info=True;User ID=ImageSmart;Password=1mage5mart" providerName="System.Data.SqlClient"/>