public async Task <IActionResult> History()
{
var userList = _userManager.Users.ToList();
var viewModel = new EvaluationListViewModel();
var evaluations = await _context.Evaluations
.Include(e => e.EvaluationDetailItems)
.Include(e => e.EvaluationStatus)
.Include(e => e.EvaluationType)
.Include(e => e.Technique)
.Where(e => e.EvaluationStatusId == (int)EvaluationStatuses.Closed)
.ToListAsync();
foreach (var evaluation in evaluations)
{
var dto = new EvaluationDto(evaluation);
dto.StudentName = userList.First(x => x.Id == evaluation.StudentId).UserName;
dto.EducatorName = userList.First(x => x.Id == evaluation.EducatorId).UserName;
viewModel.EvaluationDtos.Add(dto);
}
return(View(viewModel));
}
public async Task RatePost(EvaluationDto evaluation)
{
var eval = ObjectMapper.Map <Evaluation>(evaluation);
// Simple protection
eval.EvaluatorId = (int)AbpSession.UserId;
(var wasFounded, var evalFounded) = await _evaluationManager.TryFindEvaluation(eval);
// If a user has already rated a post he can't do it again, only update
if (wasFounded)
{
if (evalFounded.Value == eval.Value)
{
return;
}
evalFounded.Value = eval.Value;
await _evaluationManager.UpdateAsync(evalFounded);
}
else
{
await _evaluationManager.CreateAsync(eval);
}
}
public ActionResult Delete([DataSourceRequest] DataSourceRequest request, EvaluationDto evaluationDto)
{
//var evaluation = Mapper.Map<EvaluationDto, Evaluation>(evaluationDto);
_evaluationService.Delete(evaluationDto.Id);
return(Json(new { Data = evaluationDto }));
}
public IActionResult Query([FromBody] EvaluationDto parm)
{
//开始拼装查询条件
var predicate = Expressionable.Create <view_dataRecovery>();
//状态 0-未审批 1- 已审批
switch (parm.status)
{
case 0:
predicate = predicate.And(m => m.ItemStatus == 20019 && m.status == 30038);
break;
case 1:
predicate = predicate.And(m => m.status == 30040);
break;
default:
return(toResponse(StatusCodeType.Error, "状态匹配失败,请核对！"));
//break;
}
//项目编号
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.ContractItemNo), m => m.ContractItemNo.Contains(parm.ContractItemNo));
//客户名称
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.khmc), m => m.zzmc.Contains(parm.khmc));
//审核开始起
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.AcceptStartDateStart), m => m.PlanStartDate >= DateTime.Parse(parm.AcceptStartDateStart));
//审核开始止
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.AcceptStartDateEnd), m => m.PlanStartDate <= DateTime.Parse(parm.AcceptStartDateEnd));
//审核结束起
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.AcceptEndDateStart), m => m.PlanEndDate >= DateTime.Parse(parm.AcceptEndDateStart));
//审核结束止
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.AcceptEndDateEnd), m => m.PlanEndDate <= DateTime.Parse(parm.AcceptEndDateEnd));
//var response = _contractitemsubService.GetPages(predicate.ToExpression(), parm);
var response = Core.DbContext.CurrentDB.SqlQueryable <view_dataRecovery>(@"
select cp.*,k.zzmc,h.mc,c.ContractNo,ci.AuditTypeName,ci.ItemName,ci.ContractItemNo,p.UserName,cis.status as ItemStatus
from Biz_Contract_Plan cp
inner join Biz_ContractItem_Sub cis on cis.ContractPlanID = cp.ID
inner join Biz_ContractItem ci on ci.ID = cis.ContractItemID
inner join Biz_MainContract c on c.ID = ci.MainContractID
inner join uf_khxx k on k.ID = cp.CustomerID
left join uf_hzhb h ON k.hzdwID = h.ID
outer apply(select top 1 * from Biz_Contract_PlanAuditor p
where p.ContractPlanID = cp.ID and exists(select 1 from Biz_Contract_PlanAuditor_Item i where i.GroupIdentityName = '组长' and i.PlanAuditorID = p.ID)) p
where cis.ContractItemSubType > 0
").ToPage <view_dataRecovery>(predicate.ToExpression(), parm);
return(toResponse(response));
}
public IActionResult Query([FromBody] EvaluationDto parm)
{
//开始拼装查询条件
var predicate = Expressionable.Create <view_ItemCert>();
//状态 0-未翻译 1-已翻译
switch (parm.status)
{
case 0:
predicate = predicate.And(m => m.status == 50000);
break;
case 1:
predicate = predicate.And(m => m.status == 50010);
break;
default:
return(toResponse(StatusCodeType.Error, "状态匹配失败,请核对！"));
//break;
}
//项目编号
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.ContractItemNo), m => m.ContractItemNo.Contains(parm.ContractItemNo));
//客户名称
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.khmc), m => m.zzmc.Contains(parm.khmc));
//审核开始起
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.AcceptStartDateStart), m => m.PlanStartDate >= DateTime.Parse(parm.AcceptStartDateStart));
//审核开始止
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.AcceptStartDateEnd), m => m.PlanStartDate <= DateTime.Parse(parm.AcceptStartDateEnd));
//审核结束起
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.AcceptEndDateStart), m => m.PlanEndDate >= DateTime.Parse(parm.AcceptEndDateStart));
//审核结束止
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.AcceptEndDateEnd), m => m.PlanEndDate <= DateTime.Parse(parm.AcceptEndDateEnd));
//var response = _contractitemsubService.GetPages(predicate.ToExpression(), parm);
var response = Core.DbContext.CurrentDB.SqlQueryable <view_ItemCert>(@"
select c.status,m.ContractNo,ci.ItemName,ci.ContractItemNo,cis.ContractItemSubTypeCode,k.zzmc,h.mc
,cis.CNAS
from Biz_ContractItem_Sub_Certificate c
inner join Biz_MainContract m on m.ID = c.MainContractID
inner join uf_khxx k on k.ID = c.CustomerID
inner join uf_hzhb h on h.ID = k.hzdwID
inner join Biz_ContractItem_Sub cis on cis.ID = c.ContractSubItemID
inner join Biz_ContractItem ci on c.ContractItemID = ci.ID
").ToPage <view_ItemCert>(predicate.ToExpression(), parm);
return(toResponse(response));
}
public IActionResult Create([FromBody] EvaluationDto evaluationDto)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var evaluation = Mapper.Map <EvaluationDto, Evaluation>(evaluationDto);
_evaluationService.Create(evaluation);
evaluationDto.Id = evaluation.Id;
return(new ObjectResult(evaluationDto));
}
public IActionResult Save(EvaluationDto evaluationDto)
{
var evaluation = Mapper.Map <EvaluationDto, Evaluation>(evaluationDto);
if (evaluation.Id == 0)
{
_logger.LogInformation("--------------- Creating evaluation -----------------");
_evaluationService.CreateWithExistingQuestions(evaluation, evaluationDto.QuestionIds);
}
else
{
_logger.LogInformation("--------------- UPDATING evaluation -----------------");
_evaluationService.UpdateWithExistingQuestions(evaluation, evaluationDto.QuestionIds);
}
TempData["messageType"] = "toast-success";
TempData["messageText"] = "Evaluation has been successfully saved!";
return(RedirectToAction("Index", "Evaluations"));
}
public IActionResult New()
{
EvaluationDto evaluationDto = new EvaluationDto();
// get all Department Managers from users
evaluationDto.DepartmentManagers = _userService.FindBy(u => u.UserType == UserType.DM).Select(u => new SelectListItem
{
Text = u.Email,
Value = u.Id
}).ToList();
// get all seasons
evaluationDto.Seasons = _seasonService.All().Select(s => new SelectListItem
{
Text = s.Name,
Value = s.Id.ToString()
}).ToList();
return(View("Form", evaluationDto));
}
/// <summary>
/// Test propouse Method
/// </summary>
/// <param name="evalDto">The DTO</param>
/// <returns>The Entity</returns>
public IActionResult MapToEntity([FromBody] EvaluationDto evalDto)
{
return(this.Ok(this.mapper.Map <Evaluation>(evalDto)));
}
public async Task <IActionResult> AddEvaluationAsync([FromRoute] string publicationId, [FromBody] EvaluationDto evaluationDto)
{
var evaluation = _mapper.Map <evaluation>(evaluationDto);
evaluation.author = GetSession().Username;
evaluation.publicationId = publicationId;
await _reviewService.AddEvalutionAsync(publicationId, evaluation);
return(Ok());
}
