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

            IEnumerable <ClassTerm> querry = from elem in sql.AppointmentsDateForCombobox()
                                             where elem.TermId == 1 && elem.StartTime == new TimeSpan(7, 0, 0)
                                             select elem;

            Xunit.Assert.Single(querry);
        }
        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);
        }