public HashSet <ReceivingWarehouseItemModel> GetWarehouseReceiving()
{
string query = "SELECT receiving_warehouse.id, medicine.name, receiving_warehouse.quantity, receiving_warehouse.cost, receiving_warehouse.date " +
"FROM receiving_warehouse " +
"LEFT JOIN medicine ON medicine.id = receiving_warehouse.id_medicine ";
command = new MySqlCommand(query, connection);
MySqlDataReader reader = command.ExecuteReader();
HashSet <ReceivingWarehouseItemModel> items = new HashSet <ReceivingWarehouseItemModel>();
ReceivingWarehouseItemModel item;
while (reader.Read())
{
item = new ReceivingWarehouseItemModel();
item.id = reader.GetValue(0).ToString();
item.name = reader.GetValue(1).ToString();
item.quantity = reader.GetValue(2).ToString();
item.cost = reader.GetValue(3).ToString();
item.date = reader.GetValue(4).ToString();
items.Add(item);
}
command.Dispose();
return(items);
}
public ReceivingPharmacyViewModel()
{
_selectedItem = null;
GetDataFromDatabase();
}
