public ActionResult Index()
{
//using (var context = new EmployeeDetailsContext())
//{
// List<EmployeeDetails> Employeelist = context.EmployeeDetails.ToList();
// List<District> District1 = context.districts.ToList();
// List<SubDivision> SubDivision1 = context.SubDivisions.ToList();
// return View(Employeelist);
//}
EmployeeDetailsContext entities = new EmployeeDetailsContext();
DM_DashboardModel dmModel = new DM_DashboardModel();
foreach (var district in entities.districts)
{
dmModel.District.Add(new SelectListItem {
Text = district.DistName, Value = district.DistId.ToString()
});
}
return(View(dmModel));
//return View();
}
public ActionResult Index(int?districtId, int?subDivisionId)
{
DM_DashboardModel dmModel = new DM_DashboardModel();
EmployeeDetailsContext entities = new EmployeeDetailsContext();
foreach (var district in entities.districts)
{
dmModel.District.Add(new SelectListItem {
Text = district.DistName, Value = district.DistId.ToString()
});
}
if (districtId.HasValue)
{
var subDivisions = (from subDivision in entities.SubDivisions
where subDivision.DistrictId == districtId.Value
select subDivision).ToList();
foreach (var district in subDivisions)
{
dmModel.SubDivision.Add(new SelectListItem {
Text = district.SubDivName, Value = district.SubDivId.ToString()
});
}
//if (stateId.HasValue)
//{
// var cities = (from city in entities.Cities
// where city.StateId == stateId.Value
// select city).ToList();
// foreach (var city in cities)
// {
// model.Cities.Add(new SelectListItem { Text = city.CityName, Value = city.CityId.ToString() });
// }
//}
}
return(View(dmModel));
}
