public ActionResult Index(MunicipalitiesView view)
{
var municipalities = db.Municipalities
.Include(m => m.Department)
.OrderBy(m => m.Department.Name)
.ThenBy(m => m.Name)
.ToList();
if (!string.IsNullOrEmpty(view.Department))
{
municipalities = municipalities
.Where(m => m.Department.Name.ToUpper().Contains(view.Department.ToUpper()))
.ToList();
}
if (!string.IsNullOrEmpty(view.Municipality))
{
municipalities = municipalities
.Where(m => m.Name.ToUpper().Contains(view.Municipality.ToUpper()))
.ToList();
}
view.Municipalities = municipalities;
return(View(view));
}
//filter view:
// GET: MunicipalitiesView
public ActionResult Index()
{
var municipalities = db.Municipalities.Include(m => m.Department);
var view = new MunicipalitiesView
{
Municipalities = municipalities.ToList(),
};
return(View(view));
}
// GET: Municipalities
public ActionResult Index()
{
var municipalities = db.Municipalities
.Include(m => m.Department)
.OrderBy(m => m.Department.Name)
.ThenBy(m => m.Name)
.ToList();
var view = new MunicipalitiesView
{
Municipalities = municipalities,
};
return(View(view));
}