internal DoctorDetail Detail(DoctorFullData data) { SqlCommand command = CreateQuery(GetQueryText("GetAllPatientsForDoctor", new Dictionary <string, string> { { "doctorId", data.Id.ToString() } })); SqlDataReader reader = command.ExecuteReader(); IList <PatientForDoctor> patients = Get <PropertyToColumnMapper <PatientForDoctor> >().Map(reader); reader.Close(); var detailData = new DoctorDetail { Id = data.Id, FirstName = data.FirstName, LastName = data.LastName, ThirdName = data.ThirdName, Login = data.Login, Password = data.Password, Role = data.Role, Specialty = data.Specialty, Token = data.Token, Birthday = data.Birthday, Patients = patients }; return(detailData); }
internal QueryStatus Delete(DoctorFullData data) { SqlCommand command = CreateQuery(GetQueryText("DeleteDoctor", new Dictionary<string, string> {{"doctorId", data.Id.ToString()}})); SqlDataReader reader = command.ExecuteReader(); IList<QueryStatus> results = Get<PropertyToColumnMapper<QueryStatus>>().Map(reader); reader.Close(); return results.FirstOrDefault(); }
internal QueryStatus Delete(DoctorFullData data) { SqlCommand command = CreateQuery(GetQueryText("DeleteDoctor", new Dictionary <string, string> { { "doctorId", data.Id.ToString() } })); SqlDataReader reader = command.ExecuteReader(); IList <QueryStatus> results = Get <PropertyToColumnMapper <QueryStatus> >().Map(reader); reader.Close(); return(results.FirstOrDefault()); }
internal DoctorDetail Detail(DoctorFullData data) { SqlCommand command = CreateQuery(GetQueryText("GetAllPatientsForDoctor", new Dictionary<string, string> {{"doctorId", data.Id.ToString()}})); SqlDataReader reader = command.ExecuteReader(); IList<PatientForDoctor> patients = Get<PropertyToColumnMapper<PatientForDoctor>>().Map(reader); reader.Close(); var detailData = new DoctorDetail { Id = data.Id, FirstName = data.FirstName, LastName = data.LastName, ThirdName = data.ThirdName, Login = data.Login, Password = data.Password, Role = data.Role, Specialty = data.Specialty, Token = data.Token, Birthday = data.Birthday, Patients = patients }; return detailData; }