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