public JsonResult LoadRegionBySubProgramIDAjax(int subProgramID)
{
if (regionsubprogramRepository == null)
{
regionsubprogramRepository = DependencyResolver.Current.GetService(typeof(IRegionSubProgramRepository)) as IRegionSubProgramRepository;
}
var result = regionsubprogramRepository.FindAllBySubProgramID(subProgramID).GroupBy(item => new { item.RegionID, item.Region.Name }).ToList().AsEnumerable().Select(o => new { ID = o.Key.RegionID, Name = o.Key.Name }).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public RegionSubProgramController(IRegionRepository regionRepository,
IProgramRepository programRepository,
ISubProgramRepository subprogramRepository,
IRegionSubProgramRepository regionsubprogramRepository,
IWorkerRoleActionPermissionRepository workerroleactionpermissionRepository)
: base(workerroleactionpermissionRepository)
{
this.programRepository = programRepository;
this.regionRepository = regionRepository;
this.subprogramRepository = subprogramRepository;
this.regionsubprogramRepository = regionsubprogramRepository;
}
/// <summary>
/// Load Worker Sub Program Multiselect Asynchronously
/// </summary>
/// <returns>Data in JSON</returns>
public JsonResult LoadWorkerSubProgramByWorkerRoleAjax(string regionIDs, string programIDs)
{
if (regionsubprogramRepository == null)
{
regionsubprogramRepository = DependencyResolver.Current.GetService(typeof(IRegionSubProgramRepository)) as IRegionSubProgramRepository;
}
if (regionIDs.IsNullOrEmpty())
{
regionIDs = "0";
}
if (programIDs.IsNullOrEmpty())
{
programIDs = "0";
}
int[] arrayRegionIDs = regionIDs.Split(',').Select(n => Convert.ToInt32(n)).ToArray();
int[] arrayProgramIDs = programIDs.Split(',').Select(n => Convert.ToInt32(n)).ToArray();
var result = regionsubprogramRepository.FindAllByRegionIDsAndProgramIDs(arrayRegionIDs, arrayProgramIDs).GroupBy(item => new { item.SubProgramID, item.SubProgram.Name }).ToList().AsEnumerable().Select(o => new { ID = o.Key.SubProgramID, Name = o.Key.Name }).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public WorkerController05302017(IWorkerRepository workerRepository,
IWorkerRoleRepository workerroleRepository,
IProgramRepository programRepository,
ISubProgramRepository subProgramRepository,
IRegionRepository regionRepository,
IWorkerInRoleRepository workerinroleRepository,
IWorkerSubProgramRepository workersubprogramRepository,
IRegionRoleRepository regionroleRepository,
IRegionSubProgramRepository regionsubprogramRepository,
IWorkerRoleActionPermissionRepository workerroleactionpermissionRepository)
: base(workerroleactionpermissionRepository)
{
this.workerRepository = workerRepository;
this.workerroleRepository = workerroleRepository;
this.programRepository = programRepository;
this.subprogramRepository = subProgramRepository;
this.regionRepository = regionRepository;
this.workerinroleRepository = workerinroleRepository;
this.workersubprogramRepository = workersubprogramRepository;
this.regionroleRepository = regionroleRepository;
this.regionsubprogramRepository = regionsubprogramRepository;
}
