public IEnumerable <EnrollmentInfoDto> GetStudentEnrollments(string id)
{
var list = new List <EnrollmentInfoDto>();
using (SqlConnection connection = new SqlConnection(ConString))
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "select s.IndexNumber, e.Semester, st.Name, e.StartDate " +
"from Student s " +
"join Enrollment e on e.IdEnrollment = s.IdEnrollment " +
"join Studies st on st.IdStudy = e.IdStudy " +
"where s.IndexNumber = @id";
command.Parameters.AddWithValue("id", id);
connection.Open();
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
var enrollment = new EnrollmentInfoDto
{
Semester = dataReader["Semester"].ToString(),
Name = dataReader["Name"].ToString(),
StartDate = dataReader["StartDate"].ToString()
};
list.Add(enrollment);
}
}
return(list);
}
public async Task <IActionResult> EnrollStudent()
{
using (var connect = new SqlConnection(ConString))
using (var command = new SqlCommand())
{
command.Connection = connect;
connect.Open();
var tran = connect.BeginTransaction();
try {
}
catch (SqlException exc)
{
tran.Rollback();
}
var enrollment = new EnrollmentInfoDto();
return(CreatedAtAction("enroll", enrollment));
}
}
