public async Task <ActionResult <List <Lecturer> > > GetAllLecturersForCourse(int courseID)
        {
            if (Validation.IsAnyInputObjectDataNotSpecified(new List <object> {
                courseID
            }))
            {
                return(BadRequest("Error: course ID must be specified (with non-zero value)"));
            }

            using (var connection = new SqlConnection(Configuration.GetConnectionString("DefaultConnection")))
            {
                try
                {
                    connection.Open();

                    var lecturersForCourse = await CoursesLecturersRepository.GetAllLecturersForCourseAsync(connection, courseID);

                    if (lecturersForCourse.Count == 0)
                    {
                        return(NotFound("There aren't any lecturers on this course"));
                    }

                    return(lecturersForCourse);
                }
                catch (Exception ex)
                {
                    return(BadRequest(ex.Message));
                }
            }
        }