public Search_result rediscovery_data(string asset) { var Search_result = new Search_result(); String cmdText = "SELECT * from rediscovery where ictag = '" + asset + "'"; using (MySqlCommand cmd = new MySqlCommand(cmdText, conn)) { conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); //execure the reader while (reader.Read()) { Search_result.search_cpu = (reader["cpu"].ToString()); var temp_hdd = (reader["hdd"].ToString()); Regex digitsOnly = new Regex(@"[^\d]"); temp_hdd = digitsOnly.Replace(temp_hdd, ""); Search_result.is_SSD = (reader["has_SSD"].ToString()); Search_result.search_hdd = (long.Parse(temp_hdd)); Search_result.search_manu = (reader["brand"].ToString()); var temp_ram = reader["ram"].ToString(); temp_ram = digitsOnly.Replace(temp_ram, ""); Search_result.search_ram = (long.Parse(reader["ram"].ToString())); Search_result.search_model = (reader["model"].ToString()); Search_result.search_serial = (reader["serial"].ToString()); Search_result.search_optical_drive = (reader["optical_drive"].ToString()); Search_result.search_sku = (reader["pallet"].ToString()); } conn.Close(); } return(Search_result); }
public search_result(string asset) { Search_result = new Search_result(); Search_result = mysql_data.rediscovery_data(asset); //this is the viewModel for search flyout }