//Add intervening teams
public void AddInterveningTeam(Team team)
{
foreach (Resource resource in resourceList)
{
if (resource.getTeam() == team)
{
resource.setIntervening(true);
InstanceModifiedNotification();
if (team.getStatus().ToString().Equals("intervening"))
{
team.setStatus("moving");
}
return;
}
}
//Set up arrival time
if (firstTeamArrivalTime == DateTime.MinValue)
{
firstTeamArrivalTime = DateTime.Now;
}
team.incrementInterventionCount();
resourceList.Add(new Resource(this, team));
StaticDBConnection.NonQueryDatabase("INSERT INTO [Intervening_Teams] (Intervention_ID, Team_ID, Started_Intervening) VALUES (" + interventionID + ", " + team.getID() + ", '" + StaticDBConnection.DateTimeSQLite(DateTime.Now) + "');");
InstanceModifiedNotification();
}
//display the views for all operations that were completed
private void PopulateOperations()
{
Statistic.clearOperationsList();
SQLiteDataReader reader = StaticDBConnection.QueryDatabase("SELECT * FROM Operations ORDER BY Shift_Start");
while (reader.Read())
{
operationCheck = true;
CheckBox cb = new CheckBox();
cb.FontSize = 20;
cb.FontWeight = FontWeights.Bold;
cb.Foreground = Brushes.DarkSlateBlue;
cb.Name = "operation" + reader["Operation_ID"];
cb.Checked += OperationChecked;
cb.Unchecked += OperationUnchecked;
DateTime startDate = Convert.ToDateTime(reader["Shift_Start"].ToString());
DateTime endDate = Convert.ToDateTime(reader["Shift_End"].ToString());
cb.Content = "Operation ID: " + reader["Operation_ID"] + " Operation Name: " + reader["Name"] + " Start: " + startDate.ToString("g") + " End: " + endDate.ToString("g");
previousOperation.Children.Add(cb);
}
StaticDBConnection.CloseConnection();
if (operationCheck == true)
{
Button submitButton = new Button();
submitButton.Content = "Submit";
submitButton.Width = 100;
submitButton.Margin = new Thickness(0, 50, 0, 0);
submitButton.Click += OperationSubmit;
previousOperation.Children.Add(submitButton);
}
}
private void ComboBox_TeamMemberName3_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (ComboBox_TeamMemberName3.SelectedIndex == -1)
{
return;
}
if (ComboBox_TeamMemberName3.SelectedIndex == 0)
{
ComboBox_TeamMemberName3.Visibility = Visibility.Collapsed;
teamMember3.Visibility = Visibility.Visible;
//Button_OKTeamMember3.Visibility = Visibility.Visible;
Button_CancelTeamMember3.Visibility = Visibility.Visible;
}
else
{
ComboBoxItem memberNameItem = new ComboBoxItem();
memberNameItem = (ComboBoxItem)ComboBox_TeamMemberName3.SelectedItem;
using (SQLiteDataReader reader = StaticDBConnection.QueryDatabase("Select Training_Level FROM [Volunteers] WHERE Name='" + memberNameItem.Content.ToString() + "'"))
{
reader.Read();
lvlOfTraining3.SelectedIndex = Convert.ToInt32(reader["Training_Level"].ToString());
}
StaticDBConnection.CloseConnection();
}
}
//Remove a team from an intervention
public void RemoveInterveningTeam(Team team)
{
Resource resourceToRemove = null;
foreach (Resource resource in resourceList)
{
if (resource.getTeam() == team)
{
if (!resource.hasArrived())
{
resourceToRemove = resource;
}
else
{
resource.setIntervening(false);
}
StaticDBConnection.NonQueryDatabase("UPDATE [Intervening_Teams] SET Stopped_Intervening='" + StaticDBConnection.DateTimeSQLite(DateTime.Now) + "' WHERE Intervention_ID=" + interventionID + " AND Team_ID=" + team.getID() + ";");
}
}
if (resourceToRemove != null)
{
resourceList.Remove(resourceToRemove);
}
InstanceModifiedNotification();
}
//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() + ")");
}
//Set age
public void setAge(String age)
{
this.age = age;
if (age.Length > 0)
{
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Age=" + int.Parse(age) + " WHERE Intervention_ID=" + interventionID + ";");
}
}
//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();
}
}
//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;
}
//Deletes a team from the team list
private static void DeleteTeam(Team team, List <Team> list)
{
list.Remove(team);
while (team.memberList.Count > 0)
{
StaticDBConnection.NonQueryDatabase("UPDATE [Team_Members] SET Disbanded='" + StaticDBConnection.DateTimeSQLite(DateTime.Now) + "' WHERE Volunteer_ID=" + team.getMember(0).getID() + " AND Team_ID=" + team.getID() + ";");
team.memberList.RemoveAt(0);
}
ClassModifiedNotification(typeof(Team));
}
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 + ")");
}
//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);
}
//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 + "');");
}
//retrieve the total number of volunteers in operations
public int getVolunteerCountFromDB()
{
int volunteerCount = 0;
SQLiteDataReader reader = StaticDBConnection.QueryDatabase(dbQueryVolunteerCount);
while (reader.Read())
{
volunteerCount = int.Parse(reader["Num"].ToString());
}
StaticDBConnection.CloseConnection();
return(volunteerCount);
}
//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 + ");");
}
public InterventionStatisticMapper()
{
chiefComplaint.Clear();
SQLiteDataReader reader = StaticDBConnection.QueryDatabase(dBQueryComplaints);
while (reader.Read())
{
String complaint = reader["Chief_Complaint"].ToString();
chiefComplaint.Add(complaint);
}
StaticDBConnection.CloseConnection();
}
//retrieve the total number of teams in operations
public int getTeamCountFromDB()
{
int teamCount = 0;
SQLiteDataReader reader = StaticDBConnection.QueryDatabase(dbQueryTeamCount);
while (reader.Read())
{
teamCount = int.Parse(reader["Count"].ToString());
}
StaticDBConnection.CloseConnection();
return(teamCount);
}
//Children with Ambulance
public void getInterventionChildrenWithAmublanceCount(String complaint)
{
String dBQueryInterventionChildrenACount = "SELECT count(*) as Count from Interventions WHERE Conclusion LIKE 'get_ComboBoxItem_Conclusion_911' AND Operation_ID IN " + Statistic.getOperationID() + " AND Chief_Complaint='" + complaint + "' AND Age < 18";
SQLiteDataReader childrenReader = StaticDBConnection.QueryDatabase(dBQueryInterventionChildrenACount);
while (childrenReader.Read())
{
int count = int.Parse(childrenReader["Count"].ToString());
interventionChildrenAList.Add(count);
}
StaticDBConnection.CloseConnection();
}
//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));
}
protected void SavingInformation(Object sender, System.EventArgs e)
{
int id = Operation.currentOperation.getID();
string VolunteerFollowUpText = VolunteerFollowUp.Text;
string FinanceText = Finance.Text;
string VehicleText = Vehicle.Text;
string ParticularSituationText = ParticularSituation.Text;
string OrganizationFollowUpText = OrganizationFollowUp.Text;
string SupervisorFollowUpText = SupervisorFollowUp.Text;
//pushing changes to the db file for extra information at the end of the operation
StaticDBConnection.NonQueryDatabase("UPDATE [Operations] SET VolunteerFollowUp= '" + VolunteerFollowUpText + "', Finance= '" + FinanceText + "', Vehicle= '" + VehicleText + "', ParticularSituation= '" + ParticularSituationText + "', OrganizationFollowUp= '" + OrganizationFollowUpText + "', SupervisorFollowUp= '" + SupervisorFollowUpText + "' WHERE Operation_ID =" + id + ";");
MessageBox.Show(Properties.Resources.MessageBox_InformationSaved);
}
//Adds a maximum of 3 new member to the team
public bool AddMember(TeamMember member)
{
if (memberList.Count <= 2)
{
memberList.Add(member);
StaticDBConnection.NonQueryDatabase("INSERT INTO [Team_Members] (Team_ID, Volunteer_ID, Departure, Joined) VALUES (" + teamID + ", " + member.getID() + ", '" + StaticDBConnection.DateTimeSQLite(member.getDeparture()) + "', '" + StaticDBConnection.DateTimeSQLite(DateTime.Now) + "');");
if ((int)highestLevelOfTraining < (int)member.getTrainingLevel())
{
highestLevelOfTraining = member.getTrainingLevel();
}
InstanceModifiedNotification();
return(true);
}
return(false);
}
public VolunteerStatisticMapper()
{
SQLiteDataReader reader = StaticDBConnection.QueryDatabase(dbQuery);
while (reader.Read())
{
String volunteer = reader["Name"].ToString();
DateTime start = Convert.ToDateTime(reader["Joined"].ToString());
DateTime end = Convert.ToDateTime(reader["Departure"].ToString());
String operationID = reader["Operation_ID"].ToString();
//Creating volunteerStatistic
VolunteerStatistic vs = new VolunteerStatistic(volunteer, start, end, operationID);
volunteerStatisticList.Add(vs);
}
StaticDBConnection.CloseConnection();
}
public ABC(int id)
{
this.abcID = id;
using (System.Data.SQLite.SQLiteDataReader results = StaticDBConnection.QueryDatabase("SELECT Intervention_ID, Consciousness, Disoriented, Airways, Breathing, Breathing_Frequency, Circulation, Circulation_Frequency FROM [ABCs] WHERE ABC_ID=" + id + ";"))
{
results.Read();
this.interventionID = (results.IsDBNull(0)) ? 0 : results.GetInt32(0);
this.consciousness = (results.IsDBNull(1)) ? "" : results.GetString(1);
this.disoriented = (results.IsDBNull(2)) ? false : Convert.ToBoolean(results.GetString(2));
this.airways = (results.IsDBNull(3)) ? "" : results.GetString(3);
this.breathing = (results.IsDBNull(4)) ? "" : results.GetString(4);
this.breathingFrequency = (results.IsDBNull(5)) ? 0 : results.GetInt32(5);
this.circulation = (results.IsDBNull(6)) ? "" : results.GetString(6);
this.circulationFrequency = (results.IsDBNull(7)) ? 0 : results.GetInt32(7);
}
StaticDBConnection.CloseConnection();
}
private void GenerateComplainName()
{
ism = new InterventionStatisticMapper();
foreach (String complaint in ism.getListComplaint())
{
RowDefinition rd = new RowDefinition();
rd.Height = new GridLength(40);
ComplaintGrid.RowDefinitions.Add(rd);
Border border = new Border();
border.BorderThickness = new Thickness(1, 0, 5, 1);
border.BorderBrush = new SolidColorBrush(Colors.Black);
TextBlock tb = new TextBlock();
tb.FontWeight = FontWeights.Bold;
tb.Height = 40;
tb.FontSize = 13;
tb.Margin = new Thickness(5, 0, 0, 0);
tb.VerticalAlignment = VerticalAlignment.Center;
tb.HorizontalAlignment = HorizontalAlignment.Center;
tb.TextWrapping = TextWrapping.Wrap;
displayComplaint = StaticDBConnection.GetResource(complaint);
tb.Name = complaint;
tb.Text = displayComplaint;
border.Child = tb;
ComplaintGrid.Children.Add(border);
Grid.SetColumn(border, 0);
Grid.SetRow(border, count);
GenerateInterventionWithoutAmbulance(count, complaint);
GenerateInterventionWithAmbulance(count, complaint);
GenerateTotalTableHorizontal(count);
//resetting the total counters
countWithoutAmbulance = 0;
countWithAmbulance = 0;
totalChildrenHoriCount = 0;
totalAdultHoriCount = 0;
count++;
}
StaticDBConnection.CloseConnection();
GenerateTotalTableVertical(count);
totalChildrenVertical = 0;
totalAdultVertical = 0;
}
public TeamFormPage(TeamsSectionPage caller)
{
InitializeComponent();
this.caller = caller;
ComboBoxItem createUserItem = new ComboBoxItem();
createUserItem.Content = "NEW USER";
createUserItem.FontStyle = FontStyles.Italic;
createUserItem.FontWeight = FontWeights.Bold;
ComboBoxItem createUserItem2 = new ComboBoxItem();
createUserItem2.Content = "NEW USER";
createUserItem2.FontStyle = FontStyles.Italic;
createUserItem2.FontWeight = FontWeights.Bold;
ComboBoxItem createUserItem3 = new ComboBoxItem();
createUserItem3.Content = "NEW USER";
createUserItem3.FontStyle = FontStyles.Italic;
createUserItem3.FontWeight = FontWeights.Bold;
ComboBox_TeamMemberName1.Items.Add(createUserItem);
ComboBox_TeamMemberName2.Items.Add(createUserItem2);
ComboBox_TeamMemberName3.Items.Add(createUserItem3);
using (SQLiteDataReader reader = StaticDBConnection.QueryDatabase("SELECT Name FROM Volunteers"))
{
while (reader.Read())
{
ComboBoxItem cbItem = new ComboBoxItem();
cbItem.Content = reader["Name"].ToString();
ComboBoxItem cbItem2 = new ComboBoxItem();
cbItem2.Content = reader["Name"].ToString();
ComboBoxItem cbItem3 = new ComboBoxItem();
cbItem3.Content = reader["Name"].ToString();
ComboBox_TeamMemberName1.Items.Add(cbItem);
ComboBox_TeamMemberName2.Items.Add(cbItem2);
ComboBox_TeamMemberName3.Items.Add(cbItem3);
}
}
StaticDBConnection.CloseConnection();
}
//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 + ")");
}
}
private void Button_OKSupervisorName_Click(object sender, RoutedEventArgs e)
{
if (Textbox_SupervisorName.Text == "")
{
MessageBox.Show(Properties.Resources.MessageBox_EnterName);
}
else
{
StaticDBConnection.NonQueryDatabase("INSERT INTO [Volunteers] (Name, Training_Level) VALUES ('" + Textbox_SupervisorName.Text + "', 0);");
Textbox_SupervisorName.Visibility = Visibility.Collapsed;
Button_OKSupervisorName.Visibility = Visibility.Collapsed;
Button_CancelSupervisorName.Visibility = Visibility.Collapsed;
supervisorName.Visibility = Visibility.Visible;
ComboBoxItem newUser = new ComboBoxItem();
newUser.Content = Textbox_SupervisorName.Text;
supervisorName.Items.Add(newUser);
supervisorName.SelectedItem = newUser;
}
}
public OperationStatisticMapper()
{
SQLiteDataReader reader = StaticDBConnection.QueryDatabase(dbQuery);
while (reader.Read())
{
DateTime startDate = Convert.ToDateTime(reader["Shift_Start"].ToString());
DateTime endDate = Convert.ToDateTime(reader["Shift_End"].ToString());
String volunteerFollowUpText = reader["VolunteerFollowUp"].ToString();
String financeText = reader["Finance"].ToString();
String vehicleText = reader["Vehicle"].ToString();
String particularSituationText = reader["ParticularSituation"].ToString();
String organizationFollowUpText = reader["OrganizationFollowUp"].ToString();
String supervisorFollowUpText = reader["SupervisorFollowUp"].ToString();
String eventName = reader["Name"].ToString();
String dispatcherName = reader["Dispatcher"].ToString();
OperationStatistic os = new OperationStatistic(startDate, endDate, volunteerFollowUpText, financeText, vehicleText, particularSituationText, organizationFollowUpText, supervisorFollowUpText, eventName, dispatcherName);
operationStatisticList.Add(os);
}
StaticDBConnection.CloseConnection();
}
