private void SalesReport_Load(object sender, EventArgs e) { treeView1.ExpandAll(); HorsePower.FillCombo(comboBox1, "SELECT `Name` FROM `itemsmenu` WHERE 1"); //HorsePower.FillCombo(comboBox2, "SELECT `Username` FROM `login2` WHERE 1"); HorsePower.FillCombo(comboBox2, "SELECT CONCAT(FirstName,LastName) FROM workers;"); }
private void Orders_Load(object sender, EventArgs e) { HorsePower.FillCombo(comboBox2, "SELECT `TableNumber` FROM `table` WHERE 1"); try { dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`, `Date`, `Status`, `Total`, `Waiter`,`TableNumber`,`OrderStatus` FROM `Orders` WHERE OrderStatus = 'Not Seen' AND `Status` = 'Closed'"); } catch (Exception ex) { } }
private void NewStock_Load(object sender, EventArgs e) { try { get(); //load combo boxes HorsePower.FillCombo(units, "SELECT `UnitName` FROM `units` WHERE 1"); HorsePower.FillCombo(categories, "SELECT `CategoryName` FROM `categories` WHERE 1"); } catch (Exception ex) { Console.Write(ex); } }
private void NewOrder_Load(object sender, EventArgs e) { try { //initialize stuff waiter.Text = this.w; comboBox3.Text = this.w; textBox3.Text = this.w; label1.Text = this.w; LoadCategories(); LoadOrders(); DateTime D = DateTime.Now; date.Text = D.ToString(); PopulateList(); //load tables HorsePower.FillCombo(comboBox2, "SELECT `TableNumber` FROM `table` WHERE 1"); HorsePower.FillCombo(comboBox3, "SELECT CONCAT(FirstName,LastName) FROM workers;"); } catch (Exception ex) { Console.Write(ex); } }
private void Login_Load(object sender, EventArgs e) { HorsePower.FillCombo(textBox1, "SELECT Username FROM login2 WHERE 1"); }