public MakeOrderForm(int id)
{
this.id = id;
InitializeComponent();
objectsController.addColumn(objectsController.basketDataTable);
basketGridView.DataSource = objectsController.basketDataTable;
}
public void fillPackagesBasket(DataTable packagesTable, int orderID)
{
connection.Open();
ObjectsController objectsController = ObjectsController.getInstance();
objectsController.addColumn(objectsController.packagesBasketDataTable);
SqlCommand getOrderDetailsID = new SqlCommand("select OrderDetailID from OrderDetails where OrderID=" + orderID + ";", connection);
SqlDataReader idReader = getOrderDetailsID.ExecuteReader();
DataTable data = new DataTable();
data.Load(idReader);
for (int i = 0; i < data.Rows.Count; i++)
{
String command = "select TOP(select Amount from OrderDetails where OrderDetailID = " + int.Parse(data.Rows[i].ItemArray[0].ToString()) +
")[SerialNumber(SN)] from PackageOfMedicine p join OrderDetails o on p.MedicineID = o.MedicineID and o.OrderDetailID = " +
int.Parse(data.Rows[i].ItemArray[0].ToString()) + " ORDER BY p.[TermofValidity(EXP)];";
SqlDataAdapter adapter = new SqlDataAdapter(command, connection);
adapter.Fill(packagesTable);
}
idReader.Close();
connection.Close();
}
