private 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 = "MatrixDescription";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListAsDataTable(ProductID, MatrixDescription: stSearchKey, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", "0"));
}
cboVariation.SelectedIndex = 0;
clsProductVariationsMatrix.CommitAndDispose();
}
private void LoadList()
{
string SortField = "prd.Description";
if (Request.QueryString["sortfield"] != null)
{
SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID);
}
SortOption sortoption = SortOption.Ascending;
if (Request.QueryString["sortoption"] != null)
{
sortoption = (SortOption)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true);
}
string stSearchKey = string.Empty;
if (Request.QueryString["Search"] != null)
{
stSearchKey = Server.UrlDecode(Common.Decrypt((string)Request.QueryString["search"], Session.SessionID));
}
else if (Session["Search"] != null)
{
stSearchKey = Server.UrlDecode(Common.Decrypt(Session["Search"].ToString(), Session.SessionID));
}
try { Session.Remove("Search"); }
catch { }
if (stSearchKey == null)
{
stSearchKey = string.Empty;
}
else if (stSearchKey != string.Empty)
{
Session.Add("Search", Common.Encrypt(stSearchKey, Session.SessionID));
}
ProductBaseVariationsMatrixDetails clsSearchKeys = new ProductBaseVariationsMatrixDetails();
clsSearchKeys.Description = stSearchKey;
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
System.Data.DataTable dt = clsProductVariationsMatrix.BaseListAsDataTable(Int64.Parse(lblProductID.Text), Int32.Parse(Session["BranchID"].ToString()), MatrixDescription: stSearchKey, SortField: SortField, SortOrder: sortoption);
clsProductVariationsMatrix.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;
}
