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 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();
}
}
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 ActionResult AddStudent(FormCollection collection)
{
int studentIdToAdd = int.Parse(collection.GetValue("student").AttemptedValue);
int projectId = int.Parse(collection.GetValue("projectID").AttemptedValue);
int groupId = int.Parse(collection.GetValue("groupID").AttemptedValue);
DAOStudent studentdao = DatabaseFactory.getInstance().getDAOStudent();
DAOProject projectdao = DatabaseFactory.getInstance().getDAOProject();
BarometerDataAccesLayer.User studentUser = studentdao.getStudentInfo(studentIdToAdd);
IEnumerable <BarometerDataAccesLayer.ProjectMember> member = studentUser.ProjectMembers.Where(pm => pm.project_group_id == groupId);
if (member.Count() == 0)
{
BarometerDataAccesLayer.ProjectMember pMember = new BarometerDataAccesLayer.ProjectMember();
pMember.User = studentUser;
pMember.project_group_id = groupId;
BarometerDataAccesLayer.DatabaseClassesDataContext context = DatabaseFactory.getInstance().getDataContext();
context.ProjectMembers.InsertOnSubmit(pMember);
context.SubmitChanges();
}
return(RedirectToAction("ProjectGroups", new { groupId = groupId }));
}
public static List <EStudent> GetAllStudents()
{
return(DAOStudent.GetAllStudents());
}
