public PartialViewResult EmployeeDetails(string id)
{
var personDetails = new EmployeeIndexModel();
if (id != null)
{
personDetails.person_role = db.Person_Role
.Where(x => x.Person_ID == id)
.Include(pr => pr.Role);
personDetails.trainer_topic = db.Trainer_Topic
.Where(x => x.Person_ID == id)
.Include(pr => pr.Topic).ToList();
TempData["Check"] = false;
if (personDetails.trainer_topic.Any())
{
TempData["Check"] = true;
}
var selectPerson = db.Registered_Person.Find(id);
personDetails.person_id = selectPerson.Person_ID;
personDetails.person_name = selectPerson.Person_Name;
personDetails.person_surname = selectPerson.Person_Surname;
personDetails.person_email = selectPerson.Person_Email;
}
return(PartialView("EmployeeDetails", personDetails));
}
// Список сотрудников
public async Task <IActionResult> IndexAsync(string sortOrder, string searchPattern)
{
var employees = await _employees.GetEmployeesAsync(searchPattern);
ViewData["NameSortParam"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["SearchPattern"] = string.IsNullOrEmpty(searchPattern) ? "" : searchPattern;
ViewData["DepartmentSortParam"] = sortOrder == "department" ? "department_desc" : "department";
ViewData["PositionSortParam"] = sortOrder == "position" ? "position_desc" : "position";
employees = sortOrder switch
{
"name_desc" => employees.OrderByDescending(e => e.FullName).ToHashSet(),
"department" => employees.OrderBy(e => e.Department.Id).ToHashSet(),
"department_desc" => employees.OrderByDescending(e => e.Department.Id).ToHashSet(),
"position" => employees.OrderBy(e => e.Position.Id).ToHashSet(),
"position_desc" => employees.OrderByDescending(e => e.Position.Id).ToHashSet(),
_ => employees.OrderBy(e => e.FullName).ToHashSet()
};
var model = new EmployeeIndexModel {
Employees = employees
};
return(View(model));
}
// READ
public IActionResult Index()
{
if (User.IsInRole("Admin") == false)
{
return(RedirectToAction("Index", "Home"));
}
var planeModels = _employees.GetAll();
var listingResult = planeModels
.Select(result => new EmployeeListingModel
{
Id = result.Id,
FirstName = _employees.GetFirstName(result.Id),
LastName = _employees.GetLastName(result.Id),
Job = _employees.GetJob(result.Id),
EmployeeNumber = _employees.GetEmployeeNumber(result.Id),
Status = (_employees.GetStatus(result.Id) == 0) ? "Free" : "Working",
TotalHours = _employees.GetTotalHours(result.Id)
});
var model = new EmployeeIndexModel()
{
Employees = listingResult
};
return(View(model));
}
public ActionResult Get()
{
var employeModel = _employees.GetAllEmployee();
var listResult = employeModel.Select(result => new EmployeeAssetModel
{
Id = result.EmployeeId,
FirstName = result.FirstName,
LastName = result.LastName,
Position = _employees.GetPosition(result.PositionId),
Office = _employees.GetOffice(result.OfficeId),
Sex = result.Sex,
Age = result.Age,
Salary = result.Salary,
StartDate = result.StartDate,
UpdatedUtc = result.UpdatedUtc,
});
var model = new EmployeeIndexModel
{
Employees = listResult
};
return(Ok(model));
}
// GET api/employees
public IActionResult Get()
{
//Get all the employees from the database refered to the domain modol
var employeesList = _employeeTrackerService.GetAllEmployee();
// We need to transform the Domain model to View Model to get the json object we want.
var employeeListResult = employeesList.Select(result => new EmployeeAssetModel
{
Id = result.EmployeeId,
FirstName = result.FirstName,
LastName = result.LastName,
//Modified PositionId & OfficeId to Position & Office name.
Position = _employeeTrackerService.GetPosition(result.PositionId),
Office = _employeeTrackerService.GetOffice(result.OfficeId),
Sex = result.Sex,
Age = result.Age,
Salary = result.Salary,
StartDate = result.StartDate,
UpdatedUtc = result.UpdatedUtc
});
//Create the EmployeeIndexModel object that is IEnumerable of EmployeeAsetModel to return to the View
var model = new EmployeeIndexModel
{
Employees = employeeListResult
};
return(Ok(model));
}
public ActionResult EmployeeIndex()
{
IEnumerable <Employee> employees = EmployeeRepository.GetAll().Where(x => x.IsActive);
IEnumerable <State> states = StateRepository.GetAll();
IEnumerable <BenefitSetting> benefitSettings = BenefitSettingsRepository.GetPublic();
EmployeeIndexModel model = new EmployeeIndexModel(employees, states, benefitSettings);
return(View(model));
}
public PartialViewResult RoleDetails(int?id)
{
var roleAction = new EmployeeIndexModel();
if (id != null)
{
roleAction.role_action = db.Role_Action
.Where(ra => ra.Role_ID == id).Include(a => a.Action);
}
return(PartialView("RoleDetails", roleAction));
}
public ViewResult Index(bool includeNonActive = false)
{
var model = new EmployeeIndexModel();
model.IncludeNonActive = includeNonActive;
var empList = EmployeeHandler.GetAllEmployee(includeNonActive);
foreach (var emp in empList)
{
var empModel = EmployeeModelMapper.MapToEmployeeModel(emp);
model.EmployeeList.Add(empModel);
}
return(View(model));
}
public ActionResult Index(string username, string name, string surname, string email, string roleid)
{
try
{
if ((bool)TempData["Show"] == true)
{
TempData["Hidden"] = "";
TempData["Show"] = false;
}
else
{
TempData["Hidden"] = "Hidden";
TempData["Show"] = false;
}
}
catch
{
TempData["Hidden"] = "Hidden";
TempData["Show"] = false;
}
var viewModel = new EmployeeIndexModel();
viewModel.registered_person = db.Registered_Person
.Where(t => t.Person_Type.ToLower() == "employee");
List <SelectListItem> selectListItems = new List <SelectListItem>();
foreach (Role role in db.Roles)
{
SelectListItem selectListItem = new SelectListItem
{
Text = role.Role_Name,
Value = role.Role_ID.ToString()
};
selectListItems.Add(selectListItem);
}
ViewBag.Roles = selectListItems;
return(View("Index", viewModel));
}
public PartialViewResult Employees(string username, string name, string surname, string email, string roleid)
{
var viewModel = new EmployeeIndexModel();
viewModel.registered_person = db.Registered_Person
.Where(t => t.Person_Type.ToLower() == "employee");
var pRoles = (from r in db.Person_Role
where (string.IsNullOrEmpty(roleid) ? true : r.Role_ID.ToString() == roleid)
select r.Person_ID).Distinct().ToList();
viewModel.registered_person = from q in viewModel.registered_person
where ((string.IsNullOrEmpty(username) ? true : q.Person_ID.ToLower().StartsWith(username.ToLower())) &&
(string.IsNullOrEmpty(name) ? true : q.Person_Name.ToLower().StartsWith(name.ToLower())) &&
(string.IsNullOrEmpty(surname) ? true : q.Person_Surname.ToLower().StartsWith(surname.ToLower())) &&
(string.IsNullOrEmpty(email) ? true : q.Person_Email.ToLower().StartsWith(email.ToLower())))
select q;
if (pRoles != null)
{
viewModel.registered_person = viewModel.registered_person.Where(p => pRoles.Contains(p.Person_ID));
}
return(PartialView("Employees", viewModel));
}
