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; } }
public void DisplayPracType() { var allPracType = AvailabilityDB.GetAllPracType(); foreach (var item in allPracType) { PracTypes.Add(item); } }
public void DisplayDays() { var alldays = AvailabilityDB.GetAllDays(); foreach (var item in alldays) { Days.Add(item); } }
public void getAvail() { foreach (Days days in Days) { days.isChecked = false; foreach (Days avail in AvailabilityDB.GetAvailabilities(SelectedPractitioner)) { if (avail.dayID == days.dayID) { days.isChecked = true; } } } }
private void insertDays(Practitioner practitioner) { int lastRow = Practitioners.Count; for (int i = 0; i <= lastRow; i++) { if (i == lastRow) { foreach (Days d in Days) { if (d.isChecked == true) { rowsAffected = AvailabilityDB.insertAvailDays(practitioner.practitionerID, d.dayID); } } } } }
public AvailibilityManager(IConfiguration configuration) { AvailibilityDb = new AvailabilityDB(configuration); }