Very large automapping config - discussion on memory, alternatives, caching and processing in .Net Core 3+

[statler]

We have a large application with over 100 EF models, and similarly significant automappings. Please note that this is working exactly as expected and there are no complaints or issues with how Automapper performs its magic. This is a question about whether it is really beyond what AM is designed to do, and how alternative approaches affect memory allocation vs. AM

Our issue is simply a question of scale. We are at the point where the application at rest is consuming significant memory with the EF mappings and Automapper projections, especially the caching of query plans on first projection. We are aware that the extent of our mappings are likely outside the expectations and probably recommendations, and are looking at ways to implement at least some of these things in an alternate way. I am hoping to get some information about approaches that would result in a successful reduction in required memory.

Process memory starts at about 500Mb, with object memory at 50Mb. After first project it is 980Mb/85Mb. Without the mappings it drops by a third (roughly). Again - this seems reasonable considering what is going on.

As I understand it, the two significant memory uses with a large config as below will be the storage of the config itself, and then the caching of execution expressions on ProjectTo.

First question is - with .Net Core 3.1+, is caching expression trees as important? Looking at https://stackoverflow.com/questions/35805609/performance-of-expression-compile-vs-lambda-direct-vs-virtual-calls, it appears performance has improved dramatically - if memory is taking a big hit, then can we maybe treat the expression composition as transient? How would I go about testing this, because at the moment it appears the entire config is composed on first projection. For this to work, it would need to be kind of 'on-demand'. Is it even possible? Breaking up the config would be difficult (but not impossible) because each of the smaller configs would need to duplicate some models as they are shared between object graphs, possibly exarcerbating the problem.

Secondly, relating to alternatives to Automapping at least some of the complex objects:
As the restriction of data returned from the database is important to us, we would still need to create some kind of equivalent to ProjectTo, either constructing the expression or manually compiling a select - how would doing this compare to the automapper ProjectTo for memory and performance? Sure we are eliminating the caching of the Linq expression execution that AM does, but this obviously occurs for a reason, this is probably related to above.

Finally, how much does the complexity of mappings add to memory allocation, or is it just the sheer volume of fields being mapped that is at play?

This is the config. I expect that it is too complex. It is part of the problem we are trying to solve, hoping for some insight as to the best approach to do so. This is obviously an immense task to rewrite if we need to, and I would really like to understand your thoughts on how this would best be achieved - or is this really well within the scope of how you expect Automapper could be used.

