public JsonResult GetOperationData(int id) { var skillMatrices = _context.SkillMatrixs .Include(s => s.Operation) .Include(s => s.Operator) .Where(s => s.OperationId == id) .ToList(); List <OperationSkillMatrixViewModel> operatorInfoSkillMatrixViewModels = new List <OperationSkillMatrixViewModel>(); if (skillMatrices.Count != 0) { foreach (var skillMatrix in skillMatrices) { OperationSkillMatrixViewModel operatorInfoSkillMatrixViewModel = new OperationSkillMatrixViewModel(); double rowTotalSot50 = Math.Round((skillMatrix.StandardSotInSecond / skillMatrix.SotScore) * 50, 2); double rowTotalRft50 = Math.Round((skillMatrix.RftScore * 50 / skillMatrix.StandardRft), 2); double rowTotal100 = rowTotalSot50 + rowTotalRft50; if (rowTotal100 < 0) { rowTotal100 = 0; } string grade = GetGrade(rowTotal100); operatorInfoSkillMatrixViewModel.OperatorName = skillMatrix.Operator.Name; operatorInfoSkillMatrixViewModel.OperatorIdCardNumber = skillMatrix.Operator.IdCardNumber; operatorInfoSkillMatrixViewModel.Score = rowTotal100; operatorInfoSkillMatrixViewModel.Grade = grade; operatorInfoSkillMatrixViewModels.Add(operatorInfoSkillMatrixViewModel); } } return(new JsonResult(operatorInfoSkillMatrixViewModels)); }
public JsonResult GetOperationDataById(string data) { var searchOperationByLineIdViewModel = JsonConvert.DeserializeObject <SearchOperationByLineIdViewModel>(data); if (searchOperationByLineIdViewModel.OperationId == null || searchOperationByLineIdViewModel.OperatorId == null) { return(new JsonResult(false)); } var skillMatrices = _context.SkillMatrixs .Include(s => s.Operation) .Include(s => s.Operator) .Where(s => s.OperationId == searchOperationByLineIdViewModel.OperationId) .ToList(); List <OperationSkillMatrixViewModel> operatorInfoSkillMatrixViewModels = new List <OperationSkillMatrixViewModel>(); List <OperationSkillMatrixViewModel> FoundOperatorInfoSkillMatrixViewModels = new List <OperationSkillMatrixViewModel>(); if (skillMatrices == null) { return(new JsonResult(false)); } if (skillMatrices.Count != 0) { foreach (var skillMatrix in skillMatrices) { if (searchOperationByLineIdViewModel.OperatorId.Exists(m => m == skillMatrix.OperatorId)) { OperationSkillMatrixViewModel operatorInfoSkillMatrixViewModel = new OperationSkillMatrixViewModel(); double rowTotalSot50 = Math.Round((skillMatrix.StandardSotInSecond / skillMatrix.SotScore) * 50, 2); double rowTotalRft50 = Math.Round((skillMatrix.RftScore * 50 / skillMatrix.StandardRft), 2); double rowTotal100 = rowTotalSot50 + rowTotalRft50; if (rowTotal100 < 0) { rowTotal100 = 0; } string grade = GetGrade(rowTotal100); operatorInfoSkillMatrixViewModel.OperatorName = skillMatrix.Operator.Name; operatorInfoSkillMatrixViewModel.OperatorIdCardNumber = skillMatrix.Operator.IdCardNumber; operatorInfoSkillMatrixViewModel.Score = rowTotal100; operatorInfoSkillMatrixViewModel.Grade = grade; operatorInfoSkillMatrixViewModels.Add(operatorInfoSkillMatrixViewModel); } } } return(new JsonResult(operatorInfoSkillMatrixViewModels)); }