public ActionResult GetCitiesCommunitiesByCounty(int county)
{
ICitiesCommunitiesRepository citiesRepository = new CitiesCommunitiesRepository(db);
var cities = citiesRepository.GetCitiesCommunitiesByCounty(county).OrderBy(c => c.Name);
return(Json(cities.Select(c => new { value = c.CityCommunityPK, text = c.Name }), JsonRequestBehavior.AllowGet));
}
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");
}
