예제 #1
0
        public static void LoadEquipmentList()
        {
            if (Types == null)
            {
                Types = new EquipmentTypes();
                string        queryTypes = "SELECT \"Id\", \"TypeName\", \"EPrice\", \"Description\" FROM \"EquipmentType\";";
                NpgsqlCommand Command1   = new NpgsqlCommand(queryTypes, Connection);
                var           reader1    = Command1.ExecuteReader();
                if (reader1.HasRows)
                {
                    while (reader1.Read())
                    {
                        Types.AddType(reader1.GetInt32(0), reader1.GetString(1), reader1.GetDouble(2), reader1.GetString(3));
                    }
                }
                reader1.Close();
            }

            Equipments = new EquipmentList();
            string        queryEquipment = "SELECT \"Id\", \"Status\", \"Location\", \"IdType\" FROM \"Equipment\";";
            NpgsqlCommand Command2       = new NpgsqlCommand(queryEquipment, Connection);
            var           reader2        = Command2.ExecuteReader();

            if (reader2.HasRows)
            {
                while (reader2.Read())
                {
                    Equipments.AddEquipment(reader2["Id"].ToString(), reader2["Status"].ToString(), reader2["Location"].ToString(), reader2["IdType"].ToString(), Types);
                }
            }
            reader2.Close();
        }
예제 #2
0
        public Equipment(string id, string status, string location, string typeid, EquipmentTypes eTypes)
        {
            Id       = id;
            Status   = status;
            Location = location;
            IdType   = typeid;
            var t = eTypes.GetType(int.Parse(typeid));

            Price       = t.cost;
            TypeName    = t.name;
            Description = t.description;
        }
예제 #3
0
 public void AddEquipment(string id, string status, string location, string typeid, EquipmentTypes types)
 {
     equipment.Add(new Equipment(id, status, location, typeid, types));
 }