예제 #1
0
        public HashSet <DeliveryWarehouseItemModel> GetWarehouseDeliveries()
        {
            string query = "SELECT delivery_warehouse.id, medicine.name, delivery_warehouse.quantity, delivery_warehouse.cost, delivery_warehouse.date " +
                           "FROM delivery_warehouse " +
                           "LEFT JOIN medicine ON medicine.id = delivery_warehouse.id_medicine ";

            command = new MySqlCommand(query, connection);

            MySqlDataReader reader = command.ExecuteReader();
            HashSet <DeliveryWarehouseItemModel> items = new HashSet <DeliveryWarehouseItemModel>();
            DeliveryWarehouseItemModel           item;

            while (reader.Read())
            {
                item          = new DeliveryWarehouseItemModel();
                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);
        }
예제 #2
0
 public DeliveryWarehouseViewModel()
 {
     _selectedItem = null;
     GetDataFromDatabase();
 }