private void checkBox2_CheckedChanged(object sender, EventArgs e)
{
string itm = (String)listBox1.SelectedItem;
if (checkBox2.Checked == true)
{
checkBox2.Text = "Cooked";
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price` FROM `itemsmenu` WHERE `Status` ='Cooked'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
else
{
try
{
checkBox2.Text = "UnCooked";
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price` FROM `itemsmenu` WHERE `Status` = 'UnCooked'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
}
void LoadStatus()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price`, `Type`, `Details`, `Availability`,`Status` FROM `itemsmenu` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void Suppliers_Load(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT * FROM `Suppliers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void ItemStatus_Load(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price`, `Type`, `Details`, `Availability`,`Status` FROM `itemsmenu` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void getShifts()
{
try
{
dataGridView2.DataSource = HorsePower.Select("SELECT * FROM `Shift` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void get()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT * FROM `Suppliers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void gettable()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT * FROM `Table` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void ReloadGrid()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Quantity`, `Price` FROM `itemsmenu` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void LoadAllWorkers()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `FirstName`, `LastName`, `IDNumber`, `Gender`, `Telephone`, `Residence`, `WorkPosition`, `Salary`, `PaymentMode`, `WorkingDuration` FROM `workers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void LoadStatus2(string text)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price`, `Type`, `Details`, `Availability`,`Status` FROM `itemsmenu` WHERE `Status` = '" + comboBox1.Text + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`,`Status`, `Total`, `Waiter` FROM `orders` WHERE `Waiter` LIKE '" + textBox2.Text + "%'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`,`Status`, `Total`, `Waiter` FROM `orders` WHERE `Status` = '" + comboBox1.Text + "' ");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void Loads()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `ItemName` FROM `ItemCategories` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void OrdersApproval_Load(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`,`Status`, `Total`, `Waiter` FROM `orders` WHERE `Status` = 'Open' AND `Date` = '" + dateTimePicker1.Text + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Quantity`, `Price` FROM `itemsmenu` WHERE `Availability` = '" + comboBox1.Text + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void getUnits()
{
try
{
dataGridView2.DataSource = HorsePower.Select("SELECT * FROM `Units` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void get()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `FirstName`, `LastName` FROM `workers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void LoadStuff()
{
try
{
dataGridView2.DataSource = HorsePower.Select("SELECT `FullNames`, `Amount`,`Status` FROM `OpeningBalance` WHERE `Date` = '" + dateTimePicker1.Text + "'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`, `Date`, `Status`, `Total`, `Waiter`,`OrderStatus` FROM `Orders` WHERE `TableNumber`='" + comboBox2.Text + "'");
}
catch (Exception ex)
{
MessageBox.Show("Error Unable To Load data", "Error");
}
}
private void qtytotal_TextChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Code`,`ItemName`, `Quantity`, `Categories`, `PurchaseDate` FROM `stock` WHERE `ItemName` = '" + itemname.Text + "'");
}
catch (Exception ex)
{
MessageBox.Show("Error Unable To Load data", "Error");
Console.Write(ex);
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dataGridView2.DataSource = HorsePower.Select("SELECT `OrderNumber`, `Status`, `Total` FROM `orders` WHERE `Status` = '" + comboBox1.Text + "' AND `Waiter` = '" + this.w + "'");
}
catch (Exception ex)
{
MessageBox.Show("Error Unable To Load data", "Error");
Console.Write(ex);
}
}
private void Shifts_Load(object sender, EventArgs e)
{
try
{
getShifts();
dataGridView1.DataSource = HorsePower.Select("SELECT `IDNumber`,`FirstName`, `LastName`, `WorkingDuration` FROM `workers` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
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)
{
}
}
void LoadOrders()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `OrderNumber`, `Date`, `Status`, `Total`, `Waiter`,`TableNumber`,`OrderStatus` FROM `Orders` WHERE OrderStatus='Not Seen' `Status` = 'Closed'");
}
catch (Exception ex)
{
Console.Write(ex);
MessageBox.Show("Error Unable To Load data", "Error");
}
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price` FROM `itemsmenu` WHERE `Name` LIKE '" + textBox2.Text + "%'");
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void Loaditems(string name)
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Name`, `Price` FROM `itemsmenu` WHERE `Type` = '" + name + "'");
}
catch (Exception ex)
{
MessageBox.Show("Error Unable To Load data", "Error");
Console.Write(ex);
}
}
void loadMails()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `To`, `Date`, `Subject`, `Message`, `Attachments` FROM `MailMaster` WHERE 1");
}
catch (Exception ex)
{
Console.Write(ex);
MessageBox.Show("Error Unable To Load data", "Error");
}
}
private void ViewUsedStock_Load(object sender, EventArgs e)
{
String SQL = "SELECT `Code`, `Name`, `Date`, `QuantityOut`, `Notes` FROM `stockout` WHERE 1";
try
{
dataGridView1.DataSource = HorsePower.Select(SQL);
}
catch (Exception ex)
{
Console.Write(ex);
}
}
private void getAccounts()
{
try
{
dataGridView2.DataSource = HorsePower.Select("SELECT `AccountNumber`, `AccountName`, `Bank`, `DateOpened`, `Signitory`, `Accounttype` FROM `account` WHERE 1");
int total = dataGridView2.Rows.Count;
label1.Text = "( " + total + " )" + "Total Accounts ";
}
catch (Exception ex)
{
Console.Write(ex);
}
}
public void Reload()
{
try
{
dataGridView1.DataSource = HorsePower.Select("SELECT `Code`,`ItemName`, `Quantity`, `Categories`, `PurchaseDate` FROM `stock` WHERE 1");
dataGridView1.Columns[0].Visible = false;
}
catch (Exception ex)
{
MessageBox.Show("Error Unable To Load data", "Error");
Console.Write(ex);
}
}