public UserDashboardWrapper(int studentNumber)
{
this.StudentNumber = studentNumber;
student = DatabaseFactory.getInstance().getDAOStudent();
project = DatabaseFactory.getInstance().getDAOProject();
FillCurrentProject();
if (HasProject)
{
FillNextReportDate();
FillProjectMembers(student.getStudentGroup(studentNumber).First());
FillCurrentProjectOwners(student.getStudentGroup(studentNumber).First());
CurrentProjectTutor = ProjectMembers.FirstOrDefault().ProjectGroup.User;
}
try
{
FillAllProjects();
FillAllIndividualGrades();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message + " in " + ex.Source);
// doe niks met error. (dit laten staan)
}
}
public void test_11_getStudentGroup_invalid_input()
{
String exception = "";
try
{
IQueryable <ProjectGroup> b = d.getStudentGroup(-1);
}
catch (Exception e)
{
exception = e.ToString();
}
Assert.IsTrue(exception.Contains("ArgumentOutOfRange"));
}
public ActionResult Barometer(int report_id = 0)
{
BaroReportWrapper viewModel =
db.ProjectReportDates
.Where(r => r.id == report_id)
.Select(r => new BaroReportWrapper
{
ReportDate = r,
Project = r.Project,
Aspects = r.Project.BaroTemplate.BaroAspects.Where(a => a.is_head_aspect == 1).ToList()
}).FirstOrDefault();
if (viewModel == null)
{
return(HttpNotFound());
}
ProjectGroup group = daoStudent.getStudentGroup(curUser.Studentnummer).First();
if (group == null)
{
return(RedirectToAction("Dashboard"));
}
viewModel.ReporterId = curUser.StudentId;
viewModel.Members = daoProject.getUsersInGroup(group.id).ToList();
return(View(viewModel));
}
public UserProjectWrapper(int studentNumber, int project_id)
{
this.projectId = project_id;
this.studentNumber = studentNumber;
StudentNumber = studentNumber;
student = DatabaseFactory.getInstance().getDAOStudent();
project = DatabaseFactory.getInstance().getDAOProject();
FillProjectMembers(student.getStudentGroup(studentNumber).First());
FillTutors(student.getStudentGroup(studentNumber).First());
FillProjectOwners(project.GetProject(this.studentNumber, projectId).FirstOrDefault());
FillProjectDetails(project.GetProject(this.studentNumber, projectId).FirstOrDefault(), student.getStudentGroup(studentNumber).First());
FillMyGrades(project.GetProject(this.studentNumber, projectId).FirstOrDefault());
FillGrades(project.GetProject(this.studentNumber, projectId).FirstOrDefault());
FillSubAspects(project.GetProject(this.studentNumber, projectId).FirstOrDefault());
FillSubSubAspects(project.GetProject(this.studentNumber, projectId).FirstOrDefault());
}
public override void Export(object students)
{
Sheet sheet = wbPart.Workbook.Descendants <Sheet>().First();
if (sheet != null)
{
DAOStudent studentdao = DatabaseFactory.getInstance().getDAOStudent();
Worksheet ws = ((WorksheetPart)(wbPart.GetPartById(sheet.Id))).Worksheet;
int rowNumber = 2;
foreach (int studentnumber in (int[])students)
{
BarometerDataAccesLayer.User student = studentdao.getStudentInfo(studentnumber);
if (student != null)
{
string numberAdress = "A" + rowNumber;
InsertCellInWorksheet(ws, numberAdress);
UpdateValue("Blad1", numberAdress, student.student_number.ToString(), 0, false);
string firstNameAdress = "B" + rowNumber;
InsertCellInWorksheet(ws, firstNameAdress);
UpdateValue("Blad1", firstNameAdress, student.firstname, 0, true);
string lastNameAdress = "C" + rowNumber;
InsertCellInWorksheet(ws, lastNameAdress);
UpdateValue("Blad1", lastNameAdress, student.lastname, 0, true);
string emailAdress = "D" + rowNumber;
InsertCellInWorksheet(ws, emailAdress);
UpdateValue("Blad1", emailAdress, student.email, 0, true);
string groupsString = "";
foreach (BarometerDataAccesLayer.ProjectGroup group in studentdao.getStudentGroup((int)student.student_number))
{
groupsString += group.group_code + ",";
}
string groupAdress = "E" + rowNumber;
InsertCellInWorksheet(ws, groupAdress);
UpdateValue("Blad1", groupAdress, groupsString, 0, true);
}
else
{
string numberAdress = "A" + rowNumber;
InsertCellInWorksheet(ws, numberAdress);
UpdateValue("Blad1", numberAdress, studentnumber.ToString(), 0, false);
string lastNameAdress = "C" + rowNumber;
InsertCellInWorksheet(ws, lastNameAdress);
UpdateValue("Blad1", lastNameAdress, "Bestaat niet!", 0, true);
}
rowNumber++;
}
document.Close();
}
}
