private void showprogress() { DBProgressConnect DBProgressConnect_Inst = new DBProgressConnect(); DataTable ProgressData = new DataTable(); ProgressData = DBProgressConnect_Inst.Read(globaldata.current_user); datagrid1.ItemsSource = ProgressData.DefaultView; int data_count = DBProgressConnect_Inst.Count(globaldata.current_user); DateTime[] dates = new DateTime[data_count]; double[] scores = new double[data_count]; for (int i = 0; i < data_count; i++) { dates[i] = Convert.ToDateTime(ProgressData.Rows[i][1]); scores[i] = Convert.ToDouble(ProgressData.Rows[i][2]); } var datesDataSource = new EnumerableDataSource<DateTime>(dates); datesDataSource.SetXMapping(x => dateAxis.ConvertToDouble(x)); var scoreDataSource = new EnumerableDataSource<double>(scores); scoreDataSource.SetYMapping(y => y); CompositeDataSource compositeDataSource1 = new CompositeDataSource(datesDataSource, scoreDataSource); Plotter.AddLineGraph(compositeDataSource1, new Pen(Brushes.Blue, 2), new CirclePointMarker { Size = 10.0, Fill = Brushes.Red }, new PenDescription("Time vs. Score for "+globaldata.current_user+"")); Plotter.Viewport.FitToView(); }
private void getques() { if (TotalQues==0) { score = 100 * nof_correct / (nof_correct+nof_unanswered+nof_wrong); System.Windows.MessageBox.Show("Correct: " + Convert.ToString(nof_correct) + " ,wrong: " + Convert.ToString(nof_wrong) + " ,Unanswered: " + Convert.ToString(nof_unanswered)+" : So, you scored : "+Convert.ToString(score)+"% in this session"); DBProgressConnect DBProgressConnect_inst = new DBProgressConnect(); //globaldata gb = new globaldata(); DBProgressConnect_inst.Insert(globaldata.current_user, Convert.ToString(DateTime.Now), Convert.ToString(score)); ActivitySelection Actv_Instnc = new ActivitySelection(); this.Hide(); Actv_Instnc.Show(); } else { rdbtn1.IsChecked = false; rdbtn2.IsChecked = false; rdbtn3.IsChecked = false; rdbtn4.IsChecked = false; DBVocaConnect DBConnect_inst = new DBVocaConnect(); int data_count = DBConnect_inst.Count(); DataTable QuesLoadTable = new DataTable(); QuesLoadTable = DBConnect_inst.Read(); Random Rand_Gen = new Random(); int[] x = new int[4]; for (int j = 0; j < 4; j++) { x[j] = Rand_Gen.Next(data_count + 1); } string ques; ques = QuesLoadTable.Rows[x[0]][1].ToString(); ques = ques.Trim(); txtblck1.Text = "Question: " + ques; CorrectAns = QuesLoadTable.Rows[x[0]][2].ToString(); CorrectAns = CorrectAns.Trim(); //label6.Content = "Database Entry: " + (x[0] + 1).ToString() + "\nCorrect Answer: " + CorrectAns; string[] AllAns = new string[4]; for (int i = 0; i < 4; i++) { AllAns[i] = QuesLoadTable.Rows[x[i]][2].ToString(); } new Random().Shuffle(AllAns); rdbtn1.Content = AllAns[0].Trim(); rdbtn2.Content = AllAns[1].Trim(); rdbtn3.Content = AllAns[2].Trim(); rdbtn4.Content = AllAns[3].Trim(); TotalQues--; } }