CreateQuiz.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
using System.Web.Security;
using System.Collections;


namespace QUtopiaProject
{
    public partial class CreateQuiz : System.Web.UI.Page
    {
        SqlConnection SQLConn = new SqlConnection("Data Source=DESKTOP-1M38HSH; Integrated Security=True");
   
        protected void Page_Load(object sender, EventArgs e)
        {
            if(Session["sonQID"] == null)
            {
                List<int> QuestionIDs = new List<int>();
                List<int> QuestionSCRs = new List<int>();

            //List<string> ast = new List<string>();
            //ast.Add("asdas!");
            //Session["stringList"] = ast;
            //List<string> bst = (List<string>)Session["stringList"];

            
                Session["QuestionIDs"] = QuestionIDs;
                Session["QuestionSCRs"] = QuestionSCRs;
            }


        }

        //Ekrandaki tablodan herhangi bir soru seçildiğinde çalışacak fonksiyon
        protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
        {
            //İlk olarak QuestionID ve Score bilgilerini almak için 2 değişken tanımlayalım
            string QID = "";
            string scr = "";

            //1. kısım QuestionID
            QID = GridView1.SelectedRow.Cells[1].Text;

            //5. kısım Score
            scr = GridView1.SelectedRow.Cells[5].Text;

            Int32 QuestionID = Convert.ToInt32(QID);
            Int32 QuestionScore = Convert.ToInt32(scr);

            List<int> QuestionIDss = (List<int>)Session["QuestionIDs"];
            List<int> QuestionSCRss = (List<int>)Session["QuestionSCRs"];

            QuestionIDss.Add(QuestionID);
            QuestionSCRss.Add(QuestionScore);

            Session["sonQID"] = QuestionIDss;
            Session["sonSCR"] = QuestionSCRss;

        }  //seçme fonk sonu



        protected void CreateQuizButton_Click(object sender, EventArgs e)
        {
            List<int> sonQID = (List<int>)Session["sonQID"];
            List<int> sonSCR = (List<int>)Session["sonSCR"];

            Int32 maxscore = 0;
            Int32 QuizID = 0;

            if (QuizTitleTextBox.Text != null && QuizPasswordTextBox.Text != null)
            {
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);
                con.Open();

           
                SqlCommand cmd1 = new SqlCommand("insert into QuizTable (User_ID, Password, Title, Summary, Max_Score) VALUES (@User_ID, @Password, @Title, @Summary, @MaxScore)", con);
                cmd1.Parameters.AddWithValue("@User_ID", Session["UserID"]);
                cmd1.Parameters.AddWithValue("@Password", QuizPasswordTextBox.Text);
                cmd1.Parameters.AddWithValue("@Title", QuizTitleTextBox.Text);
                cmd1.Parameters.AddWithValue("@Summary", QuizSummaryTextBox.Text);
                cmd1.Parameters.AddWithValue("@MaxScore", (Int32)maxscore);
                cmd1.ExecuteNonQuery();

                SqlCommand cmd2 = new SqlCommand("select Quiz_ID from QuizTable where User_ID =@User_ID and Password=@Password and Title=@Title", con);
                cmd2.Parameters.AddWithValue("@User_ID", Session["UserID"]);
                cmd2.Parameters.AddWithValue("@Password", QuizPasswordTextBox.Text);
                cmd2.Parameters.AddWithValue("@Title", QuizTitleTextBox.Text);
                cmd2.ExecuteNonQuery();
                QuizID = (Int32)cmd2.ExecuteScalar();


                foreach (var iQID in sonQID)
                {
                    SqlCommand cmd3 = new SqlCommand("insert into QuizQuestionTable (Quiz_ID, Question_ID) VALUES (@QuizID, @QuestionID)", con);
                    cmd3.Parameters.AddWithValue("@QuizID", QuizID);
                    Label1.Text = "" + iQID;
                    cmd3.Parameters.AddWithValue("@QuestionID", (Int32)iQID);

                    cmd3.ExecuteNonQuery();
                    // Response.Write(sonQID[iQID]);
                }

                foreach (var iSCR in sonSCR)
                {
                        maxscore = maxscore + (Int32)iSCR;

                        SqlCommand cmd4 = new SqlCommand("update QuizTable set Max_Score = @MaxScore where Quiz_ID =@QuizID and Password=@Password", con);
                        cmd4.Parameters.AddWithValue("@MaxScore", maxscore);
                        cmd4.Parameters.AddWithValue("@QuizID", QuizID);
                        cmd4.Parameters.AddWithValue("@Password", QuizPasswordTextBox.Text);

                        cmd4.ExecuteNonQuery();
                    Label1.Text = "oldu";
                }
                
            }

            //Response.Redirect("~/Profile.aspx");

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/Profile.aspx");

        }
    }
    }