/// <summary>
///
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
// GET: api/ManageEmployess
public ResponseModel <List <EmployeeListViewModel> > GetEmployeeList([FromUri] EmployeeViewModelFilter filter)
{
ResponseModel <List <EmployeeListViewModel> > response = new ResponseModel <List <EmployeeListViewModel> >();
response = _manageEmployeService.GetEmployeeList(filter);
return(response);
}
public ResponseModel <List <EmployeeListViewModel> > GetEmployeeList(EmployeeViewModelFilter filter)
{
ResponseModel <List <EmployeeListViewModel> > response = new ResponseModel <List <EmployeeListViewModel> >();
response.Entity = _manageEmployeRepository.GetEmployeeList(filter);
response.Status = true;
return(response);
}
public List <EmployeeListViewModel> GetEmployeeList(EmployeeViewModelFilter filter)
{
try
{
List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >();
Param.Add(new KeyValuePair <string, object>("@Offset", filter.Offset));
Param.Add(new KeyValuePair <string, object>("@Limit", filter.Limit));
Param.Add(new KeyValuePair <string, object>("@DateFrom", filter.DateFrom));
Param.Add(new KeyValuePair <string, object>("@DateTo", filter.DateTo));
Param.Add(new KeyValuePair <string, object>("@SearchText", filter.SearchText));
Param.Add(new KeyValuePair <string, object>("@SalaryRangeFrom", filter.SalaryRangeFrom));
Param.Add(new KeyValuePair <string, object>("@SalaryRangeTo", filter.SalaryRangeTo));
Param.Add(new KeyValuePair <string, object>("@Gender", filter.Gender));
Param.Add(new KeyValuePair <string, object>("@ImportDateFrom", filter.ImportedRangeFrom));
Param.Add(new KeyValuePair <string, object>("@ImportDateTo", filter.ImportedRangeTo));
SQLHandlers sqlh = new SQLHandlers();
return(sqlh.ExecuteAsList <EmployeeListViewModel>("[dbo].[usp_GetEmployeList]", Param));
}
catch (Exception ex)
{
throw;
}
}
