public GroupDto GetGroupByName(string name) { GroupDto groupDto = new GroupDto(-1, ""); using (SqlConnection connection = DatabaseProvider.GetSqlConnection()) { SqlParameter[] parameters = { new SqlParameter("@name", name) }; using (IDataReader reader = DatabaseProvider.ExecuteCommand <IDataReader>(connection, GETGROUPBYNAME, CommandType.StoredProcedure, parameters)) { while (reader.Read()) { groupDto = DtoHelper.GetDto <GroupDto>(reader); } } } return(groupDto); }
public IList <FeedbackDto> GetAllFeedbacksForActualClass(int classId) { IList <FeedbackDto> feedbacks = new List <FeedbackDto>(); using (SqlConnection connection = DatabaseProvider.GetSqlConnection()) { SqlParameter[] parameters = { new SqlParameter("@actualClassId", classId) }; using (IDataReader reader = DatabaseProvider.ExecuteCommand <IDataReader>(connection, GETFEEDBACKS, CommandType.StoredProcedure, parameters)) { while (reader.Read()) { FeedbackDto fb = DtoHelper.GetDto <FeedbackDto>(reader); feedbacks.Add(fb); } } } return(feedbacks); }
public IList <AppointmentDto> GetAllAppointmentDtosForStudentDto(int studentId) { IList <AppointmentDto> feedbacks = new List <AppointmentDto>(); using (SqlConnection connection = DatabaseProvider.GetSqlConnection()) { SqlParameter[] parameters = { new SqlParameter("@id", studentId) }; using (IDataReader reader = DatabaseProvider.ExecuteCommand <IDataReader>(connection, GETAPPOINTMENTS, CommandType.StoredProcedure, parameters)) { while (reader.Read()) { AppointmentDto app = DtoHelper.GetDto <AppointmentDto>(reader); feedbacks.Add(app); } } } return(feedbacks); }