private void GetSpecialLabelTypesFromDataBase()
        {
            string ConnectionString = ConfigValues.GetConnectionString();

            SqlDataReader myReader      = null;
            SqlConnection TheConnection = null;

            try
            {
                TheConnection = new SqlConnection(ConnectionString);

                TheConnection.Open();

                SqlCommand myCommand = new SqlCommand("select Condition_Name, Attribute_Value from part_flags where Part_Number = '" + PartNumber + "' and Part_Version = '" + PartVersion + "'", TheConnection);
                myReader = myCommand.ExecuteReader();

                while (myReader.Read())
                {
                    string sCondition = myReader["Condition_Name"].ToString();
                    string sAttribute = myReader["Attribute_Value"].ToString();

                    // TODO: ja - store these in config?
                    SpecialAttributes.Add(sCondition);
                }

                myReader.Close();
                TheConnection.Close();
            }
            catch (System.Exception ex)
            {
                Console.WriteLine(ex.ToString());
                myReader.Close();
                TheConnection.Close();
            }
        }
        // ja - new way ....
        // TODO: ja - move to new class?
        private void AssignLabelTypesFromDataBase()
        {
            string ConnectionString = ConfigValues.GetConnectionString();

            SqlDataReader myReader      = null;
            SqlConnection TheConnection = null;

            try
            {
                TheConnection = new SqlConnection(ConnectionString);

                TheConnection.Open();

                // ja - get the label information from the database view
                SqlCommand myCommand = new SqlCommand("select * from label_Data where Part_Number = '" + PartNumber + "' and Part_Version = '" + PartVersion + "'", TheConnection);
                myReader = myCommand.ExecuteReader();

                // ja - loop through all of the assigned label types
                while (myReader.Read())
                {
                    // ja - get the information from the database
                    string sLocation     = myReader["Location_Name"].ToString();
                    string sType         = myReader["Label_Type_Name"].ToString();
                    string sQty          = myReader["Print_Qty"].ToString();
                    string sCustomerName = myReader["Customer_Name"].ToString();

                    LabelTypes  type = (LabelTypes)Enum.Parse(typeof(LabelTypes), sType);
                    PrinterArea area = (PrinterArea)Enum.Parse(typeof(PrinterArea), sLocation);

                    // ja - if the printer area matches the passed in area (Physical Printer) add to queue
                    if (area == ePrinterArea)
                    {
                        LabelProperitys lp = new LabelProperitys
                        {
                            CustomerName  = sCustomerName,
                            LabelQuanity  = Convert.ToInt32(sQty),
                            AssingedLabel = type
                        };

                        AssignedLabels.Add(lp);
                    }
                }

                myReader.Close();
                TheConnection.Close();
            }
            catch (System.Exception ex)
            {
                Console.WriteLine(ex.ToString());
                myReader.Close();
                TheConnection.Close();
            }
        }