private void runFilteredQuery(String selectStmt, DatabaseShiz.ForEachResult onResult) { //get the selected item details var dateInfo = getSelectedDateTree(); var itemInfo = getSelectedItemTree(); var locInfo = getSelectedLocationTree(); //Get total sales String queryStr = selectStmt + " from " + tableName + " where "; //set time filter queryStr += generateTimeFilter(dateInfo); queryStr += generateItemFilter(itemInfo); queryStr += generateLocationFilter(locInfo); queryStr = finalizeQuery(queryStr); Console.WriteLine(queryStr); theDB.runQuery(queryStr); theDB.forEachResult(onResult); }
public Form1() { InitializeComponent(); try { //theDB = new DatabaseShiz("CURTIS_PC\\SQLEXPRESS", "CMPT491-Warehouse", "Curtis"); theDB = new DatabaseShiz("COMPSCI-PC", "CMPT491-Warehouse", "compsci"); MessageBox.Show("Connected to database."); } catch (Exception e) { MessageBox.Show(e.Message); Application.Exit(); } TreeNode firstLoc = makeLocationTree(); TreeNode firstDate = makeDateTree(); TreeNode firstItem = makeItemTree(); locationTree.Nodes.Add(firstLoc); dateTree.Nodes.Add(firstDate); productTree.Nodes.Add(firstItem); locationTree.SelectedNode = firstLoc; dateTree.SelectedNode = firstDate; productTree.SelectedNode = firstItem; }