//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();
}
//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();
}
//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();
}
}
//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));
}
//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);
}
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);
}
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;
}
}
//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 OKButtonClicked(object sender, EventArgs e)
{
Button btnOK = (Button)sender;
TextBox volunteerTBox = allVolunteerTextBoxes[allVolunteerOKButtons.IndexOf(btnOK)];
btnOK.Visibility = Visibility.Collapsed;
allVolunteerCBoxes[allVolunteerOKButtons.IndexOf(btnOK)].Visibility = Visibility.Visible;
allVolunteerTextBoxes[allVolunteerOKButtons.IndexOf(btnOK)].Visibility = Visibility.Collapsed;
allVolunteerCancelButtons[allVolunteerOKButtons.IndexOf(btnOK)].Visibility = Visibility.Collapsed;
if (volunteerTBox.Text == "")
{
allVolunteerCBoxes[allVolunteerOKButtons.IndexOf(btnOK)].SelectedIndex = -1;
}
else
{
StaticDBConnection.NonQueryDatabase("INSERT INTO [Volunteers] (Name, Training_Level) VALUES ('" + volunteerTBox.Text + "', 0);");
ComboBoxItem newUser = new ComboBoxItem();
newUser.Content = volunteerTBox.Text;
allVolunteerCBoxes[allVolunteerOKButtons.IndexOf(btnOK)].Items.Add(newUser);
allVolunteerCBoxes[allVolunteerOKButtons.IndexOf(btnOK)].SelectedItem = newUser;
}
}
//Set first responder vehicle
public void setFirstResponderVehicle(String firstResponderVehicle)
{
this.firstResponderVehicle = firstResponderVehicle;
StaticDBConnection.NonQueryDatabase("UPDATE [Calls] SET First_Responder_Vehicle='" + firstResponderVehicle.Replace("'", "''") + "' WHERE Call_ID=" + callID + ";");
}
//Set first responder company
public void setFirstResponderCompany(String firstResponderCompany)
{
this.firstResponderCompany = firstResponderCompany;
StaticDBConnection.NonQueryDatabase("UPDATE [Calls] SET First_Responder_Company='" + firstResponderCompany.Replace("'", "''") + "' WHERE Call_ID=" + callID + ";");
}
//Set meeting point
public void setMeetingPoint(String meetingPoint)
{
this.meetingPoint = meetingPoint;
StaticDBConnection.NonQueryDatabase("UPDATE [Calls] SET Meeting_Point='" + meetingPoint.Replace("'", "''") + "' WHERE Call_ID=" + callID + ";");
}
//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 + ";");
}
//Set conclusion time
public void setConclusionTime(DateTime conclusionTime)
{
this.conclusionTime = conclusionTime;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Conclusion_Time='" + StaticDBConnection.DateTimeSQLite(conclusionTime) + "' WHERE Intervention_ID=" + interventionID + ";");
}
//Set additional conclusion info
public void setConclusionAdditionalInfo(String additionalInfo)
{
this.conclusionAdditionalInfo = additionalInfo;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Conclusion_Info='" + additionalInfo.Replace("'", "''") + "' WHERE Intervention_ID=" + interventionID + ";");
}
//Set nature of call
public void setNatureOfCall(String natureOfCall)
{
this.natureOfCall = natureOfCall;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Nature_Of_Call='" + natureOfCall.Replace("'", "''") + "' WHERE Intervention_ID=" + interventionID + ";");
}
//Set additional info
public void setAdditionalInfo(int position, InterventionAdditionalInfo info)
{
this.additionalInfo[position] = info;
StaticDBConnection.NonQueryDatabase("UPDATE [Additional_Informations] SET Intervention_ID=" + interventionID + " WHERE Additional_Info_ID=" + info.getID() + ";");
}
//Set abc
public void setABC(ABC abc)
{
this.abc = abc;
StaticDBConnection.NonQueryDatabase("UPDATE [ABCs] SET Intervention_ID=" + interventionID + " WHERE ABC_ID=" + abc.getID() + ";");
}
//Set other chief complaint
public void setOtherChiefComplaint(String otherChiefComplaint)
{
this.otherChiefComplaint = otherChiefComplaint;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Other_Chief_Complaint='" + otherChiefComplaint.Replace("'", "''") + "' WHERE Intervention_ID=" + interventionID + ";");
}
//Set ambulance vehicle
public void setAmbulanceVehicle(String ambulanceVehicle)
{
this.ambulanceVehicle = ambulanceVehicle;
StaticDBConnection.NonQueryDatabase("UPDATE [Calls] SET Ambulance_Vehicle='" + ambulanceVehicle.Replace("'", "''") + "' WHERE Call_ID=" + callID + ";");
}
//Set gender
public void setGender(String gender)
{
this.gender = gender;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Gender='" + gender.Replace("'", "''") + "' WHERE Intervention_ID=" + interventionID + ";");
}
//Set intervention code
public void setCode(int code)
{
this.code = code;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Code=" + code + " WHERE Intervention_ID=" + interventionID + ";");
}
//Set first responder arrival time
public void setFirstResponderArrivalTime(DateTime firstResponderArrivalTime)
{
this.firstResponderArrivalTime = firstResponderArrivalTime;
StaticDBConnection.NonQueryDatabase("UPDATE [Calls] SET Ambulance_Time='" + StaticDBConnection.DateTimeSQLite(firstResponderArrivalTime) + "' WHERE Call_ID=" + callID + ";");
}
//Set conclusion
public void setConclusion(String conclusion)
{
this.conclusion = conclusion;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Conclusion='" + StaticDBConnection.GetResourceName(conclusion).Replace("'", "''") + "' WHERE Intervention_ID=" + interventionID + ";");
}
//Set ambulance company
public void setAmbulanceCompany(String ambulanceCompany)
{
this.ambulanceCompany = ambulanceCompany;
StaticDBConnection.NonQueryDatabase("UPDATE [Calls] SET Ambulance_Company='" + ambulanceCompany.Replace("'", "''") + "' WHERE Call_ID=" + callID + ";");
}
//Set location
public void setLocation(String location)
{
this.location = location;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Location='" + location.Replace("'", "''") + "' WHERE Intervention_ID=" + interventionID + ";");
}
//Set ambulance arrival time
public void setAmbulanceArrivalTime(DateTime ambulanceArrivalTime)
{
this.ambulanceArrivalTime = ambulanceArrivalTime;
StaticDBConnection.NonQueryDatabase("UPDATE [Calls] SET Ambulance_Time='" + StaticDBConnection.DateTimeSQLite(ambulanceArrivalTime) + "' WHERE Call_ID=" + callID + ";");
}
//Set chief complaint
public void setChiefComplaint(String chiefComplaint)
{
this.chiefComplaint = chiefComplaint;
StaticDBConnection.NonQueryDatabase("UPDATE [Interventions] SET Chief_Complaint='" + StaticDBConnection.GetResourceName(chiefComplaint).Replace("'", "''") + "' WHERE Intervention_ID=" + interventionID + ";");
}
