public OrderDetailsWindow() { InitializeComponent(); Closing += (s, e) => { MessageBoxResult result = MessageBox.Show("Are you sure you want to close this window?", "WARNING!", MessageBoxButton.OKCancel, MessageBoxImage.Warning); if (result == MessageBoxResult.Cancel) { e.Cancel = true; } }; Loaded += (s, e) => { var setCodes = (from code in App.root.Data select code.Code).ToList(); SetCodeBox.ItemsSource = setCodes; OrderItemGrid.ItemsSource = orderItems; OrderItemGrid.Columns.RemoveAt(0); QualityCombo.ItemsSource = new List <string>() { "NM", "SP", "PLD", "HP" }; }; SetCodeBox.SelectionChanged += (s, e) => { SetNameBox.Clear(); }; SetNameBox.TextChanged += (s, e) => { SetCodeBox.SelectedIndex = -1; }; }
//private static SetList root = new SetList(); public StocksWindow() { InitializeComponent(); Loaded += (s, e) => { try { var setCodes = (from code in App.root.Data select code.Code).ToList(); SetBox.ItemsSource = setCodes; } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }; SetBox.SelectionChanged += (s, ev) => { SetNameBox.Clear(); }; SetNameBox.TextChanged += (s, ex) => { SetBox.SelectedIndex = -1; }; NameSearchBox.TextChanged += (s, eh) => { SetBox.SelectedIndex = -1; SetNameBox.Clear(); }; }
private void SearchSetsButton_Click(object sender, RoutedEventArgs e) { //SearchNameButton.IsEnabled = false; InvGrid.ItemsSource = null; DataTable dt = new DataTable(); SqlConnection sConn; string comm; if (SetBox.SelectedIndex.Equals(-1) && string.IsNullOrWhiteSpace(SetNameBox.Text)) { MessageBox.Show("No search parameter selected", "WARNING", MessageBoxButton.OK); return; } else if (SetBox.SelectedIndex > -1) { comm = "Select * from dbo.Inventory where SetCode = '" + SetBox.SelectedItem.ToString().ToUpper() + "'"; sConn = new SqlConnection(App.connstring); SqlCommand sComm = new SqlCommand(comm, sConn); sConn.Open(); using (SqlDataAdapter da = new SqlDataAdapter(sComm)) { da.Fill(dt); dt.Columns.Remove("InventoryId"); InvGrid.ItemsSource = dt.AsDataView(); } sConn.Close(); sConn.Dispose(); } else if (!string.IsNullOrWhiteSpace(SetNameBox.Text)) { comm = "Select * from dbo.Inventory where SetName like '%" + SetNameBox.Text + "%'"; sConn = new SqlConnection(App.connstring); SqlCommand sComm = new SqlCommand(comm, sConn); sConn.Open(); using (SqlDataAdapter da = new SqlDataAdapter(sComm)) { da.Fill(dt); dt.Columns.Remove("InventoryId"); InvGrid.ItemsSource = dt.AsDataView(); } sConn.Close(); sConn.Dispose(); } SetBox.SelectedIndex = -1; SetNameBox.Clear(); NameSearchBox.Clear(); //SearchNameButton.IsEnabled = true; }