public List <StudentModel> AlphabeticalOrderByCourse()
        {
            List <StudentModel> studentList = new List <StudentModel>();

            StudentDAO     st     = new StudentDAO();
            List <Student> stList = st.GetAllByOrder();

            foreach (Student student in stList)
            {
                StudentModel studentModel = new StudentModel();
                studentModel.Id          = student.Id;
                studentModel.Name        = student.Name;
                studentModel.CourseId    = student.CourseId;
                studentModel.Course.Id   = student.Course.Id;
                studentModel.Course.Name = student.Course.Name;
                studentModel.Course.Cost = student.Course.CourseCost;
                studentList.Add(studentModel);
            }

            return(studentList);
        }