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);
}
