public IQueryable <object> ZBKCopiesCreated()
{
var userId = UserHelper.GetCurrentEmployee().Id;
var data = from zbkCopy in AppContext.OBK_ZBKCopy
join StageExpDoc in AppContext.OBK_StageExpDocument
on zbkCopy.OBK_StageExpDocumentId equals StageExpDoc.Id
join adec in AppContext.OBK_AssessmentDeclaration
on StageExpDoc.AssessmentDeclarationId equals adec.Id into AssessmentDeclaraion
from AssessDec in AssessmentDeclaraion.DefaultIfEmpty()
where AssessDec.EmployeeId == userId
select new
{
stageExpDocId = StageExpDoc.Id,
expConclusionNumber = StageExpDoc.ExpConclusionNumber,
expStartDate = StageExpDoc.ExpStartDate,
status = StageExpDoc.ExpEndDate >= StageExpDoc.ExpStartDate ? "Действующий" : "Срок действия истек",
assessDecId = AssessDec.Id,
assessDecType = AssessDec.TypeId,
employeeId = AssessDec.EmployeeId,
zbkCopyId = (Guid?)zbkCopy.Id,
copyQuantity = zbkCopy.CopyQuantity,
sendDate = zbkCopy.SendDate
};
return(data);
}
public IQueryable <object> ZBKCopies(Guid?declarationNumber, int?declarationType, string decisionNumber, DateTime?decisionDate)
{
var userId = UserHelper.GetCurrentEmployee().Id;
var statusId = AppContext.OBK_Ref_Status.FirstOrDefault(o => CodeConstManager.STATUS_OBK_CONCLUSION_ISSUE.ToString().Equals(o.Code)).Id;
var data = from StageExpDoc in AppContext.OBK_StageExpDocument
join adec in AppContext.OBK_AssessmentDeclaration
on StageExpDoc.AssessmentDeclarationId equals adec.Id into AssessmentDeclaraion
from AssessDec in AssessmentDeclaraion.DefaultIfEmpty()
where AssessDec.EmployeeId == userId && AssessDec.StatusId == statusId &&
StageExpDoc.ExpConclusionNumber != null
select new
{
stageExpDocId = StageExpDoc.Id,
expConclusionNumber = StageExpDoc.ExpConclusionNumber,
expBlankNumber = StageExpDoc.ExpBlankNumber,
expStartDate = StageExpDoc.ExpStartDate,
status = StageExpDoc.ExpEndDate > StageExpDoc.ExpStartDate ? "Действующий" : "Срок действия истек",
assessDecId = AssessDec.Id,
assessDecType = AssessDec.TypeId,
employeeId = AssessDec.EmployeeId
};
var res = data.ToList();
if (decisionNumber != null && !decisionNumber.Equals(""))
{
res = res.Where(o => decisionNumber.Equals(o.expConclusionNumber)).ToList();
}
if (decisionDate != null)
{
res = res.Where(o => decisionDate == o.expStartDate).ToList();
}
if (declarationNumber != null && !declarationNumber.Equals(""))
{
res = res.Where(o => declarationNumber == o.assessDecId).ToList();
}
if (declarationType != null)
{
res = res.Where(o => o.assessDecType == declarationType).ToList();
}
return(res.AsQueryable());
}
public IEnumerable <object> AssessmentDeclarationNumbers()
{
var userId = UserHelper.GetCurrentEmployee().Id;
var statusId = AppContext.OBK_Ref_Status.FirstOrDefault(o => CodeConstManager.STATUS_OBK_CONCLUSION_ISSUE.ToString().Equals(o.Code)).Id;
var data = from StageExpDoc in AppContext.OBK_StageExpDocument
join adec in AppContext.OBK_AssessmentDeclaration
on StageExpDoc.AssessmentDeclarationId equals adec.Id into AssessmentDeclaraion
from AssessDec in AssessmentDeclaraion.DefaultIfEmpty()
where AssessDec.EmployeeId == userId && AssessDec.StatusId == statusId &&
StageExpDoc.ExpConclusionNumber != null
select new
{
Id = AssessDec.Id,
Number = AssessDec.Number
};
return(data);
}
