protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
{
Int64 id = Int64.Parse(ddlCategory.SelectedValue.ToString());
try
{
product objProduct = new product();
Cls_product_b clsProduct = new Cls_product_b();
dtProduct = clsProduct.Product_WSSelectAllProductUsingCategoryId(id);
if (dtProduct != null)
{
if (dtProduct.Rows.Count > 0)
{
//ddlProduct.DataSource = dtProduct;
//ddlProduct.DataTextField = "productname";
//ddlProduct.DataValueField = "pid";
//ddlProduct.DataBind();
//System.Web.UI.WebControls.ListItem objListItem = new System.Web.UI.WebControls.ListItem("--Select Product(s)--", "0");
//ddlProduct.Items.Insert(0, objListItem);
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
//return null;
}
finally { con.Close(); }
}
private void BindProductCombo()
{
DataTable dtProcess = new Cls_product_b().SelectAll();
ddlProduct.Items.Clear();
if (dtProcess != null)
{
if (dtProcess.Rows.Count > 0)
{
ddlProduct.DataSource = dtProcess;
ddlProduct.DataTextField = "productname";
ddlProduct.DataValueField = "pid";
ddlProduct.DataBind();
ListItem objListItem = new ListItem("--Select Product--", "0");
ddlProduct.Items.Insert(0, objListItem);
}
else
{
ddlProduct.DataSource = null;
ddlProduct.DataBind();
}
}
else
{
ddlProduct.DataSource = null;
ddlProduct.DataBind();
}
}
private void Bind()
{
//List<SelectListItem> list = new List<SelectListItem>();
DataTable dtArticle = new DataTable();
DataTable dtColor = new DataTable();
DataTable dtSize = new DataTable();
DataTable dtEmployee = new DataTable();
//if (dtProduct == null)
//{
// System.Web.UI.WebControls.ListItem objListItem = new System.Web.UI.WebControls.ListItem("--Select Product(s)--", "0");
// ddlProduct.Items.Insert(0, objListItem);
//}
try
{
Cls_product_b clsProduct = new Cls_product_b();
dtArticle = clsProduct.SelectAll();
Cls_color_b clsColor = new Cls_color_b();
dtColor = clsColor.SelectAll();
//Cls_size_b clsSize = new Cls_size_b();
//dtSize = clsSize.SelectAll();
Cls_groupmaster_b clsSize = new Cls_groupmaster_b();
dtSize = clsSize.SelectAll();
Cls_Employee_b clsEmployee = new Cls_Employee_b();
dtEmployee = clsEmployee.SelectAll();
}
catch { }
finally { con.Close(); }
if (dtArticle != null)
{
if (dtArticle.Rows.Count > 0)
{
ddlArticle.DataSource = dtArticle;
ddlArticle.DataTextField = "productname";
ddlArticle.DataValueField = "pid";
ddlArticle.DataBind();
System.Web.UI.WebControls.ListItem objListItem = new System.Web.UI.WebControls.ListItem("--Select Article--", "0");
ddlArticle.Items.Insert(0, objListItem);
}
}
if (dtColor != null)
{
if (dtColor.Rows.Count > 0)
{
//ddlColor.DataSource = dtColor;
//ddlColor.DataTextField = "colorname";
//ddlColor.DataValueField = "cid";
//ddlColor.DataBind();
//System.Web.UI.WebControls.ListItem objListItem = new System.Web.UI.WebControls.ListItem("--Select Color--", "0");
//ddlColor.Items.Insert(0, objListItem);
lstColor.DataSource = dtColor;
lstColor.DataTextField = "colorname";
lstColor.DataValueField = "cid";
lstColor.DataBind();
//System.Web.UI.WebControls.ListItem objListItem = new System.Web.UI.WebControls.ListItem("--Select Color--", "0");
//lstColor.Items.Insert(0, objListItem);
}
else
{
lstColor.DataSource = dtColor;
lstColor.DataTextField = "colorname";
lstColor.DataValueField = "cid";
lstColor.DataBind();
}
}
else
{
lstColor.DataSource = dtColor;
lstColor.DataTextField = "colorname";
lstColor.DataValueField = "cid";
lstColor.DataBind();
}
if (dtSize != null)
{
if (dtSize.Rows.Count > 0)
{
//ddlSize.DataSource = dtSize;
//ddlSize.DataTextField = "sizeName";
//ddlSize.DataValueField = "cid";
//ddlSize.DataBind();
//System.Web.UI.WebControls.ListItem objListItem = new System.Web.UI.WebControls.ListItem("--Select Size--", "0");
//ddlSize.Items.Insert(0, objListItem);
lstSize.DataSource = dtSize;
lstSize.DataTextField = "groupname";
lstSize.DataValueField = "id";
lstSize.DataBind();
}
else
{
lstSize.DataSource = dtSize;
lstSize.DataTextField = "groupname";
lstSize.DataValueField = "id";
lstSize.DataBind();
}
}
else
{
lstSize.DataSource = dtSize;
lstSize.DataTextField = "groupname";
lstSize.DataValueField = "id";
lstSize.DataBind();
}
if (dtEmployee != null)
{
if (dtEmployee.Rows.Count > 0)
{
Session["employee"] = dtEmployee;
ddlEmployee.DataSource = dtEmployee;
ddlEmployee.DataTextField = "employeeName";
ddlEmployee.DataValueField = "id";
ddlEmployee.DataBind();
System.Web.UI.WebControls.ListItem objListItem = new System.Web.UI.WebControls.ListItem("--Select Employee--", "0");
ddlEmployee.Items.Insert(0, objListItem);
}
}
}
