using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.Security;

using System.Data;

using System.Data.SqlClient;



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

{

    protected void Page_Load(object sender, EventArgs e)

    {



    }

    protected void _btnDangKy_Click(object sender, EventArgs e)

    {

        string username = _txtTenDangNhap.Text.Trim();

        string password = FormsAuthentication.HashPasswordForStoringInConfigFile(_txtMatKhau.Text, "MD5");

        string email = _txtEmail.Text.Trim();



        // kiem tra username co trung khong ?

        String sql = "SELECT * FROM [NGUOIDUNG] WHERE TenDangNhap=@Username";

        SqlParameter[] _param = new[] { new SqlParameter("@Username", username) };

        DataTable dt_username = DataAccess.ExecuteQuery(sql, _param);



        if (dt_username.Rows.Count > 0)

        {

            Response.Write("<script>alert('Tŕi kho?n ?ă t?n t?i, hăy ch?n m?t tęn tŕi kho?n khác !')</script>");

            return;

        }



        //kiem tra email co trung khong ?



        String sql2 = "SELECT * FROM [NGUOIDUNG] WHERE Email=@Email";

        SqlParameter[] _param2 = new[] { new SqlParameter("@Email", email) };

        DataTable dt_email = DataAccess.ExecuteQuery(sql2, _param2);



        if (dt_email.Rows.Count > 0)

        {

            Response.Write("<script>alert('Email ?ă t?n t?i, hăy ch?n m?t ??a ch? email khác !')</script>");

            return;

        }



        // kiem tra dong y voi dieu khoan ?



        if (!_chkDieuKhoan.Checked)

        {

            Response.Write("<script>alert('B?n ph?i ??ng ý v?i các ?i?u kho?n s? d?ng d?ch v? ?? có th? ??ng ký !')</script>");

            return;

        }



        //kiem tra ma xac nhan va thuc hien luu thong tin vao database



        if (_txtCaptcha.Text.Trim().Equals(Session["strCaptcha"].ToString()))

        {

            string sql3 = @"INSERT INTO [NGUOIDUNG] (TenDangNhap, MatKhau, Ten, Email, GioiTinh, NgaySinh, ThanhPho, Nhom) 

                                        VALUES (@TenDangNhap, @MatKhau, @Ten, @Email, @GioiTinh, @NgaySinh, @ThanhPho, @Nhom)";

            SqlParameter[] _param3 = new [] { new SqlParameter("@TenDangNhap", username), 

                                        new SqlParameter("@MatKhau", password),

                                        new SqlParameter("@Ten", _txtHoTen.Text.Trim()),

                                        new SqlParameter("@Email", email),

                                        new SqlParameter("@GioiTinh", _ddlGioiTinh.SelectedValue),

                                        new SqlParameter("@NgaySinh", _datBirthday.Value), //testing 

                                        new SqlParameter("@ThanhPho", _txtThanhPho.Text.Trim()),

                                        new SqlParameter("@Nhom", 2) // tu dong them vao nhom 2 (Thanh Vien)

                                    };



            int kq = DataAccess.ExecuteNonQuery(sql3, _param3);

            if (kq > 0)

            {

                //_lblNotifier.Text = "Signup Success!";

                MultiView1.SetActiveView(View2); // thong bao dang ky thanh cong

                ClearText();

            }

            else Response.Write("<script>alert('?ă có l?i x?y ra khi thęm d? li?u, xin vui lňng th? l?i sau !')</script>");

        }

        else Response.Write("<script>alert('mă xác nh?n không ?úng !')</script>");

    }



    void ClearText()

    {

        _txtTenDangNhap.Text = "";

        _txtHoTen.Text = "";

        _txtEmail.Text = "";

        _txtThanhPho.Text = "";

    }

}