private void loadNewQuestion()
{
//wersja z Sql server
//SqlConnection conn = new SqlConnection("Server=DESKTOP-BO91STR\\SQLEXPRESS;Database=Quiz;Integrated Security=true");
//conn.Open();
//wersja z azure
/*SqlConnection conn = null;
* try
* {
* var cb = new SqlConnectionStringBuilder();
* cb.DataSource = "serv2703.database.windows.net";
* cb.PersistSecurityInfo = false;
* cb.MultipleActiveResultSets = false;
* cb.Encrypt = true;
* cb.TrustServerCertificate = false;
* cb.ConnectTimeout = 30;
* cb.UserID = "adam";
* cb.Password = "******";
* cb.InitialCatalog = "Quiz";
*
* conn = new SqlConnection(cb.ConnectionString);
* conn.Open();
* }
* catch (SqlException e)
* {
* Console.WriteLine(e.ToString());
* }*/
//część uniwersalna dla sql
// SqlCommand cmd = new SqlCommand(
// "Select q.Description from Questions2 q where q.Topic='"+scenario+"' and q.Difficulty="+currentQuestion+"", conn);
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// Quest.Text = reader.GetString(0);
// Question.Text = "Question" + currentQuestion;
// }
// cmd=new SqlCommand(
// "select a.[Description] , a.IsCorrect from Questions2 q join Answers2 a on a.QuestionId = q.QuestionId where q.Topic='" + scenario + "' and q.Difficulty =" + currentQuestion + "", conn);
// reader.Close();
//reader = cmd.ExecuteReader();
// int currentans = 0;
// while (reader.Read())
// {
// answers.ElementAt(currentans).Text=reader.GetString(0);
// if (reader.GetBoolean(1))
// {
// correctAns = answers.ElementAt(currentans);
// }
// currentans++;
// }
// Shuffle(answers);
// ansA = answers.ElementAt(0);
// ansB = answers.ElementAt(1);
// ansC = answers.ElementAt(2);
// ansD = answers.ElementAt(3);
// foreach(Button b in answers)
// {
// if (b.Equals(correctAns))
// {
// correctNumb = answers.IndexOf(b);
// }
// }
// reader.Close();
// conn.Close();
toJson tJ = new toJson();
List <Question> lq = new List <Question>();
List <Answer> la = new List <Answer>();
lq = tJ.serializeQuestions();
la = tJ.serializeAnswers();
Question currQ = null;
foreach (Question q in lq)
{
if (q.Topic == scenario && q.Difficulty == currentQuestion)
{
currQ = q;
Quest.Text = q.Description;
Question.Text = "Question" + currentQuestion;
break;
}
}
int currentans = 0;
foreach (Answer a in la)
{
if (a.QuestionId == currQ.QuestionId)
{
answers.ElementAt(currentans).Text = a.Description;
if (a.IsCorrect == 1)
{
correctAns = answers.ElementAt(currentans);
}
currentans++;
}
}
Shuffle(answers);
ansA = answers.ElementAt(0);
ansB = answers.ElementAt(1);
ansC = answers.ElementAt(2);
ansD = answers.ElementAt(3);
foreach (Button b in answers)
{
if (b.Equals(correctAns))
{
correctNumb = answers.IndexOf(b);
}
}
}
