//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();
}
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++;
}
}
