Exemplo n.º 1
0
        protected void btnLogin_Click(object sender, EventArgs e)
        {
            userName     = txtUsername.Text.ToString();
            userPassword = txtUserPassword.Text.ToString();

            DataRow drGiris = con.GetDataRow("select ug.userGroupID,ug.userGroupName,u.userID,u.userName,p.userPasword from [userGroup] ug inner join [user] u on ug.userGroupID=u.userGroupID inner join [password] p on u.userID=p.userID where u.userName='******' and p.userPasword='" + userPassword + "'");

            if (drGiris != null)
            {
                if (drGiris["userGroupID"].ToString() == "2")
                {
                    Session["userID"] = drGiris["userID"].ToString();
                    Response.Redirect("~/page/TeacherIndex.aspx");
                }
                else if (drGiris["userGroupID"].ToString() == "3")
                {
                    Session["userID"] = drGiris["userID"].ToString();
                    Response.Redirect("~/page/StudentIndex.aspx");
                }
            }
            else
            {
                lblError.Text = "Hatalı Kullanıcı Adı veya Şifre";
            }
        }
Exemplo n.º 2
0
        protected void btnInsert_Click(object sender, EventArgs e)
        {
            if (txtAddQuestion.Text.Length < 5)
            {
                lblError1.Text = "Lütfen İçerik Doldurunuz.";
            }
            else
            {
            }

            if (rbA.Checked)
            {
                reply = 1;
            }
            else if (rbB.Checked)
            {
                reply = 2;
            }
            else if (rbC.Checked)
            {
                reply = 3;
            }
            else if (rbD.Checked)
            {
                reply = 4;
            }
            if (reply != 0)
            {
                if (rbText.Checked)
                {
                    SqlConnection connect = con.baglan();
                    SqlCommand    cmd     = new SqlCommand("insert into question (userID,subjectID,questionName,isText) values (@USERID,@SUBJECTID,@QUESTIONSNAME,@ISTEXT)", connect);
                    cmd.Parameters.Add("@USERID", Session["userID"]);
                    cmd.Parameters.Add("@SUBJECTID", drpSubject.SelectedItem.Value);
                    cmd.Parameters.Add("@QUESTIONSNAME", txtAddQuestion.Text);
                    cmd.Parameters.Add("@ISTEXT", "0");


                    if (cmd.ExecuteNonQuery() == 0)

                    {
                        connect.Close();
                        connect.Dispose();
                    }
                    else
                    {
                        DataRow drQuestions = con.GetDataRow("select * from [question]  where CONVERT(NVARCHAR(MAX), questionName)='" + txtAddQuestion.Text + "'");
                        if (drQuestions["questionID"] != null)
                        {
                            SqlCommand replyCmd = new SqlCommand("insert into reply (questionID,a,b,c,d,trueReplyID) values(@QUESTIONSID,@A,@B,@C,@D,@TRUEREPLY)", connect);
                            replyCmd.Parameters.Add("@QUESTIONSID", drQuestions["questionID"]);
                            replyCmd.Parameters.Add("@A", A.Text);
                            replyCmd.Parameters.Add("@B", B.Text);
                            replyCmd.Parameters.Add("@C", C.Text);
                            replyCmd.Parameters.Add("@D", D.Text);

                            replyCmd.Parameters.Add("@TRUEREPLY", reply);
                            replyCmd.ExecuteNonQuery();
                            Response.Redirect("RemoveQuestions.aspx");
                        }
                        else
                        {
                            connect.Close();
                            connect.Dispose();
                        }
                    }
                }
                else if (rbImages.Checked)
                {
                    if (fuA.PostedFile.ContentType == "image/png" && fuB.PostedFile.ContentType == "image/png" && fuC.PostedFile.ContentType == "image/png" && fuD.PostedFile.ContentType == "image/png")
                    {
                        if (fuA.PostedFile.ContentLength < 5000000 && fuD.PostedFile.ContentLength < 5000000 && fuC.PostedFile.ContentLength < 5000000 && fuD.PostedFile.ContentLength < 5000000)
                        {
                            if (fuA.HasFile && fuB.HasFile && fuC.HasFile && fuD.HasFile && fuQuestion.HasFile)
                            {
                                SqlConnection connect = con.baglan();

                                Random rnd = new Random();


                                fuQuestion.PostedFile.SaveAs(Server.MapPath("~/upload/") + Session["userID"].ToString() + fuQuestion.FileName.ToString());

                                SqlCommand cmd = new SqlCommand("insert into question (userID,subjectID,questionName,isText) values (@USERID,@SUBJECTID,@QUESTIONSNAME,@ISTEXT)", connect);
                                cmd.Parameters.Add("@USERID", Session["userID"]);
                                cmd.Parameters.Add("@SUBJECTID", drpSubject.SelectedItem.Value);
                                cmd.Parameters.Add("@QUESTIONSNAME", Session["userID"].ToString() + fuQuestion.FileName.ToString());
                                cmd.Parameters.Add("@ISTEXT", "1");
                                if (cmd.ExecuteNonQuery() == 0)

                                {
                                    connect.Close();
                                    connect.Dispose();
                                }
                                else
                                {
                                    DataRow drQuestions = con.GetDataRow("select * from [question]  where CONVERT(NVARCHAR(MAX), questionName)='" + Session["userID"].ToString() + fuQuestion.FileName.ToString() + "'");
                                    if (drQuestions["questionID"] != null)
                                    {
                                        fuA.PostedFile.SaveAs(Server.MapPath("~/upload/") + drQuestions["questionID"].ToString() + fuA.FileName.ToString());
                                        fuB.PostedFile.SaveAs(Server.MapPath("~/upload/") + drQuestions["questionID"].ToString() + fuB.FileName.ToString());
                                        fuC.PostedFile.SaveAs(Server.MapPath("~/upload/") + drQuestions["questionID"].ToString() + fuC.FileName.ToString());
                                        fuD.PostedFile.SaveAs(Server.MapPath("~/upload/") + drQuestions["questionID"].ToString() + fuD.FileName.ToString());

                                        SqlCommand replyCmd = new SqlCommand("insert into reply (questionID,a,b,c,d,trueReply) values(@QUESTIONSID,@A,@B,@C,@D,@TRUEREPLY)", connect);
                                        replyCmd.Parameters.Add("@QUESTIONSID", drQuestions["questionID"]);
                                        replyCmd.Parameters.Add("@A", drQuestions["questionID"].ToString() + fuA.FileName.ToString());
                                        replyCmd.Parameters.Add("@B", drQuestions["questionID"].ToString() + fuB.FileName.ToString());
                                        replyCmd.Parameters.Add("@C", drQuestions["questionID"].ToString() + fuC.FileName.ToString());
                                        replyCmd.Parameters.Add("@D", drQuestions["questionID"].ToString() + fuD.FileName.ToString());
                                        replyCmd.Parameters.Add("@TRUEREPLY", reply);
                                        replyCmd.ExecuteNonQuery();

                                        Response.Redirect("RemoveQuestions.aspx");
                                    }
                                    else
                                    {
                                        connect.Close();
                                        connect.Dispose();
                                    }
                                }
                            }
                            else
                            {
                                lblError.Visible = true;
                                lblError.Text    = "Dosya Yüklenemedi.";
                            }
                        }
                        else
                        {
                            lblError.Visible = true;
                            lblError.Text    = "Dosya boyutu uygun değil.";
                        }
                    }
                    else
                    {
                        lblError.Visible = true;
                        lblError.Text    = "Dosya uzantısı uygun değil.";
                    }
                }
            }
            else
            {
                lblError1.Visible = true;
                lblError1.Text    = "Hatalı İşlem";
            }
        }
Exemplo n.º 3
0
        void score()
        {
            DataRow drScore = con.GetDataRow("select count(s.subjectName)*2 as count  from test t inner join userReply ur on t.testID = ur.testID inner join question q on ur.questionID = q.questionID inner join[subject] s on q.subjectID = s.subjectID inner join reply r on q.questionID = r.questionID where t.testID =" + testID + " and  r.trueReplyID IN(ur.trueReplyID)");

            lblScore.Text = drScore["count"].ToString();
        }