Example #1
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            using (databaseEntities qentities = new databaseEntities())                         //input the data in the question
            {
                Question q = new Question();
              
                var temp = this.questionid.Text;
                string m = Convert.ToString(temp);
                q.Id = Convert.ToInt32(m);
                int i;
                if(bonus.Tag=="1")
                {
                    i = 1;
                }
                else if(important.Tag=="1")
                {
                    i = 2;
                }
                else
                {
                    i = 3;
                }

                q.level = i;
                q.causees = Convert.ToString(this.course.Text);
                q.questioncontent = Convert.ToString(this.questioncontent.Text);
                q.ifask = Convert.ToString("noasked");
                qentities.Question.Add(q);
                qentities.SaveChanges();


            }

        }
Example #2
0
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            Question q = new Question();
            notation result = new notation();
            using (databaseEntities shentities = new databaseEntities())
            {
                var emp = this.teacherid.Text;
                result.Id = Convert.ToInt32(emp);
                result.Certifications = this.Certifications.Text;
                string etcscore_s = this.ects.Text;
                int etcscore = Convert.ToInt32(etcscore_s);
                if (etcscore >= 15)
                {
                    result.Validation_of_ECTS_credits = "A";
                }
                else if (etcscore >= 10 && etcscore < 15)
                {
                    result.Validation_of_ECTS_credits = "B";
                }
                else
                {
                    result.Validation_of_ECTS_credits = "C";
                }

                result.work_experience = this.experience.Text;
               
                
                float s = 0;
                float count = 0;

                    Console.WriteLine("which question you asked him (input the id)? ");
                    var heihei = this.questionid.Text;
                    int qid = System.Convert.ToInt32(heihei);
                    string score = this.question.Text;
                    IQueryable<Question> soga = from c in shentities.Question where (c.Id == qid) select c;
                    foreach (var c in soga)
                    {


                        c.ifask = "asked";
                        int finalscore;
                        if (c.level == 1)
                        {
                            switch (score)
                            {
                                case "A": finalscore = 3; count++; break;
                                case "B": finalscore = 2; count++; break;
                                case "C": finalscore = 2; count += 2; break;
                                default: finalscore = 0; count++; break;
                            }
                            s += finalscore;

                        }
                        else if (c.level == 2)
                        {
                            switch (score)
                            {
                                case "A": finalscore = 6; count += 2; break;
                                case "B": finalscore = 3; count++; break;
                                case "C": finalscore = 1; count++; break;
                                default: finalscore = 0; count++; break;
                            }
                            s += finalscore;

                        }
                        else
                        {
                            switch (score)
                            {
                                case "A": finalscore = 3; count++; break;
                                case "B": finalscore = 2; count++; break;
                                case "C": finalscore = 1; count++; break;
                                default: finalscore = 0; count++; break;
                            }
                            s += finalscore;

                        }
                    }



                float finalfinalscore = s / count;
                if (finalfinalscore >= 2 && finalfinalscore <= 3) { result.questionmark = "A"; }
                else if (finalfinalscore >= 1 && finalfinalscore < 2) { result.questionmark = "B"; }
                else if (finalfinalscore < 1) { result.questionmark = "C"; }

                result.finalmark = result.Certifications + result.Validation_of_ECTS_credits + result.work_experience + result.questionmark;

                int Cfinalscore;
                int Efinalscore;
                int Wfinalscore;
                int Qfinalscore;
                int ifpass = 0;

                switch (result.Certifications)
                {
                    case "A": Cfinalscore = 3; ifpass += Cfinalscore; break;
                    case "B": Cfinalscore = 2; ifpass += Cfinalscore; break;
                    case "C": Cfinalscore = 1; ifpass += Cfinalscore; break;
                }
                switch (result.Validation_of_ECTS_credits)
                {
                    case "A": Efinalscore = 3; ifpass += Efinalscore; break;
                    case "B": Efinalscore = 2; ifpass += Efinalscore; break;
                    case "C": Efinalscore = 1; ifpass += Efinalscore; break;
                }
                switch (result.work_experience)
                {
                    case "A": Wfinalscore = 3; ifpass += Wfinalscore; break;
                    case "B": Wfinalscore = 2; ifpass += Wfinalscore; break;
                    case "C": Wfinalscore = 1; ifpass += Wfinalscore; break;
                }
                switch (result.questionmark)
                {
                    case "A": Qfinalscore = 3; ifpass += Qfinalscore; break;
                    case "B": Qfinalscore = 2; ifpass += Qfinalscore; break;
                    case "C": Qfinalscore = 1; ifpass += Qfinalscore; break;
                }
                if (ifpass >= 9)
                {
                    result.ifpassed = "pass";
                }
                else
                {
                    result.ifpassed = "failed";
                }

                resulttext.Inlines.Add(new Run("hey you " + result.ifpassed + " the score is " + result.finalmark));
                resulttext.Inlines.Add(new LineBreak());
     
                shentities.notation.Add(result);
                shentities.SaveChanges();

                if (result.ifpassed == "pass")
                {                
                    var mailwindow = new mailwindow();
                    mailwindow.Show();
   //                 sendmail(result.finalmark, result.Id);

                }
            }
        }