?using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class BackDesk_ManageCard_AddUser : System.Web.UI.Page
{
    DataCon myCon = new DataCon();
    DataOperate sqlBind = new DataOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Name"] == null)
        {
            Response.Redirect("../../FrontDesk/Login/Login.aspx");
        }
        else
        {
            labUserName.Text = Session["Name"].ToString() + "！";
        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        string sqltest = "select * from tb_User where UserID='" + this.txtUserID.Text + "'";
        SqlConnection sqlconn = myCon.getCon();
        sqlconn.Open();
        SqlCommand sqlcom = new SqlCommand(sqltest, sqlconn);
        SqlDataReader read = sqlcom.ExecuteReader();
        read.Read();
        if (read.HasRows)
        {
            if (this.txtUserID.Text.Trim() == read["UserID"].ToString().Trim())
            {
                Response.Write("<script language='javascript'>alert('該用戶ID已經注冊過');localtion='UserRegister.aspx'</script>");
                return;
            }
        }
        string sqlstr = "insert into tb_User "
            + "(UserID,UserLoginName,UserSex,UserPwd,UserName,"
            + "UserQuePwd,UserAnsPwd,UserTel,UserEmail,UserAddress,UserPostCode,UserQQ)"
            + "values('"+txtUserID.Text+"','" + txtLoginName.Text + "','" + ddlSex.Text
            + "','" + txtPwd.Text + "','" + txtTName.Text + "','" + txtQuePwd.Text
            + "','" + txtAnsPwd.Text + "','" + txtTel.Text + "','" + txtEmail.Text
            + "','" + txtAddress.Text + "','" + txtPostCode.Text + "','" + txtQQ.Text + "')";
        sqlBind.DataCom(sqlstr);
    }
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        txtUserID.Text = "";
        txtLoginName.Text = "";
        txtPwd.Text = "";
        txtSecPwd.Text = "";
        txtTName.Text = "";
        txtQuePwd.Text = "";
        txtAnsPwd.Text = "";
        txtTel.Text = "";
        txtEmail.Text = "";
        txtAddress.Text="";
        txtPostCode.Text="";
        txtQQ.Text="";
        txtUserID.Focus();
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("../../FrontDesk/Login/AdminLogined.aspx");
    }
    protected void btnTest_Click(object sender, EventArgs e)
    {
        string sqlstr = "select * from tb_User where UserID='" + this.txtUserID.Text + "'";
        SqlConnection sqlconn = myCon.getCon();
        sqlconn.Open();
        SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
        SqlDataReader read = sqlcom.ExecuteReader();
        read.Read();
        if (read.HasRows)
        {
            if (this.txtUserID.Text.Trim() == read["UserID"].ToString().Trim())
            {
                Response.Write("<script language='javascript'>alert('該用戶ID已經注冊過');localtion='UserRegister.aspx'</script>");
                return;
            }
        }
        else
        {
            Response.Write("<script language='javascript'>alert('您可以進行正常注冊');localtion='UserRegister.aspx'</script>");
        }
        read.Close();
        sqlconn.Close();
    }
}