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