Esempio n. 1
0
        public async Task <IEnumerable <KeyValuePair <string, IEnumerable <FlowLineCond> > > > HandleRequestAsync(WorkFlowDto request)
        {
            var query = from a in flowLines
                        join b in flowLineConds on a.Id equals b.FlowLink_Id
                        where a.WorkFlow_Id == request.Id
                        select b;

            var list = await query.ToListAsync();

            return(list.GroupBy(v => v.FlowLink_Id).Select(v => new KeyValuePair <string, IEnumerable <FlowLineCond> >(v.Key, v)));
        }
Esempio n. 2
0
        public async Task <IEnumerable <KeyValuePair <string, IEnumerable <RoleViewModel> > > > HandleRequestAsync(WorkFlowDto request)
        {
            var roleViews = roles.MapTo <Role, RoleViewModel>();
            var query     = from a in flowNodes
                            join b in flowNodeRoles on a.Id equals b.FlowNode_Id
                            join c in roleViews on b.Role_Id equals c.Id
                            where a.WorkFlow_Id == request.Id
                            select new
            {
                b.FlowNode_Id,
                Role = c
            };

            var list = await query.ToListAsync();

            return(list.GroupBy(v => v.FlowNode_Id).Select(v => new KeyValuePair <string, IEnumerable <RoleViewModel> >(v.Key, v.Select(r => r.Role))));
        }
Esempio n. 3
0
        public async Task <IEnumerable <KeyValuePair <string, IEnumerable <UserViewModel> > > > HandleRequestAsync(WorkFlowDto request)
        {
            var userViewModels = users.MapTo <User, UserViewModel>();
            var query          = from a in flowNodes
                                 join b in flowNodeUsers on a.Id equals b.FlowNode_Id
                                 join c in userViewModels on b.User_Id equals c.Id
                                 where a.WorkFlow_Id == request.Id
                                 select new
            {
                b.FlowNode_Id,
                User = c
            };

            var list = await query.ToListAsync();

            return(list.GroupBy(v => v.FlowNode_Id).Select(v => new KeyValuePair <string, IEnumerable <UserViewModel> >(v.Key, v.Select(r => r.User))));
        }