private void populateGrid()
{
string selectStatement = "SELECT item.item_id as 'Item Code', item.name as 'Item Name', item.unit_price as 'Item Price', item.qty as 'Quantity' FROM item ";
DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1);
populateNonComboGrids();
}
private void populateGrid()
{
string selectStatement = "SELECT supplier_material.material_id as 'Material Code', raw_material.name as 'Material Name', raw_material.qty as 'Available Quantity', supplier_material.unit_price as 'Unit Price' FROM supplier_material INNER JOIN raw_material ON raw_material.material_id = supplier_material.material_id WHERE supplier_material.supplier_id = '" + selectedSupplier + "'";
DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1);
populateNonComboGrids();
}
private void populateGrid()
{
string selectStatement = "SELECT supplier_id as 'Supplier ID', name as 'Supplier Name' , contact_no as 'Contact Number', email as 'Email' FROM SUPPLIER";
DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1);
string selectStatement4 = "SELECT raw_material.material_id as 'Material ID', raw_material.name as 'Material Name', raw_material.qty as 'Quantity' FROM raw_material ";
DatabaseHandler.populateViewwithNoParameters(selectStatement4, dataGridView2);
}
private void findByName_TextChanged(object sender, EventArgs e)
{
try
{
string selectStatement = "SELECT supplier_id as 'Supplier Code', name as 'Supplier' , contact_no as 'Contact Number', email as 'Email' FROM SUPPLIER WHERE name like '%" + findByName.Text + "%'";
DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1);
}
catch (Exception err)
{
Console.WriteLine(err);
}
}
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 findById_TextChanged(object sender, EventArgs e)
{
try
{
string selectStatement = "SELECT name as 'Client Name', client_id as 'Client ID' , contact_no as 'Contact Number', email as 'Email' FROM CLIENT WHERE client_id like '%" + findById.Text + "%'";
DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1);
}
catch (Exception err)
{
Console.WriteLine(err);
}
}
private void populateGrid()
{
string selectStatement = "SELECT member_name as 'Member Name', username as 'Member ID' , role as 'User Role' , email as 'Email' FROM user";
DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1);
}
private void populateGrid()
{
string selectStatement = "SELECT name as 'Client Name', client_id as 'Client ID' , contact_no as 'Contact Number', email as 'Email' FROM CLIENT";
DatabaseHandler.populateViewwithNoParameters(selectStatement, dataGridView1);
}