public void LoadRegionGroupFromState(int pstateid, bool includeRegional = false) { client = new SQSAdminServiceClient(); client.Endpoint.Address = new System.ServiceModel.EndpointAddress(CommonVariables.WcfEndpoint); DataSet ds = client.SQSAdmin_StandardInclusion_GetRegionGroupByState(pstateid); client.Close(); SQSRegionGroup.Clear(); SQSRegionGroupWithAll.Clear(); RegionGroup rg = null; if (pstateid == 1) { rg = new RegionGroup(); rg.RegionGroupID = 0; rg.RegionGroupName = "All Regions"; SQSRegionGroupWithAll.Add(rg); } foreach (DataRow dr in ds.Tables[0].Rows) { rg = new RegionGroup(); rg.RegionGroupID = int.Parse(dr["idregiongroup"].ToString()); rg.RegionGroupName = dr["regiongroupname"].ToString(); SQSRegionGroup.Add(rg); SQSRegionGroupWithAll.Add(rg); } if (pstateid == 1 && includeRegional) { rg = new RegionGroup(); rg.RegionGroupID = 12; rg.RegionGroupName = "Regional"; SQSRegionGroupWithAll.Insert(2, rg); } }