Source code for New user in CCFD - 1

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

  

public partial class pgNewUser : System.Web.UI.Page

{

    DataAccess data = new DataAccess();

    protected void Page_Load(object sender, EventArgs e)

    {

        txtCardNo.Focus();

    }

    protected void btnAvail_Click(object sender, EventArgs e)

    {

        data.DBReaderOpen("select * from Login where UName='" + txtLogin.Text + "'");

        if (data.dr.HasRows)

        {

            lblAvail.Text = "UserName Not Available";

            lblAvail.Visible = true;

            txtLogin.Focus();

        }

        else

        {

            lblAvail.Text = "UserName Available";

            lblAvail.Visible = true;

            txtPass.Focus();

        }

    }

   

    protected void txtCardNo_TextChanged(object sender, EventArgs e)

    {

        data.DBReaderOpen("select * from userinfo where cardNo='" + txtCardNo.Text + "'");

        if (data.dr.HasRows)

        {

            lblError.Text = "Sorry The Card Number Already Exisit";

            lblError.Visible = true;

            txtCardNo.Focus();

            rblTerms.Enabled = false;

        }

        else

        {

            lblError.Visible = false;

            rblTerms.Enabled = true;

            txtFName.Focus();

        }

       

    }

  

   

    protected void btnCancel_Click(object sender, EventArgs e)

    {

    }   

protected void  btnSub_Click(object sender, EventArgs e)

{

    if (Convert.ToInt32( rblTerms.SelectedItem.Value) == 1)

    {

        int uid = 0;

        data.DBReaderOpen("select max(Uid)from userinfo");

        if (data.dr.HasRows)

        {

            data.dr.Read();

            string ss = data.dr[0].ToString();

            if (ss == "")

            {

                uid = 101;

            }

            else

            {

                uid = Convert.ToInt32(ss.ToString()) + 1;

            }

        }

        data.DBOpen();

        data.cmd = new SqlCommand("userInfo_SP", data.cn);

        data.cmd.CommandType = CommandType.StoredProcedure;

        data.cmd.Parameters.Add(new SqlParameter("@mode", 1));

        data.cmd.Parameters.Add(new SqlParameter("@FirstName", txtFName.Text));

        data.cmd.Parameters.Add(new SqlParameter("@LastName", txtLName.Text));

        data.cmd.Parameters.Add(new SqlParameter("@Uid", uid));

        data.cmd.Parameters.Add(new SqlParameter("@UName", txtLogin.Text));

        data.cmd.Parameters.Add(new SqlParameter("@pwd", txtPass.Text));

        data.cmd.Parameters.Add(new SqlParameter("@Email", txtEmail.Text));

        data.cmd.Parameters.Add(new SqlParameter("@DOB", Convert.ToDateTime(txtDate.Text)));

        data.cmd.Parameters.Add(new SqlParameter("@Gender", ddlGender.SelectedItem.ToString()));

        data.cmd.Parameters.Add(new SqlParameter("@address1", txtAdd1.Text));

        data.cmd.Parameters.Add(new SqlParameter("@address2", txtAdd2.Text));

        data.cmd.Parameters.Add(new SqlParameter("@city ", txtCity.Text));

        data.cmd.Parameters.Add(new SqlParameter("@state", txtState.Text));

        data.cmd.Parameters.Add(new SqlParameter("@country", txtCountry.Text));

        data.cmd.Parameters.Add(new SqlParameter("@pincode", Convert.ToInt32(txtPin.Text)));

        data.cmd.Parameters.Add(new SqlParameter("@phone", Convert.ToInt32(txtPhone.Text)));

        data.cmd.Parameters.Add(new SqlParameter("@CardNo", txtCardNo.Text));

        try

        {

            data.cmd.ExecuteNonQuery();

        }

        catch (Exception ex)

        {

        }

        data.DBCmdClose();

        Session["Uid"] = uid;

        Response.Redirect("pgSecurity.aspx");

    }

    else

    {

        lblError.Text = "You Must Accept the Terms and Conditions";

        lblError.Visible = true;

    }

}