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
}
