コード例 #1
0
        public HttpResponseMessage Delete([FromBody] RequestAllocation request)
        {
            var users      = request.Users;
            var clients    = request.Clients;
            var actionUser = request.ActionUser;

            DeleteAllocation(users, clients, actionUser);
            return(Request.CreateResponse(HttpStatusCode.NoContent));
        }
コード例 #2
0
        public HttpResponseMessage GetToReallocateUsers([FromBody] RequestAllocation request)
        {
            var clients = request.ReallocatedClients;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                var userClients = (from user in context.Users
                                   join
                                   uType in context.userType on user.UserTypeID equals uType.UserTypeID
                                   join
                                   clUser in context.userClient on user.UserID equals clUser.UserID

                                   into gCUsers
                                   from clUser in gCUsers.DefaultIfEmpty()
                                   where uType.UserTypeName != "External users"
                                   select new
                {
                    userID = user.UserID,
                    userName = user.UserName,
                    clientID = clUser.ClientID == null ? 0 : clUser.ClientID
                }).ToList();

                var toReallocationUser = userClients.GroupBy(x => x.userID)
                                         .Where(g => !g.Any(gi => clients.Contains(gi.clientID)))
                                         .Select(x => new {
                    userId   = x.Key,
                    userName = x.First().userName
                }).OrderBy(x => x.userName);



                var response = new
                {
                    data = toReallocationUser
                };

                return(Request.CreateResponse(HttpStatusCode.OK, response));
            }
        }
コード例 #3
0
        public HttpResponseMessage GetToReallocateClients([FromBody] RequestAllocation request)
        {
            var users = request.ReallocatedUsers;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                var clientUsers = (from client in context.Clients
                                   join
                                   clUser in context.userClient on client.Id equals clUser.ClientID
                                   into gCUsers

                                   from clUser in gCUsers.DefaultIfEmpty()
                                   where clUser.user.userType.UserTypeName != "External users"

                                   select new
                {
                    clientId = client.Id,
                    clientName = client.Name,
                    userID = clUser.UserID == null ? 0 : clUser.UserID
                }).ToList();

                var toReallocationClient = clientUsers.GroupBy(x => x.clientId)
                                           .Where(g => !g.Any(gi => users.Contains(gi.userID)))
                                           .Select(x => new {
                    clientId   = x.Key,
                    clientName = x.First().clientName
                }).OrderBy(x => x.clientName);



                var response = new
                {
                    data = toReallocationClient
                };

                return(Request.CreateResponse(HttpStatusCode.OK, response));
            }
        }
コード例 #4
0
 public HttpResponseMessage Reallocate([FromBody] RequestAllocation request)
 {
     DeleteAllocation(request.Users, request.Clients, request.ActionUser);
     Allocate(request.ReallocatedUsers, request.ReallocatedClients, request.ActionUser);
     return(Request.CreateResponse(HttpStatusCode.Created));
 }
コード例 #5
0
 public void CreateAllocation(RequestAllocation requestAllocStr)
 {
     _context.RequestAllocation.Add(requestAllocStr);
     _context.SaveChanges();
 }