protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e) { int intProductBaseUnitID = 0; decimal decCommision = 0; lblProductSubGroupID.Text = "0"; if (cboProductCode.SelectedItem.Value != Constants.ZERO_STRING) { Products clsProduct = new Products(); try { ProductDetails clsDetails = clsProduct.Details(Convert.ToInt64(cboProductCode.SelectedValue)); intProductBaseUnitID = clsDetails.BaseUnitID; decCommision = clsDetails.PercentageCommision; lblProductSubGroupID.Text = clsDetails.ProductSubGroupID.ToString(); } catch { } txtProductCode.ToolTip = intProductBaseUnitID.ToString(); lblProductID.ToolTip = decCommision.ToString(); long ProductID = Convert.ToInt64(cboProductCode.SelectedValue); ProductPackage clsProductPackage = new ProductPackage(clsProduct.Connection, clsProduct.Transaction); lstProductPackages.DataSource = clsProductPackage.ListAsDataTable(Convert.ToInt64(cboProductCode.SelectedValue)).DefaultView; lstProductPackages.DataBind(); ProductPurchasePriceHistory clsProductPurchasePriceHistory = new ProductPurchasePriceHistory(clsProduct.Connection, clsProduct.Transaction); System.Data.DataTable dtProductPurchasePriceHistory = clsProductPurchasePriceHistory.ListAsDataTable(Convert.ToInt64(cboProductCode.SelectedValue), DateTime.Now.AddMonths(-6), "PurchasePrice", SortOption.Ascending); clsProduct.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()); string strSupplierName = "" + dr["PurchaserName"].ToString(); string strPurchaserName = "" + dr["SupplierName"].ToString(); strPurchasePriceHistory += dtePurchaseDate.ToString("ddMMMyyyy HH:mm") + ": " + strPurchaserName.PadRight(50) + " - " + decPurchasePrice.ToString("#,##0.#0").PadLeft(10) + " " + strSupplierName + "\r\n<br />" + Environment.NewLine; } lblPurchasePriceHistory.Text = "<br /><b>PURCHASE PRICE HISTORY: </b><br /><br />" + strPurchasePriceHistory; lblProductPackage.Visible = true; lnkProductPackageAdd.Visible = true; lstProductPackages.Visible = true; imgProductHistory.Visible = true; imgProductPriceHistory.Visible = true; imgInventoryAdjustment.Visible = true; imgEditNow.Visible = true; lnkPackage.Visible = true; imgVariationsMatrix.Visible = true; imgUnitsMatrix.Visible = true; string stParam = "?task=" + Common.Encrypt("list", Session.SessionID) + "&prodid=" + Common.Encrypt(cboProductCode.SelectedValue, Session.SessionID); lnkPackage.NavigateUrl = Constants.ROOT_DIRECTORY + "/MasterFiles/_Product/_Package/Default.aspx" + stParam; lnkProductPackageAdd.ToolTip = "Add new package for " + cboProductCode.SelectedItem.Text; lnkProductPackageAdd.NavigateUrl = "_Package/Default.aspx?task=" + Common.Encrypt("add", Session.SessionID) + "&prodid=" + Common.Encrypt(cboProductCode.SelectedValue, Session.SessionID) + "&productcode=" + Common.Encrypt(cboProductCode.SelectedItem.Text, Session.SessionID); txtProductCode.Text = cboProductCode.SelectedItem.Text; lblPurchasePriceHistory.Visible = true; } else if (cboProductCode.SelectedItem.Text == Constants.ZERO_STRING) { lblProductPackage.Visible = false; lnkProductPackageAdd.Visible = false; lstProductPackages.Visible = false; imgProductHistory.Visible = false; imgProductPriceHistory.Visible = false; imgInventoryAdjustment.Visible = false; imgEditNow.Visible = false; lnkPackage.Visible = false; imgVariationsMatrix.Visible = false; imgUnitsMatrix.Visible = false; lblPurchasePriceHistory.Visible = false; txtProductCode.ToolTip = intProductBaseUnitID.ToString(); lblProductID.ToolTip = decCommision.ToString(); } }
private void LoadList() { string SortField = "PackageID"; if (Request.QueryString["sortfield"]!=null) { SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); } SortOption SortOrder = SortOption.Ascending; if (Request.QueryString["sortoption"]!=null) { SortOrder = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); } ProductPackage clsProductPackage = new ProductPackage(); System.Data.DataTable dt = clsProductPackage.ListAsDataTable(Convert.ToInt64(lblProductID.Text), SortField: SortField, SortOrder: SortOrder); clsProductPackage.CommitAndDispose(); PageData.DataSource = dt.DefaultView; int iPageSize = Convert.ToInt16(Session["PageSize"]) ; PageData.AllowPaging = true; PageData.PageSize = iPageSize; try { PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1; lstItem.DataSource = PageData; lstItem.DataBind(); } catch { PageData.CurrentPageIndex = 1; lstItem.DataSource = PageData; lstItem.DataBind(); } cboCurrentPage.Items.Clear(); for (int i=0; i < PageData.PageCount;i++) { int iValue = i + 1; cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString())); if (PageData.CurrentPageIndex == i) { cboCurrentPage.Items[i].Selected = true;} else { cboCurrentPage.Items[i].Selected = false;} } lblDataCount.Text = " of " + " " + PageData.PageCount; }