private void LoadAll() { dt_items = LoadDatagrid(); itemsDataGrid.ItemsSource = dt_items.DefaultView; dt_locations = LoadLocationsFromDB(); placeList = new ArrayList(); foreach (DataRow r in dt_locations.Rows) { ItemNameClass place = new ItemNameClass(Int32.Parse(r[0].ToString()), r[1].ToString()); placeList.Add(place); } locationComboBox.ItemsSource = placeList; dt_types = LoadPartTypesFromDB(); typelist = new ArrayList(); foreach (DataRow r in dt_types.Rows) { ItemNameClass itemtype = new ItemNameClass(Int32.Parse(r[0].ToString()), r[1].ToString()); typelist.Add(itemtype); } typeComboBox.ItemsSource = typelist; dt_suppliers = LoadSuppliersFromDB(); supplierlist = new ArrayList(); foreach (DataRow r in dt_suppliers.Rows) { ItemNameClass sup = new ItemNameClass(Int32.Parse(r[0].ToString()), r[1].ToString()); supplierlist.Add(sup); } supplierComboBox.ItemsSource = supplierlist; }
private void OK_Btn_Click(object sender, RoutedEventArgs e) { SQLiteCommand sql_cmd = database.CreateCommand(); String sql_string; if (iDTBox.Text == string.Empty) { // if iDTBox is empty then this is a new record int grpindex = typeGroupComboBox.SelectedIndex; if (grpindex == -1) { // there is no group type selected sql_string = "INSERT INTO ItemType (ItemType) VALUES ('" + typeNameTBox.Text + "');"; } else { // there is a group selected ItemNameClass selected = (ItemNameClass)itemtypes[grpindex]; sql_string = "INSERT INTO ItemType (ItemType, TypeGroup) VALUES ('" + typeNameTBox.Text + "', '" + selected.getID() + "');"; } sql_cmd.CommandText = sql_string; sql_cmd.ExecuteNonQuery(); LoadDataGrid(); } else // else this is an update { int index = Int32.Parse("0" + iDTBox.Text); int grpindex = typeGroupComboBox.SelectedIndex; if (grpindex == -1) { // if no group selected sql_string = "UPDATE ItemType SET ItemType = '" + typeNameTBox.Text + "' WHERE typeID = '" + index + "';"; } else { ItemNameClass selected = (ItemNameClass)itemtypes[grpindex]; sql_string = "UPDATE ItemType SET ItemType = '" + typeNameTBox.Text + "', TypeGroup = '" + selected.getID() + "' WHERE typeID = '" + index + "';"; } sql_cmd.CommandText = sql_string; sql_cmd.ExecuteNonQuery(); LoadDataGrid(); } // clear all textboxes and reset okbtn to add new iDTBox.Text = string.Empty; typeNameTBox.Text = string.Empty; typeGroupComboBox.SelectedIndex = -1; OK_Btn.Content = "Add New"; }
private void LoadDataGrid() { SQLiteCommand sql_cmd = database.CreateCommand(); sql_cmd.CommandText = "SELECT * FROM Item"; dt_items = new DataTable(); SQLiteDataAdapter adapter = new SQLiteDataAdapter(sql_cmd); adapter.Fill(dt_items); itemsDataGrid.ItemsSource = dt_items.DefaultView; // need to also load location, suppliers and itemtypes sql_cmd.CommandText = "SELECT * FROM Locations"; SQLiteDataReader reader = sql_cmd.ExecuteReader(); placelist = new ArrayList(); while (reader.Read()) { // placelist.Add(reader.GetString(1)); places = new ItemNameClass(reader.GetInt32(0), reader.GetString(1)); placelist.Add(places); } locComboBox.ItemsSource = placelist; reader.Close(); // need to also load itemtypes sql_cmd.CommandText = "SELECT * FROM ItemType"; reader = sql_cmd.ExecuteReader(); typelist = new ArrayList(); while (reader.Read()) { types = new ItemNameClass(reader.GetInt32(0), reader.GetString(1)); typelist.Add(types); } typeComboBox.ItemsSource = typelist; reader.Close(); // need to also load suppliers sql_cmd.CommandText = "SELECT * FROM Suppliers"; reader = sql_cmd.ExecuteReader(); supplierlist = new ArrayList(); while (reader.Read()) { suppliers = new ItemNameClass(reader.GetInt32(0), reader.GetString(1)); supplierlist.Add(suppliers); } supplierComboBox.ItemsSource = supplierlist; reader.Close(); }
private void LoadDataGrid() { SQLiteCommand sql_cmd = database.CreateCommand(); dt_itemTypes = new DataTable(); sql_cmd.CommandText = "SELECT * FROM ItemType"; SQLiteDataAdapter adapter = new SQLiteDataAdapter(sql_cmd); adapter.Fill(dt_itemTypes); typeDataGrid.ItemsSource = dt_itemTypes.DefaultView; itemtypes.Clear(); foreach (DataRow r in dt_itemTypes.Rows) { types = new ItemNameClass(Int32.Parse(r[0].ToString()), r[1].ToString()); itemtypes.Add(types); } typeGroupComboBox.ItemsSource = itemtypes; }
private void supplierComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { // user has made a selection of supplier in the supplier combo box. // should reset other control to avoid confusion int selected = supplierComboBox.SelectedIndex; if (selected != -1) { lookforTBox.Text = String.Empty; locationComboBox.SelectedIndex = -1; typeComboBox.SelectedIndex = -1; ItemNameClass sup = (ItemNameClass)supplierComboBox.SelectedItem; int supp_Id = sup.getID(); DataTable dt_found = new DataTable(); dt_found = retrieveItemsBySupplier(supp_Id); itemsDataGrid.ItemsSource = dt_found.DefaultView; } }
private void locationComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { // called when user has selected a location in the location combo box. // should reset other controls int selected = locationComboBox.SelectedIndex; if (selected != -1) { lookforTBox.Text = String.Empty; typeComboBox.SelectedIndex = -1; supplierComboBox.SelectedIndex = -1; // confirmed selection made ItemNameClass loc = (ItemNameClass)locationComboBox.SelectedItem; int loc_ID = loc.getID(); DataTable dt_found = new DataTable(); dt_found = retrieveItemsByLocation(loc_ID); itemsDataGrid.ItemsSource = dt_found.DefaultView; } }
private void LoadDatagrid() { dt_locations = new DataTable(); SQLiteCommand load_cmd = database.CreateCommand(); String load_string; load_string = "SELECT * FROM Locations"; load_cmd.CommandText = load_string; SQLiteDataAdapter adapter = new SQLiteDataAdapter(load_cmd); adapter.Fill(dt_locations); locationdataGrid.ItemsSource = dt_locations.DefaultView; places.Clear(); foreach (DataRow r in dt_locations.Rows) { place = new ItemNameClass(Int32.Parse(r[0].ToString()), r[1].ToString()); places.Add(place); } groupFkCombobox.Items.DetachFromSourceCollection(); groupFkCombobox.ItemsSource = places; }
private void OK_Btn_Click(object sender, RoutedEventArgs e) { SQLiteCommand sql_cmd = database.CreateCommand(); String sql_string; // if the TBox is empty then this is a new entry else it is an update if (iDTBox.Text == String.Empty) { // this is a new entry // add to location table // MessageBox.Show("This is a new entry "); int groupindex = groupFkCombobox.SelectedIndex; if (groupindex == -1) { sql_string = "INSERT INTO Locations (Location, Type) VALUES ('" + nameTBox.Text + "', '" + typeTBox.Text + "');"; } else { ItemNameClass selected = (ItemNameClass)places[groupindex]; sql_string = "INSERT INTO Locations (Location, Type, LocationFK) VALUES ('" + nameTBox.Text + "', '" + typeTBox.Text + "', '" + selected.getID() + "');"; } // MessageBox.Show(sql_string); sql_cmd.CommandText = sql_string; sql_cmd.ExecuteNonQuery(); LoadDatagrid(); } else { // this is an update int index = Int32.Parse("0" + iDTBox.Text); { // update the record at index // MessageBox.Show("This is an update on entry " + index); int groupindex = groupFkCombobox.SelectedIndex; if (groupindex == -1) { sql_string = "UPDATE Locations SET Location, = '" + nameTBox.Text + "', Type = '" + typeTBox.Text + "' WHERE locID = '" + index + "';"; } else { ItemNameClass selected = (ItemNameClass)places[groupindex]; sql_string = "UPDATE Locations SET Location = '" + nameTBox.Text + "', Type = '" + typeTBox.Text + "', LocationFK = '" + selected.getID() + "' WHERE locID = '" + index + "';"; } // MessageBox.Show(sql_string); sql_cmd.CommandText = sql_string; sql_cmd.ExecuteNonQuery(); LoadDatagrid(); } } // clear the entries in the textboxes iDTBox.Text = String.Empty; nameTBox.Text = String.Empty; typeTBox.Text = String.Empty; groupFkCombobox.SelectedIndex = -1; OK_Btn.Content = "Add New"; // default, with empty textboxes , is Add new record }