public IActionResult GetAll()
{
try
{
var TokenDetails = User.Claims.GetTokenDetails();
if (string.IsNullOrEmpty(TokenDetails.Role) || string.IsNullOrEmpty(TokenDetails.Username))
{
Response.StatusCode = (int)HttpStatusCode.Unauthorized;
return(Json(string.Empty));
}
var managerTokenUser = _userService.GetByUsername(TokenDetails.Username);
if (TokenDetails.Role.ToLower() == "ec")
{
var enterprise = _enterpriseClientService.GetById(managerTokenUser.EnterpriseId.Value);
var subscriptionsList = _subscriptionService.GetByEnterpriseId(enterprise.Id);
var partner = _partnerService.GetById(enterprise.PartnerId);
var query = from subscription in subscriptionsList
select new
{
Id = subscription.Id,
Name = subscription.Name,
EnterpriseClientId = subscription.EnterpriseClientId,
Product = subscription.Product,
ProductName = _productService.GetByWId(subscription.Product).Name,
LicencingEnvironment = subscription.LicencingEnvironment,
LicencingEnvironmentName = _licenceEnvironmentService.GetBymanagerId(subscription.LicencingEnvironment).Name,
BrandId = subscription.BrandId,
Campaign = subscription.Campaign,
SeatCount = subscription.SeatCount,
CoreAuthUsername = subscription.CoreAuthUsername,
RegAuthUsername = subscription.RegAuthUsername,
Status = subscription.Status,
LicenceKey = subscription.LicenceKey,
ClientDownloadLocation = subscription.ClientDownloadLocation,
Partner = new { id = partner.Id, name = partner.Name },
Enterprise = new { id = enterprise.Id, name = enterprise.Name },
CreationTime = subscription.CreationTime,
CancelationTime = subscription.CancelationTime
};
return(Json(new
{
c = ResultCode.Success,
d = new { subscriptions = query, partners = partner, ec = enterprise }
}));
}
else if (TokenDetails.Role.ToLower() == "partner")
{
var partner = _partnerService.GetById(managerTokenUser.PartnerId.Value);
var enterpriseClientsList = _enterpriseClientService.GetByPartnerId(partner.Id);
var subscriptions = _subscriptionService.GetAll();
var subscriptionsList = from ec in enterpriseClientsList
join sub in subscriptions
on ec.Id equals sub.EnterpriseClientId
select new
{
sub.Id,
sub.Name,
sub.EnterpriseClientId,
sub.Product,
sub.LicencingEnvironment,
sub.BrandId,
sub.Campaign,
sub.SeatCount,
sub.CoreAuthUsername,
sub.RegAuthUsername,
sub.Status,
sub.LicenceKey,
sub.ClientDownloadLocation,
enterpriseid = ec.Id,
enterprisename = ec.Name,
sub.CreationTime,
sub.CancelationTime
};
var query = from subscription in subscriptionsList
select new
{
Id = subscription.Id,
Name = subscription.Name,
EnterpriseClientId = subscription.EnterpriseClientId,
Product = subscription.Product,
ProductName = _productService.GetByWId(subscription.Product).Name,
LicencingEnvironment = subscription.LicencingEnvironment,
LicencingEnvironmentName = _licenceEnvironmentService.GetBymanagerId(subscription.LicencingEnvironment).Name,
BrandId = subscription.BrandId,
Campaign = subscription.Campaign,
SeatCount = subscription.SeatCount,
CoreAuthUsername = subscription.CoreAuthUsername,
RegAuthUsername = subscription.RegAuthUsername,
Status = subscription.Status,
LicenceKey = subscription.LicenceKey,
ClientDownloadLocation = subscription.ClientDownloadLocation,
Partner = new { id = partner.Id, name = partner.Name },
Enterprise = new { id = subscription.enterpriseid, name = subscription.enterprisename },
CreationTime = subscription.CreationTime,
CancelationTime = subscription.CancelationTime
};
return(Json(new
{
c = ResultCode.Success,
d = new { subscriptions = query, partners = partner, ec = enterpriseClientsList }
}));
}
else if (TokenDetails.Role.ToLower() == "admin")
{
var subscriptions = _subscriptionService.GetAll();
var partners = _partnerService.GetAll();
var enterpriseClients = _enterpriseClientService.GetAll();
var resultList = from sub in subscriptions
join ec in enterpriseClients
on sub.EnterpriseClientId equals ec.Id
join partner in partners on ec.PartnerId equals partner.Id
select new
{
sub.Id,
sub.Name,
sub.EnterpriseClientId,
sub.Product,
sub.LicencingEnvironment,
sub.BrandId,
sub.Campaign,
sub.SeatCount,
sub.CoreAuthUsername,
sub.RegAuthUsername,
sub.Status,
sub.LicenceKey,
sub.ClientDownloadLocation,
enterpriseid = ec.Id,
enterprisename = ec.Name,
partnerid = partner.Id,
partnername = partner.Name,
sub.CreationTime,
sub.CancelationTime
};
var query = from sub in resultList
select new
{
Id = sub.Id,
Name = sub.Name,
EnterpriseClientId = sub.EnterpriseClientId,
Product = sub.Product,
ProductName = _productService.GetByWId(sub.Product).Name,
LicencingEnvironment = sub.LicencingEnvironment,
LicencingEnvironmentName = _licenceEnvironmentService.GetBymanagerId(sub.LicencingEnvironment).Name,
BrandId = sub.BrandId,
Campaign = sub.Campaign,
SeatCount = sub.SeatCount,
CoreAuthUsername = sub.CoreAuthUsername,
RegAuthUsername = sub.RegAuthUsername,
Status = sub.Status,
LicenceKey = sub.LicenceKey,
ClientDownloadLocation = sub.ClientDownloadLocation,
Partner = new { id = sub.partnerid, name = sub.partnername },
Enterprise = new { id = sub.enterpriseid, name = sub.enterprisename },
CreationTime = sub.CreationTime,
CancelationTime = sub.CancelationTime
};
return(Json(new
{
c = ResultCode.Success,
d = new { subscriptions = query, partners = partners, ec = enterpriseClients }
}));
}
else
{
//if code reaches this point something went wrong
Response.StatusCode = (int)HttpStatusCode.Unauthorized;
return(Json(string.Empty));
}
}
catch (Exception ex)
{
_logger.LogError(ex.GetLogText("dashboard_getall"));
return(Json(new
{
c = ResultCode.GenericException,
d = ex.Message
}));
}
}
public IActionResult GetAll()
{
try
{
var TokenDetails = User.Claims.GetTokenDetails();
if (string.IsNullOrEmpty(TokenDetails.Role) || string.IsNullOrEmpty(TokenDetails.Username))
{
Response.StatusCode = (int)HttpStatusCode.Unauthorized;
return(Json(string.Empty));
}
var managerTokenUser = _userService.GetByUsername(TokenDetails.Username);
//EOF Extract API Called Info
if (TokenDetails.Role.ToLower() == "partner")
{
var partner = _partnerService.GetById(managerTokenUser.PartnerId.Value);
var partnerEnterpriseClients = _enterpriseClientService.GetByPartnerId(partner.Id);
var query = from ec in partnerEnterpriseClients
select new
{
Id = ec.Id,
Name = ec.Name,
Location = ec.Location,
Partner = new { id = ec.PartnerId, name = partner.Name }
};
return(Json(new
{
c = ResultCode.Success,
d = query
}));
}
else if (TokenDetails.Role.ToLower() == "admin")
{
var EnterpriseClients = _enterpriseClientService.GetAll();
var Partners = _partnerService.GetAll();
var query = from ec in EnterpriseClients
join partner in Partners
on ec.PartnerId equals partner.Id
select new
{
Id = ec.Id,
Name = ec.Name,
Location = ec.Location,
Partner = new { id = ec.PartnerId, name = partner.Name }
};
return(Json(new
{
c = ResultCode.Success,
d = query
}));
}
else
{
//if code reaches this point something went wrong
Response.StatusCode = (int)HttpStatusCode.Unauthorized;
return(Json(string.Empty));
}
}
catch (Exception ex)
{
_logger.LogError(ex.GetLogText("ec_getall"));
return(Json(new
{
c = ResultCode.GenericException,
d = ex.Message
}));
}
}
public IActionResult GetAll()
{
//Extract API Called Info
try
{
var TokenDetails = User.Claims.GetTokenDetails();
if (string.IsNullOrEmpty(TokenDetails.Role) || string.IsNullOrEmpty(TokenDetails.Username))
{
Response.StatusCode = (int)HttpStatusCode.Unauthorized;
return(Json(string.Empty));
}
var managerTokenUser = _userService.GetByUsername(TokenDetails.Username);
//EOF Extract API Called Info
var identityUsers = _userManager.Users;
if (TokenDetails.Role.ToLower() == "ec")
{
var users = _userService.GetAll().Where(x => x.EnterpriseId == managerTokenUser.EnterpriseId);
var partners = _partnerService.GetAll();
var enterprises = _enterpriseClientService.GetAll();
//left outer join user and partners
var query = from user in users
join iusrs in identityUsers
on user.UserId equals iusrs.Id
join partner in partners
on user.PartnerId equals partner.Id
into pjoin
join ec in enterprises
on user.EnterpriseId equals ec.Id
into ecjoin
from partner in pjoin.DefaultIfEmpty()
from ec in ecjoin.DefaultIfEmpty()
select new
{
Id = user.Id,
Username = user.Username,
FirstName = user.Firstname,
LastName = user.Lastname,
Role = user.Role,
Partner = partner == null ? new { id = "", name = "" } : new { id = partner.Id.ToString(), name = partner.Name },
Enterprise = ec == null ? new { id = "", name = "" } : new { id = ec.Id.ToString(), name = ec.Name },
Status = iusrs.LockoutEnd != null ? "locked" : iusrs.EmailConfirmed ? "active" : "pending"
};
return(Json(new
{
c = ResultCode.Success,
d = query
}));
}
else if (TokenDetails.Role.ToLower() == "partner")
{
var users = _userService.GetAll().Where(x => x.PartnerId == managerTokenUser.PartnerId);
var partners = _partnerService.GetAll();
var enterprises = _enterpriseClientService.GetAll();
//left outer join user and partners
var query = from user in users
join iusrs in identityUsers
on user.UserId equals iusrs.Id
join partner in partners
on user.PartnerId equals partner.Id
into pjoin
join ec in enterprises
on user.EnterpriseId equals ec.Id
into ecjoin
from partner in pjoin.DefaultIfEmpty()
from ec in ecjoin.DefaultIfEmpty()
select new
{
Id = user.Id,
Username = user.Username,
FirstName = user.Firstname,
LastName = user.Lastname,
Role = user.Role,
Partner = partner == null ? new { id = "", name = "" } : new { id = partner.Id.ToString(), name = partner.Name },
Enterprise = ec == null ? new { id = "", name = "" } : new { id = ec.Id.ToString(), name = ec.Name },
Status = iusrs.LockoutEnd != null ? "locked" : iusrs.EmailConfirmed ? "active" : "pending"
};
return(Json(new
{
c = ResultCode.Success,
d = query
}));
}
else if (TokenDetails.Role.ToLower() == "admin")
{
var users = _userService.GetAll();
var partners = _partnerService.GetAll();
var enterprises = _enterpriseClientService.GetAll();
//left outer join user and partners
var query = from user in users
join iusrs in identityUsers
on user.UserId equals iusrs.Id
join partner in partners
on user.PartnerId equals partner.Id
into pjoin
join ec in enterprises
on user.EnterpriseId equals ec.Id
into ecjoin
from partner in pjoin.DefaultIfEmpty()
from ec in ecjoin.DefaultIfEmpty()
select new
{
Id = user.Id,
Username = user.Username,
FirstName = user.Firstname,
LastName = user.Lastname,
Role = user.Role,
Partner = partner == null ? new { id = "", name = "" } : new { id = partner.Id.ToString(), name = partner.Name },
Enterprise = ec == null ? new { id = "", name = "" } : new { id = ec.Id.ToString(), name = ec.Name }
,
Status = iusrs.LockoutEnd != null ? "disabled" : iusrs.EmailConfirmed ? "active" : "pending"
};
return(Json(new
{
c = ResultCode.Success,
d = query
}));
}
else
{
//if code reaches this point something went wrong
Response.StatusCode = (int)HttpStatusCode.Unauthorized;
return(Json(string.Empty));
}
}
catch (Exception ex)
{
_logger.LogError(ex.GetLogText("userapi_getall"));
return(Json(new
{
c = ResultCode.GenericException,
d = ex.Message
}));
}
}