public class AutoMapper_base : Profile
{
    public AutoMapper_base()
    {
        CreateMap<Approval, ApprovalBasicLinkDto>();
        CreateMap<Approval, ApprovalListStatuserDto>()
            .ForMember(dest => dest.StatusLastStep, opt => opt.MapFrom(src => src.CloseOutDate != null ? "Closed Out" :
                src.Workflow.StatusLastStep)).IncludeAllDerived()
            .ForMember(dest => dest.DateLastStep, opt => opt.MapFrom(src => src.Workflow.DateLastStep)).IncludeAllDerived()
            .ForMember(dest => dest.ActionDate, opt => opt.MapFrom(src => src.CloseOutDate != null || src.Workflow.ActionDate == null ?
                (DateTime?)null : src.Workflow.ActionDate)).IncludeAllDerived()
            .ForMember(dest => dest.IsLatestStepAlert, opt => opt.MapFrom(src => src.Workflow.IsLatestStepAlert)).IncludeAllDerived()
            .ForMember(dest => dest.IsCompleted, opt => opt.MapFrom(src => src.CloseOutDate != null ||
                src.DateDirectlyApproved != null ||
                (src.Workflow.IsCompleted ?? false))).IncludeAllDerived()
            .ForMember(dest => dest.IsApprovedToProceed, opt => opt.MapFrom(src => src.Workflow.HasApprovalStep)).IncludeAllDerived()
            .ForMember(dest => dest.LastActionByName, opt => opt.MapFrom(src => src.Workflow.LastActionByName)).IncludeAllDerived()
            .ForMember(dest => dest.LastActionComment, opt => opt.MapFrom(src => src.Workflow.LastActionComment)).IncludeAllDerived()
            .ForMember(dest => dest.Status, opt => opt.MapFrom(src =>
                src.CloseOutDate != null ? "Closed Out" :
                (src.Workflow.IsCompleted ?? false) ? src.Workflow.StatusLastStep :
                src.DateDirectlyApproved != null ? (src.PurchaseOrderLinkId != null ? "Directly Approved" : "Manually Approved") :
                src.Workflow.StatusLastStep ?? "Not started"
                )).IncludeAllDerived()
            .ForMember(dest => dest.DateLastStatus, opt => opt.MapFrom(src =>
                src.CloseOutDate != null ? src.CloseOutDate :
                (src.Workflow.IsCompleted ?? false) ? src.Workflow.DateLastStep :
                src.DateDirectlyApproved != null ? src.DateDirectlyApproved :
                src.Workflow.DateLastStep ?? null
                )).IncludeAllDerived();
        CreateMap<Approval, ApprovalListDto>()
            .Ignore(x => x.ApprovalTos).IncludeAllDerived()
            .Ignore(x => x.ApprovalCcs).IncludeAllDerived()
            .ForMember(dest => dest.RequestByName, opt => opt.MapFrom(src => src.RequestBy == null ? "" : src.RequestBy.FirstName + " " + src.RequestBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalCategoryName, opt => opt.MapFrom(src => src.ApprovalCategory.Description)).IncludeAllDerived()
            .ForMember(dest => dest.WorkflowName, opt => opt.MapFrom(src => src.ApprovalWorkflow.Description)).IncludeAllDerived()
            .ForMember(dest => dest.IsEmailed, opt => opt.MapFrom(src => src.EmailDate != null || src.ApprovalEmails.Count > 0)).IncludeAllDerived()
            .ForMember(dest => dest.DaysTilDue, opt => opt.MapFrom(src =>
                src.CloseOutDate != null || src.ActionDate == null ?
                (int?)null : (src.ActionDate ?? DateTime.UtcNow).Subtract(DateTime.Now).Days)).IncludeAllDerived();
        CreateMap<Approval, ApprovalListExtDto>()
            .ForMember(dest => dest.DirectlyApprovedByName, opt => opt.MapFrom(src => src.DirectlyApprovedBy == null ? "" : src.DirectlyApprovedBy.FirstName + " " + src.DirectlyApprovedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.CloseOutByName, opt => opt.MapFrom(src => src.CloseOutBy == null ? "" : src.CloseOutBy.FirstName + " " + src.CloseOutBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.LogCount, opt => opt.MapFrom(src => src.Workflow.WorkflowLogs.Count)).IncludeAllDerived()
            .ForMember(dest => dest.ActionCount, opt => opt.MapFrom(src => src.Workflow.WorkflowLogs.Where(x => x.WorkflowAction != null).Count())).IncludeAllDerived();
        CreateMap<Approval, ApprovalDto>();
        CreateMap<ApprovalTo, ApprovalToDto>();
        CreateMap<ApprovalCc, ApprovalCcDto>();
        CreateMap<ApprovalEmail, ApprovalEmailDto>()
            .ForMember(dest => dest.EmailDate, opt => opt.MapFrom(src => src.EmailLog.DateEmailed)).IncludeAllDerived()
            .ForMember(dest => dest.EmailDescription, opt => opt.MapFrom(src => src.EmailLog.Subject)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval == null ? null : src.Approval.ApprovalNo)).IncludeAllDerived();
        CreateMap<ApprovalLot, ApprovalLotDto>()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval.ApprovalNo)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml)).IncludeAllDerived()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber))
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description))
            .ForMember(dest => dest.ApprovalIsLatestStepAlert, opt => opt.MapFrom(src => src.Approval.IsLatestStepAlert)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalIsApprovedToProceed, opt => opt.MapFrom(src => src.Approval.IsApprovedToProceed)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalIsCompleted, opt => opt.MapFrom(src => src.Approval.IsCompleted)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalStatus, opt => opt.MapFrom(src => src.Approval.Status)).IncludeAllDerived();
        CreateMap<ApprovalLotItpDetail, ApprovalLotItpDetailDto>()
            .ForMember(dest => dest.ItpRef, opt => opt.MapFrom(src => src.LotItpDetail.LotItp.Itp.Description)).IncludeAllDerived()
            .ForMember(dest => dest.LotNo, opt => opt.MapFrom(src => src.LotItpDetail.LotItp.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.LotItpId, opt => opt.MapFrom(src => src.LotItpDetail.LotItpId)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval.ApprovalNo)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml)).IncludeAllDerived();
        CreateMap<Approval, ApprovalStatusInfoDto>();
        CreateMap<AreaCode, AreaCodeDto>();
        CreateMap<AtpLot, AtpLotListDto>()
            .ForMember(dest => dest.AtpNo, opt => opt.MapFrom(src => src.Atp.AtpNo)).IncludeAllDerived()
            .ForMember(dest => dest.AtpDescription, opt => opt.MapFrom(src => src.Atp.Description)).IncludeAllDerived()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber))
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description));
        CreateMap<Approval, ApprovalCategoryDto>();
        CreateMap<ApprovalItpDetail, ApprovalItpDetailDto>()
            .ForMember(dest => dest.ItpId, opt => opt.MapFrom(src => src.ItpDetail.ItpId)).IncludeAllDerived()
            .ForMember(dest => dest.ItpDetailDesc, opt => opt.MapFrom(src => src.ItpDetail.Itp.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval.ApprovalNo))
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml))
            .ForMember(dest => dest.FullItpDesc, opt => opt.MapFrom(src => src.ItpDetail.Itp == null ? "" : src.ItpDetail.Itp.ItpDocnumber + ": " + src.ItpDetail.Itp.Description));
        CreateMap<ApprovalNcr, ApprovalNcrDto>()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval.ApprovalNo)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml)).IncludeAllDerived()
            .ForMember(dest => dest.NcrNumber, opt => opt.MapFrom(src => src.Ncr.NcrNo)).IncludeAllDerived()
            .ForMember(dest => dest.NcrDescription, opt => opt.MapFrom(src => src.Ncr.Description))
            .ForMember(dest => dest.ApprovalIsLatestStepAlert, opt => opt.MapFrom(src => src.Approval.IsLatestStepAlert)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalIsApprovedToProceed, opt => opt.MapFrom(src => src.Approval.IsApprovedToProceed)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalIsCompleted, opt => opt.MapFrom(src => src.Approval.IsCompleted)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalStatus, opt => opt.MapFrom(src =>
                src.Approval.Status)).IncludeAllDerived();
        CreateMap<Approval, ApprovalSimpleTemplateDto>();
        CreateMap<Approval, ApprovalTemplateDto>()
            .ForMember(dest => dest.ProjectName, opt => opt.MapFrom(src => src.Project.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ProjectNumber, opt => opt.MapFrom(src => src.Project.ContractNumber)).IncludeAllDerived()
            .ForMember(dest => dest.WorkflowLogsOrdered, opt => opt.MapFrom(src => src.Workflow.WorkflowLogs.OrderByDescending(x => x.LogDate))).IncludeAllDerived();
        CreateMap<ApprovalWorkflow, ApprovalWorkflowDto>()
            .ForMember(dest => dest.ApprovalCategoryName, opt => opt.MapFrom(src => src.ApprovalCategory.Description)).IncludeAllDerived();
        CreateMap<ApprovalWorkflow, ApprovalWorkflowUpdaterDto>()
            .ForMember(dest => dest.ApprovalCategoryName, opt => opt.MapFrom(src => src.ApprovalCategory.Description)).IncludeAllDerived();
        CreateMap<ApprovalWorkflow, ApprovalWorkflowExportDto>().Ignore(x => x.Workflow);
        CreateMap<Atp, AtpListDto>()
            .ForMember(dest => dest.IsApproved, opt => opt.MapFrom(src => !src.AtpLots.Any(x => x.DateApproved == null)))
            .ForMember(dest => dest.SentToName, opt => opt.MapFrom(src => src.SentTo == null ? "" : src.SentTo.FirstName + " " + src.SentTo.LastName))
            .ForMember(dest => dest.RequestedByName, opt => opt.MapFrom(src => src.RequestedBy == null ? "" : src.RequestedBy.FirstName + " " + src.RequestedBy.LastName));
        CreateMap<Atp, AtpDto>();

        CreateMap<ContractNotice, ContractNoticeListDto>()
            .Ignore(x => x.CnTos).IncludeAllDerived()
            .ForMember(dest => dest.RequestByName, opt => opt.MapFrom(src => src.RequestBy == null ? "" : src.RequestBy.FirstName + " " + src.RequestBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.NumberOfResponses, opt => opt.MapFrom(src => src.CnResponses.Count())).IncludeAllDerived()
            .ForMember(dest => dest.NumberOfActionedResponses, opt => opt.MapFrom(src => src.CnResponses.Count(x => x.DateActioned != null))).IncludeAllDerived();
        CreateMap<ContractNotice, ContractNoticeDto>();
        CreateMap<ContractNotice, ContractNoticeRenderTemplateDto>()
            .ForMember(dest => dest.ProjectName, opt => opt.MapFrom(src => src.Project.Description ?? "")).IncludeAllDerived()
            .ForMember(dest => dest.ProjectNumber, opt => opt.MapFrom(src => src.Project.ContractNumber ?? "")).IncludeAllDerived()
            ;
        CreateMap<CnTo, CnToDto>()
            .ForMember(dest => dest.FullName, opt => opt.MapFrom(src => src.NoticeTo == null ? "" : src.NoticeTo.FirstName + " " + src.NoticeTo.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.EffectiveEmailAddress, opt => opt.MapFrom(src => src.NoticeTo == null ? src.NoticeEmail : src.NoticeTo.Email)).IncludeAllDerived();
        CreateMap<CnApproval, CnApprovalDto>()
            .ForMember(dest => dest.ConRef, opt => opt.MapFrom(src => src.ContractNotice.ConRef)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval == null ? null : src.Approval.ApprovalNo)).IncludeAllDerived();
        CreateMap<CnControlledDoc, CnControlledDocDto>()
            .ForMember(dest => dest.CnNumber, opt => opt.MapFrom(src => src.ContractNotice.ConRef))
            .ForMember(dest => dest.CnSubjectHtml, opt => opt.MapFrom(src => src.ContractNotice.ConSubjectHtml))
            .ForMember(dest => dest.DocumentNo, opt => opt.MapFrom(src => src.CpDocument.DocumentNo))
            .ForMember(dest => dest.DocumentDesc, opt => opt.MapFrom(src => src.CpDocument.Description));
        CreateMap<CnEmail, CnEmailDto>()
            .ForMember(dest => dest.ConRef, opt => opt.MapFrom(src => src.ContractNotice.ConRef)).IncludeAllDerived()
            .ForMember(dest => dest.EmailDate, opt => opt.MapFrom(src => src.EmailLog.DateEmailed)).IncludeAllDerived()
            .ForMember(dest => dest.EmailSubject, opt => opt.MapFrom(src => src.EmailLog.Subject)).IncludeAllDerived();
        CreateMap<CnItp, CnItpDto>()
            .ForMember(dest => dest.ConRef, opt => opt.MapFrom(src => src.ContractNotice.ConRef))
            .ForMember(dest => dest.ItpDocNumber, opt => opt.MapFrom(src => src.Itp.ItpDocnumber)).IncludeAllDerived()
            .ForMember(dest => dest.ItpName, opt => opt.MapFrom(src => src.Itp.Description)).IncludeAllDerived();
        CreateMap<CnInstruction, CnInstructionDto>()
            .ForMember(dest => dest.ConRef, opt => opt.MapFrom(src => src.ContractNotice.ConRef));
        CreateMap<CnIncident, CnIncidentDto>()
            .ForMember(dest => dest.ConRef, opt => opt.MapFrom(src => src.ContractNotice.ConRef));
        CreateMap<CnLot, CnLotDto>()
            .ForMember(dest => dest.ConRef, opt => opt.MapFrom(src => src.ContractNotice.ConRef))
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber))
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description));
        CreateMap<CnNotice, CnNoticeDto>()
            .ForMember(dest => dest.ConRef1, opt => opt.MapFrom(src => src.ContractNotice_CnId1.ConRef)).IncludeAllDerived()
            .ForMember(dest => dest.ConSubject1, opt => opt.MapFrom(src => src.ContractNotice_CnId1.SubjectHtmlTemp)).IncludeAllDerived()
            .ForMember(dest => dest.ConRef2, opt => opt.MapFrom(src => src.ContractNotice_CnId2.ConRef)).IncludeAllDerived()
            .ForMember(dest => dest.ConSubject2, opt => opt.MapFrom(src => src.ContractNotice_CnId2.SubjectHtmlTemp)).IncludeAllDerived();
        CreateMap<CnPhoto, CnPhotoDto>()
            .ForMember(dest => dest.CnNumber, opt => opt.MapFrom(src => src.ContractNotice.ConRef))
            .ForMember(dest => dest.CnSubjectHtml, opt => opt.MapFrom(src => src.ContractNotice.ConSubjectHtml))
            .ForMember(dest => dest.PhotoDescription, opt => opt.MapFrom(src => src.Photo.Description));
        CreateMap<CnVariation, CnVariationDto>()
            .ForMember(dest => dest.ConRef, opt => opt.MapFrom(src => src.ContractNotice.ConRef))
            .ForMember(dest => dest.VariationNo, opt => opt.MapFrom(src => src.Variation.VariationNo))
            .ForMember(dest => dest.VariationDesc, opt => opt.MapFrom(src => src.Variation.Description));
        CreateMap<CnResponse, CnResponseDto>()
            .ForMember(dest => dest.ResponseByName, opt => opt.MapFrom(src => src.ResponseBy == null ? "" : src.ResponseBy.FirstName + " " + src.ResponseBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ActionRequiredByName, opt => opt.MapFrom(src => src.ActionRequiredBy == null ? "" : src.ActionRequiredBy.FirstName + " " + src.ActionRequiredBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ActionCompletedByName, opt => opt.MapFrom(src => src.ActionCompletedBy == null ? "" : src.ActionCompletedBy.FirstName + " " + src.ActionCompletedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ContractNoticeReference, opt => opt.MapFrom(src => src.ContractNotice.ConRef)).IncludeAllDerived()
            .ForMember(dest => dest.ContractNoticeSubjectHtml, opt => opt.MapFrom(src => src.ContractNotice.ConSubjectHtml)).IncludeAllDerived();
        CreateMap<CnResponse, CnResponseTemplateDto>()
            .ForMember(dest => dest.ProjectName, opt => opt.MapFrom(src => src.ContractNotice.Project.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ProjectNumber, opt => opt.MapFrom(src => src.ContractNotice.Project.ContractNumber)).IncludeAllDerived();
        CreateMap<CpDocument, CpDocumentDto>();
        CreateMap<CpDocument, CpDocumentTemplateDto>()
            .ForMember(dest => dest.LastRevDate, opt => opt.MapFrom(src => src.Revisions.OrderByDescending(x => x.RevisionDate).Select(x => x.RevisionDate).FirstOrDefault())).IncludeAllDerived()
            .ForMember(dest => dest.LastRevRef, opt => opt.MapFrom(src => src.Revisions.OrderByDescending(x => x.RevisionDate).Select(x => x.RevRef).FirstOrDefault())).IncludeAllDerived();
        CreateMap<ControlLine, ControlLineDto>();
        CreateMap<ControlLinePoint, ControlLinePointDto>();
        CreateMap<CostCode, CostCodeDto>();
        CreateMap<CostCodeCustomRegItem, CostCodeCustomRegItemDto>();
        CreateMap<CustomRegister, CustomRegisterDto>();
        CreateMap<CustomRegister, CustomRegisterExportDto>();
        CreateMap<CustomRegisterItem, CustomRegisterItemDto>();
        CreateMap<CustomRegisterItem, CustomRegisterItemExportDto>();

        CreateMap<Distribution, DistributionDto>()
            .ForMember(dest => dest.DocumentDesc, opt => opt.MapFrom(src => src.CpDocument.Description)).IncludeAllDerived()
            .ForMember(dest => dest.UserFullName, opt => opt.MapFrom(src => src.User == null ? "" : src.User.FirstName + " " + src.User.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.DocumentNo, opt => opt.MapFrom(src => src.CpDocument.DocumentNo)).IncludeAllDerived();

        CreateMap<EmailLog, EmailLogDto>();
        CreateMap<EmailLog, EmailLogListDto>();

        CreateMap<FileStoreDoc, FileStoreDocDto>();
        CreateMap<FileStoreDoc, FileStoreDocTemplateDto>();
        CreateMap<FsTestReq, FsTestReqTemplateDto>();
        CreateMap<FsApproval, FsApprovalDto>()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval == null ? null : src.Approval.ApprovalNo)).IncludeAllDerived();
        CreateMap<FsEmail, FsEmailDto>()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived()
            .ForMember(dest => dest.EmailSubject, opt => opt.MapFrom(src => src.EmailLog == null ? "" : src.EmailLog.Subject)).IncludeAllDerived();
        CreateMap<FsNotice, FsNoticeDto>()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived()
            .ForMember(dest => dest.CnSubjectHtml, opt => opt.MapFrom(src => src.ContractNotice.ConSubjectHtml)).IncludeAllDerived()
            .ForMember(dest => dest.CnRef, opt => opt.MapFrom(src => src.ContractNotice == null ? null : src.ContractNotice.ConRef)).IncludeAllDerived();
        CreateMap<FsDoc, FsDocDto>()
            .ForMember(dest => dest.DocumentNo, opt => opt.MapFrom(src => src.CpDocument.DocumentNo)).IncludeAllDerived()
            .ForMember(dest => dest.DocumentDesc, opt => opt.MapFrom(src => src.CpDocument.Description)).IncludeAllDerived()
            .ForMember(dest => dest.Revision, opt => opt.MapFrom(src => src.Revision.RevRef)).IncludeAllDerived()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived();
        CreateMap<FsIncident, FsIncidentDto>()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived();
        CreateMap<FsInstruction, FsInstructionDto>()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived();
        CreateMap<FsLot, FsLotDto>()
            .ForMember(dest => dest.FullLotDesc, opt => opt.MapFrom(src => src.Lot == null ? "" : src.Lot.LotNumber + ": " + src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived();
        CreateMap<FsNcr, FsNcrDto>()
            .ForMember(dest => dest.NcrNo, opt => opt.MapFrom(src => src.Ncr.NcrNo)).IncludeAllDerived()
            .ForMember(dest => dest.NcrDesc, opt => opt.MapFrom(src => src.Ncr.Description)).IncludeAllDerived()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived();
        CreateMap<FsPurchaseOrder, FsPurchaseOrderDto>()
            .ForMember(dest => dest.FullPoDesc, opt => opt.MapFrom(src => src.PurchaseOrder == null ? "" : src.PurchaseOrder.PoNumber + ": " + src.PurchaseOrder.Supplier.SupplierName)).IncludeAllDerived()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived();
        CreateMap<FsSupplier, FsSupplierDto>()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived()
            .ForMember(dest => dest.SupplierName, opt => opt.MapFrom(src => src.Supplier.SupplierName)).IncludeAllDerived();
        CreateMap<FsTestReq, FsTestReqDto>()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDate, opt => opt.MapFrom(src => src.FileStoreDoc.FileDate)).IncludeAllDerived()
            .ForMember(dest => dest.TestReqNo, opt => opt.MapFrom(src => src.TestRequest.TestRequestNo)).IncludeAllDerived()
            .ForMember(dest => dest.TestReqDesc, opt => opt.MapFrom(src => src.TestRequest.Description)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived();
        CreateMap<FsVariation, FsVariationDto>()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived()
            .ForMember(dest => dest.VariationNo, opt => opt.MapFrom(src => src.Variation == null ? "" : src.Variation.VariationNo)).IncludeAllDerived()
            .ForMember(dest => dest.VariationDesc, opt => opt.MapFrom(src => src.Variation == null ? null : src.Variation.Description)).IncludeAllDerived();
        CreateMap<FsWorkflowLog, FsWorkflowLogDto>()
            .ForMember(dest => dest.FirstLast, opt => opt.MapFrom(src => src.WorkflowLog.User == null ? "" : src.WorkflowLog.User.FirstName + " " + src.WorkflowLog.User.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.Filename, opt => opt.MapFrom(src => src.FileStoreDoc.Filename)).IncludeAllDerived()
            .ForMember(dest => dest.LogDate, opt => opt.MapFrom(src => src.WorkflowLog.LogDate)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalId, opt => opt.MapFrom(src => src.WorkflowLog.Workflow.Approvals.FirstOrDefault().ApprovalId)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.WorkflowLog.Workflow.Approvals.FirstOrDefault().ApprovalNo)).IncludeAllDerived()
            .ForMember(dest => dest.FileDesc, opt => opt.MapFrom(src => src.FileStoreDoc.Description)).IncludeAllDerived();

        CreateMap<ImageLayer, ImageLayerDto>();
        CreateMap<ImageLayerPoint, ImageLayerPointDto>();
        CreateMap<Incident, IncidentTemplateDto>()
            .ForMember(dest => dest.IncidentTypeName, opt => opt.MapFrom(src => src.IncidentType.IncidentTypeName)).IncludeAllDerived();
        CreateMap<Incident, IncidentListDto>()
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom(src => src.RaisedBy == null ? "" : src.RaisedBy.FirstName + " " + src.RaisedBy.LastName)).IncludeAllDerived();
        CreateMap<Incident, IncidentDto>();
        CreateMap<Instruction, InstructionListDto>()
            .ForMember(dest => dest.InstructionByName, opt => opt.MapFrom(src => src.InstructionBy == null ? "" : src.InstructionBy.FirstName + " " + src.InstructionBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.InstructionToName, opt => opt.MapFrom(src => src.InstructionTo == null ? "" : src.InstructionTo.FirstName + " " + src.InstructionTo.LastName)).IncludeAllDerived();
        CreateMap<Instruction, InstructionDto>();
        CreateMap<Instruction, InstructionTemplateDto>();
        CreateMap<Itp, ItpListDto>()
            .ForMember(dest => dest.HasScheduleLink, opt => opt.MapFrom(src => src.ItpScheduleItems.Count > 0)).IncludeAllDerived();
        CreateMap<Itp, ItpDto>();
        CreateMap<ItpDetail, ItpDetailDto>()
            .ForMember(dest => dest.TestCount, opt => opt.MapFrom(src => src.ItpTestings.Count)).IncludeAllDerived();
        CreateMap<ItpTesting, ItpTestingDto>()
             .ForMember(dest => dest.TestMethodName, opt => opt.MapFrom(src => src.TestMethod == null ? "" : src.TestMethod.TestNum + ": " + src.TestMethod.TestDescription)).IncludeAllDerived();
        CreateMap<Itp, ItpTemplateDto>();
        CreateMap<ItpDetailWorkflow, ItpDetailWorkflowDto>()
            .ForMember(dest => dest.WorkflowName, opt => opt.MapFrom(src => src.ApprovalWorkflow.Description)).IncludeAllDerived();
        CreateMap<IncidentType, IncidentTypeDto>();
        CreateMap<IncidentPerson, IncidentPersonDto>()
            .ForMember(dest => dest.ContactName, opt => opt.MapFrom(src => src.Contact == null ? "" : src.Contact.FirstName + " " + src.Contact.LastName));
        CreateMap<ItpScheduleItem, ItpScheduleDto>()
            .ForMember(dest => dest.ItpDocNo, opt => opt.MapFrom(src => src.Itp.ItpDocnumber)).IncludeAllDerived()
            .ForMember(dest => dest.ItpDescription, opt => opt.MapFrom(src => src.Itp.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleNo, opt => opt.MapFrom(src => src.ScheduleItem.ScheduleNumber)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleDesc, opt => opt.MapFrom(src => src.ScheduleItem.Description)).IncludeAllDerived();

        CreateMap<Lot, LotShortListDto>();
        CreateMap<Lot, LotListDto>()
            .ForMember(dest => dest.PrimaryTag, opt => opt.MapFrom(src => src.TagCode.TagName)).IncludeAllDerived()
            .ForMember(dest => dest.LotStatus, opt => opt.MapFrom(src =>
                    src.DateRejected != null ? "rejected" :
                    src.DateConf != null ? "conformed" :
                    src.DateGuar != null ? "guaranteed" : "open"))
            //               ((src.Project.SystemProjectControls.FirstOrDefault(x => x.Key.ToLower() == "supportpreopen").Value ?? "false").ToLower() == "true") && (src.DateWorkSt == null) ? "pre-open" : "open")).IncludeAllDerived()
            .ForMember(dest => dest.EffPercentComplete, opt => opt.MapFrom(src => src.DateConf != null || src.DateGuar != null ? 1 : src.PercentComplete)).IncludeAllDerived();
        CreateMap<Lot, LotDto>()
            .ForMember(dest => dest.ControlLineName, opt => opt.MapFrom(src => src.ControlLine.ControlLineName)).IncludeAllDerived();
        CreateMap<Lot, LotTemplateDto>();
        CreateMap<LotCoordinate, LotCoordinateDto>();
        CreateMap<LotInstruction, LotInstructionDto>()
            .ForMember(dest => dest.InstructionDescriptionHtml, opt => opt.MapFrom(src => src.Instruction.DescriptionHtml)).IncludeAllDerived()
            .ForMember(dest => dest.InstructionDate, opt => opt.MapFrom(src => src.Instruction.InstructionDate))
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber))
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description));
        CreateMap<LotRelation, LotRelationDto>()
            .ForMember(dest => dest.Lot1Number, opt => opt.MapFrom(src => src.Lot1.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.Lot2Number, opt => opt.MapFrom(src => src.Lot2.LotNumber)).IncludeAllDerived();
        CreateMap<LotRelation, LotRelationFullDto>()
            .ForMember(dest => dest.Lot1Description, opt => opt.MapFrom(src => src.Lot1.Description)).IncludeAllDerived()
            .ForMember(dest => dest.Lot2Description, opt => opt.MapFrom(src => src.Lot2.Description)).IncludeAllDerived();
        CreateMap<LotTag, LotTagDto>()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.TagName, opt => opt.MapFrom(src => src.TagCode.TagName)).IncludeAllDerived()
            .ForMember(dest => dest.TagDescription, opt => opt.MapFrom(src => src.TagCode.Description)).IncludeAllDerived();
        CreateMap<LotItp, LotItpDto>()
            .ForMember(dest => dest.ItpName, opt => opt.MapFrom(src => src.Itp.Description))
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber))
            .ForMember(dest => dest.AllChecked, opt => opt.MapFrom(src => !src.LotItpDetails.Any(x => (x.CheckReqd ?? false)
                && x.CheckDate == null && x.NotApplicableDate == null && x.NcrId == null)))
            .ForMember(dest => dest.AllVerified, opt => opt.MapFrom(src => !src.LotItpDetails.Any(x => (x.VerifyReqd ?? false)
                && x.VerifyDate == null && x.NotApplicableDate == null && x.NcrId == null)))
            .ForMember(dest => dest.AllApproved, opt => opt.MapFrom(src => !src.LotItpDetails.Any(x => (x.ApprovalReqd ?? false)
                && x.NotApplicableDate == null && x.NcrId == null && x.ApproveDate == null
                && !(x.Approval.IsCompleted ?? false) && x.Approval.DateDirectlyApproved == null
                && x.Approval.CloseOutDate == null)))
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom(src => src.RaisedBy == null ? "" : src.RaisedBy.FirstName + " " + src.RaisedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovedByName, opt => opt.MapFrom(src => src.ApprovedBy == null ? "" : src.ApprovedBy.FirstName + " " + src.ApprovedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.DateRejected, opt => opt.MapFrom(src => src.Lot.DateRejected)).IncludeAllDerived()
            .ForMember(dest => dest.DateConformed, opt => opt.MapFrom(src => src.Lot.DateConf)).IncludeAllDerived()
            .ForMember(dest => dest.DateGuaranteed, opt => opt.MapFrom(src => src.Lot.DateGuar)).IncludeAllDerived()
            .ForMember(dest => dest.Status, opt => opt.MapFrom(src => src.Lot==null? "No Lot Ref" :
                src.Lot.DateRejected!=null?"Rejected":
                src.Lot.DateConf != null ? "Conformed" :
                src.Lot.DateGuar != null ? "Guaranteed" :
                src.Lot.DateClosed != null ? "Closed" : "Open")).IncludeAllDerived();
        CreateMap<LotItpDetail, LotItpDetailDto>()
            .ForMember(dest => dest.NcrNo, opt => opt.MapFrom(src => src.Ncr.NcrNo)).IncludeAllDerived()
            .ForMember(dest => dest.HasTests, opt => opt.MapFrom(src => !(src.LotItpTests.Count == 0))).IncludeAllDerived()
            .ForMember(dest => dest.IsLatestStepAlert, opt => opt.MapFrom(src => src.Approval.IsLatestStepAlert ?? false)).IncludeAllDerived()
            .ForMember(dest => dest.LatestApprovalStatus, opt => opt.MapFrom(src =>
                src.Approval == null ? (src.ApproveDate != null ? "Directly Approved" : "Open") :
                (src.Approval.IsCompleted ?? false) ? src.Approval.StatusLastStep :
                src.Approval.DateDirectlyApproved != null ? "Manually Approved" :
                src.Approval.CloseOutDate != null ? "Closed Out (Approval)" :
                src.Approval.StatusLastStep ?? "Not started"
                )).IncludeAllDerived()
            .ForMember(dest => dest.IsApprovedToProceed, opt => opt.MapFrom(src =>
                src.ApproveDate != null ||
                (src.Approval.IsApprovedToProceed ?? false) ||
                src.Approval.DateDirectlyApproved != null ||
                (src.Approval.IsCompleted ?? false))).IncludeAllDerived()
            .ForMember(dest => dest.IsApprovalCompleted, opt => opt.MapFrom(src =>
                src.ApproveDate != null ||
                src.Approval.CloseOutDate != null ||
                src.Approval.DateDirectlyApproved != null ||
                (src.Approval.IsCompleted ?? false))).IncludeAllDerived();
        CreateMap<LotItpDetail, LotItpDetailTemplateDto>()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.LotItp.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.LotItp.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ItpDocNo, opt => opt.MapFrom(src => src.LotItp.SourceItpNo)).IncludeAllDerived()
            .ForMember(dest => dest.ItpName, opt => opt.MapFrom(src => src.LotItp.Itp.Description)).IncludeAllDerived();
        CreateMap<LotItpTest, LotItpTestDto>()
            .ForMember(dest => dest.IsReducedLevelOfTesting, opt => opt.MapFrom(src => (src.LotItpDetail.LotItp.Lot.TestRed ?? false))).IncludeAllDerived()
            .ForMember(dest => dest.TestMethodName, opt => opt.MapFrom(src => src.TestMethod == null ? "" : src.TestMethod.TestNum + ": " + src.TestMethod.TestDescription)).IncludeAllDerived();
        CreateMap<LotQuantity, LotQuantityListDto>()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.EffDescription, opt => opt.MapFrom(src => src.LotId == null ? src.Description : src.Lot.LotNumber + ": " + src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleName, opt => opt.MapFrom(src => src.ScheduleItem == null ? "" : src.ScheduleItem.ScheduleNumber + ": " + src.ScheduleItem.Description)).IncludeAllDerived()
            .ForMember(dest => dest.EffectivePercComp, opt => opt.MapFrom(src => src.Lot == null ? src.PercComp :
                (src.Lot.DateConf != null || src.Lot.DateGuar != null) ? 1 :
                ((src.PercComp.HasValue && src.PercComp.Value < 1) ? src.PercComp ?? 0 : src.Lot.PercentComplete ?? 0))).IncludeAllDerived();
        CreateMap<LotQuantity, LotQuantityWithConfDto>()
            .ForMember(dest => dest.LotDateConf, opt => opt.MapFrom(src => src.Lot == null ? null : src.Lot.DateConf)).IncludeAllDerived()
            .ForMember(dest => dest.LotDateGuar, opt => opt.MapFrom(src => src.Lot == null ? null : src.Lot.DateGuar)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleNo, opt => opt.MapFrom(src => src.ScheduleItem.ScheduleNumber)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleDescription, opt => opt.MapFrom(src => src.ScheduleItem.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleSellRate, opt => opt.MapFrom(src => src.ScheduleItem.SellRate)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleUnit, opt => opt.MapFrom(src => src.ScheduleItem.Unit)).IncludeAllDerived();
        CreateMap<LotQuantity, LotQuantityDto>()
            .ForMember(dest => dest.ApprovedByName, opt => opt.MapFrom(src => src.ApprovedBy == null ? null : src.ApprovedBy.FirstName + " " + src.ApprovedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.SellRate, opt => opt.MapFrom(src => src.ScheduleItem.SellRate)).IncludeAllDerived()
            .ForMember(dest => dest.DjcRate, opt => opt.MapFrom(src => src.ScheduleItem.DjcRate)).IncludeAllDerived()
            .ForMember(dest => dest.Value, opt => opt.MapFrom(src => (src.ScheduleItem.SellRate ?? 0) * (src.Qty ?? 0))).IncludeAllDerived()
            .ForMember(dest => dest.LotAdjDate, opt => opt.MapFrom(src => src.Lot == null ? src.ModifiedOn :
                src.Lot.DateRejected != null ? src.Lot.DateRejected :
                src.Lot.DateConf != null ? src.Lot.DateConf :
                src.Lot.DateGuar != null ? src.Lot.DateGuar :
                src.Lot.DateOpen)).IncludeAllDerived();
        CreateMap<LotUser, LotUserDto>()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.UserFullName, opt => opt.MapFrom(src => src.User == null ? "" : src.User.FirstName + " " + src.User.LastName)).IncludeAllDerived();

        CreateMap<Ncr, NcrListDto>()
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom(src => src.RaisedBy == null ? "" : src.RaisedBy.FirstName + " " + src.RaisedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.LqSell, opt => opt.MapFrom(src => src.LotQuantities.Sum(x => Math.Round(((x.NonClaimable ?? false) ? 0 : 1) * x.Qty ?? 0 * x.ScheduleItem.SellRate ?? 0, 2)))).IncludeAllDerived()
            .ForMember(dest => dest.LqRpVal, opt => opt.MapFrom(src => src.LotQuantities.Sum(x => Math.Round((1 - x.ReducedPayment ?? 1) * ((x.NonClaimable ?? false) ? 0 : 1) * x.Qty ?? 0 * x.ScheduleItem.SellRate ?? 0, 2)))).IncludeAllDerived()
            .ForMember(dest => dest.ApprovedByName, opt => opt.MapFrom(src => src.ApprovalBy == null ? "" : src.ApprovalBy.FirstName + " " + src.ApprovalBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.CloseoutByName, opt => opt.MapFrom(src => src.CloseOutBy == null ? "" : src.CloseOutBy.FirstName + " " + src.CloseOutBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.IsLatestStepAlert, opt => opt.MapFrom(src => src.Approval.IsLatestStepAlert)).IncludeAllDerived()
            .ForMember(dest => dest.IsApprovedToProceed, opt => opt.MapFrom(src =>
                (src.ApprovalDate != null) ||
                (src.Approval.IsApprovedToProceed ?? false) ||
                (src.Approval.DateDirectlyApproved != null) ||
                (src.Approval.IsCompleted ?? false))).IncludeAllDerived()
            .ForMember(dest => dest.IsApprovalComplete, opt => opt.MapFrom(src =>
                (src.ApprovalDate != null) ||
                (src.CloseOutDate != null) ||
                (src.Approval.CloseOutDate != null) ||
                (src.Approval.DateDirectlyApproved != null) ||
                (src.Approval.IsCompleted ?? false))).IncludeAllDerived()
            .ForMember(dest => dest.Status, opt => opt.MapFrom(src =>
                src.CloseOutDate != null ? "Closed Out" :
                src.Approval == null ? (src.ApprovalDate != null ? "Manually Approved" : "Open") :
                (src.Approval.IsCompleted ?? false) ? src.Approval.StatusLastStep :
                src.Approval.DateDirectlyApproved != null ? "Manually Approved" :
                src.Approval.CloseOutDate != null ? "Closed Out (Approval)" :
                src.Approval.StatusLastStep ?? "Not started"
                )).IncludeAllDerived();
        CreateMap<Ncr, NcrDto>();
        CreateMap<Ncr, NcrTemplateDto>()
            .ForMember(dest => dest.ProjectName, opt => opt.MapFrom(src => src.Project.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ProjectNumber, opt => opt.MapFrom(src => src.Project.ContractNumber)).IncludeAllDerived()
            .ForMember(dest => dest.Lots, opt => opt.MapFrom(src => src.NcrLots.Select(x => x.Lot).OrderBy(x => x.LotNumber))).IncludeAllDerived();
        CreateMap<NcrDocument, NcrDocumentDto>()
             .ForMember(dest => dest.NcrNo, opt => opt.MapFrom(src => src.Ncr.NcrNo)).IncludeAllDerived()
             .ForMember(dest => dest.NcrDesc, opt => opt.MapFrom(src => src.Ncr.Description)).IncludeAllDerived()
             .ForMember(dest => dest.DocNumber, opt => opt.MapFrom(src => src.CpDocument.DocumentNo)).IncludeAllDerived()
             .ForMember(dest => dest.DocDescription, opt => opt.MapFrom(src => src.CpDocument.Description)).IncludeAllDerived();
        CreateMap<NcrLot, NcrLotDto>()
            .ForMember(dest => dest.NcrNo, opt => opt.MapFrom(src => src.Ncr.NcrNo)).IncludeAllDerived()
            .ForMember(dest => dest.NcrDesc, opt => opt.MapFrom(src => src.Ncr.Description)).IncludeAllDerived()
            .ForMember(dest => dest.NcrApprovalDate, opt => opt.MapFrom(src => src.Ncr.ApprovalDate)).IncludeAllDerived()
            .ForMember(dest => dest.NcrCloseOutDate, opt => opt.MapFrom(src => src.Ncr.CloseOutDate)).IncludeAllDerived()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived();

        CreateMap<Photo, PhotoListDto>()
            .ForMember(dest => dest.PhotoDatePart, opt => opt.MapFrom(src => src.PhotoDate == null ? src.PhotoDate : src.PhotoDate.Value.Date)).IncludeAllDerived();
        CreateMap<Photo, PhotoDto>();
        CreateMap<PhotoApproval, PhotoApprovalDto>()
            .ForMember(dest => dest.PhotoDescription, opt => opt.MapFrom(src => src.Photo.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval.ApprovalNo)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml)).IncludeAllDerived();
        CreateMap<Photo, PhotoTemplateDto>();
        CreateMap<PhotoLot, PhotoLotDto>()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.LotDesc, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.PhotoDescription, opt => opt.MapFrom(src => src.Photo.Description)).IncludeAllDerived();
        CreateMap<PhotoIncident, PhotoIncidentDto>()
            .ForMember(dest => dest.IncidentDescHtml, opt => opt.MapFrom(src => src.Incident.DescriptionHtml))
            .ForMember(dest => dest.PhotoDescription, opt => opt.MapFrom(src => src.Photo.Description));
        CreateMap<PhotoChecklistItem, PhotoChecklistItemDto>()
            .ForMember(dest => dest.LotItpId, opt => opt.MapFrom(src => src.LotItpDetail == null ? null : src.LotItpDetail.LotItpId)).IncludeAllDerived()
            .ForMember(dest => dest.ChecklistLineDesc, opt => opt.MapFrom(src => src.LotItpDetail == null ? null : src.LotItpDetail.LotItp.Lot.LotNumber ?? "" + ": " + src.LotItpDetail.LotItp.Itp.Description ?? "No ITP Link")).IncludeAllDerived()
            .ForMember(dest => dest.PhotoDescription, opt => opt.MapFrom(src => src.Photo.Description)).IncludeAllDerived();
        CreateMap<PhotoVariation, PhotoVariationDto>()
            .ForMember(dest => dest.VrnNumber, opt => opt.MapFrom(src => src.Variation.VariationNo)).IncludeAllDerived()
            .ForMember(dest => dest.VrnDesc, opt => opt.MapFrom(src => src.Variation.Description)).IncludeAllDerived()
            .ForMember(dest => dest.PhotoDescription, opt => opt.MapFrom(src => src.Photo.Description)).IncludeAllDerived();
        CreateMap<PhotoNcr, PhotoNcrDto>()
            .ForMember(dest => dest.NcrNo, opt => opt.MapFrom(src => src.Ncr.NcrNo)).IncludeAllDerived()
            .ForMember(dest => dest.NcrDesc, opt => opt.MapFrom(src => src.Ncr.Description)).IncludeAllDerived()
            .ForMember(dest => dest.PhotoDescription, opt => opt.MapFrom(src => src.Photo.Description)).IncludeAllDerived();
        CreateMap<ProgressClaimDetail, ProgressClaimDetailDto>()
            .ForMember(dest => dest.DjcTotal, opt => opt.MapFrom(src => Math.Round((src.DjcRate ?? 0) * (src.QtyScheduled ?? 0), 2))).IncludeAllDerived()
            .ForMember(dest => dest.SellTotal, opt => opt.MapFrom(src => Math.Round((src.SellRate ?? 0) * (src.QtyScheduled ?? 0), 2))).IncludeAllDerived(); CreateMap<ProgressClaimVersion_add, ProgressClaimVersion>();
        CreateMap<ProgressClaimVersion, ProgressClaimVersionDto>()
            .ForMember(dest => dest.ClaimToDate, opt => opt.MapFrom(src => src.ProgressClaimDetails.Count == 0 ? 0 : src.ProgressClaimDetails.Sum(y => Math.Round(((y.IsOverhead ?? false) ? 0 : 1) * (y.SellRate ?? 0) * (y.QtyClaimed ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.BudgetClaimed, opt => opt.MapFrom(src => src.ProgressClaimDetails.Count == 0 ? 0 : src.ProgressClaimDetails.Sum(y => Math.Round((y.DjcRate ?? 0) * (y.QtyClaimed ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.CertifiedValue, opt => opt.MapFrom(src => src.ProgressClaimDetails.Count == 0 ? 0 : src.ProgressClaimDetails.Sum(y => Math.Round(((y.IsOverhead ?? false) ? 0 : 1) * ((y.IsVariableRate ?? false) ? (y.SellRateCert ?? 0) : (y.SellRate ?? 0)) * (y.QtyCertified ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.OverUnder, opt => opt.MapFrom(src => src.ProgressClaimDetails.Count == 0 ? 0 : src.ProgressClaimDetails.Sum(y => Math.Round(((y.IsOverhead ?? false) ? 0 : 1) * (y.SellRate ?? 0) * (y.QtyOverUnder ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.OverUnderBudget, opt => opt.MapFrom(src => src.ProgressClaimDetails.Count == 0 ? 0 : src.ProgressClaimDetails.Sum(y => Math.Round((y.DjcRate ?? 0) * (y.QtyOverUnder ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.AtCompletion, opt => opt.MapFrom(src => src.ProgressClaimDetails.Count == 0 ? 0 : src.ProgressClaimDetails.Sum(y => Math.Round(((y.IsOverhead ?? false) ? 0 : 1) * ((y.IsVariableRate ?? false) ? (y.SellRateAtComp ?? 0) : (y.SellRate ?? 0)) * (y.QtyAtCompl ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.BudgetAtCompletion, opt => opt.MapFrom(src => src.ProgressClaimDetails.Count == 0 ? 0 : src.ProgressClaimDetails.Sum(y => Math.Round(((y.IsVariableRate ?? false) ? (y.DjcRateAtComp ?? 0) : (y.DjcRate ?? 0)) * (y.QtyAtCompl ?? 0), 2)))).IncludeAllDerived();
        CreateMap<ProgressClaimSnapshot, ProgressClaimSnapshotDto>()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleNumber, opt => opt.MapFrom(src => src.ScheduleItem.ScheduleNumber)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleDescription, opt => opt.MapFrom(src => src.ScheduleItem.Description)).IncludeAllDerived()
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.Unit, opt => opt.MapFrom(src => src.ScheduleItem.Unit)).IncludeAllDerived();
        CreateMap<Project, ProjectDto>()
            .ForMember(dest => dest.ProjectNumberAndName, opt => opt.MapFrom(src => src.ContractNumber == null ? src.Description : src.ContractNumber + ": " + src.Description)).IncludeAllDerived();
        CreateMap<Project, ProjectExtDto>();
        CreateMap<ProjectUser, ProjectUserDto>();

        CreateMap<PurchaseOrder, PurchaseOrderListDto>()
            .ForMember(dest => dest.SupplierName, opt => opt.MapFrom(src => src.Supplier.SupplierName)).IncludeAllDerived()
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom(src => src.RaisedBy.FirstName + " " + src.RaisedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.PoValue, opt => opt.MapFrom(src => src.PurchaseOrderDetails.Count == 0 ? 0 : Math.Round(src.PurchaseOrderDetails.Sum(x => (x.Qty ?? 0) * (x.Rate ?? 0)), 2))).IncludeAllDerived();
        CreateMap<PurchaseOrder, PurchaseOrderTemplateDto>()
            .ForMember(dest => dest.ProjectName, opt => opt.MapFrom(src => src.Project.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ProjectNumber, opt => opt.MapFrom(src => src.Project.ContractNumber)).IncludeAllDerived()
            .ForMember(dest => dest.PurchaseOrderDetailsOrdered, opt => opt.MapFrom(src => src.PurchaseOrderDetails.OrderBy(x => x.ItemNumber))).IncludeAllDerived();
        CreateMap<PoEmail, PoEmailDto>()
            .ForMember(dest => dest.EmailDate, opt => opt.MapFrom(src => src.EmailLog.DateEmailed))
            .ForMember(dest => dest.FullPoDesc, opt => opt.MapFrom(src => src.PurchaseOrder == null ? "" : src.PurchaseOrder.PoNumber + ": " + src.PurchaseOrder.Supplier.SupplierName)).IncludeAllDerived();
        CreateMap<PurchaseOrderDetail, PurchaseOrderDetailDto>()
            .ForMember(dest => dest.QtyReceipted, opt => opt.MapFrom(src => src.ReceiptDetails.Count == 0 ? 0m : src.ReceiptDetails.Sum(x => x.Qty ?? 0))).IncludeAllDerived()
            ;
        CreateMap<PurchaseOrderDetail, PurchaseOrderDetailTemplateDto>();

        CreateMap<Receipt, ReceiptDto>()
            .ForMember(dest => dest.TotalReceipted, opt => opt.MapFrom(src => src.ReceiptDetails.Count == 0 ? 0m : src.ReceiptDetails.Sum(x => Math.Round((x.Qty ?? 0) * (x.PurchaseOrderDetail.Rate ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.TotalDaycost, opt => opt.MapFrom(src => src.DayCosts.Count == 0 ? 0 : src.DayCosts.Sum(x => Math.Round((x.Qty ?? 0) * (x.Rate ?? 0), 2)))).IncludeAllDerived();
        CreateMap<ReportPeriod, ReportPeriodDto>();
        CreateMap<Resource, ResourceDto>();
        CreateMap<Revision, RevisionDto>();
        CreateMap<Role, RoleDto>()
            .ForMember(dest => dest.SubscriptionRoleType, opt => opt.MapFrom(src => src.RolePermissions.Any(x => (x.Allowed ?? false) &&
            (x.AccessKey == (int)PermissionAccessEnum.Add || x.AccessKey == (int)PermissionAccessEnum.Edit || x.AccessKey == (int)PermissionAccessEnum.Admin_Delete)) ? SubscriptionRoleTypeEnum.Full : SubscriptionRoleTypeEnum.Associate));
        CreateMap<RolePermission, RolePermissionDto>();
        CreateMap<Subscriber, SubscriptionDto>();
        CreateMap<ScheduleItem, ScheduleFlatListDto>()
            .ForMember(dest => dest.DjcTotal, opt => opt.MapFrom(src => Math.Round((src.DjcRate ?? 0) * (src.QtyScheduled ?? 0), 2))).IncludeAllDerived()
            .ForMember(dest => dest.SellTotal, opt => opt.MapFrom(src => Math.Round((src.SellRate ?? 0) * (src.QtyScheduled ?? 0), 2))).IncludeAllDerived()
            .ForMember(dest => dest.IsHeading, opt => opt.MapFrom(src => src.QtyScheduled == null && src.SellRate == null)).IncludeAllDerived()
            .ForMember(dest => dest.LotQtyTotal, opt => opt.MapFrom(src => src.LotQuantities.Sum(x => x.Qty ?? 0))).IncludeAllDerived()
            .ForMember(dest => dest.LotQtyRemaining, opt => opt.MapFrom(src => (src.QtyScheduled ?? 0) - src.LotQuantities.Sum(x => x.Qty ?? 0))).IncludeAllDerived();
        CreateMap<ScheduleItem, ScheduleFlatDto>();
        CreateMap<ScheduleItem, ScheduleItemDto>()
            .ForMember(dest => dest.IsHeading, opt => opt.MapFrom(src => src.QtyScheduled == null && src.SellRate == null)).IncludeAllDerived();
        CreateMap<ScheduleItem, ScheduleItemListDto>();
        CreateMap<SiteDiary, SiteDiaryListDto>()
            .ForMember(dest => dest.DiaryByName, opt => opt.MapFrom(src => src.DiaryBy == null ? "" : src.DiaryBy.FirstName + " " + src.DiaryBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ReviewedByName, opt => opt.MapFrom(src => src.ReviewedBy == null ? "" : src.ReviewedBy.FirstName + " " + src.ReviewedBy.LastName)).IncludeAllDerived();
        CreateMap<SiteDiary, SiteDiaryDto>();
        CreateMap<SiteDiaryCost, SiteDiaryCostDto>()
            .ForMember(dest => dest.SupplierName, opt => opt.MapFrom(src => src.Supplier.SupplierName));
        CreateMap<SiteDiaryCostCode, SiteDiaryCostCodeDto>()
            .ForMember(dest => dest.CostCodeName, opt => opt.MapFrom(src => src.CostCode.CostCodeName));
        CreateMap<Subcontractor, SubcontractorLookupDto>();
        CreateMap<SubcontractorUser, SubcontractorUserDto>()
            .ForMember(dest => dest.UserFullName, opt => opt.MapFrom(src => src.User == null ? "" : src.User.FirstName + " " + src.User.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.SubcontractorName, opt => opt.MapFrom(src => src.Subcontractor.SubcontractorName)).IncludeAllDerived();
        CreateMap<SubcontractorLot, SubcontractorLotDto>()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.SubcontractorName, opt => opt.MapFrom(src => src.Subcontractor.SubcontractorName)).IncludeAllDerived();
        CreateMap<Supplier, SupplierDto>();
        CreateMap<Supplier, SupplierListDto>();
        CreateMap<SupplierDivision, SupplierDivisionDto>()
            .ForMember(dest => dest.SupplierName, opt => opt.MapFrom(src => src.Supplier.SupplierName)).IncludeAllDerived()
            .ForMember(dest => dest.DivisionName, opt => opt.MapFrom(src => src.Division.DivisionName)).IncludeAllDerived();
        CreateMap<SystemProjectControl, ProjectControlDto>();
        CreateMap<SystemUserControl, SystemUserControlDto>();

        CreateMap<TagCode, TagCodeDto>();
        CreateMap<Template, TemplateDto>()
            .ForMember(dest => dest.TemplateTypeName, opt => opt.MapFrom(src => src.TemplateType.TypeName)).IncludeAllDerived();
        CreateMap<Template, TemplateExportDto>();
        CreateMap<TemplateType, TemplateTypeDto>();

        CreateMap<TestMethod, TestMethodDto>();
        CreateMap<TestReqEmail, TestReqEmailDto>()
            .ForMember(dest => dest.TestReqLot, opt => opt.MapFrom(src => src.TestRequest.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.EmailDate, opt => opt.MapFrom(src => src.EmailLog == null ? null : src.EmailLog.DateEmailed)).IncludeAllDerived()
            .ForMember(dest => dest.TestReqNo, opt => opt.MapFrom(src => src.TestRequest.TestRequestNo)).IncludeAllDerived()
            .ForMember(dest => dest.TestReqDate, opt => opt.MapFrom(src => src.TestRequest.DateRequest)).IncludeAllDerived();
        CreateMap<TestRequest, TestRequestBasicDto>()
             .ForMember(dest => dest.RequestedByName, opt => opt.MapFrom(src => src.RequestedBy == null ? "" : src.RequestedBy.FirstName + " " + src.RequestedBy.LastName)).IncludeAllDerived()
             .ForMember(dest => dest.RequestToName, opt => opt.MapFrom(src => src.TestRequestTo == null ? "" : src.TestRequestTo.FirstName + " " + src.TestRequestTo.LastName)).IncludeAllDerived()
             .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
             .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived();
        CreateMap<TestRequest, TestRequestListDto>()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.TestComplete, opt => opt.MapFrom(src => src.DateTestCompleted != null)).IncludeAllDerived()
            .ForMember(dest => dest.AttachmentCount, opt => opt.MapFrom(src => src.FsTestReqs.Count())).IncludeAllDerived();
        CreateMap<TestRequest, TestRequestDto>()
            .ForMember(dest => dest.HasDoc, opt => opt.MapFrom(src => src.FsTestReqs == null ? false : src.FsTestReqs.Any()))
            .ForMember(dest => dest.HasTest, opt => opt.MapFrom(src => src.TestRequestTests == null ? true : src.TestRequestTests.Any()))
            .ForMember(dest => dest.AllApproved, opt => opt.MapFrom(src => src.TestRequestTests == null ? true : src.TestRequestTests.All(x => x.TestComplete.Value == true)))
            //.ForMember(dest => dest.TestCount, opt => opt.MapFrom(src => src.TestRequestTests == null ? 0 : src.TestRequestTests.Count()))
            //.ForMember(dest => dest.TestCountUnapp, opt => opt.MapFrom(src => src.TestRequestTests == null ? 0 : src.TestRequestTests.Where(x => x.TestComplete == null || x.TestComplete.Value != true).Count()))
            ;
        CreateMap<TestRequestTest, TestRequestTestDto>()
            .ForMember(dest => dest.ScheduleName, opt => opt.MapFrom(src => src.ScheduleItem == null ? "" : src.ScheduleItem.ScheduleNumber + ": " + src.ScheduleItem.Description))
            .ForMember(dest => dest.TestMethodName, opt => opt.MapFrom(src => src.TestMethod == null ? "" : src.TestMethod.TestNum + ": " + src.TestMethod.TestDescription))
            .ForMember(dest => dest.ControlLineName, opt => opt.MapFrom(src => src.ControlLine.ControlLineName));
        CreateMap<TestRequest, TestRequestWithGeometryDto>()
            .ForMember(dest => dest.RequestedByName, opt => opt.MapFrom(src => src.RequestedBy == null ? "" : src.RequestedBy.FirstName + " " + src.RequestedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.RequestToName, opt => opt.MapFrom(src => src.TestRequestTo == null ? "" : src.TestRequestTo.FirstName + " " + src.TestRequestTo.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ControlLineName, opt => opt.MapFrom(src => src.ControlLine == null ? "" : src.ControlLine.ControlLineName)).IncludeAllDerived();
        CreateMap<TestRequest, TestRequestTemplateDto>()
            .ForMember(dest => dest.ProjectName, opt => opt.MapFrom(src => src.Project.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ProjectNumber, opt => opt.MapFrom(src => src.Project.ContractNumber)).IncludeAllDerived()
            .ForMember(dest => dest.FilestoreDocsOrdered, opt => opt.MapFrom(src => src.FsTestReqs.Select(x => x.FileStoreDoc).OrderByDescending(x => x.FileDate))).IncludeAllDerived()
            .ForMember(dest => dest.TestsOrdered, opt => opt.MapFrom(src => src.TestRequestTests.OrderBy(x => x.SampleId))).IncludeAllDerived();
        CreateMap<TestRequestProperty, TestRequestPropertyDto>();
        CreateMap<TestResultField, TestResultFieldDto>();
        CreateMap<TestCoordinate, TestCoordinateDto>();
        CreateMap<TestPropertyGroup, TestPropertyGroupDto>();
        CreateMap<TestPropertyItem, TestPropertyItemDto>();
        CreateMap<TransmittalItem, TransmittalItemDto>()
            .ForMember(dest => dest.DocumentNo, opt => opt.MapFrom(src => src.CpDocument.DocumentNo)).IncludeAllDerived()
            .ForMember(dest => dest.DocumentDesc, opt => opt.MapFrom(src => src.CpDocument.Description)).IncludeAllDerived()
            .ForMember(dest => dest.RevisionName, opt => opt.MapFrom(src => src.Revision.RevRef)).IncludeAllDerived();

        CreateMap<Unit, UnitLookupDto>();
        CreateMap<Unit, UnitDto>();
        CreateMap<User, UserDto>()
            .ForMember(dest => dest.FullName, opt => opt.MapFrom(src => src.FirstName + " " + src.LastName)).IncludeAllDerived();
        CreateMap<User, UserFullDto>()
            .ForMember(dest => dest.FullName, opt => opt.MapFrom(src => src.FirstName + " " + src.LastName)).IncludeAllDerived();
        CreateMap<User, UserBasicDto>()
            .ForMember(dest => dest.FirstLast, opt => opt.MapFrom(src => src.FirstName + " " + src.LastName)).IncludeAllDerived();
        CreateMap<User, UserAddresseeTemplateDto>();
        CreateMap<User, UserPasswordResetTemplateDto>();
        CreateMap<User, ContactDto>()
            .ForMember(dest => dest.FirstLast, opt => opt.MapFrom(src => src.FirstName + " " + src.LastName)).IncludeAllDerived();
        CreateMap<User, ContactListDto>()
            .ForMember(dest => dest.IsUser, opt => opt.MapFrom(src => !string.IsNullOrEmpty(src.Username))).IncludeAllDerived()
            .ForMember(dest => dest.FullName, opt => opt.MapFrom(src => src.FirstName + " " + src.LastName)).IncludeAllDerived();
        CreateMap<User, AddresseeDto>()
            .ForMember(dest => dest.FirstLast, opt => opt.MapFrom(src => src.FirstName + " " + src.LastName)).IncludeAllDerived();
        CreateMap<UserRole, UserRoleDto>();
        CreateMap<UserRole, UserRolePermsDto>()
            .ForMember(dest => dest.RoleName, opt => opt.MapFrom(src => src.Role.RoleName)).IncludeAllDerived()
            .ForMember(dest => dest.FullName, opt => opt.MapFrom(src => src.User.FirstName + " " + src.User.LastName)).IncludeAllDerived();
        CreateMap<UserInvite, UserInviteDto>();
        CreateMap<UserInvite, UserInviteTemplateDto>()
            .ForMember(dest => dest.ProjectName, opt => opt.MapFrom(src => src.Project.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ProjectNumber, opt => opt.MapFrom(src => src.Project.ContractNumber)).IncludeAllDerived();

        CreateMap<Variation, VariationListDto>()
            .ForMember(dest => dest.VariationStatus, opt => opt.MapFrom((src => src.VrnWaypoints.OrderByDescending(x => x.WaypointDate).Select(wp => wp.VrnStatus.Description).FirstOrDefault()))).IncludeAllDerived()
            .ForMember(dest => dest.StatusDate, opt => opt.MapFrom((src => src.VrnWaypoints.OrderByDescending(x => x.WaypointDate).Select(wp => wp.WaypointDate).FirstOrDefault()))).IncludeAllDerived()
            .ForMember(dest => dest.HasEstimate, opt => opt.MapFrom(src => src.VariationEstimates.Count > 0)).IncludeAllDerived()
            .ForMember(dest => dest.SellTotalEstimate, opt => opt.MapFrom(src => src.VariationEstimates.Count == 0 ? 0 : src.VariationEstimates.Sum(x => x.SellTotal ?? 0))).IncludeAllDerived()
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom((src => src.RaisedBy == null ? "" : src.RaisedBy.FirstName + " " + src.RaisedBy.LastName))).IncludeAllDerived();
        CreateMap<Variation, VariationDto>()
            .ForMember(dest => dest.DJCTotalEstimate, opt => opt.MapFrom(src => src.VariationEstimates.Count == 0 ? 0 : src.VariationEstimates.Sum(x => x.DjcTotal ?? 0))).IncludeAllDerived()
            .ForMember(dest => dest.DateIdentified, opt => opt.MapFrom(src => src.VrnWaypoints.Where(x => x.VrnStatusId == (int)VrnStatusEnum.Identified).Select(x => x.WaypointDate).FirstOrDefault())).IncludeAllDerived()
            .ForMember(dest => dest.DateNotified, opt => opt.MapFrom(src => src.VrnWaypoints.Where(x => x.VrnStatusId == (int)VrnStatusEnum.Notified).Select(x => x.WaypointDate).FirstOrDefault())).IncludeAllDerived()
            .ForMember(dest => dest.DateSubmitted, opt => opt.MapFrom(src => src.VrnWaypoints.Where(x => x.VrnStatusId == (int)VrnStatusEnum.Submitted).Select(x => x.WaypointDate).FirstOrDefault())).IncludeAllDerived()
            .ForMember(dest => dest.DateSubmitted, opt => opt.MapFrom(src => src.VrnWaypoints.Where(x => x.VrnStatusId == (int)VrnStatusEnum.Conditionally_Approved || x.VrnStatusId == (int)VrnStatusEnum.Approved || x.VrnStatusId == (int)VrnStatusEnum.Approved_In_Principle).Select(x => x.WaypointDate).FirstOrDefault())).IncludeAllDerived();
        CreateMap<Variation, VariationTemplateDto>();
        CreateMap<VariationLot, VariationLotDto>()
            .ForMember(dest => dest.FullLotDesc, opt => opt.MapFrom(src => src.Lot.LotNumber + ": " + src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.FullVariationDesc, opt => opt.MapFrom(src => src.Variation == null ? "" : src.Variation.VariationNo + ": " + src.Variation.Description)).IncludeAllDerived();
        CreateMap<VrnInstruction, VrnInstructionDto>()
            .ForMember(dest => dest.VrnNumber, opt => opt.MapFrom(src => src.Variation.VariationNo)).IncludeAllDerived()
            .ForMember(dest => dest.VrnDesc, opt => opt.MapFrom(src => src.Variation.Description)).IncludeAllDerived()
            .ForMember(dest => dest.InstructionDescHtml, opt => opt.MapFrom(src => src.Instruction.DescriptionHtml)).IncludeAllDerived();
        CreateMap<VariationLot, VariationLotReportDto>()
            .ForMember(dest => dest.VarNo, opt => opt.MapFrom(src => src.Variation.Description)).IncludeAllDerived()
            .ForMember(dest => dest.VarDesc, opt => opt.MapFrom(src => src.Variation.VariationNo)).IncludeAllDerived()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.LotDesc, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived();
        CreateMap<VariationSchedule, VariationScheduleDto>()
            .ForMember(dest => dest.ScheduleDesc, opt => opt.MapFrom(src => src.ScheduleItem == null ? "" : string.IsNullOrEmpty(src.ScheduleItem.ScheduleNumber) ? src.ScheduleItem.Description : src.ScheduleItem.ScheduleNumber + ": " + src.ScheduleItem.Description))
            .ForMember(dest => dest.VariationDesc, opt => opt.MapFrom(src => src.Variation == null ? "" : src.Variation.VariationNo + ": " + src.Variation.Description));
        CreateMap<VrnStatus, VrnStatusDto>();
        CreateMap<VariationEstimate, VariationEstimateDto>();
        CreateMap<VrnWaypoint, VrnWaypointDto>()
            .ForMember(dest => dest.StatusName, opt => opt.MapFrom(src => src.VrnStatus.Description));

        CreateMap<Workflow, WorkflowDto>()
            .Ignore(x => x.WorkflowActions)
            .Ignore(x => x.WorkflowSteps)
            .Ignore(x => x.WorkflowLogs);
        CreateMap<WorkflowAction, WorkflowActionDto>().Ignore(x => x.WorkflowActionPoints).Ignore(x => x.WorkflowActionRoles)
                .Ignore(x => x.WorkflowActionUsers);
        CreateMap<WorkflowAction, WorkflowUpdateActionDto>();
        CreateMap<WorkflowAction, WorkflowActionWithToStepDto>();
        CreateMap<WorkflowStep, WorkflowStepDto>();
        CreateMap<WorkflowStep, WorkflowUpdateStepDto>();
        CreateMap<WorkflowActionPoint, WorkflowActionPointDto>();
        CreateMap<WorkflowActionUser, WorkflowActionUserDto>()
            .ForMember(dest => dest.UserGuid, opt => opt.MapFrom(src => src.User.UniqueId)).IncludeAllDerived();
        CreateMap<WorkflowActionRole, WorkflowActionRoleDto>()
                .ForMember(dest => dest.RoleName, opt => opt.MapFrom(src => src.Role.RoleName)).IncludeAllDerived();
        CreateMap<WorkflowLog, WorkflowLogListDto>()
                .ForMember(dest => dest.LogByName, opt => opt.MapFrom(src => src.User == null ? "" : src.User.FirstName + " " + src.User.LastName)).IncludeAllDerived()
                .ForMember(dest => dest.StatusBefore, opt => opt.MapFrom(src => src.WorkflowAction.StepFrom.Text)).IncludeAllDerived()
                .ForMember(dest => dest.StatusAfter, opt => opt.MapFrom(src => src.WorkflowStep.Text)).IncludeAllDerived()
                .ForMember(dest => dest.ActionName, opt => opt.MapFrom(src => src.WorkflowAction.Text)).IncludeAllDerived();
        CreateMap<WorkflowLog, WorkflowLogDto>();
        CreateMap<WorkflowLog, WorkflowLogTemplateDto>();
        CreateMap<WorkType, WorkTypeDto>()
            .ForMember(dest => dest.HasScheduleLink, opt => opt.MapFrom(src => src.WorkSchedules.Count > 0));
        CreateMap<WorkSchedule, WorkScheduleDto>()
            .ForMember(dest => dest.WorkTypeName, opt => opt.MapFrom(src => src.WorkType.WorkTypeName)).IncludeAllDerived()
            .ForMember(dest => dest.WorkTypeDescription, opt => opt.MapFrom(src => src.WorkType.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleNo, opt => opt.MapFrom(src => src.ScheduleItem.ScheduleNumber)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleDesc, opt => opt.MapFrom(src => src.ScheduleItem.Description)).IncludeAllDerived();

        //Lookup
        CreateMap<Approval, ApprovalLookupDto>();
        CreateMap<ApprovalWorkflow, ApprovalWorkflowLookupDto>(); CreateMap<Atp, AtpLookupDto>();
        CreateMap<ContractNoticeTemplate, CnTemplateLookupDto>();
        CreateMap<ControlLine, ControlLineLookupDto>();
        CreateMap<CostCode, CostCodeLookupDto>();
        CreateMap<FileStoreDoc, FileStoreDocLookupDto>();
        CreateMap<Itp, ItpLookupDto>();
        CreateMap<Lot, LotLookupDto>();
        CreateMap<Ncr, NcrLookupDto>();
        CreateMap<Project, ProjectLookupDto>();
        CreateMap<Supplier, SupplierLookupDto>();
        CreateMap<TemplateType, TemplateTypeLookupDto>()
            .ForMember(dest => dest.Description, opt => opt.MapFrom(src => src.TypeName)).IncludeAllDerived();
        CreateMap<Template, TemplateLookupDto>();
        CreateMap<TestMethod, TestMethodLookupDto>();
        CreateMap<TestPropertyGroup, TestPropertyGroupLookupDto>();
        CreateMap<TestRequest, TestRequestLookupDto>();
        CreateMap<Unit, UnitLookupDto>();
        CreateMap<Variation, VrnLookupDto>();
        CreateMap<WorkflowAction, WorkflowActionLookupDto>();
        CreateMap<WorkflowStep, WorkflowStepLookupDto>();
        CreateMap<WorkType, WorktypeLookupDto>();


        //Report
        CreateMap<Approval, ApprovalListReportDto>();
        CreateMap<Approval, ApprovalReportDto>();
        CreateMap<Approval, ApprovalLotItpDetailReportDto>()
            .ForMember(dest => dest.LotItpDetailId, opt => opt.MapFrom(src => src.LotItpDetailLinkId)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.ApprovalNo)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.SubjectHtml)).IncludeAllDerived()
            .ForMember(dest => dest.RequestDate, opt => opt.MapFrom(src => src.RequestDate)).IncludeAllDerived()
            .ForMember(dest => dest.DateLastStep, opt => opt.MapFrom(src => src.DateLastStep)).IncludeAllDerived()
            .ForMember(dest => dest.Status, opt => opt.MapFrom(src => src.Status)).IncludeAllDerived()
            .ForMember(dest => dest.IsCompleted, opt => opt.MapFrom(src => src.IsCompleted)).IncludeAllDerived();
        CreateMap<ApprovalLotItpDetail, ApprovalLotItpDetailReportDto>()
            .ForMember(dest => dest.ApprovalNo, opt => opt.MapFrom(src => src.Approval.ApprovalNo)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovalSubjectHtml, opt => opt.MapFrom(src => src.Approval.SubjectHtml)).IncludeAllDerived()
            .ForMember(dest => dest.RequestDate, opt => opt.MapFrom(src => src.Approval.RequestDate)).IncludeAllDerived()
            .ForMember(dest => dest.DateLastStep, opt => opt.MapFrom(src => src.Approval.DateLastStep)).IncludeAllDerived()
            .ForMember(dest => dest.Status, opt => opt.MapFrom(src => src.Approval.Status)).IncludeAllDerived()
            .ForMember(dest => dest.IsCompleted, opt => opt.MapFrom(src => src.Approval.IsCompleted)).IncludeAllDerived();
        CreateMap<Atp, AtpReportDto>()
            .ForMember(dest => dest.RequestedByName, opt => opt.MapFrom(src => src.RequestedBy == null ? "" : src.RequestedBy.FirstName + " " + src.RequestedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.SentToName, opt => opt.MapFrom(src => src.SentTo == null ? "" : src.SentTo.FirstName + " " + src.SentTo.LastName)).IncludeAllDerived();
        CreateMap<AtpLot, AtpLotReportDto>()
            .ForMember(dest => dest.ApprovedByName, opt => opt.MapFrom(src => src.ApprovalByUser == null ? "" : src.ApprovalByUser.FirstName + " " + src.ApprovalByUser.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.AtpNo, opt => opt.MapFrom(src => src.Atp == null ? null : src.Atp.AtpNo)).IncludeAllDerived()
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived();
        CreateMap<AtpLot, AtpLotForConfReportDto>()
            .ForMember(dest => dest.AtpNo, opt => opt.MapFrom(src => src.Atp == null ? null : src.Atp.AtpNo)).IncludeAllDerived()
            .ForMember(dest => dest.ATPDate, opt => opt.MapFrom(src => src.Atp == null ? null : src.Atp.Datesub)).IncludeAllDerived()
            .ForMember(dest => dest.AtpDescription, opt => opt.MapFrom(src => src.Atp == null ? null : src.Atp.Description)).IncludeAllDerived();
        CreateMap<ApprovalLotItpDetail, LotItpDetailApprovalReportDto>();
        CreateMap<Itp, ItpReportDto>();
        CreateMap<ItpDetail, ItpDetailReportDto>();
        CreateMap<ItpTesting, ItpTestReportDto>();

        CreateMap<Lot, LotBasicReportDto>()
            .ForMember(dest => dest.RpValue, opt => opt.MapFrom(src => src.LotQuantities.Sum(x => Math.Round((1 - x.ReducedPayment ?? 1) * ((x.NonClaimable ?? false) ? 0 : 1) * x.Qty ?? 0 * x.ScheduleItem.SellRate ?? 0, 2)))).IncludeAllDerived();
        CreateMap<Approval, LotConfApprovalReportDto>();
        CreateMap<Lot, LotDatesReportDto>();
        CreateMap<Lot, LotReportDto>()
            .ForMember(dest => dest.WorkTypeName, opt => opt.MapFrom(src => src.WorkType == null ? "" : src.WorkType.WorkTypeName)).IncludeAllDerived()
            .ForMember(dest => dest.AreaCodeName, opt => opt.MapFrom(src => src.AreaCode == null ? "" : src.AreaCode.AreaCodeName)).IncludeAllDerived()
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom(src => src.RaisedBy == null ? "" : src.RaisedBy.FirstName + " " + src.RaisedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ConformedByName, opt => opt.MapFrom(src => src.ConformedBy == null ? "" : src.ConformedBy.FirstName + " " + src.ConformedBy.LastName)).IncludeAllDerived();
        CreateMap<Lot, LotSummaryReportDto>()
            .ForMember(dest => dest.NCRClosedCount, opt => opt.MapFrom(src => src.NcrLots.Where(x => x.Ncr.CloseOutDate != null).Count())).IncludeAllDerived()
            .ForMember(dest => dest.NCRAppCount, opt => opt.MapFrom(src => src.NcrLots.Where(x => x.Ncr.CloseOutDate == null && x.Ncr.ApprovalDate != null).Count())).IncludeAllDerived()
            .ForMember(dest => dest.NCRUnAppCount, opt => opt.MapFrom(src => src.NcrLots.Where(x => x.Ncr.CloseOutDate == null && x.Ncr.ApprovalDate == null).Count())).IncludeAllDerived()
            .ForMember(dest => dest.ATPInspCount, opt => opt.MapFrom(src => src.AtpLots.Count())).IncludeAllDerived()
            .ForMember(dest => dest.ATPInspUnAppCount, opt => opt.MapFrom(src => src.AtpLots.Where(x => x.DateApproved == null).Count())).IncludeAllDerived()
            .ForMember(dest => dest.QtyCount, opt => opt.MapFrom(src => src.LotQuantities.Count())).IncludeAllDerived()
            .ForMember(dest => dest.ZeroQtyCount, opt => opt.MapFrom(src => src.LotQuantities.Where(x => x.Qty == 0).Count())).IncludeAllDerived()
            .ForMember(dest => dest.TRCount, opt => opt.MapFrom(src => src.TestRequests.Count())).IncludeAllDerived()
            .ForMember(dest => dest.TRIncompleteCount, opt => opt.MapFrom(src => src.TestRequests.Where(x => x.DateTestCompleted == null).Count())).IncludeAllDerived();
        CreateMap<LotItp, ChecklistReportDto>()
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom(src => src.RaisedBy == null ? "" : src.RaisedBy.FirstName + " " + src.RaisedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ApprovedByName, opt => opt.MapFrom(src => src.ApprovedBy == null ? "" : src.ApprovedBy.FirstName + " " + src.ApprovedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.ITPName, opt => opt.MapFrom(src => src.Itp == null ? "" : src.Itp.Description)).IncludeAllDerived();
        CreateMap<LotItp, LotItpReportDto>()
            .ForMember(dest => dest.DateWorkStarted, opt => opt.MapFrom(src => src.Lot.DateWorkSt)).IncludeAllDerived()
            .ForMember(dest => dest.DateLotOpened, opt => opt.MapFrom(src => src.Lot.DateOpen)).IncludeAllDerived()
            .ForMember(dest => dest.DateWorkEnded, opt => opt.MapFrom(src => src.Lot.DateWorkEnd)).IncludeAllDerived();
        CreateMap<LotItp, LotItpStatusReportDto>();
        CreateMap<LotItpDetail, LotItpDetailReportDto>()
            .ForMember(dest => dest.LotNoDesc_ApprovalManual, opt => opt.MapFrom(src => src.ApprovalLot == null ? "" : src.ApprovalLot.LotNumber + ": " + src.ApprovalLot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.AtpNo, opt => opt.MapFrom(src => src.ApprovalAtp.AtpNo)).IncludeAllDerived()
            .ForMember(dest => dest.AtpDesc, opt => opt.MapFrom(src => src.ApprovalAtp.Description)).IncludeAllDerived();
        CreateMap<LotItpDetail, LotItpDetailStatusReportDto>();
        CreateMap<LotItpTest, LotItpTestReportDto>();
        CreateMap<LotQuantity, LotQuantityReportDto>()
            .ForMember(dest => dest.ScheduleOrderId, opt => opt.MapFrom(src => src.ScheduleItem == null ? 0 : src.ScheduleItem.OrderId)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleNo, opt => opt.MapFrom(src => src.ScheduleItem.ScheduleNumber)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleDescription, opt => opt.MapFrom(src => src.ScheduleItem.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleSellRate, opt => opt.MapFrom(src => src.ScheduleItem.SellRate)).IncludeAllDerived()
            .ForMember(dest => dest.EffectivePercComp, opt => opt.MapFrom(src => src.Lot == null ? src.PercComp :
                (src.Lot.DateConf != null || src.Lot.DateGuar != null) ? 1 :
                ((src.PercComp.HasValue && src.PercComp.Value < 1) ? src.PercComp ?? 0 : src.Lot.PercentComplete ?? 0))).IncludeAllDerived()
            .ForMember(dest => dest.LotNumber, opt => opt.MapFrom(src => src.Lot.LotNumber)).IncludeAllDerived()
            .ForMember(dest => dest.LotDescription, opt => opt.MapFrom(src => src.Lot.Description)).IncludeAllDerived()
            .ForMember(dest => dest.DateOpen, opt => opt.MapFrom(src => src.Lot.DateOpen)).IncludeAllDerived()
            .ForMember(dest => dest.DateGuar, opt => opt.MapFrom(src => src.Lot.DateGuar)).IncludeAllDerived()
            .ForMember(dest => dest.DateConf, opt => opt.MapFrom(src => src.Lot.DateConf)).IncludeAllDerived()
            .ForMember(dest => dest.DateRejected, opt => opt.MapFrom(src => src.Lot.DateRejected)).IncludeAllDerived();


        CreateMap<PhotoLot, PhotoLotReportDto>();

        CreateMap<Ncr, NcrRegisterReportDto>();
        CreateMap<Ncr, NcrDateReportDto>();
        CreateMap<Ncr, NcrReportDto>();
        CreateMap<NcrLot, NcrLotReportDto>();
        CreateMap<Photo, PhotoReportDto>();
        CreateMap<ProgressClaimDetail, ProgressClaimDetailReportDto>();
        CreateMap<ProgressClaimDetailReportDto, ProgressClaimDetailReportDto>();//For clone
        CreateMap<ProgressClaimSnapshot, ProgressClaimSnapshotReportDto>();
        CreateMap<ProgressClaimVersion, ProgressClaimVersionReportDto>()
            .ForMember(dest => dest.ProjectName, opt => opt.MapFrom(src => src.Project.Description)).IncludeAllDerived()
            .ForMember(dest => dest.ProjectNumber, opt => opt.MapFrom(src => src.Project.ContractNumber)).IncludeAllDerived();
        CreateMap<PurchaseOrder, PurchaseOrderDto>()
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom(src => src.RaisedBy == null ? "" : src.RaisedBy.FirstName + " " + src.RaisedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.SupplierName, opt => opt.MapFrom(src => src.Supplier.SupplierName)).IncludeAllDerived()
            .ForMember(dest => dest.TotalReceipted, opt => opt.MapFrom(src => src.PurchaseOrderDetails.Count == 0 ? 0m : src.PurchaseOrderDetails.Sum(x => Math.Round(x.ReceiptDetails.Sum(y => y.Qty ?? 0) * (x.Rate ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.TotalDaycost, opt => opt.MapFrom(src => src.Receipts.Count == 0 ? 0m : src.Receipts.Sum(r => r.DayCosts.Sum(x => Math.Round((x.Qty ?? 0) * (x.Rate ?? 0), 2))))).IncludeAllDerived()
            .ForMember(dest => dest.TotalInvoiced, opt => opt.MapFrom(src => src.Invoices.Count == 0 ? 0m : Math.Round(src.Invoices.Sum(x => x.Amount ?? 0), 2))).IncludeAllDerived()
            .ForMember(dest => dest.PoValue, opt => opt.MapFrom(src => (src.PurchaseOrderDetails.Count == 0) ? 0m : src.PurchaseOrderDetails.Sum(x => Math.Round((x.Qty ?? 0) * (x.Rate ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.PoValueDisplay, opt => opt.MapFrom(src => src.PurchaseOrderDetails.Where(x => !(x.IsRateOnly ?? false)).Count() == 0 ? 0m :
                src.PurchaseOrderDetails.Where(x => !(x.IsRateOnly ?? false)).Sum(x => Math.Round((x.Qty ?? 0) * (x.Rate ?? 0), 2)))).IncludeAllDerived()
            .ForMember(dest => dest.ApprovedByName, opt => opt.MapFrom(src => src.ApprovedBy == null ? "" : src.ApprovedBy.FirstName + " " + src.ApprovedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.PoContactName, opt => opt.MapFrom(src => src.PoContact == null ? "" : src.PoContact.FirstName + " " + src.PoContact.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.Status, opt => opt.MapFrom(src =>
                src.ApprovedDate != null ? "Approved" :
                src.Approval == null ? "Not requested" :
                src.Approval.CloseOutDate != null ? "Closed Out (Approval)" :
                src.Approval.StatusLastStep ?? "Not started"
                )).IncludeAllDerived();
        CreateMap<PurchaseOrder, PurchaseOrderReportDto>();
        CreateMap<PurchaseOrder, PurchaseOrderWithDetailReportDto>();
        CreateMap<PurchaseOrder, PurchaseOrderReceiptReportDto>();
        CreateMap<ScheduleItem, ScheduleFlatReportDto>();
        CreateMap<ScheduleFlatDto, ScheduleFlatDto>();//For clone
        CreateMap<ScheduleFlatReportDto, ScheduleFlatReportDto>();//For clone
        CreateMap<SchedCostCode, SchedCostCodeDto>()
            .ForMember(dest => dest.CostCodeName, opt => opt.MapFrom(src => src.CostCode.CostCodeName)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleNo, opt => opt.MapFrom(src => src.ScheduleItem.ScheduleNumber)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleDescription, opt => opt.MapFrom(src => src.ScheduleItem.Description)).IncludeAllDerived()
            .ForMember(dest => dest.CostCodeDescription, opt => opt.MapFrom(src => src.CostCode.Description)).IncludeAllDerived();
        CreateMap<TestRequestTest, TestRequestTestReportDto>()
            .ForMember(dest => dest.LotId, opt => opt.MapFrom(src => src.TestRequest.LotId)).IncludeAllDerived()
            .ForMember(dest => dest.TestRequestNo, opt => opt.MapFrom(src => src.TestRequest.TestRequestNo)).IncludeAllDerived()
            .ForMember(dest => dest.TestMethodNum, opt => opt.MapFrom(src => src.TestMethod.TestNum)).IncludeAllDerived()
            .ForMember(dest => dest.ScheduleNo, opt => opt.MapFrom(src => src.ScheduleItem.ScheduleNumber)).IncludeAllDerived()
            .ForMember(dest => dest.TestMethodDesc, opt => opt.MapFrom(src => src.TestMethod.TestDescription)).IncludeAllDerived()
            .ForMember(dest => dest.TestRequestNo, opt => opt.MapFrom(src => src.TestRequest.TestRequestNo)).IncludeAllDerived()
            ;

        CreateMap<TestMethod, TestMethodReportDto>();
        CreateMap<TestRequest, TestRequestDatesReportDto>();
        CreateMap<TestRequest, TestRequestReportDto>()
            .ForMember(dest => dest.ControlLineDescription, opt => opt.MapFrom(src => src.ControlLine.Description)).IncludeAllDerived();
        CreateMap<TestResult, TestResultReportDto>()
            .ForMember(dest => dest.TestReqId, opt => opt.MapFrom(src => src.TestRequestTest.TestRequest.TestRequestId)).IncludeAllDerived()
            .ForMember(dest => dest.SampleName, opt => opt.MapFrom(src => src.TestRequestTest.SampleId)).IncludeAllDerived()
            .ForMember(dest => dest.OrderId, opt => opt.MapFrom(src => src.TestResultField.OrderId)).IncludeAllDerived()
            .ForMember(dest => dest.ResultFieldName, opt => opt.MapFrom(src => src.TestResultField.ResultFieldName)).IncludeAllDerived()
            .ForMember(dest => dest.ResultUnit, opt => opt.MapFrom(src => src.TestResultField.ResultUnit)).IncludeAllDerived()
            .ForMember(dest => dest.TestMethod, opt => opt.MapFrom(src => src.TestRequestTest.TestMethod.TestNum)).IncludeAllDerived()
            .ForMember(dest => dest.TestMethodDescription, opt => opt.MapFrom(src => src.TestRequestTest.TestMethod.TestDescription)).IncludeAllDerived();

        CreateMap<VariationEstimate, VariationEstimateReportDto>();
        CreateMap<PhotoVariation, PhotoVariationReportDto>();
        CreateMap<VrnWaypoint, VrnWaypointReportDto>();
        CreateMap<Variation, VariationReportDto>()
            .ForMember(dest => dest.RaisedByName, opt => opt.MapFrom(src => src.RaisedBy == null ? "" : src.RaisedBy.FirstName + " " + src.RaisedBy.LastName)).IncludeAllDerived()
            .ForMember(dest => dest.CurrentStatusId, opt => opt.MapFrom(src => src.VrnWaypoints.OrderByDescending(x => x.WaypointDate).Select(x => x.VrnStatusId).FirstOrDefault())).IncludeAllDerived()
            .ForMember(dest => dest.CurrentStatusDate, opt => opt.MapFrom(src => src.VrnWaypoints.OrderByDescending(x => x.WaypointDate).Select(x => x.WaypointDate).FirstOrDefault())).IncludeAllDerived()
            .ForMember(dest => dest.HasBuildup, opt => opt.MapFrom(src => src.VariationEstimates.Count > 0)).IncludeAllDerived()
            ;

        //Reverse
        CreateMap<ApprovalToDto, ApprovalTo>();
        CreateMap<ApprovalCcDto, ApprovalCc>();
        CreateMap<ApprovalWorkflowUpdaterDto, ApprovalWorkflow>();
        CreateMap<AtpLotListDto, AtpLot>();
        CreateMap<ContactDto, User>();
        CreateMap<ContractNoticeDto, ContractNotice>();
        CreateMap<CnApprovalDto, CnApproval>();
        CreateMap<CnControlledDocDto, CnControlledDoc>();
        CreateMap<CnIncidentDto, CnIncident>();
        CreateMap<CnItpDto, CnItp>();
        CreateMap<CnLotDto, CnLot>();
        CreateMap<CnNoticeDto, CnNotice>();
        CreateMap<CnPhotoDto, CnPhoto>();
        CreateMap<CnVariationDto, CnVariation>();
        CreateMap<CostCodeDto, CostCode>();
        CreateMap<CostCodeCustomRegItemDto, CostCodeCustomRegItem>();
        CreateMap<CustomRegisterDto, CustomRegister>();
        CreateMap<CustomRegisterItemDto, CustomRegisterItem>();
        CreateMap<FileStoreDocDto, FileStoreDoc>();
        CreateMap<FsApprovalDto, FsApproval>();
        CreateMap<FsNoticeDto, FsNotice>();
        CreateMap<InstructionDto, Instruction>();
        CreateMap<ItpDto, Itp>();
        CreateMap<ItpDetailDto, ItpDetail>();
        CreateMap<ItpTestingDto, ItpTesting>();
        CreateMap<LotDto, Lot>();
        CreateMap<LotInstructionDto, LotInstruction>();
        CreateMap<LotItpDto, LotItp>();
        CreateMap<LotItpDetailDto, LotItpDetail>()
            .Ignore(x => x.Approval).IncludeAllDerived();
        CreateMap<LotItpTestDto, LotItpTest>();
        CreateMap<LotShortListDto, Lot>();
        CreateMap<LotRelationDto, LotRelation>();
        CreateMap<LotTagDto, LotTag>();
        CreateMap<PhotoDto, Photo>();
        CreateMap<NcrDto, Ncr>()
            .Ignore(x => x.Approval).IncludeAllDerived();
        CreateMap<PurchaseOrderDto, PurchaseOrder>()
            .Ignore(x => x.Approval).IncludeAllDerived();
        CreateMap<PurchaseOrderDetailDto, PurchaseOrderDetail>();
        CreateMap<TagCodeDto, TagCode>();
        CreateMap<TemplateDto, Template>();
        CreateMap<TestRequestDto, TestRequest>();
        CreateMap<TestRequestTestDto, TestRequestTest>();
        CreateMap<TestRequestPropertyDto, TestRequestProperty>();
        CreateMap<UnitDto, Unit>();
        CreateMap<VariationDto, Variation>();
        CreateMap<VariationLotDto, VariationLot>();
        CreateMap<WorkflowStepDto, WorkflowStep>();
        CreateMap<WorkflowActionDto, WorkflowAction>().Ignore(x => x.WorkflowActionPoints).Ignore(x => x.WorkflowActionRoles)
            .Ignore(x => x.WorkflowActionUsers);
        CreateMap<WorkflowActionPointDto, WorkflowActionPoint>();
        CreateMap<WorkflowActionRoleDto, WorkflowActionRole>();
        CreateMap<WorkflowActionUserDto, WorkflowActionUser>();

        //Cloners
        CreateMap<Itp, ItpCloneDto>();
        CreateMap<ItpDetail, ItpDetailCloneDto>();
        CreateMap<ItpTesting, ItpTestingCloneDto>()
            .ForMember(dest => dest.TestNum, opt => opt.MapFrom(src => src.TestMethod.TestNum));
        CreateMap<User, UserCloneDto>();
        CreateMap<ContactDto, UserCloneDto>();
        CreateMap<ScheduleItem, ScheduleItemCloneDto>();
        CreateMap<ItpCloneDto, Itp>().Ignore(x => x.ItpId);
        CreateMap<ItpDetailCloneDto, ItpDetail>().Ignore(x => x.ItpDetailId);
        CreateMap<ItpTestingCloneDto, ItpTesting>().Ignore(x => x.ItpTestId);
        CreateMap<ScheduleItemCloneDto, ScheduleItem>().Ignore(x => x.ScheduleId);
        CreateMap<UserCloneDto, User>().Ignore(x => x.UserId);
    }
}

[jbogard]

I'm not sure this is too complex - it's pretty close to what I see in production. In terms of expression tree compilation, yeah in the past it was CPU intensive. We cached it because it was slow to compile multiple times, but obviously there's a tradeoff. We defer that compilation for the first time you map, though.

With ProjectTo, there is no expression compilation, so you do save something there. I try to default to ProjectTo anyway because it's more efficient all around.

[statler]

Thanks for your comments on this. I am trying to understand where the work is happening here. Does your comment mean that

1. if I only ever map through projection - e.g. ProjectTo, then the expression tree compilation will never happen? E.g. this memory hit is never experienced?
2. If (1) is correct, then is it also true that using a non-Projection mapping will result in the entire config expression tree being compiled whether or not the mapping is only used for ProjectTo or not?
3. Is there a way to prevent the compilation of the entire config?

Ideally, if (1) is true, I will simply prevent any direct mapping, and this should mean I don't end up with the expression tree compilation at all. Nearly my entire application is Projections and I do very little direct mapping. This will improve my memory footprint after first map which is currently causing me some grief (death of a million cuts - EF, AM and model size)

Sorry my questions may be a little uninformed, I known my way around expressions and linq well, but I have difficulty understanding what happens where and when in the AM code base :)

[jbogard]

1. is correct. We compile the first time you call Map. We do create the expression tree it's just not compiled. This expression tree is actually different than the one for LINQ, which is not compiled (by AutoMapper).

2. is kinda correct. We only compile the single expression used in the map.

3. yes, never call Map 😜

[statler]

3. Lol

Oh - so its the creation of the Expression Tree which takes all the resources then? Not its compilation? And it would be the Expression Tree which is consuming memory rather that the compilation?

If I am only using ProjectTo, does the expression tree of the entire config need to be created? It is the memory associated with this that seems to be causing some grief. It may not be the AM ops, but the corresponding Linq caching as a result of the AM, but it would be great to be able to limit the hit to just the actual resources required, rather than the whole config - any options here?

[jbogard]

No my assumption is the compilation, but a memory profiler would tell you exactly what it is.