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

public partial class reg : System.Web.UI.Page
{
    static string connection = "Data Source=PC-201109290903;Initial Catalog=#Home#Malihome@2011;Integrated Security=True";
    private SqlConnection sqlConnection1 = new SqlConnection(connection);
    private SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();
    private DataSet dataSet11 = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        //諾帳號文本框內為空
        if (username.Text == "")
        {
            LabelMessage.Text = "<script language='Jscript'>" + "alert('您必須輸入帳號！');</script>";
        }
        else
        {
            string number = this.username.Text;
            SqlCommand myCommand = this.sqlConnection1.CreateCommand();
            myCommand.CommandText = "select * from HTX_Member where username='" + number + "'";
            this.sqlDataAdapter1.SelectCommand = myCommand;
            dataSet11.Clear();
            int n = this.sqlDataAdapter1.Fill(dataSet11, "HTX_Member");
            if (n != 0)
                LabelMessage.Text = "<script language='Jscript'>" + "alert('您輸入的帳戶號已經被占用，請重新輸入！');</script>";
            else
            {
                LabelMessage.Text = "";
                if (userpwd.Text != userpwd1.Text )
                    LabelMessage.Text = "<script language='Jscript'>" + "alert('密碼與重複密碼不一致，請重新輸入密碼和重複密碼！');</script>";
                else
                {
                    LabelMessage.Text = "";
                    if (useremail.Text != useremail1.Text)
                    LabelMessage.Text = "<script language='Jscript'>" + "alert('輸入的Email与電郵不一致，請重新輸入！');</script>";
                else
                {
                     LabelMessage.Text = "";
                }
                    try
                    {
                        myCommand.CommandText = "insert into HTX_Member(username,useremail,userpwd)" + "values(@username,@useremail,@userpwd)";
                        myCommand.Parameters.Add("@username", SqlDbType.NVarChar, 50, "username");
                        myCommand.Parameters.Add("@useremail", SqlDbType.NVarChar, 50, "useremail");
                        myCommand.Parameters.Add("@userpwd", SqlDbType.NVarChar, 50, "userpwd");
                        myCommand.Parameters["@username"].Value = username.Text;
                        myCommand.Parameters["@useremail"].Value = useremail.Text;
                        myCommand.Parameters["@userpwd"].Value = userpwd.Text;
                        sqlConnection1.Open();
                        myCommand.ExecuteNonQuery();
                        sqlConnection1.Close();
                        LabelMessage.Text = "您已經成功註冊！";
                    }
                    catch (Exception Exc)
                    {
                        LabelMessage.Text = Exc.Message;
                        sqlConnection1.Close();
                    }
               }

            }
        }
    }
}