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);
}