Ejemplo n.º 1
0
 public void UpdateOutput(Participant model)
 {
     using (QuizEntities db = new QuizEntities())
     {
         db.Entry(model).State = System.Data.Entity.EntityState.Modified;
         db.SaveChanges();
     }
 }
Ejemplo n.º 2
0
 public Participant Insert(Participant model)
 {
     using (QuizEntities db = new QuizEntities())
     {
         db.Participants.Add(model);
         db.SaveChanges();
         return(model);
     }
 }
Ejemplo n.º 3
0
        protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
        {
            string createdUsername = CreateUserWizard1.UserName;
            string createdPassword = CreateUserWizard1.Password;
            //dynamic profile = ProfileBase.Create(createdUsername);
            CreateUserWizardStep step1 = (CreateUserWizardStep)CreateUserWizard1.FindControl("Step1");
            //DropDownList k1 = (DropDownList)step1.ContentTemplateContainer.FindControl("ddlDept");
            DropDownList k2       = (DropDownList)step1.ContentTemplateContainer.FindControl("ddlRole");
            TextBox      k3       = (TextBox)step1.ContentTemplateContainer.FindControl("tbxName");
            TextBox      k4       = (TextBox)step1.ContentTemplateContainer.FindControl("UserName");
            TextBox      tbxEmail = (TextBox)step1.ContentTemplateContainer.FindControl("tbxEmail");

            Roles.AddUserToRole(createdUsername, k2.Text);

            // string encryptedPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(createdPassword, "MD5");

            //try
            //{
            QHSEQuiz.Model.Hub hub = new QHSEQuiz.Model.Hub();

            hub.Name     = k3.Text;
            hub.UserName = createdUsername;
            //.Password = encryptedPassword;
            if (tbxEmail.Text != "")
            {
                hub.Email = tbxEmail.Text;
            }
            else
            {
                hub.Email = "N/A";
            }
            hub.Role = k2.SelectedItem.Text;

            context.Hubs.Add(hub);
            context.SaveChanges();
            //}

            //catch (DbEntityValidationException dbEx)
            //{
            //    foreach (var validationErrors in dbEx.EntityValidationErrors)
            //    {
            //        foreach (var validationError in validationErrors.ValidationErrors)
            //        {
            //            System.Diagnostics.Trace.TraceInformation("Property: {0} Error: {1}",
            //                                    validationError.PropertyName,
            //                                    validationError.ErrorMessage);
            //        }
            //    }
            //}
        }
Ejemplo n.º 4
0
        protected void btnSubmit3choiceAnswer_Click(object sender, EventArgs e)
        {
            string answer = ddl3choiceAnswer.Text;

            try
            {
                Question q = new Question();
                q.OrderInQuiz = Convert.ToInt32(tbxOrder.Text);
                q.QuizId      = Convert.ToInt32(Session["QuizId"]);
                q.Weighted    = Convert.ToDecimal(tbxWeighted.Text);
                q.Type        = ddlType.SelectedValue;
                q.Description = tbx3choiceQuestion.Text;

                context.Questions.Add(q);
                context.SaveChanges();

                foreach (string choice in choiceList)
                {
                    QuestionOption qo = new QuestionOption();
                    qo.QuestionId  = q.QuestionId;
                    qo.Description = choice;

                    context.QuestionOptions.Add(qo);
                    context.SaveChanges();
                }

                QuestionAnswer qa = new QuestionAnswer();
                qa.QuestionId = q.QuestionId;
                qa.OptionId   = context.QuestionOptions.Where(x => x.Description == answer).Where(x => x.QuestionId == q.QuestionId).Select(x => x.OptionId).First();
                context.QuestionAnswers.Add(qa);
                context.SaveChanges();

                Response.Redirect("~/Admin/ManageQuestions.aspx");
            }

            catch
            {
                lblError.Text = "Error saving data!";
            }
        }
Ejemplo n.º 5
0
        /// <summary>
        /// Save a single user answer to the db
        /// </summary>
        /// <param name="data"></param>
        public void SaveAnswer(QuizResponse data)
        {
            using (QuizEntities context = new QuizEntities())
            {

                context.QuizResponses.AddObject(new QuizResponse
                                                    {
                                                        Date = DateTime.Now,
                                                        AnswerId = data.AnswerId,
                                                        QuestionId = data.QuestionId
                                                    });

                context.SaveChanges();

            }
        }
Ejemplo n.º 6
0
 protected void gvQuestions_RowDeleting(object sender, GridViewDeleteEventArgs e)
 {
     try
     {
         int qId = Convert.ToInt32(gvQuestions.DataKeys[e.RowIndex].Values[0]);
         using (QuizEntities context = new QuizEntities())
         {
             Question question = (from x in context.Questions
                                  where x.QuestionId == qId
                                  select x).FirstOrDefault();
             context.Questions.Remove(question);
             context.SaveChanges();
         }
         this.BindGrid();
     }
     catch
     {
         Response.Redirect("~/Admin/QuizList.aspx");
     }
 }
