コード例 #1
0
 //Save data to the sql database
 public void saveData(Question q)
 {
     BOQuestion boq = new BOQuestion();
     BOAnswer boa = new BOAnswer();
     boq.Add(q);
 }
コード例 #2
0
        //Make a question from input information
        public Question input()
        {
            TextBox[] txtAnswers = { txtAnswerA, txtAnswerB, txtAnswerC, txtAnswerD, txtAnswerE, txtAnswerF };
            CheckBox[] ckbAnswers = { ckbAnswerA, ckbAnswerB, ckbAnswerC, ckbAnswerD, ckbAnswerE, ckbAnswerF };

            answerList = new List<Answer>();
            Question q = new Question();
            Answer a;

            try
            {
                for (int i = 0; i < 6; i++)
                {
                    a = new Answer();
                    if (txtAnswers[i].Text.Equals("") == false)
                    {
                        a.Code = Convert.ToInt32(txtCode.Text)*10+i;
                        a.QCode = Convert.ToInt32(txtCode.Text);
                        a.Text = txtAnswers[i].Text;
                        a.IsCorrect = ckbAnswers[i].Checked;
                        answerList.Add(a);
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            //check input
            if (checkInput() != false)
            {
                q.Code = Convert.ToInt32(txtCode.Text);
                q.Text = (txtQuestion).Text;
                q.Mark = Convert.ToDouble(txtMark.Text);
                q.Topic = cbbTopic.Text;
                q.Answers = answerList;
                if (image != null)
                {
                    q.Image = ImageToByte(image);
                }
                else
                    q.Image = null;

                return q;
            }
            return null;
        }
コード例 #3
0
ファイル: BOQuestion.cs プロジェクト: faksam/My_FPT_C-Sharp
        //Delete a question in sql server
        public void Delete(Question q)
        {
            //connect to DB
            SqlConnection con = new SqlConnection();
            //Transaction can do many sql command, if one of them fail, transaction will abort other commands
            SqlTransaction tran;
            con.ConnectionString = conStr;
            con.Open();
            tran = con.BeginTransaction();
            //delete q in DB
            try
            {
                //delete in Answers table
                using (SqlCommand cmd =
                   new SqlCommand("DELETE FROM Answers WHERE QuestionCode = @QuestionCode", con, tran))
                {
                    //set value to parameters
                    cmd.Parameters.AddWithValue("@QuestionCode", q.Code);
                    //execute query
                    cmd.ExecuteNonQuery();
                }

                //delete in Questions table
                using (SqlCommand cmd =
                   new SqlCommand("DELETE FROM Questions WHERE QuestionCode = @QuestionCode", con, tran))
                {
                    //set value to parameters
                    cmd.Parameters.AddWithValue("@QuestionCode", q.Code);
                    //execute query
                    cmd.ExecuteNonQuery();
                }

                tran.Commit();
                MessageBox.Show("Question is deleted!");
            }catch (SqlException sqlError)
            {
                MessageBox.Show("Fail to delete question\n"+sqlError.Message);
                tran.Rollback();
            }
            con.Close();
        }
コード例 #4
0
ファイル: BOQuestion.cs プロジェクト: faksam/My_FPT_C-Sharp
        //Add a question to sql database
        public void Add(Question q)
        {
            //connect to DB
            SqlConnection con = new SqlConnection();
            //Transaction can do many sql command, if one of them fail, transaction will abort other commands
            SqlTransaction tran;
            con.ConnectionString = conStr;
            con.Open();
            tran = con.BeginTransaction();

            try
            {
                //Insert to Questions table
                using (SqlCommand cmdq = new SqlCommand("INSERT INTO Questions (QuestionCode, Text, Mark, TopicID, Image)" +
                   "VALUES (@QuestionCode, @Text, @Mark, @TopicID, @Image)", con, tran))
                {
                    //set value to parameters
                    cmdq.Parameters.AddWithValue("@QuestionCode", q.Code);
                    cmdq.Parameters.AddWithValue("@Text", q.Text);
                    cmdq.Parameters.AddWithValue("@Mark", q.Code);
                    cmdq.Parameters.AddWithValue("@TopicID", getTopicID(q.Topic));

                    cmdq.Parameters.Add("@Image", SqlDbType.Image);
                    if (q.Image != null)
                        //cmdq.Parameters.AddWithValue("@Image", q.Image);
                        cmdq.Parameters["@Image"].Value = q.Image;
                    else
                        cmdq.Parameters["@Image"].Value = DBNull.Value;
                        //cmdq.Parameters.AddWithValue("@Image", DBNull.Value);
                        //cmdq.Parameters.AddWithValue("@Image", new byte[0]);

                    //execute query
                    cmdq.ExecuteNonQuery();
                }

                //Insert to Answers table
                for (int i = 0; i < q.Answers.Count; i++)
                {
                    using (SqlCommand cmda = new SqlCommand("INSERT INTO Answers (AnswerCode, QuestionCode, Text, IsCorrect) " +
                             "VALUES (@AnswerCode, @QuestionCode, @Text, @IsCorrect)", con, tran))
                    {
                        //set value to parameters
                        cmda.Parameters.AddWithValue("@AnswerCode", q.Code*10+i);
                        cmda.Parameters.AddWithValue("@QuestionCode", q.Code);
                        cmda.Parameters.AddWithValue("@Text", q.Answers[i].Text);
                        cmda.Parameters.AddWithValue("@IsCorrect",q.Answers[i].IsCorrect);

                        //execute query
                        cmda.ExecuteNonQuery();
                    }
                }
                tran.Commit();
                MessageBox.Show("Question is added sucessfully!");
            }
            catch (SqlException sqlError)
            {
                MessageBox.Show("Fail to add question\n"+sqlError.Message);
                tran.Rollback();
            }
            con.Close();
        }
コード例 #5
0
ファイル: BOQuestion.cs プロジェクト: faksam/My_FPT_C-Sharp
        //Update a question in sql server
        public void Update(Question q, int oldCode)
        {
            //connect to DB
            SqlConnection con = new SqlConnection();
            //Transaction can do many sql command, if one of them fail, transaction will abort other commands
            SqlTransaction tran;
            con.ConnectionString = conStr;
            con.Open();
            tran = con.BeginTransaction();
            //delete q in DB
            try
            {
                //delete in Answers table
                using (SqlCommand cmd =
                   new SqlCommand("DELETE FROM Answers WHERE QuestionCode = @QuestionCode", con, tran))
                {
                    //set value to parameters
                    cmd.Parameters.AddWithValue("@QuestionCode", oldCode);
                    //execute query
                    cmd.ExecuteNonQuery();
                }
                //update in Questions table
                using (SqlCommand cmd =
               new SqlCommand("UPDATE Questions SET QuestionCode = @QuestionCode, Text = @Text, Mark = @Mark, TopicID = @TopicID" +
                   " WHERE QuestionCode = @OldQuestionCode", con, tran))
                {
                    //set value to parameters
                    cmd.Parameters.AddWithValue("@QuestionCode", q.Code);
                    cmd.Parameters.AddWithValue("@Text", q.Text);
                    cmd.Parameters.AddWithValue("@Mark", q.Mark);
                    cmd.Parameters.AddWithValue("@TopicID", getTopicID(q.Topic));
                    cmd.Parameters.AddWithValue("@OldQuestionCode", oldCode);
                    //execute query
                    cmd.ExecuteNonQuery();
                }
                //Insert to Answers table
                for (int i = 0; i < q.Answers.Count; i++)
                {
                    using (SqlCommand cmda = new SqlCommand("INSERT INTO Answers (AnswerCode, QuestionCode, Text, IsCorrect) " +
                             "VALUES (@AnswerCode, @QuestionCode, @Text, @IsCorrect)", con, tran))
                    {
                        //set value to parameters
                        cmda.Parameters.AddWithValue("@AnswerCode", q.Code * 10 + i);
                        cmda.Parameters.AddWithValue("@QuestionCode", q.Code);
                        cmda.Parameters.AddWithValue("@Text", q.Answers[i].Text);
                        cmda.Parameters.AddWithValue("@IsCorrect", q.Answers[i].IsCorrect);

                        //execute query
                        cmda.ExecuteNonQuery();
                    }
                }

                tran.Commit();
                MessageBox.Show("Question is updated!");
            }
            catch (SqlException sqlError)
            {
                MessageBox.Show("Fail to update question\n" + sqlError.Message);
                tran.Rollback();
            }
            con.Close();
        }
コード例 #6
0
ファイル: BOQuestion.cs プロジェクト: faksam/My_FPT_C-Sharp
        //Load all questions in sql server
        public List<Question> ListAll()
        {
            List<Question> list = new List<Question>();
            //connect to DB
            SqlConnection con = new SqlConnection();
            con.ConnectionString = conStr;
            con.Open();
            //Select all topics
            string sql = "SELECT * FROM Questions";
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = sql;
            cmd.Connection = con;
            //execute
            SqlDataReader dr = cmd.ExecuteReader();
            //add to list
            while (dr.Read())
            {
                //create question
                Question q = new Question();
                q.Code = (int)dr["QuestionCode"];
                q.Text = dr["Text"].ToString();
                q.Mark = (double)dr["Mark"];
                q.Topic = getTopic(dr["TopicID"].ToString());
                if(dr["Image"]==DBNull.Value)
                    q.Image = null;
                else
                    q.Image = (byte[])dr["Image"];

                //add to list
                list.Add(q);
            }
            dr.Close();
            con.Close();
            return list;
        }