/// <summary>
/// A function that removes a user from a course
/// </summary>
public ActionResult RemoveFromCourse(string ID, int courseID, string role)
{
#region Security
if (EnforceSecurity(SecurityState.ADMIN) != null)
{
return(EnforceSecurity(SecurityState.ADMIN));
}
#endregion
if (role == "Teacher")
{
Course_Teacher teacherToDelete = (from x in db.CoursesTeachers
where x.TeacherID == ID &&
x.CourseID == courseID
select x).SingleOrDefault();
db.CoursesTeachers.Remove(teacherToDelete);
db.SaveChanges();
}
else if (role == "Student")
{
Course_Student studentToDelete = (from x in db.CoursesStudents
where x.UserID == ID &&
x.CourseID == courseID
select x).SingleOrDefault();
db.CoursesStudents.Remove(studentToDelete);
db.SaveChanges();
}
return(RedirectToAction("CourseConnections", new { courseID = courseID }));
}
public static Course GetCourseByTeacher(string teacherName)
{
using (context = new Context()){
Guid teacherId = TeacherController.GetTeacherID(teacherName);
Course_Teacher course_Teacher = context.Course_Teachers.Where(x => x.TeacherID == teacherId).FirstOrDefault();
return(CourseController.GetCourseById(course_Teacher.CourseID));
}
}
/// <summary>
/// A function that connects a teacher to a course in the database
/// </summary>
public void ConnectTeachers(string userID, int courseID)
{
Course_Teacher newTeacher = new Course_Teacher
{
TeacherID = userID,
CourseID = courseID
};
db.CoursesTeachers.Add(newTeacher);
db.SaveChanges();
return;
}
public static void AddConnectionCourseTeacher()
{
using (context = new Context()){
Course_Teacher newConnection = new Course_Teacher();
newConnection.ID = Guid.NewGuid();
newConnection.TeacherID = RandomData.GetRandomTeacherID();
newConnection.CourseID = RandomData.GetRandomCourseID();
if (context.Course_Teachers.ToList().Any(x => x.TeacherID == newConnection.TeacherID && x.CourseID == newConnection.CourseID))
{
throw new ArgumentException("Connection already exists");
}
context.Course_Teachers.Add(newConnection);
context.SaveChanges();
}
}
public void Initialize()
{
MockDataContext mock = new MockDataContext();
#region Users
ApplicationUser user1 = new ApplicationUser
{
Id = "1",
Ssn = "1211",
Email = "*****@*****.**",
UserName = "******"
};
ApplicationUser user2 = new ApplicationUser
{
Id = "2",
Ssn = "2122",
Email = "*****@*****.**",
UserName = "******"
};
ApplicationUser user3 = new ApplicationUser
{
Id = "3",
Ssn = "3102",
Email = "*****@*****.**",
UserName = "******"
};
ApplicationUser user4 = new ApplicationUser
{
Id = "4",
Ssn = "3789",
Email = "*****@*****.**",
UserName = "******"
};
mock.Users.Add(user1);
mock.Users.Add(user2);
mock.Users.Add(user3);
mock.Users.Add(user4);
#endregion
#region Assignments
Assignment assignment1 = new Assignment
{
ID = 1,
Title = "HelloWorld",
Weight = 30,
CourseID = 1,
TestCases = "swag",
Description = "Forrita Hello World!",
ProgrammingLanguageID = 1,
DateCreated = new DateTime(2016, 6, 20),
DueDate = new DateTime(2016, 6, 30)
};
mock.Assignments.Add(assignment1);
#endregion
#region Milestones
Milestone milestone1 = new Milestone
{
ID = 1,
AssignmentID = 1,
Weight = 20,
Title = "mila",
Description = "mæla milu",
Input = "km",
Output = "milan",
Code = "1km",
TestCases = "profa km",
ProgrammingLanguageID = 1,
DateCreated = new DateTime(2016, 4, 20),
DueDate = new DateTime(2016, 4, 30)
};
Milestone milestone2 = new Milestone
{
ID = 2,
AssignmentID = 1,
Weight = 25,
Title = "samlagning",
Description = "leggja saman tölur",
Input = "2,8",
Output = "10",
Code = "cout << 2 + 8;",
TestCases = "profa tolur",
ProgrammingLanguageID = 2,
DateCreated = new DateTime(2016, 5, 20),
DueDate = new DateTime(2016, 5, 30)
};
Milestone milestone3 = new Milestone
{
ID = 3,
AssignmentID = 2,
Weight = 25,
Title = "samlagning",
Description = "leggja saman tölur",
Input = "2,4",
Output = "6",
Code = "cout << 2 + 4;",
TestCases = "profa tolur",
ProgrammingLanguageID = 2,
DateCreated = new DateTime(2016, 3, 20),
DueDate = new DateTime(2016, 3, 30)
};
mock.Milestones.Add(milestone1);
mock.Milestones.Add(milestone2);
mock.Milestones.Add(milestone3);
#endregion
#region CourseTeachers
Course_Teacher courseTeacher1 = new Course_Teacher
{
ID = 1,
CourseID = 1,
TeacherID = "1"
};
Course_Teacher courseTeacher2 = new Course_Teacher
{
ID = 2,
CourseID = 2,
TeacherID = "2"
};
Course_Teacher courseTeacher3 = new Course_Teacher
{
ID = 3,
CourseID = 1,
TeacherID = "3"
};
Course_Teacher courseTeacher4 = new Course_Teacher
{
ID = 4,
CourseID = 1,
TeacherID = "4"
};
mock.CoursesTeachers.Add(courseTeacher1);
mock.CoursesTeachers.Add(courseTeacher2);
mock.CoursesTeachers.Add(courseTeacher3);
mock.CoursesTeachers.Add(courseTeacher4);
#endregion
#region CourseStudents
Course_Student courseStudent1 = new Course_Student
{
ID = 1,
CourseID = 1,
UserID = "1"
};
Course_Student courseStudent2 = new Course_Student
{
ID = 2,
CourseID = 2,
UserID = "2"
};
Course_Student courseStudent3 = new Course_Student
{
ID = 3,
CourseID = 2,
UserID = "3"
};
Course_Student courseStudent4 = new Course_Student
{
ID = 4,
CourseID = 1,
UserID = "4"
};
mock.CoursesStudents.Add(courseStudent1);
mock.CoursesStudents.Add(courseStudent2);
mock.CoursesStudents.Add(courseStudent3);
mock.CoursesStudents.Add(courseStudent4);
#endregion
#region Courses
Course course1 = new Course
{
ID = 1,
Name = "Byrjenda Forritun",
SchoolID = 1,
Semester = "Vorönn",
Year = 2013
};
Course course2 = new Course
{
ID = 2,
Name = "Leikjaorritun",
SchoolID = 2,
Semester = "Haustönn",
Year = 2018
};
mock.Courses.Add(course1);
mock.Courses.Add(course2);
#endregion
#region Solutions
Solution solution1 = new Solution
{
ID = 1,
MilestoneID = 1,
StudentID = "1",
Code = "Hello World",
SubmissionID = 1,
Grade = 6.7M
};
Solution solution2 = new Solution
{
ID = 2,
MilestoneID = 3,
StudentID = "2",
Code = "Hello Universe",
SubmissionID = 2,
Grade = 7.9M
};
mock.Solutions.Add(solution1);
mock.Solutions.Add(solution2);
#endregion
#region Submissions
Submission submission1 = new Submission
{
ID = 1,
UserID = "1",
MilestoneID = 1,
IsAccepted = true,
SolutionOutput = "Hello World",
ExpectedOutput = "Hello World",
Code = "cout << Hello World "
};
mock.Submission.Add(submission1);
#endregion
#region Admins
Admin admin1 = new Admin
{
ID = 1,
UserID = "1"
};
Admin admin2 = new Admin
{
ID = 2,
UserID = "2"
};
#endregion
personServiceTest = new PersonService(mock);
assignmentServiceTest = new AssignmentsService(mock);
courseServiceTest = new CourseService(mock);
solutionServiceTest = new SolutionService(mock);
}
