public async Task <List <EmployeeInfoWorkPlace> > EmployeeInfoWorks(PayrollDbContext dbContext)
{
List <EmployeeInfoWorkPlace> employeeInfo = new List <EmployeeInfoWorkPlace>();
var infoEmployee = await dbContext.Placeswork.ToListAsync();
foreach (var place in infoEmployee)
{
var emp = await dbContext.Employees.Where(x => x.Id == place.EmployeeId).FirstOrDefaultAsync();
var emporia = await dbContext.Emporia.Where(x => x.Id == place.EmporiumId).FirstOrDefaultAsync();
var company = await dbContext.Companies.Where(x => x.Id == emporia.CompanyId).FirstOrDefaultAsync();
var positions = await dbContext.Positions.Where(x => x.Id == place.PositionsId).FirstOrDefaultAsync();
var salary = await dbContext.EmployeeSalaries.Where(x => x.PositionsId == place.PositionsId).FirstOrDefaultAsync();
DateTime date = place.StarDate;
EmployeeInfoWorkPlace infoWorkPlace = new EmployeeInfoWorkPlace
{
CompanyName = company.Name,
EmperiumName = emporia.Name,
PositionName = positions.Name,
PlasierCode = emp.PlasiyerCode,
Salary = salary.Salary,
Name = emp.Name + " " + emp.Surname,
Photo = emp.Photo,
StartDate = date,
id = emp.Id
};
employeeInfo.Add(infoWorkPlace);
}
return(employeeInfo);
}
public async Task <JsonResult> PagingWorkPlace(int?id, int elmPage)
{
List <EmployeeInfoWorkPlace> employeeInfo = new List <EmployeeInfoWorkPlace>();
var infoEmployee = await dbContext.Placeswork.ToListAsync();
foreach (var place in infoEmployee)
{
var emp = await dbContext.Employees.Where(x => x.Id == place.EmployeeId).FirstOrDefaultAsync();
var emporia = await dbContext.Emporia.Where(x => x.Id == place.EmporiumId).FirstOrDefaultAsync();
var company = await dbContext.Companies.Where(x => x.Id == emporia.CompanyId).FirstOrDefaultAsync();
var positions = await dbContext.Positions.Where(x => x.Id == place.PositionsId).FirstOrDefaultAsync();
var salary = await dbContext.EmployeeSalaries.Where(x => x.PositionsId == place.PositionsId).FirstOrDefaultAsync();
DateTime date = place.StarDate;
EmployeeInfoWorkPlace infoWorkPlace = new EmployeeInfoWorkPlace
{
CompanyName = company.Name,
EmperiumName = emporia.Name,
PositionName = positions.Name,
PlasierCode = emp.PlasiyerCode,
Salary = salary.Salary,
Name = emp.Name + " " + emp.Surname,
Photo = emp.Photo,
StartDate = date,
id = emp.Id
};
employeeInfo.Add(infoWorkPlace);
}
if (id == null)
{
id = 1;
}
var page = (int)id;
if (elmPage == 0)
{
elmPage = 10;
}
int elmpage = elmPage;
var currentData = dbContext.Employees.ToList();
var pageCount = Math.Ceiling(employeeInfo.Count() / (decimal)elmpage);
Paging paging1 = new Paging
{
CurrentPage = (int)page,
ItemPage = elmpage,
TotalItems = employeeInfo.Count(),
Prev = page > 1,
Next = page < pageCount
};
var pagingemployee = employeeInfo.Skip((page - 1) * elmpage).Take(elmpage).ToList();
return(Json(new { currentData = pagingemployee, message = 202, prevElement = paging1.Prev, nextElement = paging1.Next, pageCount = pageCount, currentPage = paging1.CurrentPage }));
}
public static decimal SalaryFindByNumberContainer(this EmployeeInfoWorkPlace salary, int value)
{
decimal a = 5;
if (salary.Salary == (decimal)value)
{
}
return(a);
}
public async Task <ActionResult> AboutEmployee(int?page)
{
if (page != null)
{
var employee = await dbContext.Employees.Where(x => x.Id == page).FirstOrDefaultAsync();
if (employee != null)
{
HttpContext.Session.SetObjectAsJson("Employ", employee);
var placework = await dbContext.Placeswork.Where(x => x.EmployeeId == page).FirstOrDefaultAsync();
var education = await dbContext.Educations.Where(x => x.EmployeeId == page).ToListAsync();
var oldworkplace = await dbContext.OldWorkPlaces.Where(x => x.EmployeeId == page).ToListAsync();
if (placework != null)
{
var emporia = await dbContext.Emporia.Where(x => x.Id == placework.EmporiumId).FirstOrDefaultAsync();
var company = await dbContext.Companies.Where(x => x.Id == emporia.CompanyId).FirstOrDefaultAsync();
var positions = await dbContext.Positions.Where(x => x.Id == placework.PositionsId).FirstOrDefaultAsync();
var departamentId = await dbContext.PositionsDepartaments.Where(x => x.PositionsId == positions.Id).FirstOrDefaultAsync();
var departament = await dbContext.Departaments.Where(x => x.Id == departamentId.DepartamentId).FirstOrDefaultAsync();
var salary = await dbContext.EmployeeSalaries.Where(x => x.PositionsId == placework.PositionsId).FirstOrDefaultAsync();
DateTime date = placework.StarDate;
EmployeeInfoWorkPlace employeeInfo = new EmployeeInfoWorkPlace
{
CompanyName = company.Name,
EmperiumName = emporia.Name,
PositionName = positions.Name,
Salary = salary.Salary,
DepartamentName = departament.Name,
StartDate = date,
};
AboutEmployeeInformationModel aboutEmployeeInformation = new AboutEmployeeInformationModel()
{
Educations = education,
Employees = employee,
OldWorkPlaces = oldworkplace,
InfoWorkPlaces = employeeInfo
};
return(View(aboutEmployeeInformation));
}
AboutEmployeeInformationModel aboutEmployeeInformation1 = new AboutEmployeeInformationModel()
{
Educations = education,
Employees = employee,
OldWorkPlaces = oldworkplace,
};
return(View(aboutEmployeeInformation1));
}
return(RedirectToAction(nameof(AllEmployee)));
}
return(RedirectToAction(nameof(AllEmployee)));
}
