public void Update(AttemptDTO attempt)
{
var connection = Connection.GetConnection();
string sqlExpression = "Attempt_Update";
connection.Execute(sqlExpression, attempt, commandType: CommandType.StoredProcedure);
}
public int AddAttemptAutoNumber(AttemptDTO attempt)
{
using (var connection = Connection.GetConnection())
{
string sqlExpression = "AddAttemptAutoNumber @userID, @testID, @userResult, @dateTime, @durationTime";
return(connection.Query <int>(sqlExpression, attempt).FirstOrDefault());
}
}
public int DeleteConcreteAttempt(AttemptDTO attempt)//удаление попытки
{
using (IDbConnection connection = Connection.GetConnection())
{
string sqlExpression = "Attempt_DeleteConcrete @UserID,@TestID,@Number";
return(connection.Execute(sqlExpression, attempt));
}
}
public int Add(AttemptDTO attempt)
{
var connection = Connection.GetConnection();
connection.Open();
string sqlExpression = "Attempt_Add @number, @userID, @testID, @userResult, @dateTime, @durationTime";
return(connection.Query <int>(sqlExpression, attempt).FirstOrDefault());
}
public int AddAttemptForAttemptCreator(int userId, int testId)
{
AttemptDTO attempt = new AttemptDTO()
{
userID = userId,
testID = testId,
dateTime = DateTime.Now
};
AttemptManager student = new AttemptManager();
return(student.AddAttemptAutoNumber(attempt));
}
public ActionResult TryToGuess(AttemptDTO model)
{
if (model.AttemptValue == null)
{
return(View(new AttemptDTO {
Message = "Value cannot be null"
}));
}
if (model != null && ModelState.IsValid)
{
return(View(new AttemptDTO
{
Message = _userService.TryToGuess(Mapper.Map <AttemptDTO, Attempt>(model))
}));
}
return(RedirectToAction("TryToGues"));
}
public int DeleteConcreteAttempt(AttemptDTO attempt) // метод - удалить конкретного попытку конкретного студента
{
TestManager teacher = new TestManager();
return(teacher.DeleteConcreteAttempt(attempt));
}
public int AddAttemptAutoNumber(AttemptDTO attempt)
{
AttemptManager newattempt = new AttemptManager();
return(newattempt.AddAttemptAutoNumber(attempt));
}
public int AddAttempt(AttemptDTO dto)
{
AttemptCRUD attempt = new AttemptCRUD();
return(attempt.Add(dto));
}
