public static CourseViewModel ViewCourse(string id, bool isAdmin, bool isTeacher, bool isStudent)
{
CourseViewModel CourseViewModel = new CourseViewModel();
using (AttendanceTrackerDatabaseConnection context = new AttendanceTrackerDatabaseConnection())
{
AttendanceTracker.Course Course = context.Courses.FirstOrDefault(x => x.Id == new Guid(id));
CourseViewModel.Course = Course;
CourseViewModel.IsAdmin = isAdmin;
CourseViewModel.IsTeacher = isTeacher;
CourseViewModel.IsStudent = isStudent;
CourseViewModel.Room = Course.Room;
CourseViewModel.Building = Course.Room.Building;
List <CourseStudentStudent> studentsTemp = new List <CourseStudentStudent>();
foreach (var student in Course.CourseStudents)
{
studentsTemp.Add(new CourseStudentStudent(student, student.User));
}
CourseViewModel.Students = studentsTemp.OrderBy(x => x.User.LastName).ToList();
}
return(CourseViewModel);
}
public static CourseIndexTableModel FromCourse(AttendanceTracker.Course course, AttendanceTrackerDatabaseConnection database)
{
var model = new CourseIndexTableModel();
var requestContext = HttpContext.Current.Request.RequestContext;
var Url = new UrlHelper(requestContext);
var commandButtonLeftHtml = "<a href='" + Url.Action("View", "Course") + "?id=" + course.Id.ToString() + "' class='btn btn-default hl-view' style='margin-right: 3px;'><i class='fa fa-search'></i></span></a>";
commandButtonLeftHtml += "<a href='" + Url.Action("Edit", "Course") + "?id=" + course.Id.ToString() + "' class='btn btn-default hl-view' style='margin-right: 3px;'><i class='fa fa-pencil'></i></span></a>";
model.Id = commandButtonLeftHtml;
model.CourseName = course.CourseCode + " " + course.CourseNumber + "-" + course.CourseSection;
model.CourseTitle = course.CourseName;
model.CourseNumber = course.ClassNumber.ToString();
model.CourseSemesterYear = course.Semester + " " + course.Year;
return(model);
}
public static CourseEditModel CourseEdit(string id)
{
string addOrEdit;
if (string.IsNullOrEmpty(id))
{
CourseEditModel CourseEditModel = new CourseEditModel(new AttendanceTracker.Course(), "Add");
return(CourseEditModel);
}
else
{
AttendanceTracker.Course course = new AttendanceTracker.Course();
using (AttendanceTrackerDatabaseConnection context = new AttendanceTrackerDatabaseConnection())
{
course = context.Courses.FirstOrDefault(x => x.Id == new Guid(id));
}
CourseEditModel CourseEditModel = new CourseEditModel(course, "Edit");
return(CourseEditModel);;
}
}
public CourseEditModel(AttendanceTracker.Course course, string addOrEdit)
{
AddOrEdit = addOrEdit;
Id = course.Id;
CourseCode = course.CourseCode;
CourseNumber = course.CourseNumber;
CourseSection = course.CourseSection;
CourseName = course.CourseName;
ClassNumber = course.ClassNumber;
IsActive = course.IsActive;
IsOnSunday = course.IsOnSunday;
IsOnMonday = course.IsOnMonday;
IsOnTuesday = course.IsOnTuesday;
IsOnWednesday = course.IsOnWednesday;
IsOnThursday = course.IsOnThursday;
IsOnFriday = course.IsOnFriday;
IsOnSaturday = course.IsOnSaturday;
StartTime = course.StartTime;
StopTime = course.StopTime;
Semester = course.Semester;
Year = course.Year;
LocationRoomId = course.LocationRoomId;
ActiveAttendanceCode = course.ActiveAttendanceCode;
}
public static AttendanceTracker.Course CourseEditPost(CourseEditModel courseModel, string userId)
{
AttendanceTracker.Course databaseCourse = new AttendanceTracker.Course();
using (AttendanceTrackerDatabaseConnection context = new AttendanceTrackerDatabaseConnection())
{
databaseCourse = context.Courses.FirstOrDefault(x => x.Id == courseModel.Id);
if (databaseCourse != null)
{
databaseCourse.CourseCode = courseModel.CourseCode;
databaseCourse.CourseNumber = courseModel.CourseNumber;
databaseCourse.CourseSection = courseModel.CourseSection;
databaseCourse.CourseName = courseModel.CourseName;
databaseCourse.ClassNumber = courseModel.ClassNumber;
databaseCourse.IsActive = courseModel.IsActive;
databaseCourse.IsOnSunday = courseModel.IsOnSunday;
databaseCourse.IsOnMonday = courseModel.IsOnMonday;
databaseCourse.IsOnTuesday = courseModel.IsOnTuesday;
databaseCourse.IsOnWednesday = courseModel.IsOnWednesday;
databaseCourse.IsOnThursday = courseModel.IsOnThursday;
databaseCourse.IsOnFriday = courseModel.IsOnFriday;
databaseCourse.IsOnSaturday = courseModel.IsOnSaturday;
databaseCourse.StartTime = courseModel.StartTime;
databaseCourse.StopTime = courseModel.StopTime;
databaseCourse.Semester = courseModel.Semester;
databaseCourse.Year = courseModel.Year;
databaseCourse.LocationRoomId = courseModel.LocationRoomId;
databaseCourse.ActiveAttendanceCode = courseModel.ActiveAttendanceCode;
}
else
{
databaseCourse = new AttendanceTracker.Course();
var databaseCourseTeacher = new AttendanceTracker.CourseOwner();
databaseCourse.CourseCode = courseModel.CourseCode;
databaseCourse.CourseNumber = courseModel.CourseNumber;
databaseCourse.CourseSection = courseModel.CourseSection;
databaseCourse.CourseName = courseModel.CourseName;
databaseCourse.ClassNumber = courseModel.ClassNumber;
databaseCourse.IsActive = courseModel.IsActive;
databaseCourse.IsOnSunday = courseModel.IsOnSunday;
databaseCourse.IsOnMonday = courseModel.IsOnMonday;
databaseCourse.IsOnTuesday = courseModel.IsOnTuesday;
databaseCourse.IsOnWednesday = courseModel.IsOnWednesday;
databaseCourse.IsOnThursday = courseModel.IsOnThursday;
databaseCourse.IsOnFriday = courseModel.IsOnFriday;
databaseCourse.IsOnSaturday = courseModel.IsOnSaturday;
databaseCourse.StartTime = courseModel.StartTime;
databaseCourse.StopTime = courseModel.StopTime;
databaseCourse.Semester = courseModel.Semester;
databaseCourse.Year = courseModel.Year;
databaseCourse.LocationRoomId = courseModel.LocationRoomId;
databaseCourse.ActiveAttendanceCode = courseModel.ActiveAttendanceCode;
databaseCourse.Id = Guid.NewGuid();
databaseCourseTeacher.Id = Guid.NewGuid();
databaseCourseTeacher.CourseId = databaseCourse.Id;
databaseCourseTeacher.UserId = context.Users.FirstOrDefault(x => x.AspNetUsersId == userId).Id;
context.CourseOwners.Add(databaseCourseTeacher);
context.Courses.Add(databaseCourse);
}
context.SaveChanges();
}
return(databaseCourse);
}
