/// <summary>
/// Method Name : GetResignationEmployeeList
/// Author : Yogesh Parmar
/// Creation Date : 17 oct 2019
/// Purpose : Featching the list of ResignationEmployeeList Name from Database
/// Revision : By Nilesh Avsthi add Paging to this Method 18 oct 2019
/// </summary>
/// <param name="filter">filter</param>
/// <returns></returns>
public List <ResignationListViewModel> GetResignationEmployeeList(ResignationFilterViewModel filter)
{
var source = (from employee in _context.Employees
join domain in _context.Domains on employee.DomainId equals domain.DomainId
join technology in _context.Technologies on employee.TechnologyID equals technology.TechnologyId
join designation in _context.Designations on employee.DesignationId equals designation.DesignationId
join resignations in _context.Resignations on employee.EmployeeId equals resignations.EmployeeId
select new ResignationListViewModel
{
FirstName = employee.FirstName,
LastName = employee.LastName,
EmployeeCode = employee.EmployeeCode,
DomainName = domain.DomainName,
TechnologyName = technology.TechnologyName,
DesignationName = designation.DesignationName,
RaisedOnDate = resignations.RaisedOnDate,
ManagerId = employee.ManagerId,
ResignationId = resignations.ResignationId,
ResignationManagerId = resignations.ManagerId,
ResignationApprovedDate = resignations.ResignationApprovedDate,
ResignationStatus = resignations.ResignationStatus
}).ToList();
return(ApplyFilter(filter, source));
}
public IActionResult GetResignationEmployeeList([FromBody] ResignationFilterViewModel filter)
{
if (ModelState.IsValid)
{
return(Ok(_approvalResignationBLL.GetResignationEmployeeList(filter)));
}
return(BadRequest());
}
/// <summary>
/// Method Name : GetResignationEmployeeList
/// Author : Yogesh Parmar
/// Creation Date : 17 oct 2019
/// Purpose : Acess the Method from DAL Layer to BLL.
/// Revision : By Nilesh Avsthi add Paging to this Method 18 oct 2019
/// </summary>
/// <param name="filter">filter</param>
public List <ResignationListViewModel> GetResignationEmployeeList(ResignationFilterViewModel filter)
{
filter.SubId = _claims.UserId;
filter.Role = _claims.Roles[1];
if (filter.Role.Equals("HR"))
{
filter.SubId = "";
}
return(_approvalResignationDAL.GetResignationEmployeeList(filter));
}
public List <ResignationListViewModel> ApplyFilter(ResignationFilterViewModel filter, List <ResignationListViewModel> source)
{
if (filter.SubId != "")
{
source = source.Where(b => b.ManagerId == GetEmployeeId(filter.SubId)).ToList();
}
else
{
// source = source.Where(b => b.ResignationStatus.Equals("Accepted by RM") || b.ResignationStatus.Equals("accept by rm")).ToList();
}
if (filter?.FromDate != null)
{
if (filter.ToDate != null)
{
source = source.Where(x => x.RaisedOnDate >= filter.FromDate && x.RaisedOnDate <= filter.ToDate).ToList();
}
else
{
source = source.Where(x => x.RaisedOnDate >= filter.FromDate && x.RaisedOnDate <= DateTime.Now).ToList();
}
}
if (filter.DomainName != null)
{
source = source.Where(x => string.Equals(x.DomainName, filter.DomainName, StringComparison.CurrentCultureIgnoreCase)).ToList();
}
if (filter.TechnologyName != null)
{
source = source.Where(x => string.Equals(x.TechnologyName, filter.TechnologyName, StringComparison.CurrentCultureIgnoreCase)).ToList();
}
if (filter.DesignationName != null)
{
source = source.Where(x => string.Equals(x.DesignationName, filter.DesignationName, StringComparison.CurrentCultureIgnoreCase)).ToList();
}
if (filter.ResignationStatus != null)
{
source = source.Where(x => string.Equals(x.ResignationStatus, filter.ResignationStatus, StringComparison.CurrentCultureIgnoreCase)).ToList();
}
if (filter.EmployeeName != null)
{
source = source.Where(x => x.FirstName.StartsWith(filter.EmployeeName, StringComparison.CurrentCultureIgnoreCase)).ToList();
}
if (filter.EmployeeCode != 0 && filter.EmployeeCode != null)
{
source = source.Where(x => x.EmployeeCode == filter.EmployeeCode).ToList();
}
return(source.Skip((filter.PageNumber - 1) * filter.Limit).Take(filter.Limit).ToList());
}
/// <summary>
/// Method Name : GetResignationEmployeeList
/// Author : Yogesh Parmar
/// Creation Date : 17 oct 2019
/// Purpose : Featching the list of ResignationEmployeeList Name from Database
/// Revision : By Nilesh Avsthi add Paging to this Method 18 oct 2019
/// </summary>
/// <param name="paging">paging</param>
/// <param name="Id">Id</param>
public List <ResignationListViewModel> GetResignationEmployeeList(ResignationFilterViewModel filter)
{
return(_databaseQuery.GetResignationEmployeeList(filter));
}
