Hello,
I am having the problem to retrieve the values in second and third list with respect to first drop down list.
Here is my Controller class code :
namespace MVCCascading.Controllers
{
public class HomeController : Controller
{
MVCDDEntities _entities = new MVCDDEntities();
public ActionResult Index()
{
ViewBag.Countries = _entities.Countries.ToList();
ViewBag.States = _entities.States.ToList();
ViewBag.Cities = _entities.Cities.ToList();
return View();
}
//Get all the states based on CountryID
public IList GetStates(int countryid)
{
return _entities.States.Where(c => c.CountryID == countryid).ToList();
}
//Get all the cities based on StateID
public IList GetCitis(int stateid)
{
return _entities.Cities.Where(c => c.StateID == stateid).ToList();
}
//filter state based on countryID
[AcceptVerbs(HttpVerbs.Get)]
public JsonResult LoadStatesByCountryID(string countryid)
{
var stateList = this.GetStates(Convert.ToInt32(countryid));
var stateData = stateList.Select(c => new SelectListItem() {
Text = c.StateName,
Value = c.StateID.ToString(),
});
return Json(stateData,JsonRequestBehavior.AllowGet);
}
//filter city based on stateID
[AcceptVerbs(HttpVerbs.Get)]
public JsonResult LoadCitiesByStateID(string stateid)
{
var cityList = this.GetCitis(Convert.ToInt32(stateid));
var cityData = cityList.Select(c => new SelectListItem()
{
Text = c.CityName,
Value = c.CityID.ToString(),
});
return Json(cityData, JsonRequestBehavior.AllowGet);
}
}
}
And here is my View for Index:
@model MVCCascading.MVCDDEntities
@{
ViewBag.Title = "Index";
}
Country, State and City
@Html.DropDownListFor(Model => Model.Countries, new SelectList(ViewBag.Countries as System.Collections.IEnumerable, "CountryID", "CountryName"),
"Select a Country", new { id = "ddlCountry" })
@Html.DropDownListFor(Model => Model.States, new SelectList(Enumerable.Empty(), "StateID", "StateName"),
"Select a State", new { id = "ddlStates" })
@Html.DropDownListFor(Model => Model.Cities, new SelectList(Enumerable.Empty(), "CityID", "CityName"),
"Select a City", new { id = "ddlCities" })
@section scripts
{
}
Please help me because I am trying this from last lots of days..
Posted Oct 15, 2014, 2:12 PM
I have seen all the other links included yours.
Thanks
Munesh SharmaPosted Oct 15, 2014, 6:23 AM