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));
}
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));
}
}
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));
}
}
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));
}
public void CreateAllocation(RequestAllocation requestAllocStr)
{
_context.RequestAllocation.Add(requestAllocStr);
_context.SaveChanges();
}