public async Task <IActionResult> GetEmployeesAsync([FromQuery] EmployeeQueryParams queryParams)
{
var employees = await _objEmployee.GetAllEmployeesAsync(queryParams);
var employeeToReturn = _mapper.Map <IEnumerable <EmployeeForListDto> >(employees);
return(Ok(employeeToReturn));
}
public async Task <IEnumerable <Employee> > GetAllEmployeesAsync(EmployeeQueryParams queryParams)
{
try
{
List <Employee> lstemployee = new List <Employee>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spGetAllEmployees", con);
cmd.CommandType = CommandType.StoredProcedure;
if (!string.IsNullOrEmpty(queryParams.SearchText))
{
cmd.Parameters.AddWithValue("@SearchText", queryParams.SearchText);
}
cmd.Parameters.AddWithValue("@PageNumber", queryParams.PageNumber);
cmd.Parameters.AddWithValue("@PageSize", queryParams.PageSize);
con.Open();
SqlDataReader rdr = await cmd.ExecuteReaderAsync();
while (rdr.Read())
{
Employee employee = new Employee();
employee.ID = Convert.ToInt32(rdr["EmployeeID"]);
employee.Name = rdr["Name"].ToString();
employee.Gender = rdr["Gender"].ToString();
employee.Department = rdr["Department"].ToString();
employee.City = rdr["City"].ToString();
employee.TotalDataCount = DataHelper.SafeGetInt(rdr, "Total"); //rdr.IsDBNull(rdr["Total"]) rdr["Total"].ToString();
employee.CreatedDate = DataHelper.SafeGetDate(rdr, "CreatedDate");
employee.Dob = DataHelper.SafeGetDate(rdr, "Dob");
lstemployee.Add(employee);
}
con.Close();
}
return(lstemployee.OrderByDescending(x => x.CreatedDate));
}
catch (Exception ex)
{
throw ex;
}
}
