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);
}
}
}
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);
}
}
}
