private void BindDSProducts() { // ------------------------------------------------------------------------ // Implement paging based upon the lettering filter specified BPProducts bp = new BPProducts(); if (ddlProductCategories.SelectedValue == "-1") { DSProducts = bp.SelectAllWithProductCategories(); } else { DSProducts = bp.SelectByProductCategoryID(Convert.ToInt32(ddlProductCategories.SelectedValue)); } DSProducts.tbl_Products.DefaultView.RowFilter = RowFilter("ProductName", "ProductActive"); DSProducts.tbl_Products.DefaultView.Sort = "ProductName"; letters_Bind(); dgProduct.DataBind(); SetPagerButtons(); if (DSProducts.tbl_Products.DefaultView.Count == 0) { lblError.Visible = true; lblError.Text = "0 Records found."; } else { lblError.Visible = false; lblError.Text = ""; } }
private void btnDeleteProductAttribute_Click(object sender, EventArgs e) { BEProducts.tbl_ProductAttributesRow attribute; BPProducts bp = new BPProducts(); BEProducts DSProducts = bp.SelectProductAttributesByProductID(ProductID); attribute = DSProducts.tbl_ProductAttributes.FindByProductAttributeID(ProductAttributeID); attribute.Delete(); bp.UpdateProductAttributes(DSProducts); ViewProductAttributes(); }
private void SaveProductAttributes() { BEProducts.tbl_ProductAttributesRow attribute; BPProducts bp = new BPProducts(); BEProducts DSProducts = bp.SelectProductAttributesByProductID(ProductID); if (ProductAttributeID == 0) { attribute = DSProducts.tbl_ProductAttributes.Newtbl_ProductAttributesRow(); attribute.DateCreated = DateTime.Now; } else { attribute = DSProducts.tbl_ProductAttributes.FindByProductAttributeID(ProductAttributeID); } attribute.ProductAttributeName = txtProductAttributeName.Text; attribute.ProductAttributeImageID = ddlProductAttributeImage.SelectedImage; attribute.ProductID = ProductID; attribute.ProductAttributeActive = chkProductAttributeActive.Checked; attribute.ModifiedByAdminID = Convert.ToInt32(CarrielUser.CarrielIdentity.MemberID); attribute.DateModified = DateTime.Now; if (ProductAttributeID == 0) { DSProducts.tbl_ProductAttributes.Rows.Add(attribute); } bp.UpdateProductAttributes(DSProducts); if (!attribute.IsProductAttributeImageIDNull()) { MWUtility.CreateResizedImage(attribute.ProductAttributeImageID, "att", "", AttributeImageSize, 0, this); } ViewProductAttributes(); }
private void ViewProductAttributes() { BPProducts bp = new BPProducts(); DSProducts = bp.SelectProductAttributesByProductID(ProductID); dgProductAttributes.DataBind(); dgProductAttributes.SelectedIndex = -1; tabViewProductAttributes.Attributes["class"] = "current"; tabAddProductAttributes.Attributes["class"] = ""; pnlAddProductAttributes.Visible = false; pnlViewProductAttributes.Visible = true; }
private void AddProductAttributes() { if (ProductAttributeID != 0) { BPProducts bp = new BPProducts(); BEProducts.tbl_ProductAttributesRow row = bp.SelectProductAttributesByProductID(ProductID).tbl_ProductAttributes.FindByProductAttributeID(ProductAttributeID); txtProductAttributeName.Text = row.ProductAttributeName; ddlProductAttributeImage.SelectedImage = row.ProductAttributeImageID; chkProductAttributeActive.Checked = row.ProductAttributeActive; btnDeleteProductAttribute.Visible = true; } else { txtProductAttributeName.Text = ""; ddlProductAttributeImage.SelectedImage = -1; chkProductAttributeActive.Checked = false; btnDeleteProductAttribute.Visible = false; } tabAddProductAttributes.Attributes["class"] = "current"; tabViewProductAttributes.Attributes["class"] = ""; pnlViewProductAttributes.Visible = false; pnlAddProductAttributes.Visible = true; }
private void SaveRelatedProducts() { ArrayList _NewRelatedProductIDs = SelectedProductsList; BEProducts.tbl_RelatedProductsRow relatedProduct; BPProducts bp = new BPProducts(); BEProducts DSProducts = new BEProducts(); bp.DeleteRelatedProductsByProductID(ProductID); foreach (object tmpProdID in _NewRelatedProductIDs) { relatedProduct = DSProducts.tbl_RelatedProducts.Newtbl_RelatedProductsRow(); relatedProduct.ProductID = ProductID; relatedProduct.RelatedProductID = Convert.ToInt32(tmpProdID); relatedProduct.DateCreated = DateTime.Now; relatedProduct.DateModified = DateTime.Now; relatedProduct.ModifiedByAdminID = Convert.ToInt32(CarrielUser.CarrielIdentity.MemberID); DSProducts.tbl_RelatedProducts.Addtbl_RelatedProductsRow(relatedProduct); } bp.UpdateRelatedProducts(DSProducts); ViewRelatedProducts(); }
// private void lstActive_SelectedIndexChanged(object sender, System.EventArgs e) // { // int active; // if (lstActive != null) // { // active = Convert.ToInt32(lstActive.SelectedValue); // } // else // { // active = -1; // } // } protected void txtInv_TextChanged(object sender, EventArgs e) { lblError.Text = string.Empty; lblError.Visible = false; try { int prodID = Convert.ToInt32(((LinkButton)((TextBox)sender).Parent.Parent.FindControl("lnkName")).CommandArgument); BPProducts bp = new BPProducts(); BEProducts.tbl_ProductsRow product; DSProducts = new BEProducts(); DSProducts = bp.SelectProductsByID(prodID); product = DSProducts.tbl_Products.FindByProductID(prodID); product.ProductInventoryLevel = Convert.ToInt32(((TextBox)sender).Text); bp.Update(DSProducts); } catch (FormatException) { lblError.Text = "Please enter a number under unit count."; lblError.Visible = true; } }
private void rptProductsList_ItemDataBound(object sender, RepeaterItemEventArgs e) { if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) { BEProducts.tbl_ProductsRow product = (BEProducts.tbl_ProductsRow) ((DataRowView) e.Item.DataItem).Row; Image imgProductThumb = (Image) e.Item.FindControl("imgProductThumb"); if (product.IsProductImageIDNull()) { imgProductThumb.Visible = false; } BEProducts dsAttributes = new BEProducts(); BPProducts bp = new BPProducts(); dsAttributes = bp.SelectActiveProductAttributesByProductID(product.ProductID); dgAttributes.DataBind(); DropDownList tmpDropDown = ((DropDownList)e.Item.FindControl("ddlAttributes")); if (dsAttributes.tbl_ProductAttributes.Rows.Count == 0) { e.Item.FindControl("lnkChooseAttribute").Visible = false; tmpDropDown.Visible = false; }else { tmpDropDown.DataSource = dsAttributes.tbl_ProductAttributes; tmpDropDown.DataTextField = "ProductAttributeName"; tmpDropDown.DataValueField = "ProductAttributeID"; tmpDropDown.DataBind(); tmpDropDown.Items.Insert(0,new ListItem("Choose A Color","0")); } } }
protected void FillAvailableProducts() { ddlAvailableProducts.Items.Clear(); BPProducts bp = new BPProducts(); if (ddlRelatedProductsCategories.SelectedIndex == 0) { DSProducts = bp.SelectNonRelatedProductsByProductID(ProductID); }else{ DSProducts = bp.SelectNonRelatedProductsByProductIDAndProductCategoryID(ProductID,Convert.ToInt32(ddlRelatedProductsCategories.SelectedValue)); } DSProducts.tbl_Products.DefaultView.Sort = "ProductName"; ddlAvailableProducts.DataTextField = "ProductName"; ddlAvailableProducts.DataValueField = "RelatedProductID"; ddlAvailableProducts.DataBind(); }
private void ViewRelatedProducts() { BPProducts bp = new BPProducts(); DSProducts = bp.SelectRelatedProductsByProductID(ProductID); dgRelatedProducts.DataBind(); }
private void btnDelete_Click(object sender, EventArgs e) { BPProducts bp = new BPProducts(); BEProducts.tbl_ProductsRow Product; DSProducts = bp.SelectProductsByID(ProductID); Product = DSProducts.tbl_Products.FindByProductID(ProductID); Product.Delete(); bp.Update(DSProducts); Response.Redirect("BrowseProducts.aspx"); }
private void btnSubmit_ServerClick(object sender, EventArgs e) { BPProducts bp = new BPProducts(); BEProducts.tbl_ProductsRow Product; DSProducts = new BEProducts(); if (ProductID == 0) { // Add new product Product = DSProducts.tbl_Products.Newtbl_ProductsRow(); hdnProductInventoryLevel.Value = txtProductInventoryLevel.Text; } else { // Edit a Product DSProducts = bp.SelectProductsByID(ProductID); Product = DSProducts.tbl_Products.FindByProductID(ProductID); } //all content to be updated/inserted between here Editor ProductDescription = edtProductDescription; string strProductDescription = Request.Form[ProductDescription.Editor_HiddenField].ToString(); Product.ProductName = txtProductName.Text; Product.ProductDescription = strProductDescription; Product.ProductCategoryID = Convert.ToInt32(ddlProductCategories.SelectedValue); if(Product.ProductCategoryID == -1) { Product.ProductCategoryID = 0; } if(txtProductPrice.Text != "") { Product.ProductPrice = Convert.ToDecimal(txtProductPrice.Text); } else { Product.ProductPrice = 0; } if(txtProductSalePrice.Text != "") { Product.ProductSalePrice = Convert.ToDecimal(txtProductSalePrice.Text); } else { Product.ProductPrice = 0; } if (dtStart.SelectedDate != DateTime.MinValue) { Product.ProductSaleStartDate = Convert.ToDateTime(dtStart.SelectedDate); } else { Product.ProductSaleStartDate = DateTime.Now; } if (dtEnd.SelectedDate != DateTime.MinValue) { Product.ProductSaleEndDate = Convert.ToDateTime(dtEnd.SelectedDate); } else { Product.ProductSaleEndDate = DateTime.Now; } Product.ProductChargeTax = chkProductChargeTax.Checked; Product.ProductSize = txtProductSize.Text; Product.ProductInventoryLevel = Convert.ToInt32(hdnProductInventoryLevel.Value); if(txtProductReorderLevel.Text !="") { Product.ProductReorderLevel = Convert.ToInt32(txtProductReorderLevel.Text); } else { Product.ProductReorderLevel = 0; } if(txtShippingSurcharge.Text != "") { Product.ProductShippingSurcharge = Convert.ToDecimal(txtShippingSurcharge.Text); } else { Product.ProductShippingSurcharge = 0; } ImageWizard ddlImageSelector = Page.FindControl("ddlImageSelector") as ImageWizard; if (ddlImageSelector.SelectedImage > 0) { Product.ProductImageID = Convert.ToInt32(ddlImageSelector.SelectedImage); } else { Product.SetProductImageIDNull(); } Product.ProductActive = chkProductActive.Checked; Product.DateModified = DateTime.Now; Product.ModifiedByAdminID = Convert.ToInt32(CarrielUser.CarrielIdentity.MemberID); //all content to be updated/inserted between here if (ProductID == 0) { //Add new Application Category Product.DateCreated = DateTime.Now; DSProducts.tbl_Products.Addtbl_ProductsRow(Product); } bp.Update(DSProducts); int tmpProductID = Product.ProductID; if (hdnShippingMethodsChanged.Value == "true" || ProductID == 0) { DSProducts.Merge(bp.SelectProductShippingMethodsByProductID(tmpProductID)); hdnShippingMethodsChanged.Value = "false"; BEProducts.tbl_ProductShippingMethodsRow dr; for(int i = 0; i < dlCheckBoxes.Items.Count; i++) { HtmlInputCheckBox tmpChk = dlCheckBoxes.Items[i].FindControl("checkBox") as HtmlInputCheckBox; if (ProductID == 0) { dr = DSProducts.tbl_ProductShippingMethods.Newtbl_ProductShippingMethodsRow(); dr.ProductID = tmpProductID; dr.ShippingMethodID = Convert.ToInt32(tmpChk.Attributes["ShippingMethodID"]); dr.ShippingRegionID = Convert.ToInt32(tmpChk.Attributes["ShippingRegionID"]); dr.ProductShippingMethodActive = tmpChk.Checked; DSProducts.tbl_ProductShippingMethods.Addtbl_ProductShippingMethodsRow(dr); } else { dr = DSProducts.tbl_ProductShippingMethods.FindByProductShippingMethodID(Convert.ToInt32(tmpChk.Attributes["ProductShippingMethodID"])); if(dr.ProductShippingMethodActive != tmpChk.Checked) { dr.ProductShippingMethodActive = tmpChk.Checked; } } } } bp.UpdateProductShippingMethods(DSProducts); //CreateResizedImage(BEImages DSImages, int ImageID, string prefix, int width, int height, Page page) if (!Product.IsProductImageIDNull()) { MWUtility.CreateResizedImage(Product.ProductImageID, "p", "tn", imageSize, thumbSize, this); } //save Document //exit page if (ProductID == 0) { Response.Redirect("EditProducts.aspx?ProductID=" + Product.ProductID); } else { Response.Redirect("BrowseProducts.aspx"); } }
private void Page_Load(object sender, EventArgs e) { this.AuthenticatePage(new string[] {PermissionLevels.EditProducts, PermissionLevels.AddProducts, PermissionLevels.ViewProducts}); if (ProductID > 0) { pnlInventoryManagement.Visible = true; lblInventoryManagement.InnerText = "Inventory Management "; if (this.CarrielUser.RolePermission(PermissionLevels.EditProducts) != 2) { btnSubmit.Visible = false; btnDelete.Visible = false; } else { btnSubmit.Visible = true; btnDelete.Visible = true; } } else { pnlInventoryManagement.Visible = false; lblInventoryManagement.InnerText = "Inventory "; if (this.CarrielUser.RolePermission(PermissionLevels.AddProducts) != 2) { btnSubmit.Visible = false; } } if (hdnGenericProductInformation.Value == "hidden") { pnlGenericProductInformation.CssClass = "panel-closed"; cntGenericProductInformation.Style.Add("display", "none"); hdnGenericProductInformation.Value = "hidden"; } else { pnlGenericProductInformation.CssClass = "panel-open"; cntGenericProductInformation.Style.Add("display", ""); hdnGenericProductInformation.Value = "visible"; } if (hdnRelatedProducts.Value == "hidden") { pnlRelatedProducts.CssClass = "panel-closed"; cntRelatedProducts.Style.Add("display", "none"); hdnRelatedProducts.Value = "hidden"; } else if (hdnRelatedProducts.Value== "visible") { pnlRelatedProducts.CssClass = "panel-open"; cntRelatedProducts.Style.Add("display", ""); hdnRelatedProducts.Value = "visible"; } else { pnlRelatedProducts.CssClass = "panel-closed"; cntRelatedProducts.Style.Add("display", "none"); hdnRelatedProducts.Value = "hidden"; } if (hdnProductAttributes.Value == "hidden") { pnlProductAttributes.CssClass = "panel-closed"; cntProductAttributes.Style.Add("display", "none"); hdnProductAttributes.Value = "hidden"; } else if (hdnProductAttributes.Value== "visible") { pnlProductAttributes.CssClass = "panel-open"; cntProductAttributes.Style.Add("display", ""); hdnProductAttributes.Value = "visible"; } else { pnlProductAttributes.CssClass = "panel-closed"; cntProductAttributes.Style.Add("display", "none"); hdnProductAttributes.Value = "hidden"; } if(!IsPostBack) { BindProductCategories(); ViewRelatedProducts(); ViewProductAttributes(); if (ProductID == 0) { lblTitle.Text = "Add Product"; btnDelete.Visible = false; btnSubmit.Value = "Next >"; pnlRelatedProducts.Visible = false; CreateCheckBoxes(); } else { BPProducts bp = new BPProducts(); BEProducts ds = bp.SelectProductsByID(ProductID); BEProducts.tbl_ProductsRow Product = ds.tbl_Products.FindByProductID(ProductID); txtProductName.Text = Product.ProductName; lblTitle.Text = "Edit Product - " + Product.ProductName; if (! Product.IsProductDescriptionNull()) { edtProductDescription.TextBoxText = Product.ProductDescription; } if (ddlProductCategories.Items.FindByValue(Product.ProductCategoryID.ToString()) != null) { ddlProductCategories.SelectedValue = Product.ProductCategoryID.ToString(); } if (Product.IsProductDocumentIDNull()==false) { ddlDocumentSelector.SelectedDocument = Product.ProductDocumentID; } if (Product.IsProductImageIDNull()==false) { ddlImageSelector.SelectedImage = Product.ProductImageID; } txtProductPrice.Text = Product.ProductPrice.ToString("#,##0.00"); txtProductSalePrice.Text = Product.ProductSalePrice.ToString("#,##0.00"); dtStart.SelectedDate = Product.ProductSaleStartDate; dtEnd.SelectedDate = Product.ProductSaleEndDate; chkProductChargeTax.Checked = Product.ProductChargeTax; txtProductSize.Text = Product.ProductSize; lblProductInventoryLevel.InnerText = Product.ProductInventoryLevel.ToString(); txtProductReorderLevel.Text = Product.ProductReorderLevel.ToString(); hdnProductInventoryLevel.Value = Product.ProductInventoryLevel.ToString(); txtShippingSurcharge.Text = Product.ProductShippingSurcharge.ToString("#,##0.00"); chkProductActive.Checked = Product.ProductActive; FillCheckBoxes(); } } else { if (edtProductDescription != null) { if (Request.Form["edtProductDescriptionHidden"] == null) { edtProductDescription.TextBoxText = ViewState["edtProductDescriptionHidden"].ToString(); } else { edtProductDescription.TextBoxText = Request.Form["edtProductDescriptionHidden"].ToString(); ViewState["edtProductDescriptionHidden"] = Request.Form["edtProductDescriptionHidden"].ToString(); } } else { if (Request.Form["edtProductDescriptionHidden"] != null) { ViewState["edtProductDescriptionHidden"] = Request.Form["edtProductDescriptionHidden"].ToString(); } } } }
private string GetProductTitle(int ProductID) { BPProducts bp = new BPProducts(); DSProducts = bp.SelectProductsByID(ProductID); BEProducts.tbl_ProductsRow title; title = DSProducts.tbl_Products.FindByProductID(ProductID); if (DSProducts.tbl_Products.Count > 0) { return title.ProductName; } else { return ""; } }
protected void FillSelectedRelatedProducts() { if (ProductID > 0) { ddlSelectedProducts.Items.Clear(); BPProducts bp = new BPProducts(); DSProducts = bp.SelectRelatedProductsByProductID(ProductID); if (DSProducts.tbl_RelatedProducts.Count > 0) { ddlSelectedProducts.DataTextField = "ProductName"; ddlSelectedProducts.DataValueField = "RelatedProductID"; ddlSelectedProducts.DataBind(); foreach (BEProducts.tbl_RelatedProductsRow content in DSProducts.tbl_RelatedProducts) { SelectedProducts.Value += content.ProductID + ","; } } } }
protected void BindProductsList() { BPProducts bp = new BPProducts(); DSProducts = bp.SelectActiveByProductCategoryID(ProductCategoryID); foreach (BEProducts.tbl_ProductsRow applications in DSProducts.tbl_Products) { DSProducts.Merge(bp.SelectProductsByID(applications.ProductID)); } rptProductsList.DataBind(); pnlProductsList.Visible = true; }
private void FillCheckBoxes() { BPProducts bp = new BPProducts(); BEProducts products = new BEProducts(); products = bp.SelectProductShippingMethodsByProductID(ProductID); dlCheckBoxes.DataSource = products; dlCheckBoxes.DataMember = "tbl_ProductShippingMethods"; dlCheckBoxes.DataBind(); }
private void LoadAttributes(int ProductID) { BPProducts bp = new BPProducts(); DSProducts = bp.SelectActiveProductAttributesByProductID(ProductID); dgAttributes.DataBind(); }
// private void ddlCategories_SelectedIndexChanged(object sender, System.EventArgs e) // { // BindSubCategories(); // } private void btnDelete_Click(object sender, EventArgs e) { BPImages bp = new BPImages(); BEImages.tbl_ImagesRow Image; DSImages = bp.SelectByID(ImageID); Image = DSImages.tbl_Images.FindByImageID(ImageID); // File.Delete(Server.MapPath(@"\Uploads\" + Image.ImageName)); File.Delete(Server.MapPath(@System.Configuration.ConfigurationSettings.AppSettings["UploadsPath"] + Image.ImageName)); Image.Delete(); bp.Update(DSImages); //remove all instances of this image in Products BPProducts bpProducts = new BPProducts(); bpProducts.RemoveImagesByImageID(ImageID); Response.Redirect("BrowseImages.aspx"); }