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