private void Facilities_Load(object sender, EventArgs e) { using (var MedDB = new MedicalEntities()) { try { if (MedDB.Facilities.Count() == 0) { AddFacility("Hospitality Hospital", "35101 place way", "12345", "3145442183", "Kansas City", "Kansas"); AddFacility("Gamble Hospital", "666 casino avenue", "77777", "2175343133", "Timbuktu", "Missouri"); AddFacility("Cavendish Memorial Hospital", "61253 Musa acuminata road", "73457", "5175643233", "Triploid", "California"); EmployeesForm.AddEmployee(MedDB.Facilities.First().FacilityID, "Sammy", "Lea", "Roberts", "315-223-9193", 0, 99.99m, "Janitor Sir", true); PatientsForm.AddPatient(MedDB.Facilities.First().FacilityID, "Kenneth", "William", "Sweet", MedDB.Employees.First().EmployeeID); } } catch (Exception exc) { MessageBox.Show(exc.Message); throw; } UpdateFacilities(); // filters out the Navigation properties id fields dgvFacilities.Columns["FacilityID"].Visible = false; dgvFacilities.Columns["FacilityEvents"].Visible = false; dgvFacilities.Columns["Patients"].Visible = false; dgvFacilities.Columns["Drugs"].Visible = false; dgvFacilities.Columns["Employees"].Visible = false; // enable after population } }
private void btnContinue_Click(object sender, EventArgs e) { if (_newFacility) { FacilitiesForm.AddFacility(this.txtName.Text, this.txtAddress.Text, this.txtZip.Text, this.txtPhone.Text, this.txtCity.Text, this.lbStates.Text); } else { using (var MedDB = new MedicalEntities()) { var entry = MedDB.Facilities.Find(_facility.FacilityID); _facility.Address = this.txtAddress.Text; _facility.City = this.txtCity.Text; _facility.Name = this.txtName.Text; _facility.Phone = this.txtPhone.Text; _facility.Zip = this.txtZip.Text; _facility.State = this.lbStates.Text; MedDB.Entry(entry).CurrentValues.SetValues(_facility); MedDB.SaveChanges(); } } this.Close(); }
public void UpdateFacilities() { using (var MedDB = new MedicalEntities()) { MedDB.Facilities.Load(); dgvFacilities.DataSource = MedDB.Facilities.Local; } }
private void AddPatient(string fname, string mname, string lname) { using (var MedDB = new MedicalEntities()) { Patient p = new Patient() { FacilityID = _facility.FacilityID, FirstName = fname, MiddleName = lname, Status = 0, PatientID = Guid.NewGuid() }; MedDB.Patients.Add(p); MedDB.SaveChanges(); } }
public static void AddFacility(string name, string address, string zip, string phone, string city, string state) { using (var MedDB = new MedicalEntities()) { Facility f = new Facility(); f.FacilityID = Guid.NewGuid(); f.Name = name; f.Address = address; f.Zip = zip; f.Phone = phone; f.City = city; f.State = state; MedDB.Facilities.Add(f); MedDB.SaveChanges(); //UpdateFacilities(); } }
private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show($"Are you sure you want to delete {selection.Name} from the facilities table?", "Are You Sure?", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { MessageBox.Show($"{selection.Name} was sucessfully deleted from the facilities table!"); using (var MedDB = new MedicalEntities()) { MedDB.Entry(selection).State = EntityState.Deleted; MedDB.SaveChanges(); } UpdateFacilities(); } }
public static void AddPatient(Guid facility, string fname, string mname, string lname) { using (var MedDB = new MedicalEntities()) { Patient p = new Patient() { FacilityID = facility, FirstName = fname, MiddleName = mname, LastName = lname, Status = 0, PatientID = Guid.NewGuid() }; MedDB.Patients.Add(p); MedDB.SaveChanges(); } }
private void Patients_Load(object sender, EventArgs e) { using (var MedDB = new MedicalEntities()) { dgvPatients.DataSource = MedDB.Facilities.Attach(_facility).Patients.ToList(); } dgvPatients.Columns["FacilityID"].Visible = false; dgvPatients.Columns["Status"].Visible = false; dgvPatients.Columns["PatientID"].Visible = false; dgvPatients.Columns["NurseID"].Visible = false; dgvPatients.Columns["Facility"].Visible = false; dgvPatients.Columns["Nurse"].Visible = false; dgvPatients.Columns["Notes"].Visible = false; dgvPatients.Columns["FacilityEvents"].Visible = false; dgvPatients.Columns["Contacts"].Visible = false; dgvPatients.Columns["Treatments"].Visible = false; }
public static void AddEmployee(Guid facility, string fname, string mname, string lname, string phone, int position, decimal salary, string title, bool working) { using (var MedDB = new MedicalEntities()) { Employee e = new Employee() { EmployeeID = Guid.NewGuid(), FirstName = fname, MiddleName = mname, LastName = lname, Phone = phone, Position = position, Salary = salary, Title = title, Working = working }; MedDB.Employees.Add(e); MedDB.SaveChanges(); } }