public static string InsertQuestionResults(QuestionResult item)
{
SqlCommand command = new SqlCommand("Insert Into QuestionResult (Results_ID, Answer_ID) values(" + item.Results_ID + ", " + item.Answer_ID
+ ");", con);
string s = ExecuteCommand(command);
SqlCommand command2 = new SqlCommand("Select * from QuestionResult where QuestionResult.Results_ID='" + item.Results_ID + "' AND QuestionResult.Answer_ID='" + item.Answer_ID + "';", con);
SqlDataReader sdr1 = command2.ExecuteReader();
while (sdr1.Read())
{
item.ID = (int)sdr1["QuestionResult_ID"];
}
sdr1.Close();
return(s);
}
public static string LoadQuestionResultsByAnswer(int answer_id, out QuestionResult[] items)
{
List <QuestionResult> itemsList = new List <QuestionResult>();
items = null;
if (con == null)
{
return("Connection is not initialized");
}
try
{
SqlCommand command2 = new SqlCommand("Select * from QuestionResult where QuestionResult.Answer_id='" + answer_id + "';", con);
SqlDataReader sdr1 = command2.ExecuteReader();
while (sdr1.Read())
{
QuestionResult item = new QuestionResult();
item.ID = (int)sdr1["QuestionResult_ID"];
item.Answer_ID = (int)sdr1["Answer_ID"];
item.Results_ID = (int)sdr1["Results_ID"];
itemsList.Add(item);
}
sdr1.Close();
}
catch (Exception e)
{
return(e.ToString());
}
items = itemsList.ToArray();
if (items.Length != 1)
{
return(items.Length + " records loaded");
}
else
{
return(items.Length + " record loaded");
}
}
public static string LoadQuestionResultsByAnswer(int answer_id, out QuestionResult[] items)
{
List<QuestionResult> itemsList = new List<QuestionResult>();
items = null;
if (con == null)
return "Connection is not initialized";
try
{
SqlCommand command2 = new SqlCommand("Select * from QuestionResult where QuestionResult.Answer_id='" + answer_id + "';", con);
SqlDataReader sdr1 = command2.ExecuteReader();
while (sdr1.Read())
{
QuestionResult item = new QuestionResult();
item.ID = (int)sdr1["QuestionResult_ID"];
item.Answer_ID = (int)sdr1["Answer_ID"];
item.Results_ID = (int)sdr1["Results_ID"];
itemsList.Add(item);
}
sdr1.Close();
}
catch (Exception e)
{
return e.ToString();
}
items = itemsList.ToArray();
if (items.Length != 1)
return items.Length + " records loaded";
else
return items.Length + " record loaded";
}
public static string InsertQuestionResults(QuestionResult item)
{
SqlCommand command = new SqlCommand("Insert Into QuestionResult (Results_ID, Answer_ID) values(" + item.Results_ID + ", " + item.Answer_ID
+ ");", con);
string s = ExecuteCommand(command);
SqlCommand command2 = new SqlCommand("Select * from QuestionResult where QuestionResult.Results_ID='" + item.Results_ID + "' AND QuestionResult.Answer_ID='" + item.Answer_ID + "';", con);
SqlDataReader sdr1 = command2.ExecuteReader();
while (sdr1.Read())
{
item.ID = (int)sdr1["QuestionResult_ID"];
}
sdr1.Close();
return s;
}
void sb_Completed(object sender, EventArgs e)
{
if (curMode == UIMode.Questionary)
{
title.Text = currentQuiz.Description;
button.Content = "Submit";
ScrollViewer scrollViewer = new ScrollViewer();
scrollViewer.VerticalScrollBarVisibility = ScrollBarVisibility.Auto;
Border border = new Border();
border.Padding = new Thickness(1);
/*border.BorderThickness = new Thickness(1);
* border.BorderBrush = List.BorderBrush;
* border.Background = Brushes.White;*/
quizViewer = new StackPanel();
quizViewer.Orientation = Orientation.Vertical;
for (int i = 0; i < currentQuizQuestions.Length; i++)
{
StackPanel answers = new StackPanel();
answers.Orientation = Orientation.Vertical;
answers.Margin = new Thickness(0, 0, 0, 5);
Answer[] a;
DB.LoadAnswers(currentQuizQuestions[i].ID, out a);
if (a != null)
{
answers.Children.Add(new TextBlock()
{
Text = currentQuizQuestions[i].Description, FontFamily = new FontFamily("Segoe UI"), FontSize = 16, Tag = currentQuizQuestions[i]
});
for (int j = 0; j < a.Length; j++)
{
answers.Children.Add(new RadioButton()
{
Content = a[j].Description, FontFamily = new FontFamily("Segoe UI"), Tag = a[j]
});
}
quizViewer.Children.Add(answers);
}
}
scrollViewer.Content = quizViewer;
border.Child = scrollViewer;
contentPanel.Children.Clear();
contentPanel.Children.Add(border);
}
else if (curMode == UIMode.ResultsView)
{
Results results = new Results(currentQuiz.ID, curUser.ID);
DB.InsertResults(ref results);
foreach (object o in quizViewer.Children)
{
if (o is StackPanel)
{
StackPanel answers = o as StackPanel;
Question question = null;
for (int i = 0; i < answers.Children.Count; i++)
{
object obj = answers.Children[i];
if (obj is TextBlock)
{
TextBlock tb = obj as TextBlock;
question = (Question)tb.Tag;
}
else if (obj is RadioButton)
{
RadioButton rb = obj as RadioButton;
if (rb.IsChecked.Value)
{
Answer answer = (Answer)rb.Tag;
QuestionResult result = new QuestionResult(answer.ID, results.ID);
DB.InsertQuestionResults(result);
}
}
}
}
}
contentPanel.Children.Clear();
Chart ch = new Chart();
ch.LoadQuiz(currentQuiz.ID, curUser.ID);
contentPanel.Children.Add(ch);
title.Text = "Results:";
button.Content = "Ok";
}
else if (curMode == UIMode.QuizSelection)
{
contentPanel.Children.Clear();
contentPanel.Children.Add(List);
title.Text = "Choose quiz:";
button.Content = "Start";
}
else if (curMode == UIMode.Login)
{
contentPanel.Children.Clear();
LoginPage page = new LoginPage();
page.Submit += Button_Click_1;
contentPanel.Children.Add(page);
title.Text = "Login";
button.Content = "Ok";
}
fadein.Begin();
}
void sb_Completed(object sender, EventArgs e)
{
if (curMode == UIMode.Questionary)
{
title.Text = currentQuiz.Description;
button.Content = "Submit";
ScrollViewer scrollViewer = new ScrollViewer();
scrollViewer.VerticalScrollBarVisibility = ScrollBarVisibility.Auto;
Border border = new Border();
border.Padding = new Thickness(1);
/*border.BorderThickness = new Thickness(1);
border.BorderBrush = List.BorderBrush;
border.Background = Brushes.White;*/
quizViewer = new StackPanel();
quizViewer.Orientation = Orientation.Vertical;
for (int i = 0; i < currentQuizQuestions.Length; i++)
{
StackPanel answers = new StackPanel();
answers.Orientation = Orientation.Vertical;
answers.Margin = new Thickness(0, 0, 0, 5);
Answer[] a;
DB.LoadAnswers(currentQuizQuestions[i].ID, out a);
if (a != null)
{
answers.Children.Add(new TextBlock() { Text = currentQuizQuestions[i].Description, FontFamily = new FontFamily("Segoe UI"), FontSize = 16, Tag = currentQuizQuestions[i] });
for (int j = 0; j < a.Length; j++)
{
answers.Children.Add(new RadioButton() { Content = a[j].Description, FontFamily = new FontFamily("Segoe UI"), Tag = a[j] });
}
quizViewer.Children.Add(answers);
}
}
scrollViewer.Content = quizViewer;
border.Child = scrollViewer;
contentPanel.Children.Clear();
contentPanel.Children.Add(border);
}
else if (curMode == UIMode.ResultsView)
{
Results results = new Results(currentQuiz.ID, curUser.ID);
DB.InsertResults(ref results);
foreach (object o in quizViewer.Children)
{
if (o is StackPanel)
{
StackPanel answers = o as StackPanel;
Question question = null;
for (int i = 0; i < answers.Children.Count; i++)
{
object obj = answers.Children[i];
if (obj is TextBlock)
{
TextBlock tb = obj as TextBlock;
question = (Question)tb.Tag;
}
else if (obj is RadioButton)
{
RadioButton rb = obj as RadioButton;
if (rb.IsChecked.Value)
{
Answer answer = (Answer)rb.Tag;
QuestionResult result = new QuestionResult(answer.ID, results.ID);
DB.InsertQuestionResults(result);
}
}
}
}
}
contentPanel.Children.Clear();
Chart ch = new Chart();
ch.LoadQuiz(currentQuiz.ID, curUser.ID);
contentPanel.Children.Add(ch);
title.Text = "Results:";
button.Content = "Ok";
}
else if (curMode == UIMode.QuizSelection)
{
contentPanel.Children.Clear();
contentPanel.Children.Add(List);
title.Text = "Choose quiz:";
button.Content = "Start";
}
else if (curMode == UIMode.Login)
{
contentPanel.Children.Clear();
LoginPage page = new LoginPage();
page.Submit += Button_Click_1;
contentPanel.Children.Add(page);
title.Text = "Login";
button.Content = "Ok";
}
fadein.Begin();
}
