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; } } } } }
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(); } } } }