public async Task <PagedList <WaterSpiderScoreRecordDto> > GetLisWaterSpiderScoreRecord(PaginationParams paginationParams, ScoreRecordParam scoreRecordParam, bool isPaging = true)
{
// WS là giá trị fix cứng
var paramAuditTypeIdByWaterSpider = await _auditTypeMRepository.FindAll(x => x.Audit_Kind.Trim() == "WS").Select(x => x.Audit_Type_ID).ToListAsync();
var queryAuditRateM = _auditRateMRepository.FindAll().Where(x => paramAuditTypeIdByWaterSpider.Contains(x.Audit_Type_ID));
var queryAuditRateD = _auditRateDRepository.FindAll();
var listAuditMes = _mesAuditOrg.FindAll(x => x.Status == 1);
if (scoreRecordParam.PDC != "")
{
queryAuditRateM = queryAuditRateM.Where(x => x.PDC.Trim() == scoreRecordParam.PDC);
}
if (scoreRecordParam.Building != "")
{
queryAuditRateM = queryAuditRateM.Where(x => x.Building.Trim() == scoreRecordParam.Building);
}
if (scoreRecordParam.Line != "")
{
queryAuditRateM = queryAuditRateM.Where(x => x.Line.Trim() == scoreRecordParam.Line);
}
if (scoreRecordParam.AuditType1 != "")
{
queryAuditRateM = queryAuditRateM.Where(x => x.Audit_Type1.Trim() == scoreRecordParam.AuditType1);
}
if (scoreRecordParam.AuditType2 != "")
{
queryAuditRateM = queryAuditRateM.Where(x => x.Audit_Type2.Trim() == scoreRecordParam.AuditType2);
}
if (scoreRecordParam.FromDate != "" && scoreRecordParam.ToDate != "")
{
DateTime d1 = Convert.ToDateTime(scoreRecordParam.FromDate + " 00:00:00");
DateTime d2 = Convert.ToDateTime(scoreRecordParam.ToDate + " 23:59:59");
queryAuditRateM = queryAuditRateM.Where(x => x.Record_Date >= d1 && x.Record_Date <= d2);
}
var data = queryAuditRateM.Join(listAuditMes, x => x.Line, t => t.Line_ID_2, (x, t) =>
new WaterSpiderScoreRecordDto
{
RecordId = x.Record_ID,
AuditType = x.Audit_Type1,
AuditDate = x.Record_Date,
LineId = x.Line,
Line_Name = t.Line_ID_2_Name,
Score = _auditRateDRepository.SumEachRating1InAuditTypeDAndAuditRateD(x.Record_ID),
Loss = _auditRateDRepository.SumEachRating0InAuditTypeDAndAuditRateD(x.Record_ID),
NA = _auditRateDRepository.SumEachRatingNAInAuditTypeDAndAuditRateD(x.Record_ID),
CheckAnswerAllYet = queryAuditRateD.Where(y => y.Record_ID == x.Record_ID && y.Rate_NA == 0 && y.Rating_0 == 0 && y.Rating_1 == 0 && y.Rating_2 == 0).Count() > 0 ? false : true
});
var result = data.Distinct().ToList();
result = result.OrderByDescending(x => x.AuditDate).ToList();
return(PagedList <WaterSpiderScoreRecordDto> .Create(result, paginationParams.PageNumber, paginationParams.PageSize, isPaging));
}
