public static void SaveMark(MarkInfo info)
{
using (IDbConnection cnn = new SqlConnection(connection()))
{
cnn.Execute("insert into Marks (Test,ActualAnswer,TheirAnswer,Question,StudentId) values (@Test,@ActualAnswer,@TheirAnswer,@Question,@StudentId)", info);
}
}
private void BtSubmit_Click(object sender, RoutedEventArgs e)
{
//filling list
test = Methods.fillTest();
//assigning variable
string questionselected = LBQuestions.SelectedItem.ToString();
//checking what they answered
if ((bool)RBAnswerA.IsChecked == true)
{
answer = 'A';
}
if ((bool)RBAnswerB.IsChecked == true)
{
answer = 'B';
}
if ((bool)RBAnswerC.IsChecked == true)
{
answer = 'C';
}
if ((bool)RBAnswerD.IsChecked == true)
{
answer = 'D';
}
//looping through list
foreach (TestInfo b in test)
{
//checking if the questions are the same
if (questionselected == ("Questions" + b.id.ToString()))
{
//chekcing is the answer they answered was right or wrong
if (answer == b.ActualAnswer.ToCharArray()[0])
{
//adding data to variables
Test = b.Test.ToString();
ActualAnswer = b.ActualAnswer.ToString();
TheirAnswer = answer.ToString();
id = b.id.ToString();
//printing that they where right
DLL.correctanswer();
}
else
{
//adding data to variables
Test = b.Test.ToString();
ActualAnswer = b.ActualAnswer.ToString();
TheirAnswer = answer.ToString();
id = b.id.ToString();
//printing that they where wrong
DLL.Wronganswer();
}
}
}
//adding answers and other info to objects
MarkInfo m = new MarkInfo();
m.Test = Test;
m.ActualAnswer = ActualAnswer;
m.TheirAnswer = TheirAnswer;
m.Question = "Question" + id;
m.StudentId = MainWindow.PersonID;
//filling list
marks = Methods.fillMarks();
//looping through list
foreach (var h in marks)
{
//checking is the person has answered this question before
if (h.StudentId == MainWindow.PersonID)
{ //checking iff match
if (h.Question == "Question" + id)
{
isthere = true;
}
}
}
if (isthere == true)
{
//saying that they have answered that question before
DLL.alreadyanswered();
}
else
{
//saves info to DB
Methods.SaveMark(m);
}
}
