using System; using System.Collections; using System.Configuration; using System.Collections.Generic; using System.Drawing; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.Web.UI.DataVisualization.Charting; public partial class SystemQue : System.Web.UI.Page { DropDownList gr = new DropDownList(); TextBox t = new TextBox(); basic b = new basic(); protected void Page_Load(object sender, EventArgs e) { string proj = Request.QueryString["pr_Id"]; b.FullDataReader("select Member_Id, Project_Id, Member_Type from Members_Projects Where Member_Id=" + int.Parse(Session["Member_Id"].ToString()) + " AND Project_Id=" + int.Parse(Session["projectId"].ToString())); if (b.SqlReader.Read()) { if (b.SqlReader["Member_Type"].ToString() == "2" || b.SqlReader["Member_Type"].ToString() == "3") { Control c1 = this.Master.FindControl("member"); HtmlControl h1 = (HtmlControl)c1; h1.Visible = false; //****************** Control c2 = this.Master.FindControl("group"); HtmlControl h2 = (HtmlControl)c2; h2.Visible = false; //****************** Control c3 = this.Master.FindControl("plan"); HtmlControl h3 = (HtmlControl)c3; h3.Visible = false; //****************** Control c4 = this.Master.FindControl("pageProj"); HtmlControl h4 = (HtmlControl)c4; h4.Visible = false; } if (b.SqlReader["Member_Type"].ToString() == "3") { Control c5 = this.Master.FindControl("task"); HtmlControl h5 = (HtmlControl)c5; h5.Visible = false; //****************** Control c6 = this.Master.FindControl("sub"); HtmlControl h6 = (HtmlControl)c6; h6.Visible = false; //****************** Control c7 = this.Master.FindControl("sys"); HtmlControl h7 = (HtmlControl)c7; h7.Visible = false; //****************** SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["Connectionstring2"].ConnectionString; conn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); cmd.Connection = conn; cmd.CommandText = "select * from Questions where User_Code='" + Request.QueryString["user"] + "' order by Q_Id"; ad.Fill(ds); if ((Int32)cmd.ExecuteScalar() == 0) { Button1.Visible = false; } gr.DataTextField = "Q_Text"; gr.DataValueField = "Q_Id"; gr.DataSource = ds; gr.DataBind(); SqlDataReader rd = default(SqlDataReader); for (int m = 0; m <= gr.Items.Count - 1; m++) { Panel mypanel = new Panel(); RadioButtonList Ra = new RadioButtonList(); Ra.ID = "R" + gr.Items[m].Text; BulletedList Bl = new BulletedList(); Bl.ID = "B" + gr.Items[m].Text; ds.Clear(); cmd.Connection = conn; cmd.CommandText = "select * from Questions where Q_Id like'" + gr.Items[m].Value + "' "; ad.Fill(ds); rd = cmd.ExecuteReader(); rd.Read(); if (rd.HasRows) { int kind_q = int.Parse(rd["Q_Kind"].ToString()); Bl.DataTextField = "Q_Text"; Bl.DataValueField = "Q_Id"; Bl.DataSource = ds; Bl.DataBind(); rd.Close(); ds.Clear(); cmd.Connection = conn; cmd.CommandText = "select * from Ansers where User_Code='" + Request.QueryString["user"] + "'and Q_Id ='" + gr.Items[m].Value + "' and Anser2='0' "; ad.Fill(ds); Ra.DataTextField = "Anser1"; Ra.DataValueField = "Ans_Id"; Ra.DataSource = ds; Ra.DataBind(); mypanel.ID = "p" + gr.Items[m].Text; mypanel.BorderWidth = 1; mypanel.Controls.Add(Bl); mypanel.Controls.Add(Ra); if (kind_q == 1) { t.ID = "T" + gr.Items[m].Text; t.TextMode = TextBoxMode.MultiLine; t.Width = 400; t.Height = 90; mypanel.Controls.Add(t); } Panel1.Controls.Add(mypanel); } rd.Close(); } conn.Close(); } b.SqlReader.Close(); b.SqlConnection.Close(); } ////////////////////////////////////////// { if (!IsPostBack) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["Connectionstring2"].ConnectionString; conn.Open(); SqlCommand cmd = new SqlCommand(); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); cmd.Connection = conn; cmd.CommandText = "select * from Questions where Project_Id='" + proj + "' order by Q_Id"; ad.Fill(ds); DropDownList gr = new DropDownList(); gr.DataTextField = "Q_Text"; gr.DataValueField = "Q_Id"; gr.DataSource = ds; gr.DataBind(); SqlDataReader rd = default(SqlDataReader); //========================================================= for (int m = 0; m <= gr.Items.Count - 1; m++) { Panel mypanel = new Panel(); RadioButtonList Ra = new RadioButtonList(); Ra.ID = "R" + gr.Items[m].Text; BulletedList Bl = new BulletedList(); Bl.ID = "B" + gr.Items[m].Text; ds.Clear(); cmd.Connection = conn; cmd.CommandText = "select * from Questions where Q_Id like'" + gr.Items[m].Value + "' "; ad.Fill(ds); rd = cmd.ExecuteReader(); rd.Read(); if (rd.HasRows) { int kind_q = int.Parse(rd["Q_Kind"].ToString()); Bl.DataTextField = "Q_Text"; Bl.DataValueField = "Q_Id"; Bl.Font.Size = 15; Bl.ForeColor = System.Drawing.Color.Red; Bl.Font.Bold = true; Bl.DataSource = ds; Bl.DataBind(); rd.Close(); ds.Clear(); cmd.Connection = conn; cmd.CommandText = "select * from Ansers where Project_Id='" + proj + "'and Q_Id ='" + gr.Items[m].Value + "' and Anser2='0' "; ad.Fill(ds); Ra.DataTextField = "Anser1"; Ra.DataValueField = "Ans_Id"; Ra.DataSource = ds; Ra.DataBind(); //-------------------------------------------- Chart chart1 = new Chart(); ChartArea ChartArea1 = new ChartArea(); chart1 = new Chart(); ChartArea1.Name = "ChartArea1"; chart1.ChartAreas.Clear(); chart1.ChartAreas.Add(ChartArea1); chart1.Series.Clear(); chart1.Series.Add("Series1" + gr.Items[m].Text); chart1.DataSource = ds; chart1.Series["Series1" + gr.Items[m].Text].ChartType = SeriesChartType.Column; chart1.Series["Series1" + gr.Items[m].Text]["DrawingStyle"] = "Emboss"; chart1.Series["Series1" + gr.Items[m].Text].XValueMember = "Anser1"; chart1.Series["Series1" + gr.Items[m].Text].YValueMembers = "nes"; chart1.Series["Series1" + gr.Items[m].Text].IsValueShownAsLabel = true; chart1.Series["Series1" + gr.Items[m].Text].LabelBackColor = System.Drawing.Color.Silver; chart1.Series["Series1" + gr.Items[m].Text].LabelForeColor = System.Drawing.Color.Red; chart1.DataBind(); //-------------------------------------------- mypanel.ID = "p" + gr.Items[m].Text; mypanel.BorderWidth = 1; mypanel.Controls.Add(Bl); if (kind_q == 1) { rd.Close(); ds.Clear(); cmd.Connection =conn ; cmd.CommandText = "select * from Ansers where Project_Id='" + proj + "'and Q_Id ='" + gr.Items[m].Value + "' "; ad.Fill(ds); Ra.DataTextField = "Anser2"; Ra.DataValueField = "Ans_Id"; Ra.DataSource = ds; Ra.DataBind(); for (int ba = 0; ba <= Ra.Items.Count - 1; ba++) { Panel panelAReeJ = new Panel(); Label t = new Label(); t.ID = Ra.Items[ba].Text; t.Text = " * " + Ra.Items[ba].Text + " "; t.BorderWidth = 1; panelAReeJ.Height = 50; panelAReeJ.Controls.Add(t); mypanel.Controls.Add(panelAReeJ); } } else { mypanel.Controls.Add(chart1); Label Ncont = new Label(); ds.Clear(); cmd.Connection = conn; cmd.CommandText = "select * from Ansers where Project_Id='" + proj + "'and Q_Id ='" + gr.Items[m].Value + "' "; ad.Fill(ds); DropDownList xx = new DropDownList(); xx.DataTextField = "nes"; xx.DataValueField = "Ans_Id"; xx.DataSource = ds; xx.DataBind(); int c = 0; for (int x = 0; x <= xx.Items.Count - 1; x++) { c = c + int.Parse(xx.Items[x].Text); } Ncont.Text = " عدد الأصوات : " + c; mypanel.Controls.Add(Ncont); } Panel1.Controls.Add(mypanel); } rd.Close(); } //================================================================================================ conn.Close(); } } } protected void Menu1_MenuItemClick(object sender, MenuEventArgs e) { MultiView1.ActiveViewIndex = int.Parse(e.Item.Value); } protected void Button2_Click(object sender, EventArgs e) { if (RadioButton1.Checked) { save_Questions(); info.Text = "تم اضافة السؤال بنجاح"; Button3.Visible = true; Panel2.Visible = false; } else { if (RadioButton2.Checked) { save_Questions(); save_Anser(); info.Text = "تم اضافة السؤال بنجاح"; Button3.Visible = true; Panel2.Visible = false; } } } public void save_Questions() { string proj = Request.QueryString["pr_Id"]; int kind = 0; if (RadioButton1.Checked) { kind = 1; } else { if (RadioButton2.Checked) { kind = 2; } } string[] data={Questions1.Text,proj,kind.ToString()}; b.insertRow("Questions", data, 3); //SqlConnection conn = new SqlConnection(); //conn.ConnectionString = ConfigurationManager.ConnectionStrings["Connectionstring2"].ConnectionString; //conn.Open(); //SqlCommand cmd = new SqlCommand(); //cmd.Connection = conn; //cmd.CommandText = "INSERT INTO Questions (Q_Text,User_Code,Q_Kind) VALUES('?','?','?')"; //cmd.Parameters.Clear(); //cmd.Parameters.AddWithValue("Q_Text", Questions1.Text); //cmd.Parameters.AddWithValue("User_Code", userCode); //cmd.Parameters.AddWithValue("Q_Kind", kind); //cmd.ExecuteNonQuery(); //conn.Close(); } public void save_Anser() { string proj = Request.QueryString["pr_Id"]; SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["Connectionstring2"].ConnectionString; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "select Q_Id from Questions where Project_Id='" + proj + "' order by Q_Id DESC "; SqlDataReader rd = default(SqlDataReader); rd = cmd.ExecuteReader(); rd.Read(); int id_q = 0; if (rd.HasRows) { rd.Close(); id_q = (Int32)cmd.ExecuteScalar(); } else { id_q = 1; } rd.Close(); cmd.Connection = conn; for (int i = 1; i <= int.Parse(NuAns.SelectedItem.Value.ToString()); i++) { string ans = "Anser" + i.ToString(); string aaaaa = (this.FindControl("Anser1") as TextBox).Text; // string aaaaa = ((TextBox)this.FindControl("Anser1")).Text; string id_ = id_q.ToString(); string pro = proj.ToString(); // string[] data = {ans1.Text,"0",id_q.ToString(),proj.ToString()}; // b.insertRow("Ansers",data,4); //cmd.CommandText = "INSERT INTO Ansers (Anser1,Anser2,Q_Id,Project_Id) VALUES(@Anser1,@Anser2,@Q_Id,@Project_Id)"; //cmd.Parameters.Clear(); //cmd.Parameters.AddWithValue("Anser1", ans1); //cmd.Parameters.AddWithValue("Anser2", "0"); //cmd.Parameters.AddWithValue("Q_Id", id_q); //cmd.Parameters.AddWithValue("Project_Id", proj); //cmd.ExecuteNonQuery(); } conn.Close(); } protected void RadioButton2_CheckedChanged(object sender, EventArgs e) { num_anser.Visible = true; NuAns.Visible = true; Anser1.Visible = true; Anser2.Visible = true; NuAns.SelectedItem.Value = "2"; } protected void RadioButton1_CheckedChanged(object sender, EventArgs e) { num_anser.Visible = false; NuAns.Visible = false; Anser1.Visible = false; Anser2.Visible = false; Anser3.Visible = false; Anser4.Visible = false; Anser5.Visible = false; } protected void NuAns_SelectedIndexChanged(object sender, EventArgs e) { Anser1.Visible = false; Anser2.Visible = false; Anser3.Visible = false; Anser4.Visible = false; Anser5.Visible = false; if (NuAns.SelectedItem.Text == "2") { Anser1.Visible = true; Anser2.Visible = true; } else { if (NuAns.SelectedItem.Text == "3") { Anser1.Visible = true; Anser2.Visible = true; Anser3.Visible = true; } else { if (NuAns.SelectedItem.Text == "4") { Anser1.Visible = true; Anser2.Visible = true; Anser3.Visible = true; Anser4.Visible = true; } else { if (NuAns.SelectedItem.Text == "5") { Anser1.Visible = true; Anser2.Visible = true; Anser3.Visible = true; Anser4.Visible = true; Anser5.Visible = true; } } } } } protected void Button3_Click(object sender, EventArgs e) { Response.Redirect("SystemQue.aspx"); } protected void Button1_Click(object sender, EventArgs e) { string proj = Request.QueryString["pr_Id"]; { SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["Connectionstring2"].ConnectionString; SqlCommand cmd = new SqlCommand(); SqlDataReader rd = default(SqlDataReader); conn.Open(); for (int m = 0; m <= gr.Items.Count - 1; m++) { BulletedList Bl = (BulletedList)Page.FindControl("B" + gr.Items[m].Text); for (int B = 0; B <= Bl.Items.Count - 1; B++) { cmd.Connection = conn; cmd.CommandText = "select * from Questions where Q_Id like '" + gr.Items[m].Value + "' "; rd = cmd.ExecuteReader(); rd.Read(); if (rd.HasRows) { int kind_q = int.Parse(rd["Q_Kind"].ToString()); rd.Close(); if (kind_q == 1) { cmd.CommandText = "INSERT INTO Ansers (Anser2,Q_Id,Project_Id) VALUES('?','?','?')"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("Anser2", ((TextBox)Page.FindControl("T" + gr.Items[m].Text)).Text); cmd.Parameters.AddWithValue("Q_Id", gr.Items[m].Value); cmd.Parameters.AddWithValue("Project_Id", proj); cmd.ExecuteNonQuery(); } else { RadioButtonList ra = (RadioButtonList)Page.FindControl("R" + gr.Items[m].Text); for (int R = 0; R <= ra.Items.Count - 1; R++) { rd.Close(); if (ra.Items[R].Selected == true) { int g = 0; cmd.Connection =conn; cmd.CommandText = "select * from Ansers where Ans_Id like '" + ra.Items[R].Value + "' "; rd = cmd.ExecuteReader(); rd.Read(); if (rd.HasRows) { g = int.Parse(rd["nes"].ToString()) + 1; } rd.Close(); cmd.CommandText = "update Ansers set nes=? where Ans_Id like '" + ra.Items[R].Value + "'"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("nes", g); cmd.ExecuteNonQuery(); } } } } } } conn.Close(); Panel1.Visible = false; info.Text = "تم ارسال الاستبيان" + "
" + "شكرا لك على التصويت"; Button1.Visible = false; } } }