protected void cboProducts_SelectedIndexChanged(object sender, System.EventArgs e) { long ProductID = Convert.ToInt64(cboProducts.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboProductVariation.DataTextField = "VariationDesc"; cboProductVariation.DataValueField = "MatrixID"; cboProductVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboProductVariation.DataBind(); cboProductVariation.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING)); cboProductVariation.SelectedIndex = 0; clsProductVariationsMatrix.CommitAndDispose(); }
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { if (cboProductCode.Items.Count == 0) return; if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING) return; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "MatrixDescription"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0")); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); cboProductUnit.DataTextField = "BottomUnitCode"; cboProductUnit.DataValueField = "BottomUnitID"; cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID,"a.MatrixID",SortOption.Ascending).DefaultView; cboProductUnit.DataBind(); Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); ProductDetails clsDetails = clsProduct.Details(ProductID, MatrixID: Int64.Parse(cboVariation.SelectedItem.Value)); clsProductVariationsMatrix.CommitAndDispose(); cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); txtPrevPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0"); txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.#0"); if (clsDetails.VAT >0) chkIsTaxable.Checked = true; else chkIsTaxable.Checked = false; ComputeItemAmount(); cboVariation_SelectedIndexChanged(null, null); }
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { if (cboProductCode.Items.Count == 0) return; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "MatrixDescription"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0"));} cboVariation.SelectedIndex = cboVariation.Items.Count - 1; ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); cboProductUnit.DataTextField = "BottomUnitCode"; cboProductUnit.DataValueField = "BottomUnitID"; cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView; cboProductUnit.DataBind(); Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); ProductDetails clsDetails = clsProduct.Details(ProductID); clsProductVariationsMatrix.CommitAndDispose(); cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); txtPrice.Text = clsDetails.WSPrice.ToString("#####0.#0"); txtSellingPrice.Text = clsDetails.Price.ToString("#####0.#0"); decimal decMargin = clsDetails.Price - clsDetails.WSPrice; try { decMargin = decMargin / clsDetails.WSPrice; } catch { decMargin = 1; } decMargin = decMargin * 100; txtMargin.Text = decMargin.ToString("#,##0.##0"); txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0"); txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0"); txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0"); if (clsDetails.VAT > 0) chkIsTaxable.Checked = true; else chkIsTaxable.Checked = false; ComputeItemAmount(); cboVariation_SelectedIndexChanged(null, null); //if (ProductID != 0) //{ // lnkVariationAdd.Visible = true; // string stParam = "?task=" + Common.Encrypt("add", Session.SessionID) + // "&prodid=" + Common.Encrypt(ProductID.ToString(), Session.SessionID); // lnkVariationAdd.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_VariationsMatrix/Default.aspx" + stParam; //} //else { lnkVariationAdd.Visible = false; } }
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { if (cboProductCode.Items.Count == 0) return; if (cboProductCode.Items.Count == 1 && cboProductCode.SelectedValue == Constants.ZERO_STRING) return; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "MatrixDescription"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", Constants.ZERO_STRING)); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); cboProductUnit.DataTextField = "BottomUnitCode"; cboProductUnit.DataValueField = "BottomUnitID"; cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID, "a.MatrixID", SortOption.Ascending).DefaultView; cboProductUnit.DataBind(); Products clsProduct = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); ProductDetails clsDetails = clsProduct.Details(ProductID); ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction); System.Data.DataTable dtProductPurchasePriceHistory = clsProductPurchasePriceHistory.ListAsDataTable(ProductID, DateTime.Now.AddMonths(-6), "PurchasePrice", SortOption.Ascending); clsProductVariationsMatrix.CommitAndDispose(); string strPurchasePriceHistory = string.Empty; foreach (System.Data.DataRow dr in dtProductPurchasePriceHistory.Rows) { DateTime dtePurchaseDate = DateTime.Parse(dr["PurchaseDate"].ToString()); decimal decPurchasePrice = decimal.Parse(dr["PurchasePrice"].ToString()); long lngSupplierID = long.Parse(dr["SupplierID"].ToString()); string strSupplierName = "" + dr["SupplierName"].ToString(); if (lngSupplierID == long.Parse(lblSupplierID.Text)) clsDetails.PurchasePrice = decPurchasePrice; strPurchasePriceHistory += dtePurchaseDate.ToString("ddMMMyyyy HH:mm") + ": " + decPurchasePrice.ToString("#,##0.##0").PadLeft(10) + " " + strSupplierName + "\r\n<br />" + Environment.NewLine; } lblPurchasePriceHistory.Text = "<br />" + strPurchasePriceHistory; cboProductUnit.Items.Insert(0, new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); txtPrice.Text = clsDetails.PurchasePrice.ToString("#####0.##0"); txtSellingPrice.Text = clsDetails.Price.ToString("#####0.##0"); txtOldSellingPrice.Text = clsDetails.Price.ToString("#####0.##0"); decimal decMargin = clsDetails.Price - clsDetails.PurchasePrice; try { decMargin = decMargin / clsDetails.PurchasePrice; } catch { decMargin = 1; } decMargin = decMargin * 100; txtMargin.Text = decMargin.ToString("#,##0.##0"); txtVAT.Text = clsDetails.VAT.ToString("#,##0.##0"); txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.##0"); txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.##0"); if (clsDetails.VAT > 0) chkIsTaxable.Checked = true; else chkIsTaxable.Checked = false; if (cboProductUnit.Items.Count == 0) { cboProductUnit.Items.Add(new ListItem("No Unit", "0")); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; ComputeItemAmount(); cboVariation_SelectedIndexChanged(null, null); lstItemFixCssClass(); }
protected void cboProductCode_SelectedIndexChanged(object sender, EventArgs e) { try { if (cboProductCode.SelectedItem.Text == "No product") { imgProductHistory.Visible = false; imgProductPriceHistory.Visible = false; imgInventoryAdjustment.Visible = false; imgEditNow.Visible = false; cboVariation.Items.Clear(); cboVariation.Items.Insert(0, new ListItem("No Product", "0")); cboVariation.SelectedIndex = 0; } else { imgProductHistory.Visible = true; imgProductPriceHistory.Visible = true; imgInventoryAdjustment.Visible = true; imgEditNow.Visible = true; txtProductCode.Text = cboProductCode.SelectedItem.Text; Int64 ProductID = Int64.Parse(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "MatrixDescription"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); cboVariation.Items.Insert(0, new ListItem("Main Product", "0")); cboVariation.Items.Insert(0, new ListItem(Constants.ALL, "-1")); cboVariation.SelectedIndex = 0; } } catch { } }
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { if (cboProductCode.Items.Count == 0) return; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); if (ProductID == 0) { cboVariation.Items.Clear(); cboVariation.Items.Add(new ListItem("No Variation", "0")); return; } ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "VariationDesc"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0")); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; clsProductVariationsMatrix.CommitAndDispose(); ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix(); cboProductUnit.DataTextField = "BottomUnitCode"; cboProductUnit.DataValueField = "BottomUnitID"; cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID,"a.MatrixID",SortOption.Ascending).DefaultView; cboProductUnit.DataBind(); clsUnitMatrix.CommitAndDispose(); Products clsProduct = new Products(); ProductDetails clsDetails = new ProductDetails(); clsDetails = clsProduct.Details(ProductID); clsProduct.CommitAndDispose(); cboProductUnit.Items.Add( new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString())); cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1; cboVariation_SelectedIndexChanged(null, null); }