/************************************************************************************************************* ************************************************************************************************************** **************************************************************************************************************/ /************************************************************************************************************* * ------------------------------------Lädt-alle-Benutzer-aus-der-Datenbank-------------------------------------- **************************************************************************************************************/ private void LoadUserFromDb() { SqlConnection con = new SqlConnection(); con.ConnectionString = (SqlHelper.GetSqlConnectionString()); string strSQL = "select idBenutzer, Benutzername From Benutzer order by idBenutzer"; SqlCommand cmd = new SqlCommand(strSQL, con); con.Open(); string strUsername = ""; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { strUsername = reader["Benutzername"].ToString(); if (strUsername != "") { ListboxItem item = new ListboxItem(); item.Username = strUsername; item.UserID = (int)reader["idBenutzer"]; this.lstbAllUsers.Items.Add(item); } } reader.Close(); con.Close(); }
// ------------------------------------------------------ // // ISelectionProvider interface implementation // // ------------------------------------------------------ // Returns an enumerator over the current selection. IRawElementProviderSimple[] ISelectionProvider.GetSelection() { int count = Length; int countSelection = IsMultipleSelection() ? GetSelectionCount() : 1; if (count <= 0 || countSelection <= 0) { return(null); } IRawElementProviderSimple[] selection = new IRawElementProviderSimple[countSelection]; int index = 0; for (int itemPos = 0; itemPos < count; itemPos++) { if (ListboxItem.IsSelected(_hwnd, itemPos)) { selection[index] = CreateListboxItem(itemPos); index++; } } if (index == 0) { return(null); } return(selection); }
/************************************************************************************************************* ************************************************************************************************************** **************************************************************************************************************/ /************************************************************************************************************* * ----------------------------Speichert-die-Weitergabe-Tabelle-in-der-Datenbank--------------------------------- **************************************************************************************************************/ private void btnSave_Click_1(object sender, EventArgs e) { int i = 0; int nMaxID = SqlHelper.GetMaxID("idBenutzerordner", "Benutzerordner"); SqlConnection con = new SqlConnection(); con.ConnectionString = (SqlHelper.GetSqlConnectionString()); string strSQL = "Delete from Benutzerordner where ID_Ordner = @m_nFolderID"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = strSQL; cmd.Parameters.AddWithValue("@m_nFolderID", m_nFolderID); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); for (i = 0; i < lstbChosenUsers.Items.Count; i++) { ListboxItem item = (ListboxItem)lstbChosenUsers.Items[i]; nMaxID = nMaxID + 1; if (item != null) { SqlHelper.SendQueryToDb("Insert into Benutzerordner values (" + nMaxID + ", " + item.UserID + ", " + m_nFolderID + ", " + i + ", 0)"); } } MessageBox.Show("Einträge wurden gespeichert.", "Gespeichert"); }
/************************************************************************************************************* * --------------------Lädt-alle-Benutzer-aus-der-Datenbank,-die-in-der-Weitergabeliste-stehen------------------- **************************************************************************************************************/ private void LoadChosenUserFromDb() { SqlConnection con = new SqlConnection(); con.ConnectionString = (SqlHelper.GetSqlConnectionString()); string strSQL = "select idbenutzer, Benutzername From Benutzer join Benutzerordner on idBenutzer = ID_Benutzer where ID_Ordner = @m_nFolderID order by Position "; SqlCommand cmd = new SqlCommand(strSQL, con); cmd.Parameters.AddWithValue("@m_nFolderID", m_nFolderID); con.Open(); string strUsername = ""; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { strUsername = reader["Benutzername"].ToString(); if (strUsername != "") { ListboxItem item = new ListboxItem(); item.Username = strUsername; item.UserID = (int)reader["idBenutzer"]; this.lstbChosenUsers.Items.Add(item); } } reader.Close(); con.Close(); }
/************************************************************************************************************* ************************************************************************************************************** **************************************************************************************************************/ /************************************************************************************************************* * ------------------------------Löscht-das-markierte-Objekt-aus-der-Weitergabe-Tabelle-------------------------- **************************************************************************************************************/ private void btnDeleteChosesUser_Click(object sender, EventArgs e) { ListboxItem item = (ListboxItem)this.lstbChosenUsers.SelectedItem; if (item != null) { this.lstbChosenUsers.Items.Remove(item); } }
/************************************************************************************************************* ************************************************************************************************************** **************************************************************************************************************/ /************************************************************************************************************* ************************************************************************************************************** **************************************************************************************************************/ private void btnInsertItem_Click(object sender, EventArgs e) { ListboxItem item = (ListboxItem)this.lstbAllUsers.SelectedItem; if (item != null) { this.lstbChosenUsers.Items.Insert(this.lstbChosenUsers.SelectedIndex + 1, item); } }
/************************************************************************************************************* ************************************************************************************************************** **************************************************************************************************************/ /************************************************************************************************************* * ------------------Kopiert-den-Benutzer-aus-der-allgemeinen-Tebelle-in-die-Weitergabe-Tabelle------------------ **************************************************************************************************************/ private void btnAddUser_Click(object sender, EventArgs e) { ListboxItem item = (ListboxItem)this.lstbAllUsers.SelectedItem; if (item != null) { this.lstbChosenUsers.Items.Add(item); } }
// Detect if there any selections in // This is used by the WindowsListBoxItem class // returns true if any items are selected private bool HasSelection() { int i, count; for (i = 0, count = Length; i < count && !ListboxItem.IsSelected(_hwnd, i); i++) { ; } return(i < count); }
// Detect if listbox has any element except skipItem selected // This is used by the WindowsListBoxItem class // returns true if any items private bool HasOtherSelections(int skipItem) { for (int i = 0, count = Length; i < count; i++) { if (i != skipItem && ListboxItem.IsSelected(_hwnd, i)) { return(true); } } return(false); }
private int GetOtherSelection(int skipItem) { for (int i = 0, count = Length; i < count; i++) { if (i != skipItem && ListboxItem.IsSelected(_hwnd, i)) { // Win32 listbox items are 0 based, UIAutomation listbox items are 1 based. return(i + 1); } } return(NativeMethods.LB_ERR); }
public ListBoxItem(ListboxItem edititem, int count) { InitializeComponent(); this.DataContext = this; editcount = count; item = new ListboxItem(); item = edititem; GameNameTxtbox.Text = item.ItemName; PriceTxtBox.Text = item.ItemPrice.ToString(); ImagePathTxtbox.Text = item.ItemImagePath; Operatingtxtbox.Text = item.ItemOperatingSystem; Yeartxtbox.Text = item.ItemYear.ToString(); }
// Adds this element to the selection void ISelectionItemProvider.AddToSelection() { // Check that control can be interacted with. // This state could change anytime if (!SafeNativeMethods.IsWindowEnabled(_hwnd)) { throw new ElementNotEnabledException(); } // check if item already selected if (ListboxItem.IsSelected(_hwnd, _item) && !_listBox.IsParentedByCombo()) { // if it is a combo, then always perform the selection otherwise the listbox won't disappear return; } bool multipleSelection = _listBox.IsMultipleSelection(); // object does not support multi-selection if (!multipleSelection) { IRawElementProviderSimple container = ((ISelectionItemProvider)this).SelectionContainer; bool selectionRequired = container != null ? ((ISelectionProvider)container).IsSelectionRequired : true; // For single selection containers that IsSelectionRequired == false and nothing is selected // an AddToSelection is valid. if (selectionRequired || _listBox.HasSelection()) { throw new InvalidOperationException(SR.Get(SRID.DoesNotSupportMultipleSelection)); } } if (_listBox.IsParentedByCombo()) { // if this is a combo and the listbox is not displayed the selection will not stick, so // display the listbox before doing the select. if (((IExpandCollapseProvider)_listBox._parent).ExpandCollapseState == ExpandCollapseState.Collapsed) { ((IExpandCollapseProvider)_listBox._parent).Expand(); } } // At this point we know: Item either supports multiple selection or nothing // is selected in the list // Try to select an item if (!Select(multipleSelection)) { throw new InvalidOperationException(SR.Get(SRID.OperationCannotBePerformed)); } }
protected bool combobox_SelectionChanged(WindowEventArgs e) { ListboxItem li = mCombobox.getSelectedItem(); if (li == null) { mLog.LogMessage(string.Format("ComboBox Selection Changed unable to getSelectedItem ")); } else { mLog.LogMessage(string.Format("ComboBox Selection Changed item {0}, {1}", li.getID(), li.getText())); } return(true); }
public static int Show(ListboxItem[] values, Font font, int defaultSelection = 0, bool zebraStripe = false) { if (values == null) { return(-1); } var li = new ListboxItem[values.Length]; for (int i = 0; i < li.Length; i++) { li[i] = new ListboxItem(values[i].Text); } return(InternalShow(li, font, defaultSelection, zebraStripe)); }
private void EditButton_Click(object sender, RoutedEventArgs e) { GameNameTxtbox.Text = GameNameTxtbox.Text.Trim(); PriceTxtBox.Text = PriceTxtBox.Text.Trim(); ImagePathTxtbox.Text = ImagePathTxtbox.Text.Trim(); Operatingtxtbox.Text = Operatingtxtbox.Text.Trim(); Yeartxtbox.Text = Yeartxtbox.Text.Trim(); if (GameNameTxtbox.Text.Length > 0) { if (PriceTxtBox.Text.Length > 0) { double price = 0; try { price = Convert.ToDouble(PriceTxtBox.Text); } catch (Exception) { MessageBox.Show("Price is not correct.Please Again", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); return; } if (ImagePathTxtbox.Text.Length > 0) { if (File.Exists(ImagePathTxtbox.Text) == true) { if (Operatingtxtbox.Text.Length > 0) { if (Yeartxtbox.Text.Length > 0) { int year = 0; try { year = Convert.ToInt32(Yeartxtbox.Text); } catch (Exception) { MessageBox.Show("Year is not correct.Please Again", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); return; } item = new ListboxItemnmsp.ListboxItem(); item.ItemName = GameNameTxtbox.Text; item.ItemPrice = price; item.ItemImagePath = ImagePathTxtbox.Text; item.ItemOperatingSystem = Operatingtxtbox.Text; item.ItemYear = year; this.DialogResult = true; this.Close(); } } else { MessageBox.Show("Operating must not be empty", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("There is no file in ImagePath.Path is not correct", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("ImagePath must not be empty", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("Price must not be empty", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("GameName must not be empty", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } }