/// <summary>
/// lookup - to get civil division name by civil division id
/// </summary>
public string GetCivilDivisionNameByID(string civilDivisionFIPS)
{
using (ApplicationServicesCoreEntities dbCivilDivision = new ApplicationServicesCoreEntities())
{
if (civilDivisionFIPS == "0")
{
return("");
}
else if (civilDivisionFIPS == "US26099")
{
return("County Wide");
}
else if (civilDivisionFIPS == "")
{
return("Out of County");
}
else
{
string name = dbCivilDivision.Regions
.Where(u => u.sz_fips_code == civilDivisionFIPS)
.Select(u => u.sz_name)
.FirstOrDefault();
return(name);
}
}
}
/// <summary>
/// to get all civil divisions
/// </summary>
public List <SelectListItem> GetCivilDivisions()
{
using (ApplicationServicesCoreEntities dbCivilDivision = new ApplicationServicesCoreEntities())
{
List <SelectListItem> civilDivisions = (List <SelectListItem>)(from cd in dbCivilDivision.Regions
join r in dbCivilDivision.RegionTypes
on cd.sz_region_type_id
equals r.sz_region_type_id
where r.sz_name == "CVT"
select new SelectListItem {
Value = cd.sz_fips_code.ToString(), Text = cd.sz_description
})
.Distinct()
.ToList();
foreach (var item in civilDivisions)
{
string text;
if (item.Text.Substring(0, 11) == "Township of")
{
text = item.Text.Replace("Township of ", "");
item.Text = text + " Township";
}
text = item.Text.Replace("City of ", "").Replace("Village of ", "").Replace("Villiage of ", "");
item.Text = text;
}
var sortedCivilDivisions = civilDivisions.OrderBy(u => u.Text).ToList();
sortedCivilDivisions.Add(new SelectListItem {
Value = "", Text = "Out of County"
});
sortedCivilDivisions.Insert(0, new SelectListItem {
Value = "US26099", Text = "County Wide"
});
return((List <SelectListItem>)sortedCivilDivisions);
}
}
