/// <summary>
/// Bind the data for a Product id
/// </summary>
public void BindData()
{
ProductAdmin _ProductAdmin = new ProductAdmin();
Product ProductList = _ProductAdmin.GetByProductId(ItemID);
if (ProductList != null)
{
ProductName = ProductList.Name;
}
}
/// <summary>
/// Binding Product Values into label Boxes
/// </summary>
public void BindViewData()
{
//Create Instance for Product Admin and Product entity
ZNode.Libraries.Admin.ProductAdmin ProdAdmin = new ProductAdmin();
Product _Product = ProdAdmin.GetByProductId(ItemId);
DataSet ds = ProdAdmin.GetProductDetails(ItemId);
//Check for Number of Rows
if (ds.Tables[0].Rows.Count != 0)
{
//Check For Product Type
productTypeID = int.Parse(ds.Tables[0].Rows[0]["ProductTypeId"].ToString());
int Count = ProdAdmin.GetAttributeCount(int.Parse(ds.Tables[0].Rows[0]["ProductTypeId"].ToString()), ZNodeConfigManager.SiteConfig.PortalID);
if (Count > 0)
{
//DivAddSKU.Visible = true;
butAddNewSKU.Enabled = true;
}
else
{
lblmessage.Text = "Note: You can add multiple SKUs or Part Numbers to a product only if the product has attributes.";
butAddNewSKU.Enabled = false;
}
}
if (_Product != null)
{
//General Informations
lblProdName.Text = _Product.Name;
//Binding product Category
DataSet dsCategory = ProdAdmin.Get_CategoryByProductID(ItemId);
StringBuilder Builder = new StringBuilder();
foreach (System.Data.DataRow dr in dsCategory.Tables[0].Rows)
{
Builder.Append(ProdAdmin.GetCategorypath(dr["Name"].ToString(), dr["Parent1CategoryName"].ToString(), dr["Parent2CategoryName"].ToString()));
Builder.Append("<br>");
}
//Bind Grid - SKU
this.BindSKU();
}
else
{
throw (new ApplicationException("Product Requested could not be found."));
}
}
/// <summary>
/// Submit Button Click Event - Fires when Submit button is triggered
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
ProductAdmin _ProductAdmin = new ProductAdmin();
Product _product = new Product();
//if edit mode then get all the values first
if (ItemID > 0)
{
_product = _ProductAdmin.GetByProductId(ItemID);
}
_product.FeaturesDesc = ctrlHtmlPrdFeatures.Html.Trim();
_product.Specifications = ctrlHtmlPrdSpec.Html.Trim();
_product.AdditionalInformation = CtrlHtmlProdInfo.Html.Trim();
bool status = false;
try
{
if (ItemID > 0) //PRODUCT UPDATE
{
status = _ProductAdmin.Update(_product);
}
if (status)
{
Response.Redirect(ManagePageLink + ItemID);
}
else
{
lblError.Text = "Unable to update product additional information settings. Please try again.";
}
}
catch (Exception)
{
lblError.Text = "Unable to update product additional information settings. Please try again.";
return;
}
}
/// <summary>
/// Binding Product Values into label Boxes
/// </summary>
public void BindViewData()
{
ZNode.Libraries.Admin.ProductAdmin ProdAdmin = new ProductAdmin();
Product _Product = ProdAdmin.GetByProductId(ItemID);
if (_Product != null)
{
//General Informations
lblProdName.Text = _Product.Name;
DataSet dsCategory = ProdAdmin.Get_CategoryByProductID(ItemID);
StringBuilder Builder = new StringBuilder();
foreach (System.Data.DataRow dr in dsCategory.Tables[0].Rows)
{
Builder.Append(ProdAdmin.GetCategorypath(dr["Name"].ToString(), dr["Parent1CategoryName"].ToString(), dr["Parent2CategoryName"].ToString()));
Builder.Append("<br>");
}
this.BindProductView();
}
else
{
throw (new ApplicationException("Product Requested could not be found."));
}
}
/// <summary>
/// Bind value for Particular Product
/// </summary>
public void BindEditData()
{
ProductAdmin _ProductAdmin = new ProductAdmin();
Product _Products = new Product();
//if edit mode then get all the values first
if (ItemID > 0)
{
_Products = _ProductAdmin.GetByProductId(ItemID);
}
lblTitle.Text += _Products.Name;
txtProductName.Text = _Products.Name;
txtSEOTitle.Text = _Products.SEOTitle;
txtSEOMetaKeywords.Text = _Products.SEOKeywords;
txtSEOMetaDescription.Text = _Products.SEODescription;
txtSEOUrl.Text = _Products.SEOURL;
ctrlHtmlDescription.Html = _Products.Description;
txtshortdescription.Text = _Products.ShortDescription;
ctrlHtmlPrdFeatures.Html = _Products.FeaturesDesc;
ctrlHtmlProdInfo.Html = _Products.AdditionalInformation;
ctrlHtmlPrdSpec.Html = _Products.Specifications;
}
/// <summary>
/// Submit Button Click Event - Fires when Submit button is triggered
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
ProductAdmin productAdmin = new ProductAdmin();
Product product = new Product();
string mappedSEOUrl = "";
// If edit mode then get all the values first
if (ItemID > 0)
{
product = productAdmin.GetByProductId(ItemID);
if (product.SEOURL != null)
mappedSEOUrl = product.SEOURL;
}
// Set properties
product.SEOTitle = txtSEOTitle.Text.Trim();
product.SEOKeywords = txtSEOMetaKeywords.Text.Trim();
product.SEODescription = txtSEOMetaDescription.Text.Trim();
product.SEOURL = null;
if (txtSEOUrl.Text.Trim().Length > 0)
{
product.SEOURL = txtSEOUrl.Text.Trim().Replace(" ", "-");
}
bool status = false;
// create transaction
TransactionManager tranManager = ConnectionScope.CreateTransaction();
try
{
if (ItemID > 0) //PRODUCT UPDATE
{
status = productAdmin.Update(product);
}
}
catch (Exception)
{
//error occurred so rollback transaction
tranManager.Rollback();
lblError.Text = "Unable to update product SEO settings. Please try again.";
return;
}
if (status)
{
UrlRedirectAdmin urlRedirectAdmin = new UrlRedirectAdmin();
bool retval = false;
try
{
retval = urlRedirectAdmin.UpdateUrlRedirectTable(SEOUrlType.Product, mappedSEOUrl, product.SEOURL, ItemID.ToString(), chkAddURLRedirect.Checked);
}
catch
{
// error occurred so rollback transaction
tranManager.Rollback();
lblError.Text = "The SEO Friendly URL you entered is already in use on another page. Please select another name for your URL";
return;
}
if (retval)
{
//Commit transaction
tranManager.Commit();
Response.Redirect(ManagePageLink + ItemID);
}
else
{
lblError.Text = "Could not update the product SEO Url. Please try again.";
}
}
else
{
lblError.Text = "Unable to update product SEO settings. Please try again.";
}
}
private void Bind()
{
//Create Instance for Product Admin and Product entity
ZNode.Libraries.Admin.ProductAdmin ProdAdmin = new ProductAdmin();
Product _Product = ProdAdmin.GetByProductId(ItemID);
if (_Product != null)
{
txtSEOTitle.Text = _Product.SEOTitle;
txtSEOMetaKeywords.Text = _Product.SEOKeywords;
txtSEOMetaDescription.Text = _Product.SEODescription;
txtSEOUrl.Text = _Product.SEOURL;
lblTitle.Text += "\"" + _Product.Name + "\"";
}
}
private void Bind()
{
//Create Instance for Product Admin and Product entity
ZNode.Libraries.Admin.ProductAdmin ProdAdmin = new ProductAdmin();
Product _Product = ProdAdmin.GetByProductId(ItemID);
if (_Product != null)
{
ctrlHtmlPrdFeatures.Html = _Product.FeaturesDesc;
ctrlHtmlPrdSpec.Html = _Product.Specifications;
CtrlHtmlProdInfo.Html = _Product.AdditionalInformation;
lblTitle.Text += "\"" + _Product.Name + "\"";
}
}
private void BindProductName()
{
ProductAdmin ProductAdminAccess = new ProductAdmin();
Product entity = ProductAdminAccess.GetByProductId(ItemId);
if (entity != null)
{
lblTitle.Text = lblTitle.Text + " for \"" + entity.Name + "\"";
}
}
/// <summary>
/// Submit Button Click Event - Fires when Submit button is triggered
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
ProductAdmin _ProductAdmin = new ProductAdmin();
Product _product = new Product();
//if edit mode then get all the values first
if (ItemID > 0)
{
_product = _ProductAdmin.GetByProductId(ItemID);
}
//Set properties
//Display Settings
_product.ActiveInd = CheckEnabled.Checked;
_product.HomepageSpecial = CheckHomeSpecial.Checked;
_product.InventoryDisplay = Convert.ToByte(false);
_product.CallForPricing = CheckCallPricing.Checked;
_product.NewProductInd = CheckNewItem.Checked;
_product.FeaturedInd = ChkFeaturedProduct.Checked;
//Inventory Setting - Out of Stock Options
if (InvSettingRadiobtnList.SelectedValue.Equals("1"))
{
//Only Sell if Inventory Available - Set values
_product.TrackInventoryInd = true;
_product.AllowBackOrder = false;
}
else if (InvSettingRadiobtnList.SelectedValue.Equals("2"))
{
//Allow Back Order - Set values
_product.TrackInventoryInd = true;
_product.AllowBackOrder = true;
}
else if (InvSettingRadiobtnList.SelectedValue.Equals("3"))
{
//Don't Track Inventory - Set property values
_product.TrackInventoryInd = false;
_product.AllowBackOrder = false;
}
//Inventory Setting - Stock Messages
if (txtOutofStock.Text.Trim().Length == 0)
{
_product.OutOfStockMsg = "Out of Stock";
}
else
{
_product.OutOfStockMsg = txtOutofStock.Text.Trim();
}
_product.InStockMsg = txtInStockMsg.Text.Trim();
_product.BackOrderMsg = txtBackOrderMsg.Text.Trim();
_product.DropShipInd = chkDropShip.Checked;
// Recurring Billing settings
if (chkRecurringBillingInd.Checked)
{
_product.RecurringBillingInd = chkRecurringBillingInd.Checked;
_product.RecurringBillingPeriod = ddlBillingPeriods.SelectedItem.Value;
_product.RecurringBillingFrequency = ddlBillingFrequency.SelectedItem.Text;
_product.RecurringBillingTotalCycles = int.Parse(txtSubscrptionCycles.Text.Trim());
}
else
{
_product.RecurringBillingInd = false;
_product.RecurringBillingInstallmentInd = false;
}
bool status = false;
try
{
if (ItemID > 0) //PRODUCT UPDATE
{
status = _ProductAdmin.Update(_product);
}
if (status)
{
Response.Redirect(ManagePageLink + ItemID);
}
else
{
lblError.Text = "Unable to update product advanced settings. Please try again.";
}
}
catch (Exception)
{
lblError.Text = "Unable to update product advanced settings. Please try again.";
return;
}
}
/// <summary>
///
/// </summary>
private void Bind()
{
//Create Instance for Product Admin and Product entity
ZNode.Libraries.Admin.ProductAdmin ProdAdmin = new ProductAdmin();
Product _product = ProdAdmin.GetByProductId(ItemID);
if (_product != null)
{
//Display Settings
CheckEnabled.Checked = _product.ActiveInd;
CheckHomeSpecial.Checked = _product.HomepageSpecial;
CheckCallPricing.Checked = _product.CallForPricing;
ChkFeaturedProduct.Checked = _product.FeaturedInd;
if (_product.NewProductInd.HasValue)
{
CheckNewItem.Checked = _product.NewProductInd.Value;
}
//Inventory Setting - Out of Stock Options
if (_product.AllowBackOrder.HasValue && _product.TrackInventoryInd.HasValue)
{
if ((_product.TrackInventoryInd.Value) && (_product.AllowBackOrder.Value == false))
{
InvSettingRadiobtnList.Items[0].Selected = true;
}
else if (_product.TrackInventoryInd.Value && _product.AllowBackOrder.Value)
{
InvSettingRadiobtnList.Items[1].Selected = true;
}
else if ((_product.TrackInventoryInd.Value == false) && (_product.AllowBackOrder.Value == false))
{
InvSettingRadiobtnList.Items[2].Selected = true;
}
}
//Inventory Setting - Stock Messages
txtInStockMsg.Text = _product.InStockMsg;
txtOutofStock.Text = _product.OutOfStockMsg;
txtBackOrderMsg.Text = _product.BackOrderMsg;
if (_product.DropShipInd.HasValue)
chkDropShip.Checked = _product.DropShipInd.Value;
lblTitle.Text += "\"" + _product.Name + "\"";
// Recurring Billing
chkRecurringBillingInd.Checked = _product.RecurringBillingInd;
pnlRecurringBilling.Visible = _product.RecurringBillingInd;
ddlBillingPeriods.SelectedValue = _product.RecurringBillingPeriod;
ddlBillingFrequency.SelectedValue = _product.RecurringBillingFrequency;
txtSubscrptionCycles.Text = _product.RecurringBillingTotalCycles.GetValueOrDefault(0).ToString();
}
}
/// <summary>
/// Submit Button Click Event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
#region Declarations
SKUAdmin skuAdminAccess = new SKUAdmin();
ProductAdmin productAdmin = new ProductAdmin();
SKUAttribute skuAttribute = new SKUAttribute();
SKU sku = new SKU();
ProductCategory productCategory = new ProductCategory();
ProductCategoryAdmin productCategoryAdmin=new ProductCategoryAdmin();
Product product = new Product();
System.IO.FileInfo fileInfo=null;
bool retVal = false;
//check if category was selected
if (CategoryTreeView.CheckedNodes.Count > 0)
{
lblCategoryError.Visible = false;
}
else
{
lblCategoryError.Visible = true;
return;
}
#endregion
#region Set Product Properties
//passing Values
product.ProductID = ItemID;
product.PortalID = ZNodeConfigManager.SiteConfig.PortalID;
//if edit mode then get all the values first
if (ItemID > 0)
{
product = productAdmin.GetByProductId(ItemID);
if (ViewState["productSkuId"] != null)
{
sku.SKUID = int.Parse(ViewState["productSkuId"].ToString());
}
}
//General Info
product.Name = txtProductName.Text;
product.ImageFile = txtimagename.Text;
product.ProductNum = txtProductNum.Text;
product.PortalID = ZNodeConfigManager.SiteConfig.PortalID;
if (ProductTypeList.SelectedIndex != -1)
{
product.ProductTypeID = Convert.ToInt32(ProductTypeList.SelectedValue);
}
else
{
//"Please add a product type before you add a new product";
}
//MANUFACTURER
if (ManufacturerList.SelectedIndex != -1)
{
if (ManufacturerList.SelectedItem.Text.Equals("No Manufacturer Selected"))
{
product.ManufacturerID = null;
}
else
{
product.ManufacturerID = Convert.ToInt32(ManufacturerList.SelectedValue);
}
}
//Supplier
if (ddlSupplier.SelectedIndex != -1)
{
if (ddlSupplier.SelectedItem.Text.Equals("None"))
{
product.SupplierID = null;
}
else
{
product.SupplierID = Convert.ToInt32(ddlSupplier.SelectedValue);
}
}
product.DownloadLink = txtDownloadLink.Text.Trim();
product.ShortDescription = txtshortdescription.Text;
product.Description = ctrlHtmlText.Html;
product.RetailPrice = Convert.ToDecimal(txtproductRetailPrice.Text);
if (txtproductSalePrice.Text.Trim().Length > 0)
{
product.SalePrice = Convert.ToDecimal(txtproductSalePrice.Text.Trim());
}
else { product.SalePrice = null; }
if (txtProductWholeSalePrice.Text.Trim().Length > 0)
{
product.WholesalePrice = Convert.ToDecimal(txtProductWholeSalePrice.Text.Trim());
}
else { product.WholesalePrice = null; }
//Quantity Available
product.QuantityOnHand = Convert.ToInt32(txtProductQuantity.Text);
if (txtReOrder.Text.Trim().Length > 0)
{
product.ReorderLevel = Convert.ToInt32(txtReOrder.Text);
}
else
{
product.ReorderLevel = null;
}
if(txtMaxQuantity.Text.Equals(""))
{
product.MaxQty = 10;
}
else
{
product.MaxQty = Convert.ToInt32(txtMaxQuantity.Text);
}
// Display Settings
product.MasterPage = ddlPageTemplateList.SelectedItem.Text;
product.DisplayOrder = int.Parse(txtDisplayOrder.Text.Trim());
// Tax Settings
if(ddlTaxClass.SelectedIndex != -1)
product.TaxClassID = int.Parse(ddlTaxClass.SelectedValue);
//Shipping Option setting
product.ShippingRuleTypeID = Convert.ToInt32(ShippingTypeList.SelectedValue);
product.FreeShippingInd = chkFreeShippingInd.Checked;
product.ShipSeparately = chkShipSeparately.Checked;
if (txtProductWeight.Text.Trim().Length > 0)
{
product.Weight = Convert.ToDecimal(txtProductWeight.Text.Trim());
}
else { product.Weight = null; }
//Product Height - Which will be used to determine the shipping cost
if (txtProductHeight.Text.Trim().Length > 0)
{
product.Height = decimal.Parse(txtProductHeight.Text.Trim());
}
else { product.Height = null; }
if (txtProductWidth.Text.Trim().Length > 0)
{
product.Width = decimal.Parse(txtProductWidth.Text.Trim());
}
else { product.Width = null; }
if (txtProductLength.Text.Trim().Length > 0)
{
product.Length = decimal.Parse(txtProductLength.Text.Trim());
}
else { product.Length = null; }
//Stock
DataSet MyAttributeTypeDataSet = productAdmin.GetAttributeTypeByProductTypeID(int.Parse(ProductTypeList.SelectedValue));
if (MyAttributeTypeDataSet.Tables[0].Rows.Count == 0)
{
product.SKU = txtProductSKU.Text.Trim();
product.QuantityOnHand = Convert.ToInt32(txtProductQuantity.Text);
}
else
{
//SKU
sku.ProductID = ItemID;
sku.QuantityOnHand = Convert.ToInt32(txtProductQuantity.Text);
sku.SKU = txtProductSKU.Text.Trim();
sku.ActiveInd = true;
product.SKU = txtProductSKU.Text.Trim();
product.QuantityOnHand = 0; //Reset quantity available in the Product table,If SKU is selected
}
product.ImageAltTag = txtImageAltTag.Text.Trim();
#endregion
#region Image Validation
// Validate image
if ((ItemID == 0 || RadioProductNewImage.Checked == true) && UploadProductImage.PostedFile.FileName.Length > 0)
{
//Check for Product Image
fileInfo = new System.IO.FileInfo(UploadProductImage.PostedFile.FileName);
if (fileInfo != null)
{
product.ImageFile = fileInfo.Name;
sku.SKUPicturePath = fileInfo.Name;
}
}
#endregion
#region Database & Image Updates
//set update date
product.UpdateDte = System.DateTime.Now;
//create transaction
TransactionManager tranManager = ConnectionScope.CreateTransaction();
try
{
if (ItemID > 0) //PRODUCT UPDATE
{
//Update product Sku and Product values
if (MyAttributeTypeDataSet.Tables[0].Rows.Count > 0) //If ProductType has SKU's
{
if (sku.SKUID > 0) //For this product already SKU if on exists
{
sku.UpdateDte = System.DateTime.Now;
// Check whether Duplicate attributes is created
string Attributes = String.Empty;
DataSet MyAttributeTypeDataSet1 = productAdmin.GetAttributeTypeByProductTypeID(ProductTypeId);
foreach (DataRow MyDataRow in MyAttributeTypeDataSet1.Tables[0].Rows)
{
System.Web.UI.WebControls.DropDownList lstControl = (System.Web.UI.WebControls.DropDownList)ControlPlaceHolder.FindControl("lstAttribute" + MyDataRow["AttributeTypeId"].ToString());
int selValue = int.Parse(lstControl.SelectedValue);
Attributes += selValue.ToString() + ",";
}
// Split the string
string Attribute = Attributes.Substring(0, Attributes.Length - 1);
// To check SKU combination is already exists.
bool RetValue = skuAdminAccess.CheckSKUAttributes(ItemID, sku.SKUID, Attribute);
if (!RetValue)
{
//then Update the database with new property values
retVal = productAdmin.Update(product, sku);
}
else
{
//Throw error if duplicate attribute
lblMsg.Text = "This Attribute combination already exists for this product. Please select different combination.";
return;
}
}
else
{
retVal = productAdmin.Update(product);
//If Product doesn't have any SKUs yet,then create new SKU in the database
skuAdminAccess.Add(sku);
}
}
else
{
retVal = productAdmin.Update(product);
// If User selectes Default product type for this product,
// then Remove all the existing SKUs for this product
skuAdminAccess.DeleteByProductId(ItemID);
}
if (!retVal) { throw (new ApplicationException()); }
// Delete existing categories
productAdmin.DeleteProductCategories(ItemID);
// Add Product Categories
foreach (TreeNode Node in CategoryTreeView.CheckedNodes)
{
ProductCategory prodCategory = new ProductCategory();
ProductAdmin prodAdmin = new ProductAdmin();
prodCategory.CategoryID = int.Parse(Node.Value);
prodCategory.ProductID = ItemID;
prodAdmin.AddProductCategory(prodCategory);
}
// Delete existing SKUAttributes
skuAdminAccess.DeleteBySKUId(sku.SKUID);
// Add SKU Attributes
foreach (DataRow MyDataRow in MyAttributeTypeDataSet.Tables[0].Rows)
{
System.Web.UI.WebControls.DropDownList lstControl = (System.Web.UI.WebControls.DropDownList)ControlPlaceHolder.FindControl("lstAttribute" + MyDataRow["AttributeTypeId"].ToString());
int selValue = int.Parse(lstControl.SelectedValue);
if (selValue > 0)
{
skuAttribute.AttributeId = selValue;
}
skuAttribute.SKUID = sku.SKUID;
skuAdminAccess.AddSKUAttribute(skuAttribute);
}
}
else // PRODUCT ADD
{
product.ActiveInd = true;
// Add Product/SKU
if (MyAttributeTypeDataSet.Tables[0].Rows.Count > 0)
{
//if ProductType has SKUs, then insert sku with Product
retVal = productAdmin.Add(product, sku, out _ProductID, out SKUId);
}
else
{
retVal = productAdmin.Add(product, out _ProductID); //if ProductType is Default
}
if (!retVal) { throw (new ApplicationException()); }
// Add Category List for the Product
foreach (TreeNode Node in CategoryTreeView.CheckedNodes)
{
ProductCategory prodCategory = new ProductCategory();
ProductAdmin prodAdmin = new ProductAdmin();
prodCategory.CategoryID = int.Parse(Node.Value);
prodCategory.ProductID = _ProductID;
prodAdmin.AddProductCategory(prodCategory);
}
// Add SKU Attributes
foreach (DataRow MyDataRow in MyAttributeTypeDataSet.Tables[0].Rows)
{
System.Web.UI.WebControls.DropDownList lstControl = (System.Web.UI.WebControls.DropDownList)ControlPlaceHolder.FindControl("lstAttribute" + MyDataRow["AttributeTypeId"].ToString());
int selValue = int.Parse(lstControl.SelectedValue);
if (selValue > 0)
{
skuAttribute.AttributeId = selValue;
}
skuAttribute.SKUID = SKUId;
skuAdminAccess.AddSKUAttribute(skuAttribute);
}
ZNode.Libraries.Admin.ProductViewAdmin imageAdmin = new ProductViewAdmin();
ZNode.Libraries.DataAccess.Entities.ProductImage productImage = new ProductImage();
productImage.Name = txtimagename.Text;
productImage.ActiveInd = false;
productImage.ShowOnCategoryPage = false;
productImage.ProductID = _ProductID;
productImage.ProductImageTypeID = 1;
productImage.DisplayOrder = 500;
productImage.ImageAltTag = txtImageAltTag.Text.Trim();
productImage.AlternateThumbnailImageFile = txtImageAltTag.Text.Trim();
if (fileInfo != null)
{
productImage.ImageFile = fileInfo.Name;
}
imageAdmin.Insert(productImage);
}
// Commit transaction
tranManager.Commit();
}
catch // error occurred so rollback transaction
{
if (tranManager.IsOpen)
tranManager.Rollback();
lblMsg.Text = "Unable to update product. Please try again.";
return;
}
// Upload File if this is a new product or the New Image option was selected for an existing product
if (RadioProductNewImage.Checked || ItemID == 0)
{
if (fileInfo != null)
{
UploadProductImage.SaveAs(Server.MapPath(ZNodeConfigManager.EnvironmentConfig.OriginalImagePath + fileInfo.Name));
ZNodeImage.ResizeImage(fileInfo, ZNode.Libraries.Framework.Business.ZNodeConfigManager.SiteConfig.MaxCatalogItemLargeWidth, Server.MapPath(ZNodeConfigManager.EnvironmentConfig.LargeImagePath));
ZNodeImage.ResizeImage(fileInfo, ZNode.Libraries.Framework.Business.ZNodeConfigManager.SiteConfig.MaxCatalogItemThumbnailWidth, Server.MapPath(ZNodeConfigManager.EnvironmentConfig.ThumbnailImagePath));
ZNodeImage.ResizeImage(fileInfo, ZNode.Libraries.Framework.Business.ZNodeConfigManager.SiteConfig.MaxCatalogItemMediumWidth, Server.MapPath(ZNodeConfigManager.EnvironmentConfig.MediumImagePath));
ZNodeImage.ResizeImage(fileInfo, ZNode.Libraries.Framework.Business.ZNodeConfigManager.SiteConfig.MaxCatalogItemSmallWidth, Server.MapPath(ZNodeConfigManager.EnvironmentConfig.SmallImagePath));
ZNodeImage.ResizeImage(fileInfo, ZNode.Libraries.Framework.Business.ZNodeConfigManager.SiteConfig.MaxCatalogItemSwatchWidth, Server.MapPath(ZNodeConfigManager.EnvironmentConfig.SwatchImagePath));
ZNodeImage.ResizeImage(fileInfo, ZNode.Libraries.Framework.Business.ZNodeConfigManager.SiteConfig.MaxCatalogItemCrossSellWidth, Server.MapPath(ZNodeConfigManager.EnvironmentConfig.CrossSellImagePath));
}
}
#endregion
#region Redirect to next page
//Redirect to next page
if (ItemID > 0)
{
string ViewLink = "~/admin/secure/catalog/product/view.aspx?itemid=" + ItemID.ToString();
Response.Redirect(ViewLink);
}
else
{
string NextLink = "~/admin/secure/catalog/product/view.aspx?itemid=" + _ProductID.ToString();
Response.Redirect(NextLink);
}
#endregion
}
/// <summary>
/// Bind value for Particular Product
/// </summary>
public void BindEditData()
{
ProductAdmin productAdmin = new ProductAdmin();
Product product = new Product();
SKUAdmin skuAdmin = new SKUAdmin();
if (ItemID > 0)
{
product = productAdmin.GetByProductId(ItemID);
// General Information - Section1
lblTitle.Text += product.Name;
txtProductName.Text = product.Name;
txtProductNum.Text = product.ProductNum;
if (ProductTypeList.SelectedIndex != -1)
{
ProductTypeList.SelectedValue = product.ProductTypeID.ToString();
}
if (ManufacturerList.SelectedIndex != -1)
{
ManufacturerList.SelectedValue = product.ManufacturerID.ToString();
}
if (ddlSupplier.SelectedIndex != -1)
{
ddlSupplier.SelectedValue = product.SupplierID.ToString();
}
// Product Description and Image - Section2
txtshortdescription.Text = product.ShortDescription;
ctrlHtmlText.Html = product.Description;
Image1.ImageUrl = ZNode.Libraries.Framework.Business.ZNodeConfigManager.EnvironmentConfig.MediumImagePath + product.ImageFile;
// Displaying the Image file name in a textbox
txtimagename.Text = product.ImageFile;
txtImageAltTag.Text = product.ImageAltTag;
// Product properties
if(product.RetailPrice.HasValue)
txtproductRetailPrice.Text = product.RetailPrice.Value.ToString("N");
if (product.SalePrice.HasValue)
txtproductSalePrice.Text = product.SalePrice.Value.ToString("N");
if (product.WholesalePrice.HasValue)
txtProductWholeSalePrice.Text = product.WholesalePrice.Value.ToString("N");
txtDownloadLink.Text = product.DownloadLink;
// Tax Classes
if(product.TaxClassID.HasValue)
ddlTaxClass.SelectedValue = product.TaxClassID.Value.ToString();
// Category List
this.BindEditCategoryList();
//Display Settings
txtDisplayOrder.Text = product.DisplayOrder.ToString();
ddlPageTemplateList.SelectedValue = product.MasterPage;
// Inventory
DataSet MySKUDataSet = skuAdmin.GetByProductID(ItemID);
if (MySKUDataSet.Tables[0].Rows.Count != 0)
{
ViewState["productSkuId"] = MySKUDataSet.Tables[0].Rows[0]["skuid"].ToString();
txtProductSKU.Text = MySKUDataSet.Tables[0].Rows[0]["sku"].ToString();
txtProductQuantity.Text = MySKUDataSet.Tables[0].Rows[0]["quantityonhand"].ToString();
this.BindAttributes(product.ProductTypeID);
}
else
{
if (product.QuantityOnHand.HasValue)
{
txtProductQuantity.Text = product.QuantityOnHand.Value.ToString();
}
if (product.ReorderLevel.HasValue)
{
txtReOrder.Text = product.ReorderLevel.Value.ToString();
}
txtProductSKU.Text = product.SKU;
}
if (product.MaxQty.HasValue)
{
txtMaxQuantity.Text = product.MaxQty.Value.ToString();
}
// Shipping settings
ShippingTypeList.SelectedValue = product.ShippingRuleTypeID.ToString();
EnableValidators(); //This method will enable or disable validators based on the shippingtype
if(product.FreeShippingInd.HasValue)
chkFreeShippingInd.Checked = product.FreeShippingInd.Value;
chkShipSeparately.Checked = product.ShipSeparately;
if (product.Weight.HasValue)
txtProductWeight.Text = product.Weight.Value.ToString("N2");
if (product.Height.HasValue)
txtProductHeight.Text = product.Height.Value.ToString("N2");
if (product.Width.HasValue)
txtProductWidth.Text = product.Width.Value.ToString("N2");
if (product.Length.HasValue)
txtProductLength.Text = product.Length.Value.ToString("N2");
// Release the Resources
MySKUDataSet.Dispose();
}
}
/// <summary>
/// Binding Product Values into label Boxes
/// </summary>
public void BindViewData()
{
//Create Instance for Product Admin and Product entity
ZNode.Libraries.Admin.ProductAdmin prodAdmin = new ProductAdmin();
Product product=prodAdmin.GetByProductId(ItemId);
DataSet ds = prodAdmin.GetProductDetails(ItemId);
int Count = 0;
//Check for Number of Rows
if (ds.Tables[0].Rows.Count != 0)
{
//Bind ProductType,Manufacturer,Supplier
lblProdType.Text = ds.Tables[0].Rows[0]["producttype name"].ToString();
lblManufacturerName.Text = ds.Tables[0].Rows[0]["MANUFACTURER NAME"].ToString();
//Check For Product Type
productTypeID = int.Parse(ds.Tables[0].Rows[0]["ProductTypeId"].ToString());
Count = prodAdmin.GetAttributeCount(int.Parse(ds.Tables[0].Rows[0]["ProductTypeId"].ToString()), ZNodeConfigManager.SiteConfig.PortalID);
//Check product atributes count
if (Count > 0)
{
tabProductDetails.Tabs[2].Enabled = true; // Enable Manage inventory tab
}
else
{
tabProductDetails.Tabs[2].Enabled = false;// Disable Manage inventory tab
}
}
if (product != null)
{
//General Information
lblProdName.Text = product.Name;
lblProdNum.Text = product.ProductNum.ToString();
if (Count > 0)
{
lblProductSKU.Text = "See Manage SKUs tab";
lblQuantity.Text = "See Manage SKUs tab";
lblReOrder.Text = "See Manage SKUs tab";
lblSupplierName.Text = "See Manage SKUs tab";
}
else
{
lblProductSKU.Text = product.SKU;
if(product.QuantityOnHand.HasValue)
lblQuantity.Text = product.QuantityOnHand.Value.ToString();
if(product.ReorderLevel.HasValue)
lblReOrder.Text = product.ReorderLevel.Value.ToString();
lblSupplierName.Text = ds.Tables[0].Rows[0]["Supplier Name"].ToString();
}
if (product.MaxQty.HasValue)
lblMaxQuantity.Text = product.MaxQty.Value.ToString();
//image
if (product.ImageFile.Trim().Length > 0)
{
string ImageFilePath = ZNodeConfigManager.EnvironmentConfig.MediumImagePath + product.ImageFile;
ItemImage.ImageUrl = ImageFilePath;
}
else
{
ItemImage.ImageUrl = ZNodeConfigManager.SiteConfig.ImageNotAvailablePath;
}
//Product Description and Features
lblShortDescription.Text = product.ShortDescription;
lblProductDescription.Text = product.Description;
lblProductFeatures.Text = product.FeaturesDesc;
lblproductspecification.Text = product.Specifications;
lbladditionalinfo.Text = product.AdditionalInformation;
lblDownloadLink.Text = product.DownloadLink;
//Product Attributes
if (product.RetailPrice.HasValue)
lblRetailPrice.Text = product.RetailPrice.Value.ToString("c");
if (product.WholesalePrice.HasValue)
lblWholeSalePrice.Text = product.WholesalePrice.Value.ToString("c");
lblSalePrice.Text = FormatPrice(product.SalePrice);
lblWeight.Text = this.FormatProductWeight(product.Weight);
if (product.Height.HasValue)
lblHeight.Text = product.Height.Value.ToString("N2") + " " + ZNodeConfigManager.SiteConfig.DimensionUnit;
if (product.Width.HasValue)
lblWidth.Text = product.Width.Value.ToString("N2") + " " + ZNodeConfigManager.SiteConfig.DimensionUnit;
if (product.Length.HasValue)
lblLength.Text = product.Length.Value.ToString("N2") + " " + ZNodeConfigManager.SiteConfig.DimensionUnit;
//Display Settings
chkProductEnabled.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(bool.Parse(product.ActiveInd.ToString()));
lblProdDisplayOrder.Text = product.DisplayOrder.ToString();
chkIsSpecialProduct.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(this.DisplayVisible(product.HomepageSpecial));
chkIsNewItem.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(this.DisplayVisible(product.NewProductInd));
chkProductPricing.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(this.DisplayVisible(product.CallForPricing));
chkproductInventory.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(this.DisplayVisible(product.InventoryDisplay));
// Display Tax Class Name
if (product.TaxClassID.HasValue)
{
TaxRuleAdmin taxRuleAdmin = new TaxRuleAdmin();
TaxClass taxClass = taxRuleAdmin.GetByTaxClassID(product.TaxClassID.Value);
if(taxClass != null)
lblTaxClass.Text = taxClass.Name;
}
// Recurring Billing
imgRecurringBillingInd.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(this.DisplayVisible(product.RecurringBillingInd));
lblBillingPeriod.Text = product.RecurringBillingPeriod;
lblFrequency.Text = product.RecurringBillingFrequency;
lblTotalCycles.Text = product.RecurringBillingTotalCycles.GetValueOrDefault(0).ToString();
shipSeparatelyInd.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(product.ShipSeparately);
lblMastePageName.Text = product.MasterPage;
//seo
lblSEODescription.Text = product.SEODescription;
lblSEOKeywords.Text = product.SEOKeywords;
lblSEOTitle.Text = product.SEOTitle;
lblSEOURL.Text = product.SEOURL;
//checking whether the image is active or not
//ZNode.Libraries.Admin.ProductViewAdmin pp = new ProductViewAdmin();
//Inventory Setting - Out of Stock Options
if (product.TrackInventoryInd.HasValue && product.AllowBackOrder.HasValue)
{
if ((product.TrackInventoryInd.Value) && (product.AllowBackOrder.Value == false))
{
chkCartInventoryEnabled.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(bool.Parse("true"));
chkIsBackOrderEnabled.Src = SetCheckMarkImage();
chkIstrackInvEnabled.Src = SetCheckMarkImage();
}
else if (product.TrackInventoryInd.Value && product.AllowBackOrder.Value)
{
chkCartInventoryEnabled.Src = SetCheckMarkImage();
chkIsBackOrderEnabled.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(bool.Parse("true"));
chkIstrackInvEnabled.Src = SetCheckMarkImage();
}
else if ((product.TrackInventoryInd.Value == false) && (product.AllowBackOrder.Value == false))
{
chkCartInventoryEnabled.Src = SetCheckMarkImage();
chkIsBackOrderEnabled.Src = SetCheckMarkImage();
chkIstrackInvEnabled.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(bool.Parse("true"));
}
}
else
{
chkCartInventoryEnabled.Src = SetCheckMarkImage();
chkIsBackOrderEnabled.Src = SetCheckMarkImage();
chkIstrackInvEnabled.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(bool.Parse("true"));
}
//Inventory Setting - Stock Messages
lblInStockMsg.Text = product.InStockMsg;
lblOutofStock.Text = product.OutOfStockMsg;
lblBackOrderMsg.Text = product.BackOrderMsg;
if (product.DropShipInd.HasValue)
{
IsDropShipEnabled.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(product.DropShipInd.Value);
}
else
{
IsDropShipEnabled.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(bool.Parse("false"));
}
//Binding product Category
DataSet dsCategory = prodAdmin.Get_CategoryByProductID(ItemId);
StringBuilder Builder = new StringBuilder();
foreach (System.Data.DataRow dr in dsCategory.Tables[0].Rows)
{
Builder.Append(prodAdmin.GetCategorypath(dr["Name"].ToString(),dr["Parent1CategoryName"].ToString(), dr["Parent2CategoryName"].ToString()));
Builder.Append("<br>");
}
if (product.FeaturedInd)
{
FeaturedProduct.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(true);
}
else
{
FeaturedProduct.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(false);
}
lblProductCategories.Text = Builder.ToString();
//Bind ShippingRule type
if(product.ShippingRuleTypeID.HasValue)
lblShippingRuleTypeName.Text = GetShippingRuleTypeName(product.ShippingRuleTypeID.Value);
if (product.FreeShippingInd.HasValue)
freeShippingInd.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(product.FreeShippingInd.Value);
else
freeShippingInd.Src = ZNode.Libraries.Framework.Business.ZNodeHelper.GetCheckMark(false);
//Bind Grid - Product Related Items
this.BindRelatedItems();
//this.BindImage();
this.BindImageDatas();
//Bind Grid - Product Addons
BindProductAddons();
//Bind Grid - Inventory
BindSKU();
//Tiered Pricing
BindTieredPricing();
//Digital Asset
BindDigitalAssets();
//Bind product highlights
BindProductHighlights();
}
else
{
throw (new ApplicationException("Product Requested could not be found."));
}
}