public static void FillProductsComboBox(InvoiceForm f)
{
DataTable medecines;
try
{
if (f.comboBox1.SelectedValue == null)
{
MessageBox.Show("please select a Supplier");
}
else
{
object[,] Params = new object[2, 1];
Params[0, 0] = "@S_ID";
Params[1, 0] = f.comboBox1.SelectedValue;
medecines = dt.GetData_StoredProcedure("GetMedecinesINDVBySupplier", Params, "medecines");
medecines.Columns.Add("Info");
foreach (DataRow item in medecines.Rows)
{
item["Info"] = item["Name"].ToString() + " - " + item["Dosage"].ToString() + " - " + item["Volume"].ToString();
}
Filling.FillComboBox(f.myComboBox11, medecines, "ID", "Info");
}
}
catch { MessageBox.Show("ERROR!!"); }
}
public static void FillSupplierComboBox(InvoiceForm f)
{
DataTable suppliers;
suppliers = dt.GetData_StoredProcedure("GetSuppliersNames", "suppliers");
Filling.FillComboBox(f.comboBox1, suppliers, "ID", "Supplier");
}
