using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Web;
	using System.Web.UI;
	using System.Web.UI.WebControls;
	using System.Web.UI.WebControls.WebParts;
	using Microsoft.SharePoint;
	using System.Drawing;
	using System.Data.SqlClient;
	using System.Data;
	using Microsoft.SharePoint.WebControls;
	
	namespace vote_poll
	{
	   public class vote : WebPart
	   {
	       public Label label = new Label();
	       public RadioButtonList radiolist = new RadioButtonList();
	       public Button button = new Button();
	       public Button button1 = new Button();
	       SqlConnection conn = new SqlConnection("Data Source=INBLRPIOJNJ2;Initial Catalog=master;User id=sa;Password=password@123");
	       protected override void OnInit(EventArgs e)
	       {
	           base.OnInit(e);
	           label.Text = "Who is your favourite cricketer";
	           label.ForeColor = System.Drawing.Color.Chocolate;
	           label.Font.Size = FontUnit.XLarge;
	           label.Font.Bold = true;
	           Controls.Add(label);
	           radiolist.Items.Add(new ListItem("Sachin"));
	           radiolist.Items.Add(new ListItem("Dravid"));
	           radiolist.Items.Add(new ListItem("Dhoni"));
	           Controls.Add(radiolist);
	           button.Click += new EventHandler(button_Click);
	           button.Text = "Vote";
	           button.ForeColor = Color.White;
	           button.Font.Bold = true;
	           button.BackColor = Color.FromArgb(79, 129, 189);
	           button.BorderColor = Color.FromArgb(56, 93, 138);
	           button.CausesValidation = true;
	           Controls.Add(button);
	           button1.Click += new EventHandler(button1_Click);
	           button1.Text = "Reset";
	           button1.ForeColor = Color.White;
	           button1.Font.Bold = true;
	           button1.BackColor = Color.FromArgb(79, 129, 189);
	           button1.BorderColor = Color.FromArgb(56, 93, 138);
	           Controls.Add(button1);
	       }
	       void button1_Click(object sender, EventArgs e)
	       {
	           radiolist.ClearSelection();
	       }
	       void button_Click(object sender, EventArgs e)
	       {
	           SPWeb theSite = SPControl.GetContextWeb(Context);
	           SPUser theUser = theSite.CurrentUser;
	           string strUserName = theUser.LoginName;
	           conn.Open();
	           SqlCommand cmd = new SqlCommand("insert into radio values("+radiolist.SelectedIndex+",'"+strUserName+"')",conn);
	           cmd.ExecuteNonQuery();
	           conn.Close();
	           radiolist.ClearSelection();
	       }
	       protected override void OnLoad(EventArgs e)
	       {
	           base.OnLoad(e);
	       }
	       protected override void CreateChildControls()
	       {
	           base.CreateChildControls();
	       }
	       protected override void Render(HtmlTextWriter writer)
	       {
	           EnsureChildControls();
	           string y="";
	           SPWeb theSite = SPControl.GetContextWeb(Context);
	           SPUser theUser = theSite.CurrentUser;
	           string strUserName = theUser.LoginName;
	           conn.Open();
	           SqlCommand cmd = new SqlCommand("select count(*) from radio where username='" + strUserName + "'",conn);
	           SqlCommand cmdd = new SqlCommand("select indexx from radio where username='" + strUserName + "'", conn);
	           SqlCommand sachin = new SqlCommand("select count(indexx) from radio where indexx=0",conn);
	           SqlCommand dravid = new SqlCommand("select count(indexx) from radio where indexx=1",conn);
	           SqlCommand dhoni = new SqlCommand("select count(indexx) from radio where indexx=2",conn);
	           int check =Convert.ToInt16(cmd.ExecuteScalar());
	           int x=Convert.ToInt16(cmdd.ExecuteScalar());
	           int sa=Convert.ToInt16(sachin.ExecuteScalar());
	           int dr = Convert.ToInt16(dravid.ExecuteScalar());
	           int dh = Convert.ToInt16(dhoni.ExecuteScalar());
	           if(x==0)
	               y="Sachin";
	           if (x == 1)
	               y = "Dravid";
	           if (x == 2)
	               y = "Dhoni";
	           if (check==1)
	           {
	               writer.Write("You Have voted to "+y+"");
	               writer.Write("<br/>");
	               writer.Write("Thanks for voting.....");
	               writer.Write("<br/>");
	               writer.Write("Sachin votes:"+sa+"");
	               writer.Write("<br/>");
	               writer.Write("Dravid votes:"+dr+"");
	               writer.Write("<br/>");
	               writer.Write("Dhoni votes:"+dh+"");
	           }
	           else
	           {
	               label.RenderControl(writer);
	               radiolist.RenderControl(writer);
	               button.RenderControl(writer);
	               button1.RenderControl(writer);
	           }
	       }
	   }
	}