private void ProductNameComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            //Handling sqlserver connection error
            try
            {
                SqlConnection sCon = SqlServer.GetConnection();
                sCon.Open();
                sCon.Close();
                sqlConnection = true;
            }
            catch (Exception ex)
            {
                LoggerUtil.LogMessageToFile("Application SQL DB ISSUE : " + ex.ToString() + Environment.NewLine + ex.StackTrace.ToString());
                sqlConnection = false;
            }

            if (sqlConnection)
            {
                ProgressBarDisplay();

                try
                {
                    TestDllNameComboBox.Items.Clear();
                    SelectCategoryComboBox.Items.Clear();
                    SelectModuleComboBox.Items.Clear();
                    SelectTestCaseComboBox.Items.Clear();

                    SelectedProduct = ProductNameComboBox.SelectedItem.ToString();
                    if (SelectedProduct.ToUpper() == "MADE2MANAGE")
                    {
                        Browse.Visibility          = System.Windows.Visibility.Visible;
                        FileNameTextBox.Visibility = System.Windows.Visibility.Visible;
                    }
                    else
                    {
                        Browse.Visibility          = System.Windows.Visibility.Hidden;
                        FileNameTextBox.Visibility = System.Windows.Visibility.Hidden;
                    }
                    Hashtable ht = ProductConfiguration.GetProductConfigurationHashtable(ProductNameComboBox.SelectedItem.ToString());
                    BuildDefinition = ht["BuildDefinition"].ToString();
                    TestDlls        = ht["TestDlls"].ToString();
                    string testBuildNumber = null;
                    foreach (string str in ht["Type"].ToString().Split(','))
                    {
                        LoadSettingsElements(str);
                    }
                    try
                    {
                        foreach (string str in BuildDefinition.Split(','))
                        {
                            testBuildNumber = TfsUtils.GetLastSuccededDropLocation(ProductNameComboBox.SelectedItem.ToString(), str);
                            ProductDetails.CopyBuildToLocalMachine(TfsUtils.GetLatestTestBuild(), str);
                        }
                    }
                    catch (Exception exception)
                    {
                        if (exception.ToString().Contains("TeamFoundation"))
                        {
                            //throw exception;
                        }
                        DisplayErrorMessage("Loading Test Builds Failed - " + exception.Message);
                    }
                    if (testBuildNumber != null)
                    {
                        var a = testBuildNumber.Split('\\');
                        testBuildNumber = a[a.Length - 1];
                    }
                    TestBuildNameTextBox.Text = testBuildNumber;

                    foreach (var str in TestDlls.Split(','))
                    {
                        var temp = str.Split('\\');
                        TestDllNameComboBox.Items.Add(temp[temp.Length - 1]);
                    }

                    string cmp = Compatibility.ComparisonLogic(ProductNameComboBox.SelectedValue.ToString());

                    if (cmp != null)
                    {
                        DisplayContentMessage(cmp, "Compatibility");
                    }
                }
                catch (Exception ex)
                {
                    DisplayErrorMessage(ex.ToString());
                    // waitLabel.Visibility = System.Windows.Visibility.Hidden;
                }
                finally
                {
                    InactiveDisplayComponents();
                }
            }
            else
            {
                DisplayErrorMessage("Unable to Connect to Test Server." + Environment.NewLine + "Please Navigate to [Settings] -> [REPORT AN ISSUE] and report this issue.");
            }
        }