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;
}
