public JsonResult Get(string query)
{
List <Location> locations;
List <LocationVm> records;
using (AppDB_Context context = new AppDB_Context())
{
locations = context.Locations.ToList();
if (!string.IsNullOrWhiteSpace(query))
{
locations = locations.Where(q => q.Name.Contains(query)).ToList();
}
records = locations.Where(l => l.ParentID == null).OrderBy(l => l.OrderNumber)
.Select(l => new LocationVm
{
id = l.ID,
text = l.Name,
@checked = l.Checked,
//population = l.Population,
//flagUrl = l.FlagUrl,
children = GetChildren(locations, l.ID)
}).ToList();
}
return(this.Json(records, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveCheckedNodes(List <int> checkedIds)
{
if (checkedIds == null)
{
checkedIds = new List <int>();
}
using (AppDB_Context context = new AppDB_Context())
{
var locations = context.Locations.ToList();
foreach (var location in locations)
{
location.Checked = checkedIds.Contains(location.ID);
}
context.SaveChanges();
}
return(this.Json(true));
}
