We are using VS2012, WPF attempting to implement MVVM, C# and Postgresql as our database engine.
We require that the MainWindow have a combobox (CompanyID,CompanyName) that upon selected index changing, updates the current tab's usercontrols (which contain gridviews or other usercontrols with gridviews on them) populated by datasets requiring “CompanyID” parameter to pass through immediately for all objects within the current focused tab.
We have a combobox (cbStores) that is populated by a postgresql query that returns 6 stores (CompanyID,CompanyName). We have 8 tabs on the "MainWindow" (GM, New, Used, Parts, Service, Bodyshop, Office). Each tab has two or more user controls, each user control contains a "gridview" populated by a datasource. Below are 4 of these UserControls:
UserControl: Inventory, "SELECT * FROM inventory WHERE locationid=?"
UserControl: Deals, "SELECT * FROM Deals WHERE locationid=? AND dealstatus=?"
UserControl: Parts, "SELECT * FROM parts WHERE locationid=?"
UserControl: Payroll, "SELECT * FROM payroll WHERE locationid=? and employeeid=?"
I think this should be enough to provide the foundation, let me know if you need anything further.