protected void Singup(object sender, EventArgs e)
{
//Storing Info
string[] address = new string[10];
//Personal info
address[0] = (string)Fname.Text;
address[1] = (string)Lname.Text;
address[2] = (string)phone.Text;
//Address info
address[3] = (string)addressNumber.Text;
address[4] = (string)addressStreet.Text;
address[5] = (string)city.Text;
address[6] = (string)state.Text;
address[7] = (string)uname.Text;
address[8] = (string)passwd.Text;
address[9] = (string)TextBox1.Text;
//Getting the Address together in the form the database wants
string fullAddress = address[3] + ", " + address[4] + ", " + address[5] + ", " + ", " + address[6];
loginDataSetTableAdapters.customerTableAdapter singup = new loginDataSetTableAdapters.customerTableAdapter();
////Using the DataSet with the sing up method
singup.registerUser(address[0], address[1], fullAddress, address[2], address[7], address[8], address[9]);
Response.Redirect("/login.aspx");
#region Old way
/*
* string conString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " + Server.MapPath("~/ebookstoredb.mdb");
* using (OleDbConnection conn = new OleDbConnection(conString))
* {
* conn.Open();
*
* String query = "INSERT INTO customer ([Fname],[Lname],[Address],[Phone],[uname],[passwd],[email]) values(@first , @last , @address , @phone , @uname, @passwd, @email)";
* using (OleDbCommand cmd = new OleDbCommand(query, conn))
* {
* cmd.Parameters.AddWithValue("@first", address[0]);
* cmd.Parameters.AddWithValue("@last", address[1]);
* cmd.Parameters.AddWithValue("@address", fullAddress);
* cmd.Parameters.AddWithValue("@phone", address[2]);
* cmd.Parameters.AddWithValue("@uname", address[7]);
* cmd.Parameters.AddWithValue("@passwd", address[8]);
* cmd.Parameters.AddWithValue("@email", address[9]);
* cmd.ExecuteNonQuery();
* }
* conn.Close();
* Response.Write("<script> alert('Your sign up was Successful'); " +
* "window.location.assign('/default.aspx');" +
* "</script>");
* } */
#endregion
}
protected void LoginFunction(object sender, EventArgs e)
{
string uname = (string)username.Text;
string pwd = (string)passwd.Text;
//Using a dataSet for the login
loginDataSetTableAdapters.customerTableAdapter login = new loginDataSetTableAdapters.customerTableAdapter();
if (Convert.ToInt32(login.trylogin(uname, pwd)) > 0)
{
Session["ID"] = login.getUsersID(uname);
Response.Redirect("Default.aspx");
}
else
{
console.Text = "Please try again";
}
#region OldWay
/*
* string conString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " + Server.MapPath("~/ebookstoredb.mdb");
* using (OleDbConnection conn = new OleDbConnection(conString))
* {
* conn.Open();
*
* String query = "SELECT * FROM customer WHERE uname = @username AND passwd = @passwd";
* using (OleDbCommand cmd = new OleDbCommand(query, conn))
* {
* cmd.Parameters.AddWithValue("@username", uname);
* cmd.Parameters.AddWithValue("@passwd", passwd.Text);
* int? result = (int?)cmd.ExecuteScalar();
* if (result != null)
* {
* Session["username"] = uname;
* Response.Redirect("Default.aspx");
* }
* else
* {
* console.Text = "Please try again";
* }
* }
* conn.Close();*/
#endregion
}