private async Task <TheListOfPersonnelReserveViewModel> FillingInTheModel(int TableOrganizations) { var position = await _context.TablePosition.Include(i => i.Position) .Where(i => i.TableOrganizationsId == TableOrganizations) .Select(i => new { TablePositionId = i.TablePositionId, JobTitle = i.Position.JobTitle }).ToListAsync(); ViewBag.TablePositionId = new SelectList(position, "TablePositionId", "JobTitle"); var historyOfAppointments = await _context.TableHistoryOfAppointments .Include(i => i.Position) .Include(i => i.Position.Position) .Include(i => i.EmployeeRegistrationLog) .Include(i => i.EmployeeRegistrationLog.Worker) .Include(i => i.Position.Organizations) .Where(i => i.DateOfDismissal == null) .Where(i => i.Position.TableOrganizationsId == TableOrganizations) .ToListAsync(); var educationals = await _context.TableEducational .Include(i => i.EducationalInstitutions) .Include(i => i.tableSpecialty) .Include(i => i.Worker) .Where(i => i.Worker.TableOrganizationsId == TableOrganizations).ToListAsync(); var reserveOfPersonnels = await _context.reserveOfPersonnels .Include(i => i.tablePosition) .Include(i => i.employeeRegistrationLog) .Where(i => i.EndDateReserve == null) .Where(i => i.employeeRegistrationLog.TableOrganizationsId == TableOrganizations) .ToListAsync(); var advancedTrainings = await _context.advancedTrainings .Include(i => i.EducationalInstitutions) .Include(i => i.EmployeeRegistrationLog) .Where(i => i.EmployeeRegistrationLog.TableOrganizationsId == TableOrganizations).ToListAsync(); var location = new Uri($"{Request.Scheme}://{Request.Host}{Request.Path}{Request.QueryString}"); TheListOfPersonnelReserveViewModel model = new TheListOfPersonnelReserveViewModel { Id = TableOrganizations, tableHistoryOfAppointments = historyOfAppointments, tableEducationals = educationals, reserveOfPersonnels = reserveOfPersonnels, advancedTrainingViewModels = advancedTrainings, }; return(model); }
private async Task <TheListOfPersonnelReserveViewModel> Reports5(int TableOrganizations) { var historyOfAppointments = await _context.TableHistoryOfAppointments .Include(i => i.Position) .Include(i => i.Position.Position) .Include(i => i.EmployeeRegistrationLog) .Include(i => i.EmployeeRegistrationLog.Worker) .Include(i => i.Position.Organizations) .Where(i => i.DateOfDismissal == null) .Where(i => i.Position.Position.JobTitle.Contains("Начальник")) .ToListAsync(); var tablePositions = await _context.TablePosition .Include(i => i.Organizations) .Include(i => i.Position) .Where(i => i.Position.JobTitle.Contains("Начальник")) .ToListAsync(); var AllhistoryOfAppointments = await _context.TableHistoryOfAppointments .Include(i => i.Position) .Include(i => i.Position.Position) .Include(i => i.EmployeeRegistrationLog) .Include(i => i.EmployeeRegistrationLog.Worker) .Include(i => i.Position.Organizations) .Where(i => i.DateOfDismissal == null) .ToListAsync(); var educationals = await _context.TableEducational .Include(i => i.EducationalInstitutions) .Include(i => i.tableSpecialty) .Include(i => i.Worker) .Include(i => i.Qualification) .ToListAsync(); var reserveOfPersonnels = await _context.reserveOfPersonnels .Include(i => i.tablePosition) .Include(i => i.employeeRegistrationLog) .Include(i => i.tablePosition.Position) .Include(i => i.employeeRegistrationLog.Worker) .Where(i => i.EndDateReserve == null) .ToListAsync(); var advancedTrainings = await _context.advancedTrainings .Include(i => i.EducationalInstitutions) .Include(i => i.EmployeeRegistrationLog) .ToListAsync(); var organizations = await _context.TableOrganizations .ToListAsync(); TheListOfPersonnelReserveViewModel model = new TheListOfPersonnelReserveViewModel { Id = TableOrganizations, tableHistoryOfAppointments = historyOfAppointments, tableEducationals = educationals, reserveOfPersonnels = reserveOfPersonnels, advancedTrainingViewModels = advancedTrainings, Organizations = organizations, AllHistoryOfAppointments = AllhistoryOfAppointments, tablePositions = tablePositions }; return(model); }
private async Task <TheListOfPersonnelReserveViewModel> TheModelIsFilledWithAllTheData(int TableOrganizations) { var historyOfAppointments = await _context.TableHistoryOfAppointments .Include(i => i.Position) .Include(i => i.Position.Position) .Include(i => i.EmployeeRegistrationLog) .Include(i => i.EmployeeRegistrationLog.Worker) .Include(i => i.Position.Organizations) .Where(i => i.DateOfDismissal == null) .Where(i => i.Position.Position.JobTitle == "Председатель правления" || i.Position.Position.JobTitle == "Председатель ревизионной комиссии" || i.Position.Position.JobTitle == "Директор филиала" || i.Position.Position.JobTitle == "И.о.председателя правления" || i.Position.Position.JobTitle == "И.о.директора филиала" || i.Position.Position.JobTitle == "И.о.директора" || i.Position.Position.JobTitle == "И.о.председателя ревизионной комиссии" || i.Position.Position.JobTitle == "Директор") .ToListAsync(); var tablePositions = await _context.TablePosition .Include(i => i.Organizations) .Include(i => i.Position) .Where(i => i.Position.JobTitle == "Председатель правления" || i.Position.JobTitle == "Председатель ревизионной комиссии" || i.Position.JobTitle == "Директор филиала" || i.Position.JobTitle == "И.о.председателя правления" || i.Position.JobTitle == "И.о.директора филиала" || i.Position.JobTitle == "И.о.директора" || i.Position.JobTitle == "И.о.председателя ревизионной комиссии" || i.Position.JobTitle == "Директор") .ToListAsync(); var AllhistoryOfAppointments = await _context.TableHistoryOfAppointments .Include(i => i.Position) .Include(i => i.Position.Position) .Include(i => i.EmployeeRegistrationLog) .Include(i => i.EmployeeRegistrationLog.Worker) .Include(i => i.Position.Organizations) .Where(i => i.DateOfDismissal == null) .ToListAsync(); var educationals = await _context.TableEducational .Include(i => i.EducationalInstitutions) .Include(i => i.tableSpecialty) .Include(i => i.Worker) .Include(i => i.Qualification) .ToListAsync(); var reserveOfPersonnels = await _context.reserveOfPersonnels .Include(i => i.tablePosition) .Include(i => i.employeeRegistrationLog) .Include(i => i.tablePosition.Position) .Include(i => i.employeeRegistrationLog.Worker) .Where(i => i.EndDateReserve == null) .ToListAsync(); var advancedTrainings = await _context.advancedTrainings .Include(i => i.EducationalInstitutions) .Include(i => i.EmployeeRegistrationLog) .ToListAsync(); var organizations = await _context.TableOrganizations .ToListAsync(); TheListOfPersonnelReserveViewModel model = new TheListOfPersonnelReserveViewModel { Id = TableOrganizations, tableHistoryOfAppointments = historyOfAppointments, tableEducationals = educationals, reserveOfPersonnels = reserveOfPersonnels, advancedTrainingViewModels = advancedTrainings, Organizations = organizations, AllHistoryOfAppointments = AllhistoryOfAppointments, tablePositions = tablePositions }; return(model); }