public void GetCustomersFromDBByUserUID(string query) { MySqlDataReader reader; reader = MySqlUtil.ExecuteMySQLQuery(CustomerServiceConfig.MySqlConnection, query); if (reader.HasRows) { while (reader.Read()) { CustDetails.CustomerUID = reader["CustomerUID"].ToString().ToLower(); CustDetails.Name = reader["CustomerName"].ToString(); if (reader["CustomerTypeID"].ToString() == "1") { CustDetails.CustomerType = "Dealer"; CustDetails.NetworkDealerCode = reader["NetworkDealerCode"].ToString(); CustDetails.DisplayName = "(" + CustDetails.NetworkDealerCode + ") " + CustDetails.Name; } else if (reader["CustomerTypeID"].ToString() == "2") { CustDetails.CustomerType = "Customer"; CustDetails.NetworkCustomerCode = reader["NetworkCustomerCode"].ToString(); CustDetails.DisplayName = "(" + CustDetails.NetworkCustomerCode + ") " + CustDetails.Name; } CustomersForUserAccountDBResult.Customers.Add(CustDetails); } } }
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(); }