protected void BindProductCategoriesList() { BPProductCategories bpcat = new BPProductCategories(); DSProductCategories = bpcat.SelectAll(); DSProductCategories.tbl_ProductCategories.DefaultView.Sort = "ProductCategoryOrder"; dgProductCategories.DataBind(); }
public BEProductCategories SelectAllInactive() { BEProductCategories ds = new BEProductCategories(); DAProductCategories da = new DAProductCategories(); da.SelectAllInactive((DataTable)ds.tbl_ProductCategories); return ds; }
public BEProductCategories SelectProductCategoryByID(int ProductCategoryID) { BEProductCategories ds = new BEProductCategories(); DAProductCategories da = new DAProductCategories(); da.SelectByID(ProductCategoryID.ToString(), (DataTable)ds.tbl_ProductCategories); return ds; }
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")); }
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 ""; } }
public void Update(BEProductCategories ds) { DAProductCategories da = new DAProductCategories(); da.Update((DataTable)ds.tbl_ProductCategories); }
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; }