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(); } }
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); } } }