public List <VideoAnalysisDto> GetAllVideoAnalysis(VideoAnalysisDto input)
{
var query = (from videoAnalysis in _context.TrainingVideo.ToList()
join videoCategory in _context.VideoCategory.ToList()
on videoAnalysis.Id equals videoCategory.Id
select new VideoAnalysisDto
{
CloudFolder = videoAnalysis.CloudFolder,
CloudKey = videoAnalysis.CloudKey,
ImagePath = videoAnalysis.ImagePath,
DateCreated = videoAnalysis.DateCreated,
Status = videoAnalysis.Status,
UserId = videoAnalysis.UserId,
VideoCategoryName = videoCategory.Name,
}).ToList().Skip((input.PagedResultDto.Page - 1) * input.PagedResultDto.SkipCount).Take(input.PagedResultDto.MaxResultCount);
// Map Records
List <VideoAnalysisDto> trainingVideoDto = MappingProfile.MappingConfigurationSetups().Map <List <VideoAnalysisDto> >(query);
//Apply Sort
trainingVideoDto = Sort(input.PagedResultDto.Sort, input.PagedResultDto.SortOrder, trainingVideoDto);
// Apply search
if (!string.IsNullOrEmpty(input.PagedResultDto.Search))
{
trainingVideoDto = trainingVideoDto.Where(p => p.Status != null && p.Status.ToLower().ToString().ToLower().Contains(input.PagedResultDto.Search.ToLower()) ||
p.VideoCategoryName != null && p.VideoCategoryName.ToString().ToLower().Contains(input.PagedResultDto.Search.ToLower()) ||
p.DateCreated != null && p.DateCreated.ToString().ToLower().Contains(input.PagedResultDto.Search.ToLower()) ||
p.ImagePath != null && p.ImagePath.ToString().ToLower().ToString().Contains(input.PagedResultDto.Search.ToLower()) ||
p.CloudFolder != null && p.CloudFolder.ToString().ToLower().ToString().Contains(input.PagedResultDto.Search.ToLower()) ||
p.CloudKey != null && p.CloudKey.ToString().ToLower().ToString().Contains(input.PagedResultDto.Search.ToLower())
).ToList();
}
return(trainingVideoDto);
}
protected virtual async Task Create(VideoAnalysisDto input)
{
VideoAnalysis videoAnalysisDto = MappingProfile.MappingConfigurationSetups().Map <VideoAnalysis>(input);
_context.VideoAnalysis.Add(videoAnalysisDto);
await _context.SaveChangesAsync();
}
protected virtual async Task Update(VideoAnalysisDto input)
{
var videoAnalysis = await _context.VideoAnalysis.Where(x => x.Id == input.Id).FirstOrDefaultAsync();
if (videoAnalysis != null)
{
VideoAnalysis videoAnalysisDto = MappingProfile.MappingConfigurationSetups().Map <VideoAnalysis>(input);
_context.VideoAnalysis.Update(videoAnalysisDto);
await _context.SaveChangesAsync();
}
}
public async Task CreateOrEditVideoAnalysis(VideoAnalysisDto input)
{
if (input.Id == null || input.Id == 0)
{
await Create(input);
}
else
{
await Update(input);
}
}
public async Task <VideoAnalysisDto> GetVideoAnalysisForEdit(VideoAnalysisDto input)
{
var users = await _context.Role.Where(x => x.Id == input.Id).FirstOrDefaultAsync();
if (users != null)
{
TrainingVideo trainingVideoDto = MappingProfile.MappingConfigurationSetups().Map <TrainingVideo>(input);
_context.TrainingVideo.Update(trainingVideoDto);
await _context.SaveChangesAsync();
return(MappingProfile.MappingConfigurationSetups().Map <VideoAnalysisDto>(trainingVideoDto));
}
return(new VideoAnalysisDto());
}
public List <VideoAnalysisDto> GetAllVideoAnalysis(VideoAnalysisDto input)
{
return(_unitOfWork.VideoAnalysis.GetAllVideoAnalysis(input));
}
public async Task GetVideoAnalysisForEdit(VideoAnalysisDto input)
{
await _unitOfWork.VideoAnalysis.GetVideoAnalysisForEdit(input);
}
public async Task CreateOrEditVideoAnalysis(VideoAnalysisDto input)
{
await _unitOfWork.VideoAnalysis.CreateOrEditVideoAnalysis(input);
}
