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 })); } }