protected void DDLCustGroup_SelectedIndexChanged(object sender, EventArgs e) { CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); if (DDLCustGroupNew.Text == "ALL") { string queryALLCustomer = " Select CUSTOMER_CODE, CUSTOMER_NAME from ax.acxcustmaster where SITE_CODE='" + Session["SiteCode"].ToString() + "' and DATAAREAID='" + Session["DATAAREAID"].ToString() + "'" + " UNION " + "SELECT SUBDISTRIBUTOR AS Customer_Code, SUBDISTRIBUTOR + '-' + NAME AS CUSTOMER_NAME from ax.ACX_SDLINKING where OTHER_SITE='" + Session["SiteCode"].ToString() + "' and DATAAREAID='" + Session["DATAAREAID"].ToString() + "'"; DDLCustomersNew.Items.Clear(); DDLCustomersNew.Items.Add("-Select-"); obj.BindToDropDownp(DDLCustomersNew, queryALLCustomer, "CUSTOMER_NAME", "CUSTOMER_CODE"); } else { string queryCustomer = " Select CUSTOMER_CODE, CUSTOMER_NAME from ax.acxcustmaster where CUST_GROUP='" + DDLCustGroupNew.SelectedValue.ToString() + "' " + " and SITE_CODE='" + Session["SiteCode"].ToString() + "' and DATAAREAID='" + Session["DATAAREAID"].ToString() + "'" + " UNION " + "SELECT SUBDISTRIBUTOR AS Customer_Code, SUBDISTRIBUTOR + '-' + NAME AS CUSTOMER_NAME from ax.ACX_SDLINKING where CUSTGROUP='" + DDLCustGroupNew.SelectedValue.ToString() + "' " + " and OTHER_SITE='" + Session["SiteCode"].ToString() + "' and DATAAREAID='" + Session["DATAAREAID"].ToString() + "'"; DDLCustomersNew.Items.Clear(); DDLCustomersNew.Items.Add("-Select-"); obj.BindToDropDownp(DDLCustomersNew, queryCustomer, "CUSTOMER_NAME", "CUSTOMER_CODE"); } }
protected void DDLProductGroup_SelectedIndexChanged(object sender, EventArgs e) { try { CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); if (DDLProductGroupNew.Text == "ALL") { DDLSubCategoryNew.Items.Clear(); DDLProductNew.Items.Clear(); } else { string strQuery = " Select distinct replace(replace(PRODUCT_SUBCATEGORY, char(9), ''), char(13) + char(10), '') as SUBCATEGORY from " + " ax.INVENTTABLE where replace(replace(PRODUCT_GROUP, char(9), ''), char(13) + char(10), '') = '" + DDLProductGroupNew.SelectedItem.Text.ToString() + "' "; DDLSubCategoryNew.Items.Clear(); DDLSubCategoryNew.Items.Clear(); DDLSubCategoryNew.Items.Add("-Select-"); obj.BindToDropDownp(DDLSubCategoryNew, strQuery, "SUBCATEGORY", "SUBCATEGORY"); } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
protected void DDLCustGroup_SelectedIndexChanged(object sender, EventArgs e) { try { CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); if (DDLCustGroupNew.Text == "ALL") { string queryALLCustomer = " Select CUSTOMER_CODE, CUSTOMER_NAME from ax.acxcustmaster where SITE_CODE='" + Session["SiteCode"].ToString() + "' and DATAAREAID='" + Session["DATAAREAID"].ToString() + "'and BLOCKED = 0"; DDLCustomersNew.Items.Clear(); //DDLCustomers.Items.Add("-Select-"); //obj.BindToDropDown(DDLCustomers, queryALLCustomer, "CUSTOMER_NAME", "CUSTOMER_CODE"); } else { string queryCustomer = " Select CUSTOMER_CODE, CUSTOMER_NAME from ax.acxcustmaster where CUST_GROUP='" + DDLCustGroupNew.SelectedValue.ToString() + "' " + " and SITE_CODE='" + Session["SiteCode"].ToString() + "' and DATAAREAID='" + Session["DATAAREAID"].ToString() + "'and BLOCKED = 0"; DDLCustomersNew.Items.Clear(); DDLCustomersNew.Items.Add("-Select-"); obj.BindToDropDownp(DDLCustomersNew, queryCustomer, "CUSTOMER_NAME", "CUSTOMER_CODE"); } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
private void BindFilters() { CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); string queryCustomerGroup = " Select CUSTGROUP_CODE, CUSTGROUP_NAME, CUSTGROUP_CODE+'-'+ CUSTGROUP_NAME as CUSTGROUP from [ax].[ACXCUSTGROUPMASTER] where DATAAREAID='" + Session["DATAAREAID"].ToString() + "' and BLOCKED<>1 "; DDLCustGroupNew.Items.Clear(); DDLCustGroupNew.Items.Add("ALL"); obj.BindToDropDownp(DDLCustGroupNew, queryCustomerGroup, "CUSTGROUP", "CUSTGROUP_CODE"); string query = "select bm.bu_code,bu_desc from ax.acxsitebumapping sbp join ax.ACXBUMASTER bm on bm.bu_code = sbp.BU_CODE where SITEID = '" + Convert.ToString(Session["SiteCode"]) + "'"; DDLBusinessUnitNew.Items.Clear(); DDLBusinessUnitNew.Items.Add("All..."); obj.BindToDropDownp(DDLBusinessUnitNew, query, "bu_desc", "bu_code"); DDLCustGroup_SelectedIndexChanged(null, null); }
private void BindFilters() { CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); string queryCustomerGroup = " Select CUSTGROUP_CODE, CUSTGROUP_NAME, CUSTGROUP_CODE+'-'+ CUSTGROUP_NAME as CUSTGROUP from [ax].[ACXCUSTGROUPMASTER] where DATAAREAID='" + Session["DATAAREAID"].ToString() + "' and BLOCKED<>1 "; DDLCustGroupNew.Items.Clear(); DDLCustGroupNew.Items.Add("ALL"); obj.BindToDropDownp(DDLCustGroupNew, queryCustomerGroup, "CUSTGROUP", "CUSTGROUP_CODE"); }
private void BindFilters() { try { CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); string queryCustomerGroup = " Select CUSTGROUP_CODE, CUSTGROUP_NAME, CUSTGROUP_CODE+'-'+ CUSTGROUP_NAME as CUSTGROUP from [ax].[ACXCUSTGROUPMASTER] where DATAAREAID='" + Session["DATAAREAID"].ToString() + "' and BLOCKED<>1 "; DDLCustGroupNew.Items.Clear(); DDLCustGroupNew.Items.Add("ALL"); obj.BindToDropDownp(DDLCustGroupNew, queryCustomerGroup, "CUSTGROUP", "CUSTGROUP_CODE"); string queryProductGroup = "Select distinct PRODUCT_GROUP from ax.INVENTTABLE"; DDLProductGroupNew.Items.Clear(); DDLProductGroupNew.Items.Add("ALL"); obj.BindToDropDownp(DDLProductGroupNew, queryProductGroup, "PRODUCT_GROUP", "PRODUCT_GROUP"); } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
public void fillCustomerGroup() { try { query = "Select CUSTGROUP_CODE+'-'+CUSTGROUP_NAME as Name,CUSTGROUP_CODE from ax.ACXCUSTGROUPMASTER where DATAAREAID ='" + Session["DATAAREAID"].ToString() + "' and Blocked = 0"; drpCustomerGroupNew.Items.Clear(); drpCustomerGroupNew.Items.Add("--Select--"); obj.BindToDropDownp(drpCustomerGroupNew, query, "Name", "CUSTGROUP_CODE"); } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["USERID"] == null || Session["USERID"].ToString() == string.Empty) { Response.Redirect("Login.aspx"); return; } if (!IsPostBack) { string query = "select bm.bu_code,bu_desc from ax.acxsitebumapping sbp join ax.ACXBUMASTER bm on bm.bu_code = sbp.BU_CODE where SITEID ='" + ucRoleFilters.GetCommaSepartedSiteId() + "' "; DDLBusinessUnitNew.Items.Clear(); DDLBusinessUnitNew.Items.Add("All..."); baseObj.BindToDropDownp(DDLBusinessUnitNew, query, "bu_desc", "bu_code"); fillStateCode(); fillSiteCode(); } }
protected void DDLSubCategory_SelectedIndexChanged(object sender, EventArgs e) { try { CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global(); if (DDLSubCategoryNew.Text == "-Select-") { DDLProductNew.Items.Clear(); } else { string strQuery = " Select ITEMID +'-(' + PRODUCT_NAME+')' as PRODUCT_NAME,PRODUCT_NAME as PRODDESCP, ITEMID,PRODUCT_GROUP, PRODUCT_SUBCATEGORY from ax.INVENTTABLE where " + " replace(replace(PRODUCT_SUBCATEGORY, char(9), ''), char(13) + char(10), '') = '" + DDLSubCategoryNew.SelectedItem.Text.ToString() + "' "; DDLProductNew.Items.Clear(); DDLProductNew.Items.Add("-Select-"); obj.BindToDropDownp(DDLProductNew, strQuery, "PRODUCT_NAME", "PRODDESCP"); } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }