public AddOfficerForm()
{
InitializeComponent();
using (StaffMemberContext dc = new StaffMemberContext())
{
var ambulances = from k in dc.Ambulances select k;
String[] ambulance = new String[ambulances.Count()];
int count = 0;
foreach (Ambulance a in ambulances)
{
ambulance[count] = a.AmbulanceID;
count += 1;
}
String[] skills = { "Basic", "Intermediate", "Advanced" };
for (int h = 0; h < skills.Length; h++)
{
skillComboBox.Items.Add(skills[h]);
}
for (int i = 0; i < ambulance.Length; i++)
{
ambComboBox.Items.Add(ambulance[i]);
}
skillComboBox.SelectedIndex = 0;
ambComboBox.SelectedIndex = 0;
validateFirst();
validateSur();
validateSkill();
validateAmbulance();
validateID();
}
fnTextBox.Focus();
}
public AmbulanceOfficerForm()
{
InitializeComponent(); try
{
using (StaffMemberContext db = new StaffMemberContext())
{
var rowSelect = from h in db.StaffMembers select h;
String ambulanceID = "";
foreach (StaffMember officer in rowSelect)
{
if (officer.AmbulanceID == null)
{
ambulanceID = "None";
}
else
{
ambulanceID = officer.AmbulanceID;
}
amboffcrtable.Rows.Add(officer.ID, officer.GivenNames + " " + officer.Surname, officer.SkillLevel, ambulanceID);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
Environment.Exit(0);
}
}
private void ambulanceTable_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
String oldID = "";
String oldStation = "";
int count = 0;//Counter for crew loop.
foreach (DataGridViewRow row in ambulanceTable.SelectedRows)
{
oldID += row.Cells[0].Value.ToString();
oldStation += row.Cells[1].Value.ToString();
}
using (StaffMemberContext dj = new StaffMemberContext())
{
var crewCheck = from r in dj.StaffMembers where r.AmbulanceID == oldID select r;
String[] crewList = new String[crewCheck.Count()];
foreach (StaffMember crew in crewCheck)
{
crewList[count] = crew.GivenNames + " " + crew.Surname;
count++;
}
AddAmbulanceForm editForm = new AddAmbulanceForm(oldID, oldStation, crewList);
editForm.Visible = true;
Visible = false;
}
}
private void savebtn_Click(object sender, EventArgs e)
{
using (StaffMemberContext db = new StaffMemberContext())
{
String surname = lnTexBox.Text;
String firstNames = fnTextBox.Text;
String ID = idTextBox.Text;
String skill = skillComboBox.SelectedItem.ToString();
String ambID = ambComboBox.SelectedItem.ToString();
int x;
if (idTextBox.ReadOnly)
{
var idCheck = from j in db.StaffMembers where j.ID == ID select j;
idCheck.First().GivenNames = firstNames.Replace(" ", "");
idCheck.First().Surname = surname;
idCheck.First().SkillLevel = skill;
idCheck.First().AmbulanceID = ambID;
db.SaveChanges();
AmbulanceOfficerForm ambulance = new AmbulanceOfficerForm();
ambulance.Visible = true;
Visible = false;
}
else
{
if (!(int.TryParse(ID, out x)) || ID.Length != 6)
{
MessageBox.Show("ID must be a number.\n Or the ID length must be of length 6.");
idTextBox.Clear();
idTextBox.Focus();
}
else
{
var idCheck = from j in db.StaffMembers where j.ID == ID select j;
if (idCheck.Count() != 0)
{
MessageBox.Show("ID must be unique.");
idTextBox.Clear();
idTextBox.Focus();
}
else
{
var newMem = new StaffMember {
GivenNames = firstNames, Surname = surname, ID = ID, SkillLevel = skill, AmbulanceID = ambID
};
db.StaffMembers.Add(newMem);
db.SaveChanges();
AmbulanceOfficerForm ambulance = new AmbulanceOfficerForm();
ambulance.Visible = true;
Visible = false;
}
}
}
}
}
public RosterForm()
{
InitializeComponent();
using (StaffMemberContext dl = new StaffMemberContext())
{
var ambCount = from d in dl.Ambulances select d;
foreach (Ambulance a in ambCount)
{
String idA = a.AmbulanceID;
TextBox rosterBox = new TextBox();
rosterBox.Location = new Point(x, y);
rosterBox.Width = width;
rosterBox.Height = height;
rosterBox.Multiline = true;
rosterBox.ReadOnly = true;
rosterBox.ScrollBars = ScrollBars.Vertical;
y = y + height + 22;//Gap between two buttons.
using (StaffMemberContext dp = new StaffMemberContext())
{
var crewCount = from w in dp.StaffMembers where w.AmbulanceID == idA select w;
string[] crewList = new string[crewCount.Count()];
int count = 0;
foreach (StaffMember staff in crewCount)
{
crewList[count] = staff.ID + " (" + staff.SkillLevel + ")";
count++;
}
rosterBox.Text = a.AmbulanceID + Environment.NewLine + string.Join(Environment.NewLine, crewList);
switch (paintSwatch)
{
case 0:
rosterBox.BackColor = Color.Crimson;
paintSwatch++;
break;
case 1:
rosterBox.BackColor = Color.GhostWhite;
paintSwatch--;
break;
}
}
rosterPanel.Controls.Add(rosterBox);
}
}
}
public AddOfficerForm(String givenNames, String surname, String ID, String skill, String AmbulanceID)
{
InitializeComponent();
int counterA = 0; // count of Skill Combo Box Index.
int counterS = 0; //counter of Ambulance Combo Box.
using (StaffMemberContext dc = new StaffMemberContext())
{
var ambulances = from k in dc.Ambulances select k;
String[] ambulance = new String[ambulances.Count() + 1];
ambulance[0] = "None";
int count = 1;
foreach (Ambulance a in ambulances)
{
ambulance[count] = a.AmbulanceID;
count += 1;
}
String[] skills = { "Basic", "Intermediate", "Advanced" };
for (int h = 0; h < skills.Length; h++)
{
skillComboBox.Items.Add(skills[h]);
if (skills[h].Equals(skill))
{
counterS = h;
}
}
for (int i = 0; i < ambulance.Length; i++)
{
ambComboBox.Items.Add(ambulance[i]);
if (ambulance[i].Equals(AmbulanceID))
{
counterA = i;
}
}
}
titlelbl.Text = "Ambulance Officer: " + givenNames + surname;
fnTextBox.Text = givenNames;
lnTexBox.Text = surname;
idTextBox.Text = ID;
idTextBox.ReadOnly = true;
skillComboBox.SelectedIndex = counterS;
ambComboBox.SelectedIndex = counterA;
fnTextBox.Focus();
}
public AmbulanceForm()
{
InitializeComponent();
try
{
using (StaffMemberContext db = new StaffMemberContext())
{
var rowSelect = from h in db.Ambulances select h;
foreach (Ambulance ambulance in rowSelect)
{
ambulanceTable.Rows.Add(ambulance.AmbulanceID, ambulance.Station);
}
}
}catch (Exception e)
{
Console.WriteLine(e.StackTrace);
Environment.Exit(0);
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
using (StaffMemberContext db = new StaffMemberContext())
{
String aID = AIDTextBox.Text;
String station = StationTextBox.Text;
string isA = aID.Substring(0, 1);
int x;
if (aID.Length > 4)
{
MessageBox.Show("Ambulance ID must be at least length 4.");
AIDTextBox.Clear();
AIDTextBox.Focus();
}
if (!(isA.Equals("A")))
{
MessageBox.Show("Ambulance ID must start with 'A'.");
AIDTextBox.Clear();
AIDTextBox.Focus();
}
else
{
String intCheck = aID.Substring(1);
if (int.TryParse(intCheck, out x))
{
if (AIDTextBox.BackColor.Equals(Color.AliceBlue))
{
using (StaffMemberContext dp = new StaffMemberContext())
{
var amb = from s in dp.Ambulances where s.AmbulanceID == aIDb select s;
var updateStaff = from t in dp.StaffMembers where t.AmbulanceID == aIDb select t;
foreach (StaffMember s in updateStaff)
{
s.AmbulanceID = aID;
}
String istasyon = amb.First().Station;
dp.Ambulances.RemoveRange(amb);
var updatedAmb = new Ambulance {
AmbulanceID = aID, Station = istasyon
};
dp.Ambulances.Add(updatedAmb);
dp.SaveChanges();
AmbulanceForm returnForm = new AmbulanceForm();
returnForm.Visible = true;
Visible = false;
}
}
else
{
var idCheck = from g in db.Ambulances where g.AmbulanceID == aID select g;
if (idCheck.Count() == 0)
{
var newAmb = new Ambulance {
AmbulanceID = aID, Station = station
};
db.Ambulances.Add(newAmb);
db.SaveChanges();
AmbulanceForm returnForm = new AmbulanceForm();
returnForm.Visible = true;
Visible = false;
}
else
{
MessageBox.Show("Ambulance ID must be unique.");
AIDTextBox.Clear();
AIDTextBox.Focus();
}
}
}
else
{
MessageBox.Show("The sequence following 'A' must be an integer.");
AIDTextBox.Clear();
AIDTextBox.Focus();
}
}
}
}