private void fillIDS() { if (cmbWizardType.SelectedValue.ToString() == addNewAccount) { using (SqlConnection sqlConnection = new SqlConnection(FrmWizard.GetFromWizardSettings("OLTP.Connection.string"))) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand("SELECT (MAX(Account_ID)+1) FROM User_GUI_Account", sqlConnection)) { txtAccountID.Text = sqlCommand.ExecuteScalar().ToString(); } } FillClientID(int.Parse(txtAccountID.Text)); FillScopeID(int.Parse(txtAccountID.Text)); } }
private void FillCPAReplaceComboBox() { cmbCpaReplaceTo.DataSource = null; List <string> comboValues = new List <string>(); //Load default values from app.config string[] googleDefaultValues = FrmWizard.GetFromWizardSettings("EdgeBI.Wizards.GoogleConversions").Split(','); foreach (string str in googleDefaultValues) { string itemReplaced = str; foreach (ListViewItem item in listViewBeData.Items) { if (item.Text == str) { itemReplaced = item.SubItems[1].Text; break; } } comboValues.Add(itemReplaced); } foreach (ListViewItem item in listViewBeData.Items) { if (item.SubItems[0].Text.StartsWith("BO Client Specific")) { comboValues.Add(item.SubItems[1].Text.Trim()); } } cmbCpaReplaceTo.DataSource = comboValues; //cmbBeData.ValueMember = "Key"; //cmbBeData.DisplayMember = "Value"; //cmbCPA.DataSource = _CPAData.ToList(); //cmbCPA.ValueMember = "Key"; //cmbCPA.DisplayMember = "Value"; }
private void InitLaizeComboBoxs() { //Clean the combo boxs cmbBeData.DataSource = null; _BEDataValues.Clear(); //Load default values from app.config string[] googleDefaultValues = FrmWizard.GetFromWizardSettings("EdgeBI.Wizards.GoogleConversions").Split(','); foreach (string str in googleDefaultValues) { if (!_BEDataValues.ContainsKey("AccountSettings." + str)) { _BEDataValues.Add("AccountSettings." + str, str); } } _BEDataValues.Add("BEData", "BEData"); int numOfCpa = FrmWizard.GetCountLikeSettings("AccountSettings.ACQ"); for (int i = 1; i <= numOfCpa; i++) { string value = "AccountSettings.ACQ" + i.ToString(); if (!_CPAData.ContainsKey("AccountSettings." + value)) { _CPAData.Add("AccountSettings." + value, "Acquisition" + i.ToString()); } } cmbBeData.DataSource = _BEDataValues.ToList(); cmbBeData.ValueMember = "Key"; cmbBeData.DisplayMember = "Value"; cmbCPA.DataSource = _CPAData.ToList(); cmbCPA.ValueMember = "Key"; cmbCPA.DisplayMember = "Value"; }
private void txtBIScopeID_Validated(object sender, EventArgs e) { try { int scopeId; if (int.TryParse(txtBIScopeID.Text.Trim(), out scopeId)) { if (cmbWizardType.SelectedValue.ToString() == addNewBI || cmbWizardType.SelectedValue.ToString() == NewBIForActiveAccount) { using (SqlConnection sqlConnection = new SqlConnection(FrmWizard.GetFromWizardSettings("OLTP.Connection.string"))) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand(@"Select Account_Name From User_GUI_Account Where Scope_ID=@Scope_ID", sqlConnection)) { sqlCommand.Parameters.AddWithValue("@Scope_ID", int.Parse(txtBIScopeID.Text.Trim())); using (SqlDataReader reader = sqlCommand.ExecuteReader()) { if (reader.Read()) { txtBIScopName.Text = reader[0].ToString(); } } if (cmbWizardType.SelectedValue.ToString() == NewBIForActiveAccount && !string.IsNullOrEmpty(txtBIScopeID.Text)) { txtRole.Text = string.Format("Role {0}", txtBIScopeID.Text.Trim()); } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }