public void insert()
{
if (Request.QueryString["id"] != null)
{
Session["qid"] = Request.QueryString["id"].ToString();
}
DBC check = new DBC();
check.ExcecuteQuery("Select * from Chart where Qid='" + Session["qid"] + "'");
DBC q = new DBC();
q.ExcecuteQuery("select * from Questions where id='" + Session["qid"] + "'");
if (check.DT.Rows.Count == 0)
{
double score = getADW(q.DT.Rows[0]["Question"].ToString(), txtPost.Value);
double animal = getADW(q.DT.Rows[0]["Question"].ToString() + " " + txtPost.Value, "Animal#n Wild#n");
double nature = getADW(q.DT.Rows[0]["Question"].ToString() + " " + txtPost.Value, "Nature#n");
double food = getADW(q.DT.Rows[0]["Question"].ToString() + " " + txtPost.Value, "Food#n");
if (animal > nature && animal > food)
{
check.ExcecuteNonQuery("insert into Chart values('','" + animal + "','','" + score + "','" + Session["qid"] + "')");
}
else if (nature > animal && nature > food)
{
check.ExcecuteNonQuery("insert into Chart values('" + nature + "','','','" + score + "','" + Session["qid"] + "')");
}
else
{
check.ExcecuteNonQuery("insert into Chart values('','','" + food + "','" + score + "','" + Session["qid"] + "')");
}
}
}
public void getPosts(int id)
{
DBC getPost = new DBC();
getPost.ExcecuteQuery("Select * from Posts where Qid='" + id + "'");
Posts.Reset();
Posts = getPost.DT;
}
public void login(object sender, EventArgs e)
{
check.ExcecuteQuery("Select * from UserTable where Pass='******'");
if (check.DT.Rows.Count > 0)
{
Session["usr"] = check.DT.Rows[0]["UserID"].ToString();
Response.Redirect("Home.aspx");
}
else
{
}
}
public int getQId()
{
int newId;
DBC getid = new DBC();
getid.ExcecuteQuery("Select max(id) from Questions");
if (getid.DT.Rows.Count > 0 && getid.DT.Rows[0][0].ToString() != "")
{
newId = Convert.ToInt32(getid.DT.Rows[0][0].ToString()) + 1;
return(newId);
}
return(00);
}
public bool check(string pp)
{
string data = Encrypt(pp);
query.ExcecuteQuery("Select * from UserTable where Pass='******'");
if (query.DT.Rows.Count > 0)
{
return(false);
}
else
{
return(true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
chkLogin();
if (!loggedin)
{
Response.Redirect("Home.aspx");
}
Question = new DataTable();
Post = new DataTable();
if (Request.QueryString["id"] != null)
{
Session["qid"] = Request.QueryString["id"].ToString();
}
user = new DBC();
user.ExcecuteQuery("Select * from UserTable where UserID='" + Session["usr"] + "'");
if (user.DT.Rows.Count > 0)
{
userId = Session["usr"].ToString();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Login to access')", true);
Response.Redirect("Login.aspx");
}
if (Session["qid"] != null)
{
posts = new DBC();
qstn = new DBC();
if (Request.QueryString["id"] != null)
{
Session["qid"] = Request.QueryString["id"].ToString();
}
qstn.ExcecuteQuery("Select * from Questions where id='" + Session["qid"] + "'");
Question = qstn.DT;
posts.ExcecuteQuery("Select * from posts where Qid='" + Session["qid"] + "'");
Post = posts.DT;
}
else
{
Response.Redirect("Home.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DBC chart = new DBC();
Random random = new Random();
chart.ExcecuteQuery("select * from Chart t1 inner join Questions t2 on t1.Qid=t2.id");
Chart1.Series[0].ChartType = SeriesChartType.Bubble;
Chart1.Series[0].MarkerStyle = MarkerStyle.Circle;
Chart1.Series[1].ChartType = SeriesChartType.Bubble;
Chart1.Series[1].MarkerStyle = MarkerStyle.Circle;
Chart1.Series[2].ChartType = SeriesChartType.Bubble;
Chart1.Series[2].MarkerStyle = MarkerStyle.Circle;
Chart1.DataSource = chart.DT;
Chart1.Series[0].XValueMember = "nature";
Chart1.Series[0].YValueMembers = "size";
Chart1.Series[1].XValueMember = "food";
Chart1.Series[1].YValueMembers = "size";
Chart1.Series[2].XValueMember = "animal";
Chart1.Series[2].YValueMembers = "size";
Chart1.DataBind();
int i = 0;
foreach (DataPoint d in Chart1.Series[0].Points)
{
d.ToolTip = chart.DT.Rows[i]["Question"].ToString();
i++;
}
int j = 0;
foreach (DataPoint d in Chart1.Series[1].Points)
{
d.ToolTip = chart.DT.Rows[i]["Question"].ToString();
j++;
}
int k = 0;
foreach (DataPoint d in Chart1.Series[1].Points)
{
d.ToolTip = chart.DT.Rows[i]["Question"].ToString();
k++;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Questions = new DataTable();
if (!IsPostBack)
{
chkLogin();
if (loggedin)
{
user.ExcecuteQuery("select * from UserTable where UserID='" + Session["usr"] + "'");
}
DBC load = new DBC();
load.ExcecuteQuery("Select * from Questions");
Questions = load.DT;
DBC chart = new DBC();
Random random = new Random();
chart.ExcecuteQuery("select * from Chart t1 inner join Questions t2 on t1.Qid=t2.id");
Chart1.Series[0].ChartType = SeriesChartType.Bubble;
Chart1.Series[0].MarkerStyle = MarkerStyle.Circle;
Chart1.Series[1].ChartType = SeriesChartType.Bubble;
Chart1.Series[1].MarkerStyle = MarkerStyle.Circle;
Chart1.Series[2].ChartType = SeriesChartType.Bubble;
Chart1.Series[2].MarkerStyle = MarkerStyle.Circle;
Chart1.ChartAreas[0].AxisX.MinorGrid.Enabled = false;
Chart1.ChartAreas[0].AxisX.MajorTickMark.Enabled = false;
Chart1.ChartAreas[0].AxisX.MinorTickMark.Enabled = false;
Chart1.ChartAreas[0].AxisX.Interval = 0;
Chart1.ChartAreas[0].AxisX.LabelStyle.ForeColor = Color.White;
Chart1.ChartAreas[0].AxisY.LabelStyle.Enabled = false;
Chart1.ChartAreas[0].AxisY.MajorTickMark.Enabled = false;
Chart1.ChartAreas[0].AxisY.MinorTickMark.Enabled = false;
Chart1.ChartAreas[0].AxisX.LineWidth = 0;
Chart1.ChartAreas[0].AxisY.LineWidth = 0;
Chart1.DataSource = chart.DT;
Chart1.Series[0].XValueMember = "nature";
Chart1.Series[0].YValueMembers = "size";
Chart1.Series[1].XValueMember = "food";
Chart1.Series[1].YValueMembers = "size";
Chart1.Series[2].XValueMember = "animal";
Chart1.Series[2].YValueMembers = "size";
Chart1.DataBind();
int i = 0;
foreach (DataPoint d in Chart1.Series[0].Points)
{
d.ToolTip = chart.DT.Rows[i]["Question"].ToString();
i++;
}
int j = 0;
foreach (DataPoint d in Chart1.Series[1].Points)
{
d.ToolTip = chart.DT.Rows[j]["Question"].ToString();
j++;
}
int k = 0;
foreach (DataPoint d in Chart1.Series[2].Points)
{
d.ToolTip = chart.DT.Rows[k]["Question"].ToString();
k++;
}
}
Posts = new DataTable();
}
