Beispiel #1
0
        public IQueryable <ProcessSequenceLineIndexViewModel> GetProcessSequenceLineListForProductCollectionIndex(int ProductCollectionId)
        {
            int RefDocTypeId = new DocumentTypeService(_unitOfWork).Find(MasterDocTypeConstants.ProductCollection).DocumentTypeId;

            var temp = from L in db.ProcessSequenceLine
                       join P in db.Process on L.ProcessId equals P.ProcessId into ProcessTable
                       from ProcessTab in ProcessTable.DefaultIfEmpty()
                       join t in db.ProcessSequenceHeader on L.ProcessSequenceHeaderId equals t.ProcessSequenceHeaderId
                       where t.ReferenceDocId == ProductCollectionId && t.ReferenceDocTypeId == RefDocTypeId
                       orderby L.Sequence
                       select new ProcessSequenceLineIndexViewModel
            {
                ProcessSequenceHeaderId = L.ProcessSequenceHeaderId,
                ProcessSequenceLineId   = L.ProcessSequenceLineId,
                ProcessId    = L.ProcessId,
                ProcessName  = ProcessTab.ProcessName,
                Sequence     = L.Sequence,
                Days         = L.Days,
                CreatedBy    = L.CreatedBy,
                CreatedDate  = L.CreatedDate,
                ModifiedBy   = L.ModifiedBy,
                ModifiedDate = L.ModifiedDate,
            };

            return(temp);
        }
Beispiel #2
0
        public ProcessSequenceHeader GetProcessSequenceHeaderForProductCollection(int id)
        {
            int RefDocTypeId = new DocumentTypeService(_unitOfWork).Find(MasterDocTypeConstants.ProductCollection).DocumentTypeId;

            var temp = (from p in db.ProcessSequenceHeader
                        where p.ReferenceDocId == id && p.ReferenceDocTypeId == RefDocTypeId
                        select p).FirstOrDefault();

            if (temp != null)
            {
                return(temp);
            }
            else
            {
                ProcessSequenceHeader Header = new ProcessSequenceHeader();
                Header.ReferenceDocTypeId = RefDocTypeId;
                return(Header);
            }
        }