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;

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

        DataSet ds = new DataSet();
        string sql = "";

        if (Request.Form.Count > 0)
        {
            sql = "SELECT * FROM members where email='" + Request.Form["email"] + "'";

            ds = DBHelper.GetDataSet(sql);
            if (ds.Tables[0].Rows.Count > 0)
            {
                Response.Write("User Exists");

            }
            else
            {
                string fname, lname, gender, tel, email, yearBorn, username, password;
                fname = Request.Form["fname"];
                lname = Request.Form["lname"];
                gender = Request.Form["gender"].ToString();
                tel = Request.Form["Select1"] + "-" + Request.Form["tel"];
                email = Request.Form["email"];


                yearBorn = Request.Form["yearBorn"];

                username = Request.Form["username"];
                password = Request.Form["password"];

                string strSql = "Insert into members (fname,lname,gender, tel,email, yearborn, username, password)";
                strSql += " values ('" + fname + "','" + lname + "','" + gender + "','" + tel + "','" + email + "'," + yearBorn + ",'" + username + "','" + password + "')";
                DBHelper.InsertUpdateDelete(strSql);

            }
        }






    }
}