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); }