public async Task <IEnumerable <Appointment> > GetAppointmentsByDateAsync(DateTime date)
{
try
{
var result = await _sql.LoadData <Appointment, dynamic>("spAppointments_GetByDate", new { AppointmentDate = date.Date });
return(result);
}
catch (SqlException)
{
throw;
}
}
public async Task <Patient> GetPatientByIdAsync(int id)
{
try
{
var patient = await _sql.LoadData <Patient, dynamic>("spPatients_GetById", new { Id = id });
return(patient.FirstOrDefault());
}
catch (SqlException)
{
throw;
}
}
public async Task <Intervention> GetInterventionById(int id)
{
try
{
var result = await _sql.LoadData <Intervention, dynamic>("spIntervention_GetById", new { Id = id });
return(result.FirstOrDefault());
}
catch (SqlException)
{
throw;
}
}
public async Task <Tooth> GetToothByIdAsync(int id)
{
var output = await _sql.LoadData <Tooth, dynamic>("spTooth_GetById", new { Id = id });
return(output.FirstOrDefault());
}