public async Task <IEnumerable <EmployeeWFHEntity> > GetEmployeeWFHAllAsync(EmployeeWFHEntity employeeWFHEntity)
{
_logger.LogInformation("### Calling base repository method ### ");
string sQuery = "Select wfh.id, wfh.EmployeeId,wfh.VacationTypeId,wfh.WFHDaysId, wfhDays.Days from EmployeeWFH wfh, WFHDays wfhDays where wfhDays.Id=wfh.WFHDaysId and wfh.VacationTypeId=@VacationTypeId";
return(await _baseRepository.GetAllEntitiesAsync(sQuery, employeeWFHEntity));
}
public async Task <bool> DeleteEmployeeWFH(EmployeeWFHEntity employeeWFHEntity)
{
_logger.LogInformation("Delete Employee WFH operation requested");
try
{
return(await _employeeWFHDeleteRepository.DeleteEmployeeWFHAsync(employeeWFHEntity));
}
catch (Exception ex)
{
_logger.LogError($"Exception occured while calling delete WFH operation " + ex);
throw;
}
}
public async Task <bool> DeleteEmployeeWFHAsync(EmployeeWFHEntity employeeWFHEntity)
{
_logger.LogInformation("Performing Delete operation for Employee WFH.");
_logger.LogDebug("Delete operation - Payload employeeWFHEntity = " + employeeWFHEntity);
try
{
return(await _baseRepository.DeleteEntityContribAsync(employeeWFHEntity));
}
catch (Exception ex)
{
_logger.LogCritical("Exception Occured while performing delete trainings operation." + ex);
throw;
}
}
public async Task <int> AddEmployeeWFH(EmployeeWFHEntity employeeWFHEntity)
{
_logger.LogInformation("Performing Add operation for Employee WFH");
_logger.LogDebug("Add operation - Payload employeeWFHEntity = " + employeeWFHEntity);
try
{
int recordCreated = await _baseRepository.AddEntityContribAsync(employeeWFHEntity);
return(recordCreated);
}
catch (Exception ex)
{
_logger.LogCritical("Exeption occured while performing Add employees WFH operation." + ex);
throw;
}
}
public async Task <bool> UpdateEmployeeWFH(EmployeeWFHEntity employeeWFHEntity)
{
_logger.LogInformation("Performing Update operation for Employee WFH");
_logger.LogDebug("Update peration - Payload employeeWFHEntity = " + employeeWFHEntity);
try
{
bool isChanged = await _baseRepository.UpdateEntityContribAsync(employeeWFHEntity);
return(isChanged);
}
catch (Exception ex)
{
_logger.LogCritical("Exeption occured while performing Update employees WFH operation." + ex);
throw;
}
}
private async Task <EmployeeWFHEntity> GetEmployeeWFHEntity(int id)
{
try
{
EmployeeWFHEntity employeeWFHEntity = await _employeeWFHRepository.GetEmployeeWFHByPrimaryKeyId(id);
if (employeeWFHEntity == null)
{
_logger.LogError("Record Not found and Null is returned whilst calling GetEmployeeWFHByPrimaryKeyId method from DeleteEmployeeTrainings having id - " + id);
}
return(employeeWFHEntity);
}
catch (Exception ex)
{
_logger.LogError($"Exception occured whilst calling a GetEmployeeWFHByPrimaryKeyId operation from DeleteEmployeeWFH for id = {id} -->" + ex);
throw;
}
}
public async Task <IActionResult> DeleteEmployeeWFH(string employeeId, int vacationTypeId, int wfhDaysID)
{
_logger.LogInformation($"In a delete employee WFH control to delete WFH details");
try
{
EmployeeWFHEntity employeeWFHEntity = new EmployeeWFHEntity();
employeeWFHEntity.EmployeeId = employeeId;
employeeWFHEntity.VacationTypeId = vacationTypeId;
employeeWFHEntity.WFHDaysId = wfhDaysID;
var statusInBoolean = await _employeeWFHDeleteService.DeleteEmployeeWFH(employeeWFHEntity);
return(Ok(statusInBoolean));
}
catch (Exception ex)
{
_logger.LogError($"Exception occured in a controller while calling delete WFH leaves" + ex);
throw;
}
}
public async Task <IEnumerable <EmployeeWFHEntity> > GetAllEmployeesByWFHIdAsync(EmployeeWFHEntity employeeWFHEntity)
{
string sQuery = "Select * from EmployeeWFH wfh, WFHDays wfhDays where wfhDays.Id=wfh.WFHDaysId and wfh.VacationTypeId=@VacationTypeId and wfh.WFHDaysId=@WFHDaysId";
return(await _baseRepository.GetAllEntitiesAsync(sQuery, employeeWFHEntity));
}
