public static void Delete <TEntity>(this QueryRunnerEntities context, TEntity entity) where TEntity : class
{
if (context.Entry(entity).State == System.Data.Entity.EntityState.Detached)
{
context.Set <TEntity>().Attach(entity);
}
context.Set <TEntity>().Remove(entity);
}
internal IQueryable <ModelRole> Get(QueryRunnerEntities context)
{
return(from role in context.Roles
select new ModelRole
{
RoleName = role.RoleName,
RoleActive = role.RoleActive
});
}
internal IQueryable <ModelUser> Get(QueryRunnerEntities context)
{
return(from user in context.Users
select new ModelUser
{
Username = user.Username,
PasswordHash = user.PasswordHash,
UserActive = user.UserActive
});
}
internal IQueryable <ModelUserRole> Get(QueryRunnerEntities context)
{
return(from userrole in context.UserRoles
select new ModelUserRole
{
URID = userrole.URID,
RoleName = userrole.RoleName,
Username = userrole.Username,
UserRoleActive = userrole.UserRoleActive
});
}
internal IQueryable <ModelUserLogin> Get(QueryRunnerEntities context)
{
return(from userlogin in context.UserLogins
select new ModelUserLogin
{
LoginID = userlogin.LoginID,
Username = userlogin.Username,
LoginTimestamp = userlogin.LoginTimestamp,
LogoutTimestamp = userlogin.LogoutTimestamp,
PCNumber = userlogin.PCNumber,
UserLoginActive = userlogin.UserLoginActive
});
}
internal IQueryable <ModelQuestion> Get(QueryRunnerEntities context)
{
return(from question in context.Questions
select new ModelQuestion
{
QuestionID = question.QuestionID,
TestID = question.TestID,
Instruction = question.Instruction,
QuestionActive = question.QuestionActive,
QuestionAnswer = question.QuestionAnswer,
MaxMark = question.MaxMark
});
}
internal IQueryable <ModelTest> Get(QueryRunnerEntities context)
{
return(from test in context.Tests
select new ModelTest
{
TestID = test.TestID,
TestName = test.TestName,
Username = test.Username,
Date = test.Date,
StartTime = test.StartTime,
EndTime = test.EndTime,
TestActive = test.TestActive
});
}
internal IQueryable <ModelStudentAnswer> Get(QueryRunnerEntities context)
{
return(from studentanswer in context.StudentAnswers
select new ModelStudentAnswer
{
SAID = studentanswer.SAID,
QuestionID = studentanswer.QuestionID,
Username = studentanswer.Username,
Answer = studentanswer.Answer,
Flagged = studentanswer.Flagged,
Type = studentanswer.Type,
StudentAnswerActive = studentanswer.StudentAnswerActive,
MarkObtained = studentanswer.MarkObtained
});
}
internal IQueryable <ModelToken> Get(QueryRunnerEntities context)
{
return(from token in context.Tokens
select new ModelToken
{
TokenString = token.TokenString,
Username = token.Username,
TestID = token.TestID,
CreatedTime = token.CreatedTime,
ExpiredTime = token.ExpiredTime,
TokenActive = token.TokenActive,
TokenID = token.TokenID,
TestComment = token.TestComment
});
}
public StoreStudentAnswer(QueryRunnerEntities context)
{
_ctx = context ?? throw new ArgumentNullException("context");
}
public static IToken GetToken(QueryRunnerEntities context)
{
return(new StoreToken(context));
}
public static IStudentAnswer GetStudentAnswer(QueryRunnerEntities context)
{
return(new StoreStudentAnswer(context));
}
public static ITest GetTest(QueryRunnerEntities context)
{
return(new StoreTest(context));
}
public static IQuestion GetQuestion(QueryRunnerEntities context)
{
return(new StoreQuestion(context));
}
public static IUserLogin GetUserLogin(QueryRunnerEntities context)
{
return(new StoreUserLogin(context));
}
public static IUserRole GetUserRole(QueryRunnerEntities context)
{
return(new StoreUserRole(context));
}
public static void Update <TEntity>(this QueryRunnerEntities context, TEntity entity) where TEntity : class
{
context.Set <TEntity>().Attach(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
}
public static TEntity Insert <TEntity>(this QueryRunnerEntities context, TEntity entity) where TEntity : class
{
return(context.Set <TEntity>().Add(entity));
}
public StoreUserLogin(QueryRunnerEntities context)
{
_ctx = context ?? throw new ArgumentNullException("context");
}
