//Creates an additional information
public InterventionAdditionalInfo(String information, DateTime timestamp)
{
this.information = information;
this.timestamp = timestamp;
this.additionalInfoID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Additional_Informations] (Intervention_ID, Information, Timestamp) VALUES (" + interventionID + ", '" + information.Replace("'", "''") + "', '" + StaticDBConnection.DateTimeSQLite(timestamp) + "')");
}
public Resource(Team team)
{
this.team = team;
this.intervening = true;
this.moving = DateTime.Now;
this.movingBool = true;
this.resourceID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Resources] (Intervention_ID, Team_ID) VALUES (" + interventionID + ", " + team.getID() + ")");
}
//Constructors
public Resource(String resourceName, Team team, bool intervening, DateTime moving, DateTime arrival)
{
this.resourceName = resourceName;
this.team = team;
this.intervening = intervening;
this.moving = moving;
this.arrival = arrival;
this.resourceID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Resources] (Intervention_ID, Name, Team_ID, Intervening, Moving, Arrival) VALUES (" + interventionID + ", '" + resourceName.Replace("'", "''") + "', " + team.getID() + ", " + intervening + "', '" + StaticDBConnection.DateTimeSQLite(moving) + "', '" + StaticDBConnection.DateTimeSQLite(arrival) + ")");
}
//Creates a new operation
public Operation(String operationName, String acronym, DateTime shiftStart, DateTime shiftEnd, String dispatcherName)
{
this.operationName = operationName;
this.acronym = acronym;
this.shiftStart = shiftStart;
this.shiftEnd = shiftEnd;
this.dispatcherName = dispatcherName;
this.operationID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Operations] (Name, Acronym, Shift_Start, Shift_End, Dispatcher) VALUES ('" + operationName.Replace("'", "''") + "', '" + acronym.Replace("'", "''") + "', '" + StaticDBConnection.DateTimeSQLite(shiftStart) + "', '" + StaticDBConnection.DateTimeSQLite(shiftEnd) + "', '" + dispatcherName.Replace("'", "''") + "')");
currentOperation = this;
}
private bool assigned; //Used when checking if the equipment is assigned to any team
//Creates an equipment and notifies the list of observers
public Equipment(String name)
{
this.equipmentType = (Equipments)Enum.Parse(typeof(Equipments), name);
equipmentList.Add(this);
ClassModifiedNotification(typeof(Equipment));
if (Operation.currentOperation != null)
{
this.operationID = Operation.currentOperation.getID();
}
this.equipmentID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Equipments] (Operation_ID, Type_ID) VALUES (" + operationID + ", " + 1 + (int)equipmentType + ")");
}
//User inputs default values for all ABC objects
public ABC(int intervention, String consciousness, bool disoriented, String airways, String breathing, int breathingFrequency, String circulation, int circulationFrequency)
{
this.consciousness = consciousness;
this.disoriented = disoriented;
this.airways = airways;
this.breathing = breathing;
this.breathingFrequency = breathingFrequency;
this.circulation = circulation;
this.circulationFrequency = circulationFrequency;
this.interventionID = intervention;
this.abcID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [ABCs] (Intervention_ID, Consciousness, Disoriented, Airways, Breathing, Breathing_Frequency, Circulation, Circulation_Frequency) VALUES ('" + interventionID + "', '" + consciousness + "', '" + disoriented + "', '" + airways + "', '" + breathing + "', '" + breathingFrequency + "', '" + circulation + "', '" + circulationFrequency + "');");
}
//Set default values for all ABC objects
public ABC()
{
this.consciousness = "notSet";
this.disoriented = false;
this.airways = "notSet";
this.breathing = "notSet";
this.breathingFrequency = -1;
this.circulation = "notSet";
this.circulationFrequency = -1;
this.abcID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [ABCs] (Intervention_ID) VALUES (" + interventionID + ");");
}
//Creates a new team
public Team(String name)
{
this.name = name;
status = Statuses.available;
if (Operation.currentOperation != null)
{
this.operationID = Operation.currentOperation.getID();
}
this.teamID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Teams] (Operation_ID, Name, Status) VALUES (" + operationID + ", '" + name.Replace("'", "''") + "', " + (int)status + ")");
teamList.Add(this);
ClassModifiedNotification(typeof(Team));
}
//Constructor
public Intervention()
{
this.resourceList = new List <Resource>();
this.interventionNumber = ++lastIntervention;
this.timeOfCall = DateTime.Now;
this.additionalInfo = new InterventionAdditionalInfo[10];
this.abc = new ABC(this);
this.isConcludedBool = false;
this.firstTeamArrivalTime = DateTime.MinValue;
this.callID = -1;
activeInterventionList.Add(this);
ClassModifiedNotification(typeof(Intervention));
if (Operation.currentOperation != null)
{
this.operationID = Operation.currentOperation.getID();
}
this.interventionID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Interventions] (Operation_ID, Intervention_Number, Time_Of_Call) VALUES (" + operationID + ", " + interventionNumber + ", '" + StaticDBConnection.DateTimeSQLite(timeOfCall) + "')");
}
//Creates a new team member
public TeamMember(String name, Trainings training, DateTime departure)
{
this.name = name;
this.trainingLevel = training;
this.departure = departure;
try
{
using (SQLiteDataReader reader = StaticDBConnection.QueryDatabase("Select Volunteer_ID FROM [Volunteers] WHERE Name='" + name + "'"))
{
reader.Read();
this.volunteerID = Convert.ToInt32(reader["Volunteer_ID"].ToString());
}
StaticDBConnection.CloseConnection();
StaticDBConnection.NonQueryDatabase("UPDATE [Volunteers] SET Training_Level=" + (int)this.trainingLevel + " WHERE Volunteer_ID=" + this.volunteerID + ";");
}
catch
{
this.volunteerID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Volunteers] (Name, Training_Level) VALUES ('" + name.Replace("'", "''") + "', " + (int)training + ")");
}
}
//Set 911 call time
public void setCall911Time(DateTime call911Time)
{
this.callID = StaticDBConnection.NonQueryDatabaseWithID("INSERT INTO [Calls] (Intervention_ID) VALUES (" + this.interventionID + ");");
this.call911Time = call911Time;
StaticDBConnection.NonQueryDatabase("UPDATE [Calls] SET Call_Time='" + StaticDBConnection.DateTimeSQLite(call911Time) + "' WHERE Call_ID=" + callID + ";");
}
