public void BindDdlBranch() { FuneralServiceReference.FuneralServicesClient client = new FuneralServiceReference.FuneralServicesClient(); ddlBranch.DataSource = client.GetAllBranch(ParlourId); ddlBranch.DataBind(); ddlMemberBranch.DataSource = client.GetAllBranch(ParlourId); ddlMemberBranch.DataBind(); }
//public void BindDdlExpenseBranch() //{ // // string[] Policystatuslist = client.GetDistinctPolicyStatusList(); // SqlCommand com = new SqlCommand(); // com.CommandType = CommandType.StoredProcedure; // com.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["FuneralConnection"].ConnectionString); // com.CommandText = "SelectDistinctExpensesBranchList"; // SqlDataAdapter adp = new SqlDataAdapter(com); // DataTable dt = new DataTable(); // adp.Fill(dt); // if (dt.Rows.Count > 0) // { // ddlExpenseBranch.DataSource = dt; // ddlExpenseBranch.DataTextField = "ExpenseBranch"; // ddlExpenseBranch.DataValueField = "ExpenseBranch"; // ddlExpenseBranch.DataBind(); // ddlExpenseBranch.Items.Insert(0, new ListItem("All", "All")); // ddlExpenseBranch.Items.FindByText("All").Selected = true; // } //} public void BindDdlBranch() { FuneralServiceReference.FuneralServicesClient client = new FuneralServiceReference.FuneralServicesClient(); ddlBranch.DataSource = client.GetAllBranch(ParlourId); ddlBranch.DataBind(); ddlBranch.Items.Insert(0, new ListItem("ALL", "ALL")); ddlBranch.Items.FindByText("ALL").Selected = true; ddlMemberBranch.DataSource = client.GetAllBranch(ParlourId); ddlMemberBranch.DataBind(); ddlMemberBranch.Items.Insert(0, new ListItem("ALL", "ALL")); ddlMemberBranch.Items.FindByText("ALL").Selected = true; ddlMemberPerBranch.DataSource = client.GetAllBranch(ParlourId); ddlMemberPerBranch.DataBind(); ddlMemberPerBranch.Items.Insert(0, new ListItem("ALL", "ALL")); ddlMemberPerBranch.Items.FindByText("ALL").Selected = true; }