//for displaying options and questions of specific category public void displaycatwise() { string s = textBox1.Text; long l; long.TryParse(s, out l); var q = (from Question qs1 in catAppDB.Questions join Question_category qs2 in catAppDB.Question_categories on qs1._id equals qs2.Q_id where qs2.C_id == l select qs1).Count(); var q1 = from Question qs1 in catAppDB.Questions join Question_category qs2 in catAppDB.Question_categories on qs1._id equals qs2.Q_id where qs2.C_id == l select qs1; Questions = new ObservableCollection <Question>(q1); var v = Questions.ToList(); int count = 1; // long l1; for (int i = 0; i < q; i++) { PivotItem pi = new PivotItem(); pi.Header = string.Format("Q {0}", count); Opt puc = new Opt(); // Question s2 = v[i].Header.Replace("<br />", "\n"); //Question s3 = v[i].Content.Replace("<br />","\n"); // s2 = qq.Content.ToString(); //Question s4 = s2 + s3; // Question s5=s4.ToList(); puc.DataContext = v[i] as Question; pi.Content = puc; pivot1.Items.Add(pi); count++; } }
private void yearwise_Loaded(object sender, RoutedEventArgs e) { noque nq = new noque(); Opt op = new Opt(); string st = nq.button2.Content.ToString(); string st2 = "ON"; if (st.Equals(st2)) { displayyearwise(); } else if (!(st.Equals(st2))) { displayyearwise(); } //displayyearwise(); }
public void displayyearwise() { string s = textBox1.Text; long l; long.TryParse(s, out l); var q = (from Question qs1 in catAppDB.Questions where qs1.T_id == l select qs1).Count(); var q1 = from Question qs1 in catAppDB.Questions where qs1.T_id == l select qs1; Questions = new ObservableCollection<Question>(q1); var v = Questions.ToList(); int count = 1; //string s2,s3; // long l1; for (int i = 0; i < q; i++) { PivotItem pi = new PivotItem(); pi.Header = string.Format("Q {0}", count); Opt puc = new Opt(); // s2 = v[i].Header.ToString(); //s3 = v[i].Content.ToString(); // s2 = qq.Content.ToString(); puc.DataContext = v[i] as Question; pi.Content = puc; pivot1.Items.Add(pi); count++; } // MessageBox.Show("record Added Successfully!!!"); // StringBuilder strBuilder = new StringBuilder(); //strBuilder.AppendLine("Attempt Details"); //IList<Attempt> AttemptList = this.GetAttemptList(); //foreach (Attempt att1 in AttemptList) //{ // // strBuilder.AppendLine("AID" + "UID - " + att1.U_id + "TID-" + att1.T_id + "timestamp-" + att1.Timpstamp); // strBuilder.AppendLine("TID-" + att1.T_id +"UID"+ att1.U_id + "timestamp-" + att1.Timpstamp); //} //MessageBox.Show(strBuilder.ToString()); }
//for displaying options and questions of specific category public void displaycatwise() { string s = textBox1.Text; long l; long.TryParse(s, out l); var q = (from Question qs1 in catAppDB.Questions join Question_category qs2 in catAppDB.Question_categories on qs1._id equals qs2.Q_id where qs2.C_id == l select qs1).Count(); var q1 = from Question qs1 in catAppDB.Questions join Question_category qs2 in catAppDB.Question_categories on qs1._id equals qs2.Q_id where qs2.C_id == l select qs1; Questions = new ObservableCollection<Question>(q1); var v = Questions.ToList(); int count = 1; // long l1; for (int i = 0; i < q;i++ ) { PivotItem pi = new PivotItem(); pi.Header = string.Format("Q {0}", count); Opt puc = new Opt(); puc.DataContext= v[i] as Question ; pi.Content = puc; pivot1.Items.Add(pi); count++; } }