public CourseDataTableManager(ExtensibleDbContext dbCtx, List <DataTableStudent> students = null)
{
_dbCtx = dbCtx;
_config = SystemConfig.LoadConfig();
_canvasDataAccess = new CanvasDataAccess(_config);
Students = students;
}
private static void PopulateAssignmentRows(ref CourseDataTable table, string accessToken, int courseId)
{
var config = SystemConfig.LoadConfig();
var dataAccess = new CanvasDataAccess(config);
foreach (var student in table.Students)
{
var data = dataAccess.GetAnalysisData(accessToken, courseId, student.Id);
foreach (var col in table.AssignmentGradeColumns)
{
var colData = data.Where(x => x.AssignmentId == col.RelatedDataId).ToList();
foreach (var cdata in colData)
{
var row = new NumericDataRow
{
Value = (cdata.Submission.Score != null) ? (double)cdata.Submission.Score : 0,
ColumnId = col.ColumnId,
AssociatedUser = student,
ValueChanged = false
};
((NumericDataColumn)col).Rows.Add(row);
}
}
}
}
public CanvasCourseController(ExtensibleDbContext dbCtx)
{
_dbCtx = dbCtx;
_config = SystemConfig.LoadConfig();
_tokenManager = new TokenManager(_dbCtx, _config);
_canvasTokenManager = new CanvasTokenManager(_dbCtx);
_canvasDataAccess = new CanvasDataAccess(_config);
}
// Load students
private static List <DataTableStudent> GetStudents(int courseId, string accessToken)
{
var config = SystemConfig.LoadConfig();
var dataAccess = new CanvasDataAccess(config);
var students = dataAccess.GetUsersInCourse(accessToken, courseId, EnrollmentParamType.student);
var tableStudents = new List <DataTableStudent>();
foreach (var student in students)
{
var tbStudent = new DataTableStudent
{
Name = student.Name,
Id = student.Id,
InstitutionId = student.SisUserId
};
tableStudents.Add(tbStudent);
}
return(tableStudents);
}
private static List <CourseDataColumn> GetAssignmentColumns(int courseId, string accessToken)
{
var assignmentCols = new List <CourseDataColumn>();
var config = SystemConfig.LoadConfig();
var dataAccess = new CanvasDataAccess(config);
var assignments = dataAccess.GetCourseAssignments(accessToken, courseId);
foreach (var assignment in assignments)
{
var col = new NumericDataColumn
{
Name = assignment.Name,
RelatedDataId = assignment.Id,
ColumnId = Guid.NewGuid(),
ColumnType = ColumnType.Assignment_Score,
DataType = ColumnDataType.Number,
ColMaxValue = assignment.PointsPossible,
ColMinValue = 0,
Rows = new List <NumericDataRow>()
};
assignmentCols.Add(col);
}
return(assignmentCols);
}
public UserCustomDataManager(ExtensibleDbContext dbCtx)
{
_dbCtx = dbCtx;
_config = SystemConfig.LoadConfig();
_canvasDataAccess = new CanvasDataAccess(_config);
}
