Ejemplo n.º 1
0
        protected void SalesRepresentative_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow && SalesRepresentativeGridView.EditIndex == e.Row.RowIndex)
            {
                SalesRepresentativeReportingChild li = new SalesRepresentativeReportingChild();

                //Find the DropDownList in the Row
                DropDownList ddlSalesRepTypeNameList = (e.Row.FindControl("SalesRepTypeName") as DropDownList);
                ddlSalesRepTypeNameList.DataSource     = li.SalesRepTypeNameList().Tables[0];
                ddlSalesRepTypeNameList.DataTextField  = "SalesRepTypeName";
                ddlSalesRepTypeNameList.DataValueField = "SalesRepTypeName";
                ddlSalesRepTypeNameList.DataBind();

                //Add Default Item in the DropDownList
                ddlSalesRepTypeNameList.Items.Insert(0, new ListItem("Select One"));

                //Select the Country of Customer in DropDownList
                string salesRepTypeNames = (e.Row.FindControl("lblSalesRepTypeName") as Label).Text;
                ddlSalesRepTypeNameList.Items.FindByValue(salesRepTypeNames).Selected = true;

                //Find the DropDownList in the Row
                DropDownList ddlTerritoryNameList = (e.Row.FindControl("TerritoryName") as DropDownList);
                ddlTerritoryNameList.DataSource     = li.TerritoryNameList().Tables[0];
                ddlTerritoryNameList.DataTextField  = "TerritoryName";
                ddlTerritoryNameList.DataValueField = "TerritoryName";
                ddlTerritoryNameList.DataBind();

                //Add Default Item in the DropDownList
                ddlTerritoryNameList.Items.Insert(0, new ListItem("Select One"));

                //Select the Country of Customer in DropDownList
                string   territoryNames = (e.Row.FindControl("lblTerritoryName") as Label).Text;
                ListItem item           = ddlTerritoryNameList.Items.FindByValue(territoryNames);

                if (item != null)
                {
                    ddlTerritoryNameList.SelectedValue = territoryNames;
                }

                //Find the DropDownList in the Row
                DropDownList ddlRegionNameList = (e.Row.FindControl("RegionName") as DropDownList);
                ddlRegionNameList.DataSource     = li.RegionNameList().Tables[0];
                ddlRegionNameList.DataTextField  = "RegionName";
                ddlRegionNameList.DataValueField = "RegionName";
                ddlRegionNameList.DataBind();

                //Add Default Item in the DropDownList
                ddlRegionNameList.Items.Insert(0, new ListItem("Select One"));

                //Select the Country of Customer in DropDownList
                string   regionNames = (e.Row.FindControl("lblRegionName") as Label).Text;
                ListItem item1       = ddlRegionNameList.Items.FindByValue(regionNames);

                if (item1 != null)
                {
                    ddlRegionNameList.SelectedValue = regionNames;
                }


                //DropDownList ddlDistributionRegionNameList = (e.Row.FindControl("DistributionRegionName") as DropDownList);
                //ddlDistributionRegionNameList.DataSource = li.DistributionRegionNameList().Tables[0];
                //ddlDistributionRegionNameList.DataTextField = "DistributionRegionName";
                //ddlDistributionRegionNameList.DataValueField = "DistributionRegionName";
                //ddlDistributionRegionNameList.DataBind();

                ////Add Default Item in the DropDownList
                //ddlDistributionRegionNameList.Items.Insert(0, new ListItem("Select One"));

                ////Select the Country of Customer in DropDownList
                //string distributionRegionNames = (e.Row.FindControl("lblDistributionRegionName") as Label).Text;
                //ddlDistributionRegionNameList.Items.FindByValue(distributionRegionNames).Selected = true;


                //Find the DropDownList in the Row
                DropDownList ddlSubBusinessUnitNameList = (e.Row.FindControl("SubBusinessUnitName") as DropDownList);
                ddlSubBusinessUnitNameList.DataSource     = li.SubBusinessUnitNameList().Tables[0];
                ddlSubBusinessUnitNameList.DataTextField  = "SubBusinessUnitName";
                ddlSubBusinessUnitNameList.DataValueField = "SubBusinessUnitName";
                ddlSubBusinessUnitNameList.DataBind();

                //Add Default Item in the DropDownList
                ddlSubBusinessUnitNameList.Items.Insert(0, new ListItem("Select One"));

                //Select the Country of Customer in DropDownList
                string   subBusinessUnitNames = (e.Row.FindControl("lblSubBusinessUnitName") as Label).Text;
                ListItem item2 = ddlSubBusinessUnitNameList.Items.FindByValue(subBusinessUnitNames);

                if (item2 != null)
                {
                    ddlSubBusinessUnitNameList.SelectedValue = subBusinessUnitNames;
                }


                //Find the DropDownList in the Row
                DropDownList ddlBusinessUnitNameList = (e.Row.FindControl("BusinessUnitName") as DropDownList);
                ddlBusinessUnitNameList.DataSource     = li.BusinessUnitNameList().Tables[0];
                ddlBusinessUnitNameList.DataTextField  = "BusinessUnitName";
                ddlBusinessUnitNameList.DataValueField = "BusinessUnitName";
                ddlBusinessUnitNameList.DataBind();

                //Add Default Item in the DropDownList
                ddlBusinessUnitNameList.Items.Insert(0, new ListItem("Select One"));

                //Select the Country of Customer in DropDownList
                string   businessUnitNames = (e.Row.FindControl("lblBusinessUnitName") as Label).Text;
                ListItem item3             = ddlBusinessUnitNameList.Items.FindByValue(businessUnitNames);

                if (item3 != null)
                {
                    ddlBusinessUnitNameList.SelectedValue = businessUnitNames;
                }


                //Find the DropDownList in the Row
                DropDownList ddlCompanyNameList = (e.Row.FindControl("CompanyName") as DropDownList);
                ddlCompanyNameList.DataSource     = li.CompanyNameList().Tables[0];
                ddlCompanyNameList.DataTextField  = "CompanyName";
                ddlCompanyNameList.DataValueField = "CompanyName";
                ddlCompanyNameList.DataBind();

                //Add Default Item in the DropDownList
                ddlCompanyNameList.Items.Insert(0, new ListItem("Select One"));

                //Select the Country of Customer in DropDownList
                string companyNames = (e.Row.FindControl("lblCompanyName") as Label).Text;
                ddlCompanyNameList.Items.FindByValue(companyNames).Selected = true;
            }
        }
Ejemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //VBFunctions.ADFunctions obj = new VBFunctions.ADFunctions();
            //string userID = obj.GetUserName();
            //// string dirEntry = obj.GetDirectoryEntry();
            //memberships = obj.VerifyGroupMemberships("LDAP://192.168.100.3/ou=Cooper Network Users,dc=coopersurgical1,dc=com", "webapps", "Yankees#1", userID);

            if (!Page.IsPostBack)

            {
                //if (memberships == 1 || memberships == 4)
                //{
                SalesRepresentativeReportingChild li = new SalesRepresentativeReportingChild();

                DataTable table = new DataTable();

                ddlSalesRepLastName.DataSource    = li.LastNameList().Tables[0];
                ddlSalesRepLastName.DataTextField = "SalesRepLastName";
                ddlSalesRepLastName.DataBind();

                ddlSalesRepTypeName.DataSource    = li.SalesRepTypeNameList().Tables[0];
                ddlSalesRepTypeName.DataTextField = "SalesRepTypeName";
                ddlSalesRepTypeName.DataBind();

                newSalesRepTypeName.DataSource    = ddlSalesRepTypeName.DataSource;
                newSalesRepTypeName.DataTextField = "SalesRepTypeName";
                newSalesRepTypeName.DataBind();

                ddlTerritoryName.DataSource    = li.TerritoryNameList().Tables[0];
                ddlTerritoryName.DataTextField = "TerritoryName";
                ddlTerritoryName.DataBind();

                newTerritoryName.DataSource    = ddlTerritoryName.DataSource;
                newTerritoryName.DataTextField = "TerritoryName";
                newTerritoryName.DataBind();

                ddlRegionName.DataSource    = li.RegionNameList().Tables[0];
                ddlRegionName.DataTextField = "RegionName";
                ddlRegionName.DataBind();

                newRegionName.DataSource    = ddlRegionName.DataSource;
                newRegionName.DataTextField = "RegionName";
                newRegionName.DataBind();

                ddlDistributionRegionName.DataSource    = li.DistributionRegionNameList().Tables[0];
                ddlDistributionRegionName.DataTextField = "DistributionRegionName";
                ddlDistributionRegionName.DataBind();

                newDistributionRegionName.DataSource    = ddlDistributionRegionName.DataSource;
                newDistributionRegionName.DataTextField = "DistributionRegionName";
                newDistributionRegionName.DataBind();

                ddlSubBusinessUnitName.DataSource    = li.SubBusinessUnitNameList().Tables[0];
                ddlSubBusinessUnitName.DataTextField = "SubBusinessUnitName";
                ddlSubBusinessUnitName.DataBind();

                newSubBusinessUnitName.DataSource    = ddlSubBusinessUnitName.DataSource;
                newSubBusinessUnitName.DataTextField = "SubBusinessUnitName";
                newSubBusinessUnitName.DataBind();

                ddlBusinessUnitName.DataSource    = li.BusinessUnitNameList().Tables[0];
                ddlBusinessUnitName.DataTextField = "BusinessUnitName";
                ddlBusinessUnitName.DataBind();

                newBusinessUnitName.DataSource    = ddlBusinessUnitName.DataSource;
                newBusinessUnitName.DataTextField = "BusinessUnitName";
                newBusinessUnitName.DataBind();

                ddlCompanyName.DataSource    = li.CompanyNameList().Tables[0];
                ddlCompanyName.DataTextField = "CompanyName";
                ddlCompanyName.DataBind();

                newCompanyName.DataSource    = ddlCompanyName.DataSource;
                newCompanyName.DataTextField = "CompanyName";
                newCompanyName.DataBind();


                newCountryName.DataSource    = li.CountryNameList().Tables[0];
                newCountryName.DataTextField = "CountryName";
                newCountryName.DataBind();


                newStateProvinceName.DataSource    = li.StateProvinceNameList().Tables[0];
                newStateProvinceName.DataTextField = "StateProvinceName";
                newStateProvinceName.DataBind();


                //newCustomerNumber.DataSource = li.CustomerNumberList().Tables[0];
                //newCustomerNumber.DataTextField = "CustomerID";
                //newCustomerNumber.DataBind();

                BindGridView();
                //   }
            }
        }