public List<AreaViewModel> GetAreaViewModelsByVideoAreas(ASJDE context, IQueryable<VideoArea> videoAreas)
{
var areaViewModels = new List<AreaViewModel>();
foreach (var videoArea in videoAreas)
{
var areaViewModel = new AreaViewModel
{
ID = videoArea.ID,
Name = videoArea.Name,
GroupViewModels = new List<GroupViewModel>()
};
var area = videoArea;
var groups = context.VideoGroups.Where(g => g.VideoAreaID == area.ID);
foreach (var videoGroup in groups)
{
var groupViewModel = new GroupViewModel
{
ID = videoGroup.ID,
Name = videoGroup.Name,
VideoViewModels = new List<VideoViewModel>()
};
var vGroup = videoGroup;
var videos = context.Videos.Where(v => v.VideoGroupID == vGroup.ID);
foreach (var videoViewModel in videos.Select(video => new VideoViewModel
{
ID = video.ID,
Name = video.Name,
ReferenceID = video.ReferenceID,
Type = "video",
}))
{
groupViewModel.VideoViewModels.Add(videoViewModel);
}
areaViewModel.GroupViewModels.Add(groupViewModel);
}
areaViewModels.Add(areaViewModel);
}
return areaViewModels;
}
public ActionResult AreaDestroy([DataSourceRequest] DataSourceRequest request, AreaViewModel areaViewModel)
{
try
{
if (areaViewModel != null)
{
using (var context = new ASJDE())
{
var videoArea = context.VideoAreas.FirstOrDefault(va => va.ID == areaViewModel.ID);
context.VideoAreas.Remove(videoArea);
context.SaveChanges();
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return Json(ModelState.ToDataSourceResult());
}
public ActionResult AreaUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, AreaViewModel areaViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoArea = context.VideoAreas.FirstOrDefault(va => va.ID == areaViewModel.ID);
if (videoArea != null)
{
videoArea.CompanyID = areaViewModel.CompanyID;
videoArea.StrategicBusinessUnitID = areaViewModel.StrategicBusinessUnitID;
videoArea.OperationalBusinessUnitID = areaViewModel.OperationalBusinessUnitID;
videoArea.BusinessUnitID = areaViewModel.BusinessUnitID;
videoArea.BranchID = areaViewModel.BranchID;
videoArea.DepotID = areaViewModel.DepotID;
videoArea.Name = areaViewModel.Name;
}
context.SaveChanges();
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return Json(new[] { areaViewModel }.ToDataSourceResult(dataSourceRequest, ModelState));
}
public ActionResult AreaCreate([DataSourceRequest] DataSourceRequest request, AreaViewModel areaViewModel)
{
try
{
if (areaViewModel != null && ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoArea = new VideoArea
{
CompanyID = areaViewModel.CompanyID,
StrategicBusinessUnitID = areaViewModel.StrategicBusinessUnitID,
OperationalBusinessUnitID = areaViewModel.OperationalBusinessUnitID,
BusinessUnitID = areaViewModel.BusinessUnitID,
BranchID = areaViewModel.BranchID,
DepotID = areaViewModel.DepotID,
Name = areaViewModel.Name
};
context.VideoAreas.Add(videoArea);
context.SaveChanges();
areaViewModel.ID = videoArea.ID;
}
}
return Json(new[] { areaViewModel }.ToDataSourceResult(request, ModelState));
}
catch (Exception e)
{
Logger.Error("Exception", e);
return null;
}
}