public void FetchAssets()
{
string query = string.Format(AssetServiceMySqlQueries.Select_Assets, AssetServiceConfig.CustomerUID);
MySqlDataReader reader = MySqlUtil.ExecuteMySQLQuery(MySqlConnectionString, query);
while (reader.Read())
{
assetUIDS.Add(reader["HEX(AssetUID)"].ToString());
}
MySqlUtil.CloseConnection();
List <Guid> assets = new List <Guid>();
assets = assetUIDS.ConvertAll(Guid.Parse);
assetUIDS.Clear();
assetUIDS = assets.Select(a => Convert.ToString(a)).ToList();
}