Ejemplo n.º 7
0
        protected void gvUser_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string username = gvUser.Rows[e.RowIndex].Cells[1].Text;

            string query = "SELECT DISTINCT UserId FROM aspnet_Users WHERE UserName = '******'";

            con = new SqlConnection(conStr);
            SqlDataAdapter adapter = new SqlDataAdapter(query, con);
            DataTable      dt      = new DataTable();

            adapter.Fill(dt);
            //DataSet dataset = new DataSet();
            //adapter.Fill(dataset);

            Guid userId = Guid.Parse(dt.Rows[0][0].ToString());



            using (QuizEntities context = new QuizEntities())
            {
                QHSEQuiz.Model.Hub hub = context.Hubs.Where(x => x.UserName == username).First();
                context.Hubs.Remove(hub);

                //aspnet_Profile profile = context.aspnet_Profile.Where(x => x.PropertyValuesString == username).First();
                //context.aspnet_Profile.Remove(profile);

                aspnet_Users user = context.aspnet_Users.Where(x => x.UserName == username).First();
                context.aspnet_Users.Remove(user);

                aspnet_Membership mem = context.aspnet_Membership.Where(x => x.UserId == userId).First();
                context.aspnet_Membership.Remove(mem);

                aspnet_UsersInRoles userInRole = context.aspnet_UsersInRoles.Where(x => x.UserId == userId).First();
                context.aspnet_UsersInRoles.Remove(userInRole);


                context.SaveChanges();
                Response.Redirect("~/Admin/ManageUsers.aspx");
            }
        }
Ejemplo n.º 8
0
        protected void gvQuestions_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            int quizResultId = Convert.ToInt32(Session["ResultId"]);

            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                QuizControl qc = new QuizControl();

                Label lblQuestionId    = (Label)e.Row.FindControl("lblQuestionId");
                Label lblRightWrong    = (Label)e.Row.FindControl("lblRightWrong");
                Label lblYourAnswer    = (Label)e.Row.FindControl("lblYourAnswer");
                Label lblCorrectAnswer = (Label)e.Row.FindControl("lblCorrectAnswer");

                int questionId = Convert.ToInt32(lblQuestionId.Text);


                lblYourAnswer.Text    = qc.GetOwnAnswer(questionId, quizResultId);
                lblCorrectAnswer.Text = qc.GetCorrectAnswer(questionId);

                if (lblYourAnswer.Text == lblCorrectAnswer.Text)
                {
                    lblRightWrong.ForeColor = System.Drawing.Color.Green;
                    lblRightWrong.Text      = "Correct! 正确!";
                    correctCount++;
                    decimal questionScore = context.Questions.Where(x => x.QuestionId == questionId).Select(x => x.Weighted).First();
                    weightedScore = weightedScore + questionScore;
                }

                else if (lblYourAnswer.Text == null || lblYourAnswer.Text == "")
                {
                    lblYourAnswer.Visible    = false;
                    lblCorrectAnswer.Visible = false;
                    lblRightWrong.ForeColor  = System.Drawing.Color.Red;
                    lblRightWrong.Text       = "Cannot mark. This question might have been added after your quiz attempt. - 不能标记. 您的测验尝试后可能会添加此问题。";
                }

                else
                {
                    lblRightWrong.ForeColor = System.Drawing.Color.Red;
                    lblRightWrong.Text      = "Incorrect! 不正确!";
                    incorrectCount++;
                }

                decimal percentage = 100 * weightedScore / totalMark;
                lblScore.Text = percentage.ToString() + "%";
                if (percentage >= 80)
                {
                    lblScore.ForeColor = System.Drawing.Color.Green;
                }
                else
                {
                    lblScore.ForeColor = System.Drawing.Color.Red;
                }

                QuizResult qr = context.QuizResults.Where(x => x.ResultId == quizResultId).First();
                //if (qr.Correct == null || qr.Incorrect == null || qr.Result == null)
                //{
                qr.Correct   = correctCount;
                qr.Incorrect = incorrectCount;
                qr.Mark      = percentage;



                if (percentage >= 80)
                {
                    qr.Result = "Passed - 及格";
                }
                else
                {
                    qr.Result = "Failed - 不及格";
                }
                context.SaveChanges();
                //}
            }
        }
