Comments by Member 11233046 (Top 11 by date)

public ActionResult GetStates(string countryId)
{
int id = 0;
bool isValid = Int32.TryParse(countryId, out id);
if (id == 0)
throw new ArgumentException("countryId", "Must be a valid ID int");
return PartialView(db.States
.Where(x => x.Country_Id == id).ToList());
}
(like you said before)
the razor partial View
@model IEnumerable<farcontrol.models.addressmodel>
<script type="text/javascript">
$(function () {
$("#CountryId").change(function () {
var selectedItem = $(this).val();
var statesProgress = $("#states-loading-progress");
statesProgress.show();
$.ajax({
cache: false,
type: "GET",
url: "@(Url.RouteUrl("GetStates"))",
data: { "countryId": selectedItem },
success: function (data) {
tableStates.html(data);
statesProgress.hide();
},
error: function (xhr, ajaxOptions, thrownError) {
alert('Failed to retrieve states.');
statesProgress.hide();
}
});
});
});
</script>

@if (Model != null)
{
<table>
@foreach (var states in Model)
{
<tr><td>@states.AvailableStates</td></tr>


}
</table>
}

to make you have a big idea I´m gonna show all . . .
hope you understand now
public class AddressModel
{
public AddressModel()
{
AvailableCountries = new List<SelectListItem>();
AvailableStates = new List<SelectListItem>();

}
public int CountryId { get; set; }
[Display(Name = "Country")]
public IList<SelectListItem> AvailableCountries { get; set; }
[Display(Name = "State")]
public int StateId { get; set; }
public IList<SelectListItem> AvailableStates { get; set; }
public IList<addressmodel> partialModel { get; set; }
}

Get states on my controller , like you said , there´s a error, when I put IEnumerable<string> list . . . appear a error on sql instruction , even IEnumerable<addressmodel>that I think the right way... I resolve it putting IEnumerable<states> list... doing that I have to change the razor view to @model FarControl.Models.AddressModel did you get ???

public ActionResult GetStates(string countryId)
{
int id = 0;
bool isValid = Int32.TryParse(countryId, out id);
IEnumerable<states> list = (from States in db.States
where States.Country_Id == id select States);
return PartialView(list);
}

I did this on controller like you said
public ActionResult GetStates(string countryId)
{
int id = 0;
bool isValid = Int32.TryParse(countryId, out id);
IEnumerable<string> list = (from States in db.States
where States.Country_Id == id select States);
return PartialView(list);
}
on my view I can do that @model IEnumerable<string> because my main view is of type @model FarControl.Models.AddressModel as I put above

my deadline is closing

Nathan thanks you help . . . it seems work, but I still have some issues... I can´t handle your code with mine...
on controller . . .
I have this
public class AddressController : Controller
{
Entities db = new Entities();

private IAddressRepository _repository1;

public AddressController()
: this(new AddressRepository())
{
}

public AddressController(IAddressRepository repository)
{
_repository1 = repository;
}



public ActionResult Index()
{
AddressModel model = new AddressModel();
model.AvailableCountries.Add(new SelectListItem { Text = "-Please select-", Value = "Selects items" });
var countries1 = _repository1.GetAllCountries();
//var countries = _repository.GetAllCountries();
foreach (var country in countries1)
{
model.AvailableCountries.Add(new SelectListItem()
{
Text = country.Name,
Value = country.Id.ToString()
});
}
return View(model);
}

[AcceptVerbs(HttpVerbs.Get)]
public ActionResult GetStatesByCountryId(string countryId)
{
if (String.IsNullOrEmpty(countryId))
{
throw new ArgumentNullException("countryId");
}
int id = 0;
bool isValid = Int32.TryParse(countryId, out id);
var states = _repository1.GetAllStatesByCountryId(id);
var result = (from s in states
select new
{
id = s.Id,
name = s.Name
}).ToList();
return Json(result, JsonRequestBehavior.AllowGet);
}
}}
on my model . . .
<pre lang="sql">public class AddressModel
{
public AddressModel()
{
AvailableCountries = new List<SelectListItem>();
AvailableStates = new List<SelectListItem>();
}
public int CountryId { get; set; }
[Display(Name = "Country")]
public IList<SelectListItem> AvailableCountries { get; set; }
[Display(Name = "State")]
public int StateId { get; set; }
public IList<SelectListItem> AvailableStates { get; set; }
}</pre>
<pre lang="xml">public interface IAddressRepository
{
IList<Country> GetAllCountries();
IList<State> GetAllStatesByCountryId(int countryId);
}</pre>
<pre lang="xml">public class AddressRepository : IAddressRepository
{
Entities db = new Entities();

public IList<Country> GetAllCountries()
{
var query = from Countries in db.Countries
select Countries;
var content = query.ToList<Country>();
return content;
}
public IList<State> GetAllStatesByCountryId(int countryId)
{
var query = from States in db.States
where States.Country_Id == countryId
select States;
var content = query.ToList<State>();
return content;

}

}</pre>
can you give a word ? "I´m totally new, but I have to do this"

yeah Nathan that´s right ...
on the same page when I selected the country
please help me