public void BindDDLs(LegalEntityBranchView legalEntityBranchView, ObjectContext db) { //countries ddl ICountriesRepository countriesRepository = new CountriesRepository(db); legalEntityBranchView.Countries = new SelectList(countriesRepository.GetValid().OrderBy("Name ASC").ToList(), "CountryPK", "Name"); //counties ddl ICountiesRepository countiesRepository = new CountiesRepository(db); legalEntityBranchView.Counties = new SelectList(countiesRepository.GetCountiesByCountry((int)legalEntityBranchView.CountryFK).OrderBy("Name ASC").ToList(), "CountyPK", "Name"); //citiesCommunities dll if (legalEntityBranchView.CountyFK != null) { ICitiesCommunitiesRepository citiesCommunitiesRepository = new CitiesCommunitiesRepository(db); legalEntityBranchView.CitiesCommunities = new SelectList(citiesCommunitiesRepository.GetCitiesCommunitiesByCounty(Convert.ToInt32(legalEntityBranchView.CountyFK)).OrderBy("Name ASC"), "CityCommunityPK", "Name", legalEntityBranchView.CityCommunityFK); } else { legalEntityBranchView.CitiesCommunities = new SelectList(new List <CityCommunity>(), "CityCommunityPK", "Name"); } //postal offices dll if (legalEntityBranchView.CountyFK != null) { IPostalOfficesRepository postalOfficesRepository = new PostalOfficesRepository(db); legalEntityBranchView.PostalOffices = new SelectList(postalOfficesRepository.GetValidByCounty(Convert.ToInt32(legalEntityBranchView.CountyFK)).OrderBy("Name ASC"), "PostalOfficePK", "Name", legalEntityBranchView.PostalOfficeFK); } else { legalEntityBranchView.PostalOffices = new SelectList(new List <PostalOffice>(), "PostalOfficePK", "Name"); } //places dll if (legalEntityBranchView.PostalOfficeFK != null) { IPlacesRepository placesRepository = new PlacesRepository(db); legalEntityBranchView.Places = new SelectList(placesRepository.GetPlacesByPostalOffice(Convert.ToInt32(legalEntityBranchView.PostalOfficeFK)).OrderBy("Name ASC"), "PlacePK", "Name", legalEntityBranchView.PlaceFK); } else { legalEntityBranchView.Places = new SelectList(new List <Place>(), "PlacePK", "Name"); } }
public void BindDDLs(PhysicalEntityView physicalEntityView, ObjectContext db) { //countries ddl ICountriesRepository countriesRepository = new CountriesRepository(db); physicalEntityView.Citizenships = new SelectList(countriesRepository.GetCitizenships().ToList(), "CountryPK", "Citizenship"); physicalEntityView.BirthCountries = new SelectList(countriesRepository.GetValid().OrderBy("Name ASC").ToList(), "CountryPK", "Name"); physicalEntityView.ResidenceCountries = new SelectList(countriesRepository.GetValid().OrderBy("Name ASC").ToList(), "CountryPK", "Name"); physicalEntityView.PassportCountriesOfIssue = new SelectList(countriesRepository.GetValid().OrderBy("Name ASC").ToList(), "CountryPK", "Name"); //counties ddl if (physicalEntityView.BirthCountryFK != null) { ICountiesRepository countiesRepository = new CountiesRepository(db); physicalEntityView.BirthCounties = new SelectList(countiesRepository.GetCountiesByCountry(Convert.ToInt32(physicalEntityView.BirthCountryFK)), "CountyPK", "Name", physicalEntityView.BirthCountyFK); } else { physicalEntityView.BirthCounties = new SelectList(new List <County>(), "CountyPK", "Name"); } if (physicalEntityView.ResidenceCountryFK != null) { ICountiesRepository countiesRepository = new CountiesRepository(db); physicalEntityView.ResidenceCounties = new SelectList(countiesRepository.GetCountiesByCountry(Convert.ToInt32(physicalEntityView.ResidenceCountryFK)), "CountyPK", "Name", physicalEntityView.ResidenceCountyFK); } else { physicalEntityView.ResidenceCounties = new SelectList(new List <County>(), "CountyPK", "Name"); } //citiesCommunities ddl if (physicalEntityView.BirthCountyFK != null) { ICitiesCommunitiesRepository citiesCommunitiesRepository = new CitiesCommunitiesRepository(db); physicalEntityView.BirthCitiesCommunities = new SelectList(citiesCommunitiesRepository.GetCitiesCommunitiesByCounty(Convert.ToInt32(physicalEntityView.BirthCountyFK)), "CityCommunityPK", "Name", physicalEntityView.BirthCityCommunityFK); } else { physicalEntityView.BirthCitiesCommunities = new SelectList(new List <CityCommunity>(), "CityCommunityPK", "Name"); } if (physicalEntityView.ResidenceCountyFK != null) { ICitiesCommunitiesRepository citiesCommunitiesRepository = new CitiesCommunitiesRepository(db); physicalEntityView.ResidenceCitiesCommunities = new SelectList(citiesCommunitiesRepository.GetCitiesCommunitiesByCounty(Convert.ToInt32(physicalEntityView.ResidenceCountyFK)), "CityCommunityPK", "Name", physicalEntityView.ResidenceCityCommunityFK); } else { physicalEntityView.ResidenceCitiesCommunities = new SelectList(new List <CityCommunity>(), "CityCommunityPK", "Name"); } //postal offices if (physicalEntityView.ResidenceCountyFK != null) { IPostalOfficesRepository postalOfficesRepository = new PostalOfficesRepository(db); var postalOffices = postalOfficesRepository.GetValidByCounty(Convert.ToInt32(physicalEntityView.ResidenceCountyFK)).OrderBy(c => c.Name); physicalEntityView.ResidencePostalOffices = new SelectList(postalOffices.Select(c => new { value = c.PostalOfficePK, text = c.Name + " (" + SqlFunctions.StringConvert((double)c.Number).Trim() + ")" }), "value", "text", physicalEntityView.ResidencePostalOfficeFK); } else { physicalEntityView.ResidencePostalOffices = new SelectList(new List <PostalOffice>(), "PostalOfficePK", "Name"); } //places if (physicalEntityView.ResidencePostalOfficeFK != null) { IPlacesRepository placesRepository = new PlacesRepository(db); physicalEntityView.ResidencePlaces = new SelectList(placesRepository.GetPlacesByPostalOffice(Convert.ToInt32(physicalEntityView.ResidencePostalOfficeFK)), "PlacePK", "Name", physicalEntityView.ResidencePlaceFK); } else { physicalEntityView.ResidencePlaces = new SelectList(new List <Place>(), "PlacePK", "Name"); } //regional offices ddl IRegionalOfficesRepository regionalOfficesView = new RegionalOfficesRepository(db); physicalEntityView.IdentityCardRegionalOffices = new SelectList(regionalOfficesView.GetValid().ToList(), "RegionalOfficePK", "Name", physicalEntityView.IdentityCardRegionalOfficeFK); physicalEntityView.ReferentRegionalOffices = new SelectList(regionalOfficesView.GetValid().ToList(), "RegionalOfficePK", "Name", physicalEntityView.ReferentRegionalOfficeFK); //substations if (physicalEntityView.ReferentRegionalOfficeFK != null) { ISubstationsRepository substationsRepository = new SubstationsRepository(db); physicalEntityView.ReferentSubstations = new SelectList(substationsRepository.GetValidByRegionalOffice(Convert.ToInt32(physicalEntityView.ReferentRegionalOfficeFK)), "SubstationPK", "Name", physicalEntityView.ReferentSubstationFK); } else { physicalEntityView.ReferentSubstations = new SelectList(new List <Place>(), "SubstationPK", "Name"); } // genders dll physicalEntityView.Genders = new SelectList(GeneratorView.GenerateGenders(), "Value", "Text"); }