private string BindQuizable(string testid)
{
//string htmltext = ChecekMode?"<table class=\"History_Quiz_tabel\">":"<table class=\"Quiz_table\">";
string htmltext = "";
DataSet Ds = new DataSet();
string SelectCmd_Q = "Select TTRelationship.RelationshipID,Topic.TopicID,Topic.TopicContent,Topic.HaveContent,Topic.MoreContent From TTRelationship inner join Topic on TTRelationship.TopicID=Topic.TopicID where TTRelationship.TestID=" + testid;
using (MySqlConnection Sc = new MySqlConnection(Diya.ConectionString))
{
Sc.Open(); MySqlDataAdapter Da = new MySqlDataAdapter(SelectCmd_Q, Sc);
Da.Fill(Ds);
}
int TestCount = 0;
DataTable Dt = Ds.Tables[0];
using (MySqlDataReader read = new Diya().RowReader("select TestCount from TestInfo where TestID=" + testid))
{
if (read.Read())
{
TestCount = read.GetInt32(0);
}
else
{
TestCount = 0;
}
read.Close();
}
for (int i = 0; i < TestCount; i++)
{
htmltext = "<tr class=\"item_Quiz\"><td style=\text-align:left\"><label>" + (i + 1) + " ." + Dt.Rows[i]["TopicContent"] + "</label></td></tr>";
DataSet Dso = new DataSet();
using (MySqlConnection Sc = new MySqlConnection(Diya.ConectionString))
{
Sc.Open(); MySqlDataAdapter da = new MySqlDataAdapter("Select Options.OptionID,Options.OptionContent From Options inner join OTRelationship on OTRelationship.OptionID=Options.OptionID Where OTRelationship.TTRelationshipID=" + Dt.Rows[i]["RelationshipID"].ToString(), Sc);
da.Fill(Dso);
}
DataTable Options = Dso.Tables[0];
for (int j = 0; j < Options.Rows.Count; j++)
{
htmltext += "<tr style=\"height:2%\"><td> </td></tr>";
htmltext += "<tr><td><div class=\"item_Options\"> title=\"\" id=\"" + Options.Rows[j]["OptionID"] + "n\"><input type=\"checkbox\" runat=\"server\" id=\"" + Options.Rows[j]["OptionID"] + "\" onserverchange=\"test_ServerChange\" disabled=\"disabled\" style=\"border:1px solid Black\">" + Convert.ToChar(65 + j) + ". " + Options.Rows[j]["OptionContent"] + "</div></td></tr>";
if (j == Options.Rows.Count - 1)
{
htmltext += "<tr style=\"height:5%\"><td> </td></tr>";
}
}
Dst.Addstate(htmltext);
}
return(htmltext);
}
private void BindQuizable(string testid, string TSRelationshipID)
{
string HtmlText = "";
string SelectCmd = "Select TTRelationship.RelationshipID,Topic.TopicID,Topic.TopicContent,Topic.HaveContent,Topic.MoreContent From TTRelationship inner join Topic on TTRelationship.TopicID=Topic.TopicID where TTRelationship.TestID=" + testid;
DataSet TDs = new DataSet();
using (MySqlConnection Sc = new MySqlConnection(Diya.ConectionString))
{
Sc.Open(); MySqlDataAdapter Da = new MySqlDataAdapter(SelectCmd, Sc);
Da.Fill(TDs);
Sc.Close();
}
int testcount;
using (MySqlDataReader read = new Diya().RowReader("Select TestCount from TestInfo where TestID=" + testid))
{
read.Read();
testcount = read.GetInt32(0);
read.Close();
}
QuizCount = testcount;
DataTable Tdt = TDs.Tables[0];
for (int i = 0; i < testcount; i++)
{
string Topic = UpdateEnter(Tdt.Rows[i]["TopicContent"].ToString());
if (TDs.Tables[0].Rows[i]["HaveContent"].ToString() == "1")
{
Topic += UpdateEnter("\n" + Tdt.Rows[i]["MoreContent"].ToString());
}
DataSet ODs = new DataSet();
using (MySqlConnection Sc = new MySqlConnection(Diya.ConectionString))
{
Sc.Open(); MySqlDataAdapter da = new MySqlDataAdapter("Select Options.OptionID,Options.OptionContent,Options.IsTrue From Options inner join OTRelationship on OTRelationship.OptionID=Options.OptionID Where OTRelationship.TTRelationshipID=" + Tdt.Rows[i]["RelationshipID"].ToString(), Sc);
da.Fill(ODs);
Sc.Close();
}
DataTable Odt = ODs.Tables[0];
HtmlText = "<tr class=\"item_Quiz\"> <td style=\"text-align:left\"><label>" + (i + 1) + " ." + Topic + "</label></td></tr>";
int j = 0;
foreach (DataRow dr in Odt.Rows)
{
HtmlText += "<tr style=\"height:2%\"><td> </td></tr>";
string div = "<div class=\"item_Options\" title=\"\" id=\"" + dr["OptionID"] + "n\" >";
using (MySqlDataReader read = new Diya().RowReader("select * From HTRelationship where SelectedOptionID=" + dr["OptionID"] + " and TSRelationshipID=" + TSRelationshipID))
{
if (read.Read())
{
div = "<div style=\"border:2px solid red\">";
}
}
string input = "<input type=\"checkbox\" runat=\"server\" id=\"" + dr["OptionID"] + "\" onserverchange=\"test_ServerChange\" disabled=\"disabled\" style=\"border:1px solid Black\"/>";
if (dr["IsTrue"].ToString() == "1")
{
input = " <input type=\"checkbox\" id=\"" + dr["OptionID"] + "\" checked=\"checked\" disabled=\"disabled\" style=\"border:1px solid Black\"/>";
}
HtmlText += "<tr><td>" + div + input + Convert.ToChar(65 + j) + " ." + UpdateEnter(dr["OptionContent"].ToString()) + "</div></td></tr>";
if (j == Odt.Rows.Count - 1)
{
HtmlText += "<tr style=\"height:5%\"><td> </td></tr>";
}
j++;
}
Dst.Addstate(HtmlText);
}
}