private void UpdatePractitioner() { try { rowsAffected = PractitionerDB.updatePractitioner(SelectedPractitioner); int delete = AvailabilityDB.deleteAvailDays(SelectedPractitioner.practitionerID); foreach (Days d in Days) { if (d.isChecked == true) { rowsAffected = AvailabilityDB.insertAvailDays(SelectedPractitioner.practitionerID, d.dayID); } } //Practitioners.Clear(); //DisplayAllPractitioner(); if (rowsAffected != 0) { MessageBox.Show("Practitioner Updated"); } else { MessageBox.Show("Update Failed"); } } catch (Exception e) { throw e; } }
//Method to displayAllPractitioner public void DisplayAllPractitioner() { var allPractitioner = PractitionerDB.GetAllPractitioners(); foreach (var item in allPractitioner) { Practitioners.Add(item); } }
//Method to call the searchpatient instance from the PatientDB. //This method will be attached to the button 'Search' command. private void SearchPractitioner() { Practitioners.Clear(); var search = PractitionerDB.SearchPractitioner(SearchInput); foreach (var item in search) { Practitioners.Add(item); } }
//Method to call the instance of insertPatient from the PatientDB. //This method will be attached to the button 'Insert' command. private void InsertPractitioner() { try { rowsAffected = PractitionerDB.insertPractitioner(SelectedPractitioner); insertDays(SelectedPractitioner); //Practitioners.Clear(); //DisplayAllPractitioner(); if (rowsAffected != 0) { MessageBox.Show("Practitioner Added"); } else { MessageBox.Show("Insert Failed"); } } catch (Exception e) { throw e; } }