public List <QuizSettings> GetQuestionsForUpdate(string QuizName) { List <QuizSettings> Questions = new List <QuizSettings>(); string connString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlConnection con = new SqlConnection(connString); SqlCommand cmnd = new SqlCommand("GetQuestions", con); cmnd.CommandType = CommandType.StoredProcedure; SqlParameter ParamCheckname = new SqlParameter(); ParamCheckname.ParameterName = "@QuizName"; ParamCheckname.Value = QuizName; cmnd.Parameters.Add(ParamCheckname); con.Open(); SqlDataReader dr = cmnd.ExecuteReader(); while (dr.Read()) { QuizSettings QuestionandAnsw = new QuizSettings(); QuestionandAnsw.Question = dr["Question"].ToString(); QuestionandAnsw.QuizID = int.Parse(dr["QuesID"].ToString()); QuestionandAnsw.Name = dr["QuizName"].ToString(); QuestionandAnsw.Answer1 = dr["Answer1"].ToString(); QuestionandAnsw.Answer2 = dr["Answer2"].ToString(); QuestionandAnsw.Answer3 = dr["Answer3"].ToString(); QuestionandAnsw.Answer4 = dr["Answer4"].ToString(); QuestionandAnsw.CorrectAnswer = dr["CorrectAnswer"].ToString(); QuestionandAnsw.Points = dr["points"].ToString(); Questions.Add(QuestionandAnsw); } return(Questions); }
public void AddQuizSettings(QuizSettings quizSet) { { string connString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlConnection con = new SqlConnection(connString); SqlCommand cmnd = new SqlCommand("CheckQuizName", con); cmnd.CommandType = CommandType.StoredProcedure; cmnd.Parameters.Add("@Name", SqlDbType.VarChar).Value = quizSet.Name; con.Open(); int count = int.Parse(cmnd.ExecuteScalar().ToString()); con.Close(); if (count == 0) { quizSet.ErrorMessage = ""; SqlCommand cmd = new SqlCommand("spSaveQuizSettings", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Quiztype", SqlDbType.VarChar).Value = quizSet.Quiztype; cmd.Parameters.Add("@QuizGroup", SqlDbType.VarChar).Value = quizSet.QuizGroup; cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = quizSet.Name; cmd.Parameters.Add("@Shuffleanswers", SqlDbType.VarChar).Value = quizSet.Shuffleanswers; cmd.Parameters.Add("@Timelimit", SqlDbType.VarChar).Value = quizSet.Timelimit; cmd.Parameters.Add("@Minut", SqlDbType.VarChar).Value = quizSet.Minut; cmd.Parameters.Add("@Studentsseequiz", SqlDbType.VarChar).Value = quizSet.Studentsseequiz; cmd.Parameters.Add("@Showcrctans", SqlDbType.VarChar).Value = quizSet.Showcrctans; cmd.Parameters.Add("@Allowmultattempt", SqlDbType.VarChar).Value = quizSet.Allowmultattempt; cmd.Parameters.Add("@Showoneques", SqlDbType.VarChar).Value = quizSet.Showoneques; cmd.Parameters.Add("@RestQuiz", SqlDbType.VarChar).Value = quizSet.RestQuiz; con.Open(); cmd.ExecuteNonQuery(); } else { quizSet.ErrorMessage = "Quiz Name already Exists. Please create Quiz with other name"; } } }
public void InsertQuestionAnswers(QuizSettings quizSet) { string connString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlConnection con = new SqlConnection(connString); SqlCommand getQuestionId = new SqlCommand("GetQuestionCount", con); getQuestionId.CommandType = CommandType.StoredProcedure; getQuestionId.Parameters.Add("@QuizName", SqlDbType.VarChar).Value = quizSet.Name; SqlParameter iCount = getQuestionId.Parameters.Add("@Count", SqlDbType.Int); iCount.Direction = ParameterDirection.Output; con.Open(); getQuestionId.ExecuteNonQuery(); con.Close(); int QuesID = int.Parse(iCount.Value.ToString()) + 1; SqlCommand cmd = new SqlCommand("SaveQuestionAndAnswers", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@QuizName", SqlDbType.VarChar).Value = quizSet.Name; cmd.Parameters.Add("@QuestionType", SqlDbType.VarChar).Value = quizSet.Quiztype; cmd.Parameters.Add("@Question", SqlDbType.VarChar).Value = quizSet.Question; cmd.Parameters.Add("@Answer1", SqlDbType.VarChar).Value = quizSet.Answer1; cmd.Parameters.Add("@Answer2", SqlDbType.VarChar).Value = quizSet.Answer2; cmd.Parameters.Add("@Answer3", SqlDbType.VarChar).Value = quizSet.Answer3; cmd.Parameters.Add("@Answer4", SqlDbType.VarChar).Value = quizSet.Answer4; cmd.Parameters.Add("@CorrectAnswer", SqlDbType.VarChar).Value = quizSet.CorrectAnswer; cmd.Parameters.Add("@points", SqlDbType.VarChar).Value = quizSet.Points; cmd.Parameters.Add("@QuesID", SqlDbType.VarChar).Value = QuesID.ToString(); con.Open(); cmd.ExecuteNonQuery(); }
public void UpdateQuestionAndANswers(QuizSettings quizSet) { string connString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlConnection con = new SqlConnection(connString); SqlCommand getQuestionId = new SqlCommand("UpdateQandA", con); getQuestionId.CommandType = CommandType.StoredProcedure; getQuestionId.Parameters.Add("@QuizName", SqlDbType.VarChar).Value = quizSet.Name; getQuestionId.Parameters.Add("@Question", SqlDbType.VarChar).Value = quizSet.Question; getQuestionId.Parameters.Add("@Answer1", SqlDbType.VarChar).Value = quizSet.Answer1; getQuestionId.Parameters.Add("@Answer2", SqlDbType.VarChar).Value = quizSet.Answer2; getQuestionId.Parameters.Add("@Answer3", SqlDbType.VarChar).Value = quizSet.Answer3; getQuestionId.Parameters.Add("@Answer4", SqlDbType.VarChar).Value = quizSet.Answer4; getQuestionId.Parameters.Add("@CorrectAnswer", SqlDbType.VarChar).Value = quizSet.CorrectAnswer; getQuestionId.Parameters.Add("@points", SqlDbType.VarChar).Value = quizSet.Points; getQuestionId.Parameters.Add("@QuesID", SqlDbType.VarChar).Value = quizSet.QuesID; con.Open(); getQuestionId.ExecuteNonQuery(); }