public int CreateUserAnswer(CreatingUserAnswerModel userAnswer)
{
var result = DefaultErrorCode;
using (var connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString;
var command = connection.CreateCommand();
command.CommandText = "[TestInfo].[CreateUserAnswer]";
command.CommandType = CommandType.StoredProcedure;
var testSesIdParam = command.CreateParameter();
testSesIdParam.ParameterName = "@TestSessionID";
testSesIdParam.DbType = DbType.Int32;
testSesIdParam.Value = userAnswer.TestSessionID;
var answerIdParam = command.CreateParameter();
answerIdParam.ParameterName = "@AnswerID";
answerIdParam.DbType = DbType.Int32;
answerIdParam.Value = userAnswer.AnswerID;
command.Parameters.AddRange(new[] { testSesIdParam, answerIdParam });
connection.Open();
result = (int)command.ExecuteScalar();
}
return(result);
}
public void DeleteUserAnswer(CreatingUserAnswerModel userAnswer)
{
using (var connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString;
var command = connection.CreateCommand();
command.CommandText = "[TestInfo].[DeleteUserAnswer]";
command.CommandType = CommandType.StoredProcedure;
var testSesIdParam = command.CreateParameter();
testSesIdParam.ParameterName = "@TestSessionID";
testSesIdParam.DbType = DbType.Int32;
testSesIdParam.Value = userAnswer.TestSessionID;
var answerIdParam = command.CreateParameter();
answerIdParam.ParameterName = "@AnswerID";
answerIdParam.DbType = DbType.Int32;
answerIdParam.Value = userAnswer.AnswerID;
command.Parameters.AddRange(new[] { testSesIdParam, answerIdParam });
connection.Open();
command.ExecuteNonQuery();
}
}
