/// <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)); }