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();
}
