public void TestGetAllAppoitments()
        {
            SqlAppointment sql = new SqlAppointment();

            IEnumerable <ClassAppointment> querry = from elem in sql.GetAllAppoitments()
                                                    where elem.Doctor.Doctor_id == 1 && elem.AppointmendtId == 1 && elem.Patient.PatientId == 1
                                                    select elem;

            Xunit.Assert.Single(querry);
        }
        public void TestUpdateAppointment(int appointmentId, string description, string topic)
        {
            SqlAppointment sql = new SqlAppointment();

            sql.UpdateAppointment(appointmentId, description, topic);

            IEnumerable <ClassAppointment> querry = from elem in sql.GetAllAppoitments()
                                                    where elem.AppointmendtId == 1 && elem.Description == "Badania3" && elem.Topic == "badania3"
                                                    select elem;

            Xunit.Assert.Single(querry);
        }