//Removing equipment from the team list public void RemoveEquipment(Equipment equipment) { if (equipmentList.Contains(equipment)) { equipmentList.Remove(equipment); StaticDBConnection.NonQueryDatabase("UPDATE [Assigned_Equipment] SET Removed_Time='" + StaticDBConnection.DateTimeSQLite(DateTime.Now) + "' WHERE Equipment_ID=" + equipment.getID() + " AND Team_ID=" + teamID + ";"); InstanceModifiedNotification(); } }
//Adds a maximum of 3 equipments to the team public bool AddEquipment(Equipment equipment) { if (equipmentList.Count < 3) { equipmentList.Add(equipment); StaticDBConnection.NonQueryDatabase("INSERT INTO [Assigned_Equipment] (Equipment_ID, Team_ID, Assigned_Time) VALUES (" + equipment.getID() + ", " + teamID + ", '" + StaticDBConnection.DateTimeSQLite(DateTime.Now) + "');"); InstanceModifiedNotification(); return(true); } MessageBox.Show(ETD.Properties.Resources.MessageBox_Notification_EquipmentLimit); return(false); }