} //end inventory click /// <summary> /// gets the inventory data from the database. /// I am also creating a dictionary to refer back to. I use this in the Add/Update click event. /// This prevents additional reads to the database to retrieve the ItemCode. /// </summary> public void populateInventory() { ///try catch block to handle exceptions try { //gets data from database and load into dgInventoryItems //Method should be run in initialize method ///sQuery for inventory items String sQuery = mydb.SelectInventoryItems(); ///database query dtInventory = db.FillSqlDataTable(sQuery); ///inventory items set to default view dgInventoryItems.ItemsSource = dtInventory.DefaultView; ///foreach loop to populate the grid foreach (DataRow row in dtInventory.Rows) { inventoryDictionary.Add(row[1].ToString(), row[0].ToString()); } } catch (Exception)///catch exceptions { MessageBox.Show(MethodInfo.GetCurrentMethod().DeclaringType.Name); } //end catch } //end populateInventory()
private void invoiceIDComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { ///Disable other drop down menu's if this is selected if (invoiceIDComboBox.IsEnabled) { invoiceDateComboBox.IsEnabled = false; invoiceAmountComboBox.IsEnabled = false; } ///The two other drop down menu's will be disbled when this is being used ///When selected this combo box will show a drop down list with invoice ID's ///The user will be able to highlight/select an ID and it will be recieved ///by the dataGrid1 to show that specific invoice only Console.Write("textbox Value: " + invoiceIDComboBox.SelectedItem); //get query needed find invoice String sQuery = mydb.SelectInvoiceID(invoiceIDComboBox.SelectedItem.ToString()); //datatable used to fget table data. dt = db.FillSqlDataTable(sQuery); //fill the datagrid invoiceGrid1.ItemsSource = dt.DefaultView; }
/// <summary> /// Populates datagrid with all items. /// </summary> private void populateDatagridInv() { try { // Gets all items from the database sSQL = mydb.SelectInventoryItems(); dt = db.FillSqlDataTable(sSQL); dataGrid.ItemsSource = dt.DefaultView; // Inserts items into the datagrid. foreach (DataRow row in dt.Rows) { inventoryDictionary.Add(row[1].ToString(), row[0].ToString()); } } catch (Exception) { MessageBox.Show(MethodInfo.GetCurrentMethod().DeclaringType.Name); } }