private void populateGrid() { string selectStatement = "SELECT supplier_code as 'Supplier Code', supplier_name as 'Supplier' , contact_name as 'Contact Person', contact_number as 'Contact Number', email as 'Email' FROM SUPPLIER"; DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1); string selectStatement4 = "SELECT STORE.item_code as 'Item Code', STORE.item_name as 'Item Name', STORE.description as 'Description', SUPPLIER.supplier_code as 'Supplier Code', SUPPLIER.supplier_name as 'Supplier' FROM SUPPLIER INNER JOIN STORE ON SUPPLIER.supplier_code = STORE.supplier_code WHERE STORE.pending_removal='Yes'"; DatabaseHandler.populateViewwithNoParameters(selectStatement4, dataGridView3); if (!String.IsNullOrEmpty(findById.Text)) { string selectStatement2 = "SELECT STORE.item_code as 'Item Code', STORE.item_name as 'Item Name', STORE.description as 'Description', SUPPLIER.supplier_code as 'Supplier Code', SUPPLIER.supplier_name as 'Supplier' FROM SUPPLIER INNER JOIN STORE ON SUPPLIER.supplier_code = STORE.supplier_code WHERE SUPPLIER.supplier_code like '%" + findById.Text + "%'"; DatabaseHandler.populateViewwithNoParameters(selectStatement2, dataGridView2); } else if (!String.IsNullOrEmpty(findByName.Text)) { string selectStatement3 = "SELECT STORE.item_code as 'Item Code', STORE.item_name as 'Item Name', STORE.description as 'Description', SUPPLIER.supplier_code as 'Supplier Code', SUPPLIER.supplier_name as 'Supplier' FROM SUPPLIER INNER JOIN STORE ON SUPPLIER.supplier_code = STORE.supplier_code WHERE SUPPLIER.supplier_name like '%" + findByName.Text + "%'"; DatabaseHandler.populateViewwithNoParameters(selectStatement3, dataGridView2); } else { string selectStatement3 = "SELECT STORE.item_code as 'Item Code', STORE.item_name as 'Item Name', STORE.description as 'Description', SUPPLIER.supplier_code as 'Supplier Code', SUPPLIER.supplier_name as 'Supplier' FROM SUPPLIER INNER JOIN STORE ON SUPPLIER.supplier_code = STORE.supplier_code"; DatabaseHandler.populateViewwithNoParameters(selectStatement3, dataGridView2); } }
private void populateGrid() { string selectStatement = "SELECT STORE.item_code as 'Item Code', STORE.item_name as 'Item Name', STORE.description as 'Item Description', SUPPLIER.supplier_name as 'Supplier' FROM STORE INNER JOIN SUPPLIER ON STORE.supplier_code = SUPPLIER.supplier_code WHERE SUPPLIER.supplier_code = '" + selectedSupplier + "'"; DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1); populateNonComboGrids(); }
private void findMemId_TextChanged(object sender, EventArgs e) { try { string selectStatement = "SELECT member_name as 'Member Name', username as 'Username' , role as 'User Role' FROM user WHERE username like '%" + findMemId.Text + "%'"; DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1); } catch (Exception err) { Console.WriteLine(err); } }
private void removeSupplierId_TextChanged(object sender, EventArgs e) { try { string selectStatement = "SELECT supplier_code as 'Supplier Code', supplier_name as 'Supplier' , contact_name as 'Contact Person', contact_number as 'Contact Number', email as 'Email' FROM SUPPLIER WHERE supplier_code like '%" + removeSupplierId.Text + "%'"; DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1); } catch (Exception err) { Console.WriteLine(err); } }
private void findByName_TextChanged(object sender, EventArgs e) { try { string selectStatement = "SELECT hospital as 'Hospital', identifier_code as 'Identifier Code' , area as 'Area', contact_name as 'Contact Name',contact_number as 'Contact Number', email as 'Email' FROM CLIENT WHERE hospital like '%" + findByName.Text + "%'"; DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1); } catch (Exception err) { Console.WriteLine(err); } }
private void findByName_TextChanged(object sender, EventArgs e) { try { string selectStatement = "SELECT supplier_code as 'Supplier Code', supplier_name as 'Supplier' , contact_name as 'Contact Person', contact_number as 'Contact Number', email as 'Email' FROM SUPPLIER WHERE supplier_name like '%" + findByName.Text + "%'"; DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1); string selectStatement2 = "SELECT STORE.item_code as 'Item Code', STORE.item_name as 'Item Name', STORE.description as 'Description', SUPPLIER.supplier_code as 'Supplier Code', SUPPLIER.supplier_name as 'Supplier' FROM SUPPLIER INNER JOIN STORE ON SUPPLIER.supplier_code = STORE.supplier_code WHERE SUPPLIER.supplier_name like '%" + findByName.Text + "%'"; DatabaseHandler.populateViewwithNoParameters(selectStatement2, dataGridView2); } catch (Exception err) { Console.WriteLine(err); } }
private void populateGrid() { string selectStatement = "SELECT member_name as 'Member Name', username as 'Username' , role as 'User Role' FROM user"; DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1); }
private void populateGrid() { string selectStatement = "SELECT hospital as 'Hospital', identifier_code as 'Identifier Code' , area as 'Area', contact_name as 'Contact Name',contact_number as 'Contact Number', email as 'Email' FROM CLIENT"; DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1); }