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)
{
string thename_s = this.search.Text;
using (databaseEntities sentities = new databaseEntities())
{
IQueryable<Teacher> temp = from c in sentities.Teacher where (c.Name == thename_s) select c;
foreach (var c in temp)
{
result.Text = c.Id + '\n' + c.Name + '\n' + c.Firstname + '\n' + c.Promotion_during_validation + '\n' + c.Current_Promotion + '\n' + c.E_mail + '\n' + c.Campus + '\n' + c.Courses_that_he_already_teach + '\n' + c.Courses_that_he_would_teach + '\n' + c.The_campus_on_which_he_has_already_given_a_course + '\n' + c.The_campus_on_which_he_would_give_a_course + '\n';
}
}
}
private void searchbotton_Click(object sender, RoutedEventArgs e)
{
using (databaseEntities shentities = new databaseEntities())
{
/* var temp=shentities.Question
.Where(question=> question.causees==this.searchcontent.Text)
.Select( question => new question
{
question.level,
question.causees,
question.questioncontent
});*/
IQueryable<Question> temp = from c in shentities.Question where c.causees == this.searchcontent.Text select c;
// IQueryable<Question> temp = from c in shentities.Question select c;
foreach (var c in temp)
{
{
string level_s;
switch (c.level)
{
case 1: level_s = "important"; break;
case 2: level_s = "bonus"; break;
case 3: level_s = "common"; break;
default: level_s = "common"; break;
}
text.Text = level_s+"\n" +c.causees+"\n"+c.questioncontent+"\n";
/*text.Inlines.Add(new Run(level_s));
text.Inlines.Add(new LineBreak());
text.Inlines.Add(new Run(c.causees));
text.Inlines.Add(new LineBreak());
text.Inlines.Add(new Run(c.questioncontent));
text.Inlines.Add(new LineBreak());
text.Inlines.Add(new LineBreak());
text.Inlines.Add(new LineBreak());*/
}
}
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
using (databaseEntities entities = new databaseEntities()) //put the information in teacher
{
Teacher t = new Teacher();
var temp = this.trainerid.Text;
string m = Convert.ToString(temp);
t.Id = Convert.ToInt32(m);
t.Name = Convert.ToString(this.trainername.Text);
t.Firstname = Convert.ToString(this.trainerfirstname.Text);
t.Promotion_during_validation = Convert.ToString(this.trainervalidation.Text);
t.Current_Promotion = Convert.ToString(this.trainerPromotion.Text);
t.E_mail = Convert.ToString(this.trainermail.Text);
t.Campus = Convert.ToString(this.Campus.Text);
t.Courses_that_he_would_teach = Convert.ToString(this.alcourse.Text);
t.Courses_that_he_already_teach = Convert.ToString(this.hacourse.Text);
t.The_campus_on_which_he_would_give_a_course = Convert.ToString(this.alcampus.Text);
t.The_campus_on_which_he_has_already_given_a_course = Convert.ToString(this.wouldcampus.Text);
entities.Teacher.Add(t);
entities.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);
}
}
}
