public SecurityModels.GetUsersResponse GetUsers(SecurityModels.GetListRequest getUsersRequest) { SecurityModels.GetUsersResponse getUsersResponse = new SecurityModels.GetUsersResponse(); List <SecurityModels.User> Users = new List <SecurityModels.User>(); using (SqlConnection con = new SqlConnection(securityConnectionString)) { using (SqlCommand cmd = new SqlCommand("GetUsers", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@searchParm", SqlDbType.VarChar, 30).Value = getUsersRequest.searchParm; cmd.Parameters.Add("@pageSize", SqlDbType.Int, 0).Value = getUsersRequest.pageSize; cmd.Parameters.Add("@pageNumber", SqlDbType.Int, 0).Value = getUsersRequest.pageNumber; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); int recordNumber = 1; while (reader.Read()) { if (recordNumber == 1) { getUsersResponse.recordCount = Convert.ToInt32(reader["recordCount"].ToString()); } Users.Add(new SecurityModels.User { id = Convert.ToInt32(reader["ID"].ToString()), userName = reader["UserName"].ToString(), firstName = reader["firstName"].ToString(), lastName = reader["lastName"].ToString(), email = reader["Email"].ToString(), active = Convert.ToBoolean(reader["Active"].ToString()) }); } getUsersResponse.users = Users; } con.Close(); } return(getUsersResponse); }
public IActionResult GetUsers([FromQuery] SecurityModels.GetListRequest getUsersRequest) { SecurityModels.GetUsersResponse getUserResponse = securityInventoryRepo.GetUsers(getUsersRequest); return(StatusCode(StatusCodes.Status200OK, getUserResponse)); }