using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Web.Services;
using System.Data;



public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
    }
    protected void txtName_TextChanged(object sender, EventArgs e)
    {
        
    }
    protected void Send_Click(object sender, EventArgs e)
    {
        //Connect connection = new Connect("/App_Data/Database.accdb");
        // string queryString = "INSERT users.[userName], users.[password], users.[email] FROM users";
        ////queryString+= string.format("{0}')" 
        //OleDbCommand command = new OleDbCommand(queryString);
        // connection.TakeAction(command);



        string name = txtName.Text;
        string pass = txtPassword.Text;
        string email = txtEmail.Text;
        string address = txtAddress.Text;

        Error1.Text = "You did not fill the following registration fields: ";

        bool finalcheck = true;
        if (name == "")
        {
            Error1.Visible = true;
            Error1.Text = Error1.Text + " Name.";
            finalcheck = false;
        }
        if (pass == "")
        {
            Error1.Visible = true;
            Error1.Text = Error1.Text + " Password.";
            finalcheck = false;
        } if (email == "")
        {
            Error1.Visible = true;
            Error1.Text = Error1.Text + " Email.";
            finalcheck = false;
        } if (address == "")
        {
            Error1.Visible = true;
            Error1.Text = Error1.Text + " Address.";
            finalcheck = false;
        }
        localhost.WebService w = new localhost.WebService();
        string check = "SELECT * FROM users WHERE userName = '" + name + "'";
        DataTable dt = w.GetConn(check);
        string check1 = "SELECT * FROM users WHERE email = '" + email + "'";
        DataTable dt1 = w.GetConn(check1);
        if (dt.Rows.Count > 0)
        {
            Error2.Text = "This username already exists, please choose a different one";
            finalcheck = false;
        }
        else
        {
            Error2.Text = "";
        }
        if (dt1.Rows.Count > 0)
        {
            Error3.Text = "This email already exists, please use a different one";
            finalcheck = false;
        }
        else
        {
            Error3.Text = "";
        }
        if (finalcheck == true)
        {
            Error1.Visible = false;
            string salt = w.RandomString();
            string hash = w.getHashSha256(salt + pass);

            w.Insert(name, hash, email, address, salt);
            Error3.Text = "You have successfully registered!";
        }
    }
}