private static void insertQuestion(QuestionItem qi, string user_id)
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString);
string str = "insert into question (text, user_id, points) values (@text, @user_id, @points)";
SqlCommand cmd = new SqlCommand(str, con);
cmd.Parameters.AddWithValue("text", qi.Text);
cmd.Parameters.AddWithValue("user_id",user_id);
cmd.Parameters.AddWithValue("points",qi.Points);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw new ApplicationException("Не удалось сохранить вопрос");
}
finally {
con.Close();
}
}
public static void CopyTempTest(string id, string user_id)
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString);
insertTest(SelectTempTest(id));
string newTest_id = TestId(id);
string str = "select * from tempquestions where test_id = @id";
string questint_id = "";
SqlCommand cmd = new SqlCommand(str, con);
cmd.Parameters.AddWithValue("id", id);
try
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if(dr.HasRows)
while (dr.Read()) {
QuestionItem QI = new QuestionItem(dr["text"].ToString(), dr["points"].ToString());
insertQuestion(QI, user_id);
questint_id = QuestionId(dr["text"].ToString());
insertTestQuestion(questint_id, newTest_id);
copyAnswerForQuestion(dr["question_id"].ToString(), questint_id);
}
}
catch (Exception)
{
throw new ApplicationException("Не удается добавить тест");
}
finally {
con.Close();
}
}
