protected void BindProductCategoriesList() { BPProductCategories bpcat = new BPProductCategories(); DSProductCategories = bpcat.SelectAll(); DSProductCategories.tbl_ProductCategories.DefaultView.Sort = "ProductCategoryOrder"; dgProductCategories.DataBind(); }
protected void BindProductCategories() { BPProductCategories bp = new BPProductCategories(); DSProductCategories = bp.SelectAllActive(); DSProductCategories.tbl_ProductCategories.DefaultView.Sort = "ProductCategoryName"; ddlProductCategories.DataBind(); ddlProductCategories.Items.Insert(0, new ListItem("(All Categories)", "-1")); ddlProductCategories.Items.Insert(1, new ListItem("(Not Assigned)", "0")); }
private void dgProductCategories_ItemCommand(object source, DataGridCommandEventArgs e) { int ProductCategoryID = Convert.ToInt32((e.CommandArgument)); if(e.CommandName == "Up") { BPProductCategories bp = new BPProductCategories(); bp.MoveProductCategoryUp(ProductCategoryID); if(dgProductCategories.SelectedIndex == e.Item.ItemIndex) { if(dgProductCategories.SelectedIndex - 1 >= 0) { dgProductCategories.SelectedIndex = dgProductCategories.SelectedIndex - 1; } else if(dgProductCategories.SelectedIndex == e.Item.ItemIndex - 1) { dgProductCategories.SelectedIndex = dgProductCategories.SelectedIndex + 1; } } BindDSProductCategories(); } else if(e.CommandName == "Down") { BPProductCategories bp = new BPProductCategories(); bp.MoveProductCategoryDown(ProductCategoryID); if(dgProductCategories.SelectedIndex == e.Item.ItemIndex) { if(dgProductCategories.SelectedIndex + 1 <= dgProductCategories.Items.Count - 1) { dgProductCategories.SelectedIndex = dgProductCategories.SelectedIndex + 1; } } else if(dgProductCategories.SelectedIndex == e.Item.ItemIndex + 1 ) { dgProductCategories.SelectedIndex = dgProductCategories.SelectedIndex - 1; } BindDSProductCategories(); } else { Response.Redirect("EditProductCategories.aspx?ProductCategoryID=" + ProductCategoryID); } }
protected void BindProductCategoriesList() { BPProductCategories bpAppCats = new BPProductCategories(); if (ProductCategoryID > 0) { DSProductCategories = bpAppCats.SelectProductCategoryByID(ProductCategoryID); BindProductsList(); } else { DSProductCategories = bpAppCats.SelectAllActive(); } rptProductCategories.DataBind(); }
private string GetProductCategoryTitle(int ProjectCategoryID) { BPProductCategories bp = new BPProductCategories(); DSProductCategories = bp.SelectProductCategoryByID(ProjectCategoryID); BEProductCategories.tbl_ProductCategoriesRow title; title = DSProductCategories.tbl_ProductCategories.FindByProductCategoryID(ProjectCategoryID); if (DSProductCategories.tbl_ProductCategories.Count > 0) { return title.ProductCategoryName; } else { return ""; } }
private void Page_Load(object sender, EventArgs e) { this.AuthenticatePage(new string[] {PermissionLevels.EditProductCategories, PermissionLevels.AddProductCategories, PermissionLevels.ViewProductCategories}); if (ProductCategoryID > 0) { if (this.CarrielUser.RolePermission(PermissionLevels.EditProductCategories) != 2) { btnSubmit.Visible = false; btnDelete.Visible = false; } else { btnSubmit.Visible = true; btnDelete.Visible = true; } } else { if (this.CarrielUser.RolePermission(PermissionLevels.AddProductCategories) != 2) { btnSubmit.Visible = false; } } if(!IsPostBack) { if (ProductCategoryID == 0) { lblTitle.Text = "Add Product Category"; btnDelete.Visible = false; lblActiveWarning.Visible = false; } else { BPProductCategories bpCat = new BPProductCategories(); BEProductCategories ds = bpCat.SelectProductCategoryByID(ProductCategoryID); BEProductCategories.tbl_ProductCategoriesRow category = ds.tbl_ProductCategories.FindByProductCategoryID(ProductCategoryID); txtProductCategoryName.Text = category.ProductCategoryName; lblTitle.Text = "Edit Product Category - " + category.ProductCategoryName; edtProductCategoryDescription.TextBoxText = category.ProductCategoryDescription; chkProductCategoryActive.Checked = category.ProductCategoryActive; lblActiveWarning.Visible = true; } } }
private void btnDelete_Click(object sender, EventArgs e) { // BPProducts bpProducts = new BPProducts(); // DSProducts = bpProducts.SelectLockedProductsByProductCategoryID(ProductCategoryID); // if (DSProducts.tbl_Products.Count > 0) // { // pnlLockedError.Visible = true; // } // else // { BPProductCategories bp = new BPProductCategories(); BEProductCategories.tbl_ProductCategoriesRow ProductCategory; DSProductCategories = bp.SelectProductCategoryByID(ProductCategoryID); ProductCategory = DSProductCategories.tbl_ProductCategories.FindByProductCategoryID(ProductCategoryID); ProductCategory.Delete(); bp.Update(DSProductCategories); bp.UpdateByProductCategoryID(ProductCategoryID); Response.Redirect("BrowseProductCategories.aspx"); // } }
private void btnSubmit_ServerClick(object sender, EventArgs e) { BPProductCategories bp = new BPProductCategories(); BEProductCategories.tbl_ProductCategoriesRow category; DSProductCategories = new BEProductCategories(); //if they are making this category inactive make all items below this category unassigned and inactive if (ProductCategoryID > 0) { bool wasActive = GetProductCategoryActiveStatus(ProductCategoryID); if ((wasActive) && (! chkProductCategoryActive.Checked)) { bp.UpdateByProductCategoryID(ProductCategoryID); } } if (ProductCategoryID == 0) { // Add a Product Category category = DSProductCategories.tbl_ProductCategories.Newtbl_ProductCategoriesRow(); } else { // Edit a Product Category DSProductCategories = bp.SelectProductCategoryByID(ProductCategoryID); category = DSProductCategories.tbl_ProductCategories.FindByProductCategoryID(ProductCategoryID); } //all content to be updated/inserted between here Editor ApplicationContent = edtProductCategoryDescription; string strCategoryDescription = Request.Form[ApplicationContent.Editor_HiddenField].ToString(); category.ProductCategoryName = txtProductCategoryName.Text; category.ProductCategoryDescription = strCategoryDescription; category.ProductCategoryActive = chkProductCategoryActive.Checked; category.DateModified = DateTime.Now; category.ModifiedByAdminID = Convert.ToInt32(CarrielUser.CarrielIdentity.MemberID); //all content to be updated/inserted between here if (ProductCategoryID == 0) { //Add new Product Category category.ProductCategoryOrder = bp.GetProductCategoryMaxOrder(); category.DateCreated = DateTime.Now; DSProductCategories.tbl_ProductCategories.Addtbl_ProductCategoriesRow(category); } bp.Update(DSProductCategories); Response.Redirect("BrowseProductCategories.aspx"); }
protected bool GetProductCategoryActiveStatus(int ProductCategoryID) { BPProductCategories bp = new BPProductCategories(); DSProductCategories = bp.SelectProductCategoryByID(ProductCategoryID); BEProductCategories.tbl_ProductCategoriesRow category = DSProductCategories.tbl_ProductCategories[0]; category = DSProductCategories.tbl_ProductCategories[0]; return category.ProductCategoryActive; }