/// <summary>
/// Get the projectgroup(s) the student belongs to
/// </summary>
/// <param name="studentNumber">The student you want to query</param>
/// <returns></returns>
public IQueryable <ProjectGroup> getStudentGroup(int studentNumber)
{
if (studentNumber > 0)
{
DatabaseFactory factory = DatabaseFactory.getInstance();
DatabaseClassesDataContext context = factory.getDataContext();
var projectGroup =
from pg in context.ProjectGroups
join pm in context.ProjectMembers on pg.id equals pm.project_group_id
join u in context.Users on pm.student_user_id equals u.id
where u.student_number == studentNumber
select pg;
if (projectGroup.ToList().Count > 0)
{
return(projectGroup);
}
return(null);
}
else
{
throw new ArgumentOutOfRangeException();
}
}
public void putStudentInDatabase(int studentNumber, string email)
{
DatabaseFactory factory = DatabaseFactory.getInstance();
DatabaseClassesDataContext context = factory.getDataContext();
User newUser;
bool userExists = false;
var usertest = from u in context.Users
where u.student_number == studentNumber
select u;
if (usertest.Count() == 0)
{
newUser = new User();
newUser.student_number = studentNumber;
newUser.email = email + "@avans.nl";
newUser.rol_name = "user";
}
else
{
userExists = true;
newUser = usertest.First();
}
CurrentUser.getInstance().Studentnummer = studentNumber;
CurrentUser.getInstance().Role = newUser.rol_name;
if (!userExists)
{
context.Users.InsertOnSubmit(newUser);
}
context.SubmitChanges();
CurrentUser.getInstance().StudentId = newUser.id;
}
