public async Task <IEnumerable <Practice> > GetPracticesAsync()
{
var qf = new QueryFactory();
var q = qf.Create <PracticeEntity>();
using (var adapter = AdapterFactory.CreateAdapter(_connectionString, "DEVTEST"))
{
var practiceEntities = await adapter.FetchQueryAsync(q);
var practices = new List <Practice>();
foreach (PracticeEntity practice in practiceEntities)
{
practices.Add(new Practice(practice));
}
return(practices);
}
}
public async Task <IEnumerable <ClinicDto> > GetClinicsAsync(Guid practicePk)
{
var qf = new QueryFactory();
var q = qf.Create <ClinicEntity>()
.Where(ClinicFields.PracticePk.Equal(practicePk));
using (var adapter = AdapterFactory.CreateAdapter(_connectionString, _environment))
{
var results = await adapter.FetchQueryAsync <ClinicEntity>(q);
var clinics = new List <ClinicDto>();
foreach (ClinicEntity clinic in results)
{
clinics.Add(new ClinicDto()
{
ClinicName = clinic.Name,
ClinicPk = clinic.ClinicPk,
PracticePk = clinic.PracticePk
});
}
return(clinics);
}
}