public async Task <IActionResult> AccountDetails( [FromRoute] int tenantId, [FromRoute] int accountId, [FromQuery] PaginationViewModel pagination) { // TODO: Either in here or in an attribute, verify authorization for the tenant var account = await _accountRepository.GetAccountByIdAsync(accountId); if (account == null) { return(NotFound()); } // TODO: If doesn't belong to selected tenant either 404 not found or 403 forbidden // Get pending transactions var pendingTransactions = await _accountRepository.GetPendingTransactionsAsync(accountId); // Get posted transactions var paginationModel = ViewBag.Pagination as Pagination; var paginatedPostedTransactions = await _accountRepository.GetPostedTransactionsAsync( accountId, paginationModel); var resultViewModel = new AccountDetailsViewModel() { Account = AccountDisplayViewModel.FromModel(account), PendingTransactions = pendingTransactions.Select(AccountTransactionViewModel.FromModel), PostedTransactions = new PagedResult <AccountTransactionViewModel>() { Pagination = paginatedPostedTransactions.Pagination, Results = paginatedPostedTransactions.Results.Select(AccountTransactionViewModel.FromModel) } }; return(View(resultViewModel)); }
public ActionResult CareerClusterDisplay(int id) { AccountDisplayViewModel model = new AccountDisplayViewModel(); using (var db = new WiredHackEntities()) { var item = db.CareerClusters.Where(cc => cc.CCId == id); model.ClustClusterName = item.FirstOrDefault().Name; model.ClustClusterDescription = item.FirstOrDefault().Description; } return View(model); }
public ActionResult SchoolDisplay(int Id) { using (var db = new WiredHackEntities()) { var model = new AccountDisplayViewModel(); var itemUniversity = db.Universities.Where(cc => cc.Id == Id); if (itemUniversity.Any()) { model.UniAddress = itemUniversity.FirstOrDefault().Address; model.UniName = itemUniversity.FirstOrDefault().Name; model.UniState = itemUniversity.FirstOrDefault().State; model.UniCity = itemUniversity.FirstOrDefault().City; model.UniZip = itemUniversity.FirstOrDefault().Zip; model.UniDescription = itemUniversity.FirstOrDefault().Description; model.UniCounty = itemUniversity.FirstOrDefault().County; model.UniLogo = itemUniversity.FirstOrDefault().Logo; } return View(model); } }
public ActionResult EmployerDisplay(int Id) { using (var db = new WiredHackEntities()) { var model = new AccountDisplayViewModel(); var itemEmployer = db.Employers.Where(cc => cc.EmployerID == Id); if (itemEmployer.Any()) { model.EmployerName = itemEmployer.FirstOrDefault().Name; model.EmployerDescription = itemEmployer.FirstOrDefault().Description; model.EmployerId = itemEmployer.FirstOrDefault().EmployerID; model.EmployerAddress = itemEmployer.FirstOrDefault().Address + "</br>" + itemEmployer.FirstOrDefault().Address2; model.EmployerCity = itemEmployer.FirstOrDefault().City; model.EmployerState = itemEmployer.FirstOrDefault().State; model.EmployerZip = itemEmployer.FirstOrDefault().Zip; model.EmployerCounty = itemEmployer.FirstOrDefault().County; model.EmployerPhone = itemEmployer.FirstOrDefault().Phone; model.EmployerAmtOfEmployees = itemEmployer.FirstOrDefault().NumEmployees; model.EmployerLogo = itemEmployer.FirstOrDefault().Logo; } return View(model); } }
public ActionResult JobDisplay(int Id) { using (var db = new WiredHackEntities()) { var model = new AccountDisplayViewModel(); var itemEmployeeJonCon = db.EmployeeJobConnections.Where(cc => cc.JobId == Id); if (itemEmployeeJonCon.Any()) { model.JobPayRate = itemEmployeeJonCon.FirstOrDefault().PayRate; model.JobStartDate = itemEmployeeJonCon.FirstOrDefault().StartDate; model.JobEndDate = itemEmployeeJonCon.FirstOrDefault().EndDate.HasValue ? itemEmployeeJonCon.FirstOrDefault().EndDate.Value : new DateTime(1, 1, 1); var itemJob = db.Jobs.Where(cc => cc.JobID == itemEmployeeJonCon.FirstOrDefault().JobId); if (itemJob.Any()) { model.JobName = itemJob.FirstOrDefault().Name; model.JobBaseSalary = itemJob.FirstOrDefault().BaseSalary; } var itemJobCCConnect = db.JobCCConnections.Where(cc => cc.JobID == itemJob.FirstOrDefault().JobID); if (itemJobCCConnect.Any()) { var itemCareerCluster = db.CareerClusters.Where( cc => cc.CCId == itemJobCCConnect.FirstOrDefault().CCID); if (itemCareerCluster.Any()) { model.ClustClusterDescription = itemCareerCluster.FirstOrDefault().Description; model.ClustClusterName = itemCareerCluster.FirstOrDefault().Name; model.CCID = itemCareerCluster.FirstOrDefault().CCId; } } } return View(model); } }
public ActionResult AccountDisplay(int Id) { AccountDisplayViewModel model = new AccountDisplayViewModel(); using (var db = new WiredHackEntities()) { var itemUsers = db.Users.Where(cc => cc.Id == Id); model.AccFirstName = itemUsers.FirstOrDefault().FirstName; model.AccLastName = itemUsers.FirstOrDefault().LastName; if (itemUsers.FirstOrDefault().EmployerId.HasValue) { var itemEmployer = db.Employers.Where(cc => cc.EmployerID == itemUsers.FirstOrDefault().EmployerId.Value); if (itemEmployer.Any()) { model.EmployerName = itemEmployer.FirstOrDefault().Name; model.EmployerDescription = itemEmployer.FirstOrDefault().Description; model.EmployerId = itemEmployer.FirstOrDefault().EmployerID; model.EmployerAddress = itemEmployer.FirstOrDefault().Address + "</br>" + itemEmployer.FirstOrDefault().Address2; model.EmployerCity = itemEmployer.FirstOrDefault().City; model.EmployerState = itemEmployer.FirstOrDefault().State; model.EmployerZip = itemEmployer.FirstOrDefault().Zip; model.EmployerCounty = itemEmployer.FirstOrDefault().County; model.EmployerPhone = itemEmployer.FirstOrDefault().Phone; model.EmployerAmtOfEmployees = itemEmployer.FirstOrDefault().NumEmployees; model.EmployerLogo = itemEmployer.FirstOrDefault().Logo; } } if (itemUsers.FirstOrDefault().EmployeeId.HasValue) { model.AccEmployeeId = itemUsers.FirstOrDefault().EmployeeId.Value; var itemEmployee = db.Employees.Where(cc => cc.Id == itemUsers.FirstOrDefault().Id); if (itemEmployee.Any()) { model.AccAddress = itemEmployee.FirstOrDefault().Address; model.AccCity = itemEmployee.FirstOrDefault().City; model.AccState = itemEmployee.FirstOrDefault().State; model.AccZip = itemEmployee.FirstOrDefault().Zip; model.AccCounty = itemEmployee.FirstOrDefault().County; model.AccImage = itemEmployee.FirstOrDefault().Image; model.AccJobId = itemEmployee.FirstOrDefault().JobID.HasValue ? itemEmployee.FirstOrDefault().JobID.Value : 0; model.AccBio = itemEmployee.FirstOrDefault().Bio; model.UniID = itemEmployee.FirstOrDefault().UniversityID; model.MajorID = itemEmployee.FirstOrDefault().MajorID; var itemEmployeeJonCon = db.EmployeeJobConnections.Where(cc => cc.JobId == model.AccJobId); if (itemEmployeeJonCon.Any()) { model.JobPayRate = itemEmployeeJonCon.FirstOrDefault().PayRate; model.JobStartDate = itemEmployeeJonCon.FirstOrDefault().StartDate; model.JobEndDate = itemEmployeeJonCon.FirstOrDefault().EndDate.HasValue ? itemEmployeeJonCon.FirstOrDefault().EndDate.Value : new DateTime(1, 1, 1); var itemJob = db.Jobs.Where(cc => cc.JobID == itemEmployeeJonCon.FirstOrDefault().JobId); if (itemJob.Any()) { model.JobName = itemJob.FirstOrDefault().Name; model.JobBaseSalary = itemJob.FirstOrDefault().BaseSalary; var itemJobCCConnect = db.JobCCConnections.Where(cc => cc.JobID == itemJob.FirstOrDefault().JobID); if (itemJobCCConnect.Any()) { var itemCareerCluster = db.CareerClusters.Where( cc => cc.CCId == itemJobCCConnect.FirstOrDefault().CCID); if (itemCareerCluster.Any()) { model.ClustClusterDescription = itemCareerCluster.FirstOrDefault().Description; model.ClustClusterName = itemCareerCluster.FirstOrDefault().Name; model.CCID = itemCareerCluster.FirstOrDefault().CCId; } } } } var itemUniversity = db.Universities.Where(cc => cc.Id == model.UniID); if (itemUniversity.Any()) { model.UniAddress = itemUniversity.FirstOrDefault().Address; model.UniName = itemUniversity.FirstOrDefault().Name; model.UniState = itemUniversity.FirstOrDefault().State; model.UniCity = itemUniversity.FirstOrDefault().City; model.UniZip = itemUniversity.FirstOrDefault().Zip; model.UniDescription = itemUniversity.FirstOrDefault().Description; model.UniCounty = itemUniversity.FirstOrDefault().County; model.UniLogo = itemUniversity.FirstOrDefault().Logo; } var itemMajor = db.Majors.Where(cc => cc.Id == model.MajorID); if (itemMajor.Any()) { model.MajorDescription = itemMajor.FirstOrDefault().Description; } } } } return View(model); }