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