Exemple #1
0
        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;
            }
        }
Exemple #2
0
        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);
                        }
                    }
                }
            }
        }