using System;
using System.Collections;
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.Configuration;

public partial class registration : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
        
    }

    protected void Submit_Click(object sender, EventArgs e)
    {
        
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            con.Open();
            string cmdstr = "Select count(*) from registration where UserName='" + TextBoxun.Text + "'";
            SqlCommand userExist = new SqlCommand(cmdstr, con);
            int temp = Convert.ToInt32(userExist.ExecuteScalar().ToString());
            
            if (temp == 1)
            {
                con.Close();
                Response.Write("UserName Alrady Exist<br/> Please Choose Another UserName");
                
            }
            else
            {
               
                string insCmd = "Insert into registration (UserName, Password, FullName, Email, Country) values (@UserName, @Password, @FullName, @Email, @Country)";
                SqlCommand insertuser = new SqlCommand(insCmd, con);
                insertuser.Parameters.AddWithValue("@UserName", TextBoxun.Text);
                insertuser.Parameters.AddWithValue("@Password", TextBoxp.Text);
                insertuser.Parameters.AddWithValue("@FullName", TextBoxfn.Text);
                insertuser.Parameters.AddWithValue("@Email", TextBoxea.Text);
                insertuser.Parameters.AddWithValue("@Country", DropDownListc.SelectedItem.ToString());
                insertuser.ExecuteNonQuery();

                string cmdstr3 = "Select id from registration where Username='" + TextBoxun.Text + "'";
                SqlCommand take = new SqlCommand(cmdstr3, con);
                int temp1 = take.ExecuteScalar().GetHashCode();
               string conv = Convert.ToString(temp1);

               string insCmd2 = "Insert into text1 (UserName, UserNum) values (@UserName, @UserNum)";
                SqlCommand insertxt2 = new SqlCommand(insCmd2, con);
                insertxt2.Parameters.AddWithValue("@UserName", TextBoxun.Text);
                insertxt2.Parameters.AddWithValue("@UserNum", conv);
                insertxt2.ExecuteNonQuery();   

                
                try
                {
                    con.Close();
                    Response.Redirect  ("login.aspx");
                }
                catch (Exception)
                {
                    
                    Response.Write("<b> something Really Bad Mappened .. Please try Again .</b>");
                }
                finally
                {
                    //any thing
                }
            }
        }
    }