public async override Task <DoctorDto> GetByIdAsync(int id) { string sql = "exec [dbo].[GetDoctor] @id"; using (SqlConnection connection = new SqlConnection(_connectionString)) using (SqlCommand command = connection.CreateCommand()) { connection.Open(); command.CommandText = sql; command.Parameters.AddWithValue("id", id); using (var reader = await command.ExecuteReaderAsync()) { reader.Read(); var doctor = await ParserExtension.DoctorParser(reader); return(doctor); } } }
public async override Task <IEnumerable <DoctorDto> > GetAllAsync() { var doctors = new List <DoctorDto>(); string sql = "exec [dbo].[GetAllDoctors]"; using (SqlConnection connection = new SqlConnection(_connectionString)) using (SqlCommand command = connection.CreateCommand()) { connection.Open(); command.CommandText = sql; using (var reader = await command.ExecuteReaderAsync()) { while (reader.Read()) { var doctor = await ParserExtension.DoctorParser(reader); doctors.Add(doctor); } } return(doctors); } }
public async Task <IEnumerable <DoctorDto> > SearchAsync(string pattern) { var doctors = new List <DoctorDto>(); string sql = "exec [dbo].[SearchDoctors] @pattern"; using (SqlConnection connection = new SqlConnection(_connectionString)) using (SqlCommand command = connection.CreateCommand()) { connection.Open(); command.CommandText = sql; command.Parameters.AddWithValue("pattern", pattern); using (var reader = await command.ExecuteReaderAsync()) { while (reader.Read()) { var doctor = await ParserExtension.DoctorParser(reader); doctors.Add(doctor); } } return(doctors); } }