Ejemplo n.º 9
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            //questionIdList = (List<int>)Session["questionIdList"];
            //choiceList = (List<int>)Session["choiceList"];
            if (Page.IsValid)
            {
                IIdentity id       = User.Identity;
                dynamic   profile  = ProfileBase.Create(id.Name);
                string    username = id.Name;

                foreach (GridViewRow row in gvQuestions.Rows)
                {
                    RadioButtonList rblOptions    = (RadioButtonList)row.FindControl("rblOptions");
                    Label           lblQuestionId = (Label)row.FindControl("lblQuestionId");
                    Label           lblQuestion   = (Label)row.FindControl("lblQuestion");

                    if (rblOptions.SelectedItem != null)
                    {
                        int qId      = Convert.ToInt32(lblQuestionId.Text);
                        int choiceId = Convert.ToInt32(rblOptions.SelectedValue);
                        questionIdList.Add(qId);
                        choiceList.Add(choiceId);
                    }
                }

                string confirmValue = Request.Form["confirm_value"];
                if (confirmValue == "Yes")
                {
                    QuizResult qr     = new QuizResult();
                    int        quizId = Convert.ToInt32(Session["QuizId"]);
                    qr.QuizId   = quizId;
                    qr.Username = username;
                    qr.Name     = tbxName.Text;
                    if (tbxHRMS.Text != "")
                    {
                        qr.HRMS = Convert.ToInt32(tbxHRMS.Text);
                    }
                    //qr.Name = context.Employees.Where(x => x.UserName == username).Select(x => x.Name).First();
                    qr.TimeSubmitted = DateTime.Now;
                    context.QuizResults.Add(qr);
                    context.SaveChanges();

                    QuizResult qr2          = context.QuizResults.Where(x => x.Username == username).Where(x => x.QuizId == quizId).OrderByDescending(x => x.ResultId).First();
                    int        quizResultId = qr2.ResultId;

                    for (int i = 0; i < questionIdList.Count; i++)
                    {
                        QuestionResponse qresp = new QuestionResponse();
                        qresp.ResultId      = qr2.ResultId;
                        qresp.QuestionId    = questionIdList.ElementAt(i);
                        qresp.OptionId      = choiceList.ElementAt(i);
                        qresp.TimeSubmitted = DateTime.Now;
                        context.QuestionResponses.Add(qresp);
                        context.SaveChanges();
                    }

                    Session["ResultId"] = quizResultId;
                    Response.Redirect("~/Hub/ViewQuizResult.aspx");
                }
            }
        }
Ejemplo n.º 10
0
        //start new quiz
        protected void submitquiz_click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                try
                {
                    string name        = txtname.Text.Trim();
                    string description = txtdescription.Text.Trim();
                    //string completiondesc = txtcompletiondescription.Text.Trim();
                    string   start     = txtstartdate.Text;
                    string   end       = txtenddate.Text;
                    DateTime startdate = new DateTime();
                    startdate = Convert.ToDateTime(start);
                    DateTime enddate = new DateTime();
                    enddate = Convert.ToDateTime(end);
                    enddate = enddate.AddHours(23).AddMinutes(59).AddSeconds(59);

                    if ((startdate > enddate) || (startdate < updatedate))
                    {
                        lblalert.Visible = true;
                        lblalert.Text    = "Please check Start date and End date!";
                    }
                    else
                    {
                        Quiz q = new Quiz();

                        q.Name        = name;
                        q.Description = description;
                        q.StartDate   = startdate;
                        q.EndDate     = enddate;



                        context.Quizs.Add(q);
                        context.SaveChanges();

                        int quizId = q.QuizId;
                        List <QHSEQuiz.Model.Hub> hubList = context.Hubs.Where(x => x.UserName.Contains("hub")).ToList();
                        foreach (QHSEQuiz.Model.Hub hub in hubList)
                        {
                            QuizDateRange dateRange = new QuizDateRange();
                            dateRange.HubId     = hub.HubID;
                            dateRange.QuizId    = q.QuizId;
                            dateRange.StartDate = startdate;
                            dateRange.EndDate   = enddate;

                            context.QuizDateRanges.Add(dateRange);
                            context.SaveChanges();
                        }

                        //SqlCommand insertnew = new SqlCommand("insert into " + quizdetailstable + " (name, description, completiondescription, startdate, enddate, termsandconditions, lastupdated) values (@name, @description, @completiondescription, @startdate, @enddate, @termsandconditions, @lastupdated)");
                        //insertnew.Parameters.AddWithValue("name", name);
                        //insertnew.Parameters.AddWithValue("description", description);
                        ////insertnew.Parameters.AddWithValue("completiondescription", completiondesc);
                        //insertnew.Parameters.AddWithValue("startdate", startdate);
                        //insertnew.Parameters.AddWithValue("enddate", enddate);
                        ////insertnew.Parameters.AddWithValue("termsandconditions", quizterms);
                        ////insertnew.Parameters.AddWithValue("lastupdated", updatedate);

                        //db insertnewquiz = new db();
                        //insertnewquiz.ExecuteQuery(insertnew);
                        Session["QuizId"] = q.QuizId;
                        Response.Redirect("~/Admin/ManageQuestions.aspx", false);
                    }
                }
                catch
                {
                    lblalert.Visible = true;
                    lblalert.Text    = "Please enter the complusory fields and try again!";
                }
            }
            else
            {
                lblalert.Visible = true;
                lblalert.Text    = "Please enter the complusory fields and try again!";
            }
        }