public async Task <ICollection <Holiday> > GetByEmployeeStatus(EmployeeStatusEnum employeeStatus)
{
var holidays = await Context.Holidays.Include(x => x.Employee).Where(x => x.Employee.Status == employeeStatus)
.ToArrayAsync();
return(holidays);
}
public async Task <Employee> SaveStatusAndAddTimelineEntry(
Employee employee,
EmployeeStatusEnum newStatus
)
{
var newStatusCode = newStatus.Code;
var oldStatusCode = employee.CurrentEmployeeStatusCode;
// Update employee status.
employee.CurrentEmployeeStatusCode = newStatusCode;
// Create a new timeline entry.
employee.TimelineEntries.Add(new EmployeeTimelineEntry
{
EmployeeActionCode = EmployeeActionEnum.UpdateByTask.Code,
EmployeeStatusCode = newStatusCode,
Comment = $"Status updated by script: " +
$"{oldStatusCode} → {newStatusCode}."
});
context.Entry(employee).State = EntityState.Modified;
// Update in CallWeb.
await callWeb.UpdateSurvey(employee);
// Save.
await context.SaveChangesAsync();
return(employee);
}
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
if (value == null)
{
return(null);
}
EmployeeStatusEnum gender = (EmployeeStatusEnum)value;
return(((int)gender).ToString());
}
public void SetEmployeeOrganizationalDetails(string locationName, string supervisorEmpCode, DateTime?hireDate, string recordStatus, int countryId, string city, string region, DateTime?actualTerminationDate, EmployeeStatusEnum employeeStatus)
{
LocationName = locationName;
SupervisorEmpCode = supervisorEmpCode;
HireDate = hireDate;
RecordStatus = recordStatus;
CountryId = countryId;
City = city;
Region = region;
ActualTerminationDate = actualTerminationDate;
EmployeeStatus = employeeStatus;
}
public async Task <ICollection <GetEmployeeDto> > GetByEmployeeStatus(EmployeeStatusEnum employeeStatus)
{
var employees = await _repository.GetByEmployeeStatus(employeeStatus);
var employeesDto = _mapper.Map <GetEmployeeDto[]>(employees);
foreach (var employee in employeesDto)
{
employee.Role = await _userService.GetUserRole(employee.Id);
}
return(employeesDto);
}
public async Task <ICollection <GetHolidayDto> > GetByEmployeeStatus(EmployeeStatusEnum employeeStatus)
{
var holidays = await _holidaysRepository.GetByEmployeeStatus(employeeStatus);
var holidaysDto = _mapper.Map <GetHolidayDto[]>(holidays).OrderByDescending(h => h.RequestCreatedDate).ToList();
holidaysDto.ForEach(holidayDto => AddOvertimeDetails(holidayDto));
foreach (var holidayDto in holidaysDto)
{
holidayDto.ConfirmerFullName = await GetConfirmerFullName(holidayDto);
}
return(holidaysDto);
}
public async Task <ICollection <Employee> > GetByEmployeeStatus(EmployeeStatusEnum employeeStatus)
{
var employees = await Context.Employees.Where(x => x.Status == employeeStatus).ToArrayAsync();
return(employees);
}
public void AddEmployee(string id, string name, GenderEnum gender, string idNum, DateTime entryDate, decimal salary, string serialNum, string dutyId, EmployeeStatusEnum status, string principalId, string operatorId, DateTime createTime, string remark)
{
string sql = "INSERT into \"T_Employee\" (\"Id\",\"Name\",\"Gender\",\"IdNum\",\"EntryDate\",\"Salary\",\"SerialNum\",\"DutyId\",\"Status\",\"PrincipalId\",\"OperatorId\",\"CreateTime\",\"Remark\")VALUES(:id,:name,:gender,:idNum,:entryDate,:salary,:serialNum,:dutyId,:status,:principalId,:operatorId,:createTime,:remark)";
IDbParameters pms = AdoTemplate.CreateDbParameters();
pms.AddWithValue("id", id);
pms.AddWithValue("name", name);
pms.AddWithValue("gender", (int)gender);
pms.AddWithValue("idNum", idNum);
pms.AddWithValue("entryDate", entryDate);
pms.AddWithValue("salary", salary);
pms.AddWithValue("serialNum", serialNum);
pms.AddWithValue("dutyId", dutyId);
pms.AddWithValue("status", (int)status);
pms.AddWithValue("principalId", principalId);
pms.AddWithValue("operatorId", operatorId);
pms.AddWithValue("createTime", createTime);
pms.AddWithValue("remark", remark);
AdoTemplate.ExecuteNonQuery(CommandType.Text, sql, pms);
}
public void UpdateEmployee(string name, GenderEnum gender, string idNum, DateTime entryDate, decimal salary, string serialNum, string dutyId, EmployeeStatusEnum status, string principalId, string remark, string id)
{
string sql = "UPDATE \"T_Employee\" SET \"Name\"=:name,\"Gender\"=:gender,\"IdNum\"=:idNum,\"EntryDate\"=:entryDate,\"Salary\"=:salary,\"SerialNum\"=:serialNum,\"DutyId\"=:dutyId,\"Status\"=:status,\"PrincipalId\"=:principalId,\"Remark\"=:remark where \"Id\"=:id";
IDbParameters pms = AdoTemplate.CreateDbParameters();
pms.AddWithValue("name", name);
pms.AddWithValue("gender", (int)gender);
pms.AddWithValue("idNum", idNum);
pms.AddWithValue("entryDate", entryDate);
pms.AddWithValue("salary", salary);
pms.AddWithValue("serialNum", serialNum);
pms.AddWithValue("dutyId", dutyId);
pms.AddWithValue("status", (int)status);
pms.AddWithValue("principalId", principalId);
pms.AddWithValue("remark", remark);
pms.AddWithValue("id", id);
AdoTemplate.ExecuteNonQuery(CommandType.Text, sql, pms);
}
public async Task <IActionResult> GetByEmployeeStatus(EmployeeStatusEnum employeeStatus)
{
var holidays = await _holidaysService.GetByEmployeeStatus(employeeStatus);
return(Ok(holidays));
}
public async Task <IActionResult> GetByEmployeeStatus(EmployeeStatusEnum employeeStatus)
{
var employees = await _employeesService.GetByEmployeeStatus(employeeStatus);
return(Ok(employees));
}
