private void numericUpDown1_ValueChanged(object sender, EventArgs e)
{
String query = "Select * from pharmacy.inventory where ProductID like '" + numericUpDown1.Value.ToString() + "%" + "' and Branch = '" + branch + "';";
SqlCon.updateDataGridView(query, dataGridView1);
}
private void supDetails_search_SelectedIndexChanged(object sender, EventArgs e)
{
String query = "Select * from pharmacy.debit_balances where SupplierName like'" + supDetails_search.Text + "';";
SqlCon.updateDataGridView(query, debitDetails_dgv);
}
private void Inventory_details_welivita_Load(object sender, EventArgs e)
{
String query = "Select * from pharmacy.inventory where Branch = '" + branch + "';";
SqlCon.updateDataGridView(query, dataGridView1);
}
private void refreshDatagrid(object sender, EventArgs e)
{
String query = "Select * from pharmacy.supplierdetails;";
SqlCon.updateDataGridView(query, supplierDetailsDgv);
}
private void button1_Click_1(object sender, EventArgs e)
{
String query = "Select * from pharmacy.supplierdetails;";
SqlCon.updateDataGridView(query, supplierDetailsDgv);
}
private void supDetails_search1_SelectedIndexChanged(object sender, EventArgs e)
{
String query = "Select * from pharmacy.supplier_transactions where SupplierName like'" + supDetails_search1.Text + "';";
SqlCon.updateDataGridView(query, supplier_transactionsDetails);
}
private void supplierName_search2_SelectedIndexChanged(object sender, EventArgs e)
{
String query = "Select * from pharmacy.credit_details where SupplierName like'" + supplierName_search2.Text + "';";
SqlCon.updateDataGridView(query, creditDetails);
}
public void inventory_details_Load(object sender, EventArgs e)
{
String query = "Select * from inventory where Branch = '" + branch + "';";
SqlCon.updateDataGridView(query, dataGridView1);
}