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