public ActionResult Index()
{
int userId = Int32.Parse(User.Identity.Name);
User u = Lib.DatabaseManager.UserManager.Current.Get(userId);
if (u.Status == Lib.Entity.User.UserStatus.Ready)
{
return(RedirectToAction("Index", "News"));
}
List <SortingQuizValue> answeredQuestions = Lib.DatabaseManager.SortingQuizValueManager.Current.GetFromUser(userId);
SortingQuizValue latestAnsweredQuestion = answeredQuestions.OrderByDescending(x => x.QuestionNo).FirstOrDefault();
int questionNo = 1;
if (latestAnsweredQuestion != null)
{
questionNo = latestAnsweredQuestion.QuestionNo + 1;
}
SortingQuestion_VM sq = new SortingQuestion_VM();
sq.Question = Lib.Entity.SortingQuizQuestion.QuizQuestions.FirstOrDefault(x => x.QuestionNo == questionNo);
if (sq.Question == null)
{
return(RedirectToAction("SortedResult"));
}
return(View(sq));
}
private void Update(MySqlCommand cmd, SortingQuizValue value)
{
cmd.Parameters.Clear();
cmd.CommandText = @"UPDATE SortingQuiz_Values SET QuestionNo=@QuestionNo, AnswerValue=@AnswerValue WHERE Id=@Id;";
cmd.Parameters.AddWithValue("Id", value.Id);
cmd.Parameters.AddWithValue("QuestionNo", value.QuestionNo);
cmd.Parameters.AddWithValue("AnswerValue", value.AnswerValue);
cmd.ExecuteNonQuery();
}
private int Create(MySqlCommand cmd, SortingQuizValue value)
{
cmd.Parameters.Clear();
cmd.CommandText = @"INSERT INTO SortingQuiz_Values(UserId, QuestionNo, AnswerValue)
Values(@UserId, @QuestionNo, @AnswerValue);";
cmd.CommandText += " SELECT last_insert_id();";
cmd.Parameters.AddWithValue("UserId", value.UserId);
cmd.Parameters.AddWithValue("QuestionNo", value.QuestionNo);
cmd.Parameters.AddWithValue("AnswerValue", value.AnswerValue);
return(int.Parse(cmd.ExecuteScalar().ToString()));
}
public int Create(SortingQuizValue value)
{
try
{
MySqlCommand cmd = BeginTransaction();
int result = Create(cmd, value);
Commit(cmd);
return(result);
}
catch
{
return(-1);
}
}
private List <SortingQuizValue> Get(string where, Dictionary <string, object> param)
{
List <SortingQuizValue> result = new List <SortingQuizValue>();
DataTable dt = GetQuery(string.Format("SELECT * FROM SortingQuiz_Values {0}", where), param);
foreach (DataRow dr in dt.Rows)
{
SortingQuizValue temp = new SortingQuizValue();
temp.Id = int.Parse(dr["Id"].ToString());
temp.UserId = int.Parse(dr["UserId"].ToString());
temp.QuestionNo = int.Parse(dr["QuestionNo"].ToString());
temp.AnswerValue = int.Parse(dr["AnswerValue"].ToString());
result.Add(temp);
}
return(result);
}
