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