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 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 }));
}
private void FillDatabase(Dictionary<int, object[]> rowData, Project insertProject)
{
BarometerDataAccesLayer.DatabaseClassesDataContext context = DatabaseFactory.getInstance().getDataContext();
foreach (KeyValuePair<int, object[]> cell in rowData)
{
bool userExists = false;
if (cell.Key != 0 && cell.Value[0].ToString() != "")
{
int studentNumber = int.Parse(cell.Value[0].ToString());
BarometerDataAccesLayer.User insertUser = null;
var existingUser =
from u in context.Users
where u.student_number == studentNumber
select u;
int test = 0;
if (!existingUser.Any())
{
//If doesnt exist, create empty one
insertUser = new BarometerDataAccesLayer.User();
}
else
{
//If exists, get user
userExists = true;
insertUser = existingUser.First();
}
insertUser.student_number = int.Parse(cell.Value[0].ToString());
insertUser.firstname = cell.Value[1].ToString();
insertUser.lastname = cell.Value[2].ToString();
insertUser.email = cell.Value[3].ToString();
if (cell.Value[4].ToString() != "")
{
string[] groups = cell.Value[4].ToString().Split(',');
foreach (string groupcode in groups)
{
bool groupExists = false;
var currentGroup =
from pg in context.ProjectGroups
where pg.group_code == groupcode
select pg;
ProjectGroup newGroup = null;
if (currentGroup.Count() == 0)
{
//Groep bestaat nog niet, aanmaken
newGroup = new ProjectGroup();
newGroup.group_code = groupcode;
}
else
{
groupExists = true;
newGroup = currentGroup.First();
}
if (insertProject != null)
{
newGroup.Project = insertProject;
}
ProjectMember member = new ProjectMember();
member.student_user_id = insertUser.id;
member.ProjectGroup = newGroup;
if (!groupExists)
{
context.ProjectGroups.InsertOnSubmit(newGroup);
}
context.ProjectMembers.InsertOnSubmit(member);
}
}
if (!userExists)
{
context.Users.InsertOnSubmit(insertUser);
}
}
}
context.SubmitChanges();
}
private void FillDatabase(Dictionary <int, object[]> rowData, Project insertProject)
{
BarometerDataAccesLayer.DatabaseClassesDataContext context = DatabaseFactory.getInstance().getDataContext();
foreach (KeyValuePair <int, object[]> cell in rowData)
{
bool userExists = false;
if (cell.Key != 0 && cell.Value[0].ToString() != "")
{
int studentNumber = int.Parse(cell.Value[0].ToString());
BarometerDataAccesLayer.User insertUser = null;
var existingUser =
from u in context.Users
where u.student_number == studentNumber
select u;
int test = 0;
if (!existingUser.Any())
{
//If doesnt exist, create empty one
insertUser = new BarometerDataAccesLayer.User();
}
else
{
//If exists, get user
userExists = true;
insertUser = existingUser.First();
}
insertUser.student_number = int.Parse(cell.Value[0].ToString());
insertUser.firstname = cell.Value[1].ToString();
insertUser.lastname = cell.Value[2].ToString();
insertUser.email = cell.Value[3].ToString();
if (cell.Value[4].ToString() != "")
{
string[] groups = cell.Value[4].ToString().Split(',');
foreach (string groupcode in groups)
{
bool groupExists = false;
var currentGroup =
from pg in context.ProjectGroups
where pg.group_code == groupcode
select pg;
ProjectGroup newGroup = null;
if (currentGroup.Count() == 0)
{
//Groep bestaat nog niet, aanmaken
newGroup = new ProjectGroup();
newGroup.group_code = groupcode;
}
else
{
groupExists = true;
newGroup = currentGroup.First();
}
if (insertProject != null)
{
newGroup.Project = insertProject;
}
ProjectMember member = new ProjectMember();
member.student_user_id = insertUser.id;
member.ProjectGroup = newGroup;
if (!groupExists)
{
context.ProjectGroups.InsertOnSubmit(newGroup);
}
context.ProjectMembers.InsertOnSubmit(member);
}
}
if (!userExists)
{
context.Users.InsertOnSubmit(insertUser);
}
}
}
context.SubmitChanges();
}
