protected void cmdVariationSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e) { string stSearchKey = txtVariation.Text.ToString(); if (txtVariation.Text == null) stSearchKey = ""; DataClass clsDataClass = new DataClass(); long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); cboVariation.DataTextField = "Description"; cboVariation.DataValueField = "MatrixID"; cboVariation.DataSource = clsDataClass.DataReaderToDataTable(clsProductVariationsMatrix.Search(ProductID, stSearchKey, "VariationDesc",SortOption.Ascending)).DefaultView; cboVariation.DataBind(); if (cboVariation.Items.Count == 0) { cboVariation.Items.Add(new ListItem("No Variation", "0")); } cboVariation.SelectedIndex = cboVariation.Items.Count - 1; clsProductVariationsMatrix.CommitAndDispose(); }
private void LoadItemData() { try { DataClass clsData = new DataClass(); ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); System.Data.DataTable dt = clsData.DataReaderToDataTable(clsProductVariationsMatrix.Search(mDetails.ProductID, "", "a.Description", SortOption.Ascending, 100, mboShowItemMoreThanZeroQty)); clsProductVariationsMatrix.CommitAndDispose(); lstItems.Items.Clear(); int iImgCtr = 0; foreach (System.Data.DataRow dr in dt.Rows) { if (mboIsPriceInq) lstItems.Items.Add(dr["MatriXID"].ToString(), "[" + dr["Price"].ToString() + "]" + Environment.NewLine + dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["Description"].ToString(), iImgCtr); else lstItems.Items.Add(dr["MatriXID"].ToString(), dr["Quantity"].ToString() + " " + dr["UnitCode"].ToString() + " - " + dr["Description"].ToString(), iImgCtr); if (iImgCtr == 7) iImgCtr = 0; else iImgCtr++; } try { lstItems.Items[0].Selected = true; } catch { } } catch (Exception ex) { if (ex.Message.ToLower() != "index was outside the bounds of the array.") MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); } }
private void LoadItemData() { ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(); try { string searchkey = "" + txtSearch.Text; DataClass clsData = new DataClass(); System.Data.DataTable dt = clsData.DataReaderToDataTable(clsProductVariationsMatrix.Search(mDetails.ProductID,searchkey,"a.Description",SortOption.Ascending, 100, mboShowItemMoreThanZeroQty)); clsProductVariationsMatrix.CommitAndDispose(); //dt.TableName = "tblProductVariationsMatrix"; this.dgStyle.MappingName = dt.TableName; dgItems.DataSource = dt; dgItems.Select(0); dgItems.CurrentRowIndex=0; } catch (Exception ex) { clsProductVariationsMatrix.CommitAndDispose(); if (ex.Message.ToLower() != "index was outside the bounds of the array.") MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error); } }