Example #1
0
        /// <summary>
        /// Saves the import data.
        /// </summary>
        /// <param name="importZipCodes">The import zip codes.</param>
        /// <exception cref="System.NotImplementedException"></exception>
        public void SaveImportData(IEnumerable <OutboundData> importZipCodes)
        {
            try
            {
                //先砍掉全部資料
                using (var db = new TestDataEntities())
                {
                    foreach (var item in db.OutboundData.OrderBy(x => x.ID))
                    {
                        db.OutboundData.Remove(item);
                    }
                    db.SaveChanges();
                }

                //再把匯入的資料給存到資料庫
                using (var db = new TestDataEntities())
                {
                    foreach (var item in importZipCodes)
                    {
                        db.OutboundData.Add(item);
                    }
                    db.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Example #2
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sname = TextBox1.Text;

        using (var context = new TestDataEntities())
        {
            var user = (from u in context.Scores
                        where u.Name == sname
                        select u.Name).FirstOrDefault();

            if (user != null)
            {
                Session["Username"] = Label1.Text;
                Response.Redirect("Exam.aspx");
            }
            else
            {
                Score s = new Score
                {
                    Name  = sname,
                    Marks = 0,
                };
                context.Scores.Add(s);
                context.SaveChanges();
                Session["Username"] = Label1.Text;
                Response.Redirect("Exam.aspx");
            }
        }
    }
Example #3
0
    private AnswerStatus CheckAnswer()
    {
        var yourAnswer = RadioButtonList1.SelectedValue;

        using (var context = new TestDataEntities())
        {
            var question = (from q in context.Questions
                            where q.QuizId == 1
                            select q).FirstOrDefault();
            if (yourAnswer == null)
            {
                return(AnswerStatus.Blank);
            }
            return(question.Ans == yourAnswer ? AnswerStatus.Correct : AnswerStatus.Wrong);
        }
    }
Example #4
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        using (var context = new TestDataEntities())
        {
            Question q = new Question
            {
                QuizId  = 10,
                Quest   = TextBox1.Text,
                Answers = TextBox2.Text,
                Ans     = TextBox3.Text,
                Level   = Convert.ToInt32(TextBox4.Text)
            };

            context.Questions.Add(q);
            context.SaveChanges();
        }
    }
Example #5
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        switch (CheckAnswer())
        {
        case AnswerStatus.Correct:
            Level = Level + 1;
            break;

        case AnswerStatus.Wrong:
            if (Level > 0)
            {
                Level = Level - 1;
            }
            break;
        }
        QuizIds.Add(int.Parse(QuizIdField.Value));
        RadioButtonList1.Items.Clear();
        using (var context = new TestDataEntities())
        {
            var question = (from q in context.Questions
                            where !QuizIds.Contains(q.QuizId) && // QuizIds = {1} ==> 'QuizId NOT IN (1)'
                            q.Level == Level
                            select q).FirstOrDefault();


            if (question != null)
            {
                Label1.Text = question.Quest;

                string[] options = question.Answers.Split('|');

                foreach (string option in options)
                {
                    ListItem i = new ListItem(option);
                    RadioButtonList1.Items.Add(i);
                }
            }
        }
    }
Example #6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            using (var context = new TestDataEntities())
            {
                var question = (from q in context.Questions
                                where q.Level == 0
                                select q).FirstOrDefault();
                if (question != null)
                {
                    Label1.Text       = question.Quest;
                    QuizIdField.Value = question.QuizId.ToString();
                    string[] options = question.Answers.Split('|');

                    foreach (string option in options)
                    {
                        ListItem i = new ListItem(option);
                        RadioButtonList1.Items.Add(i);
                    }
                }
            }
        }
    }