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)); }