//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);
}