protected void Register_User(string addr1, string addr2, string city, string region, string country, string postcode,
string username, string password, string email, string phoneno, string firstname, string lastname)
{
//STEP 1: Get Hash/Salt for password
Auth.AuthData authdata = Auth.StringToHashSalt(password);
//STEP 2: (Optional) Attempt to get coords for address
string coordsX = "0";
string coordsY = "0";
//STEP 3: Register!
try
{
DataSetTableAdapters.QueriesTableAdapter querytableadapter = new DataSetTableAdapters.QueriesTableAdapter();
querytableadapter.RegisterUser(addr1, addr2, city, region, country, postcode, coordsX, coordsY, true,
username, authdata.Hash, authdata.Salt, email, phoneno, firstname, lastname, true);
}
catch (Exception exc)
{
if (exc.Message.Contains("Cannot insert duplicate key in object 'dbo.Users'"))
{
Alert_Composer("alert-danger", "Could not register account!", "Username already exists. Try another one.");
}
return;
}
//STEP 4: Send a confirmation email
Common.Email.SendEmail(textBoxEmail.Text, "Thank you for joining QACinemas", String.Format("{0} {1}, {2} registered.", textBoxFirstN.Text, textBoxLastN.Text, textBoxUsername.Text));
Response.Redirect("/Login.aspx?alert=4&username=" + textBoxUsername.Text);
}
protected void GridView2_RowDeleting(Object sender, GridViewDeleteEventArgs e)
{
DataSet dataset = new DataSet();
DataSetTableAdapters.QueriesTableAdapter qta = new DataSetTableAdapters.QueriesTableAdapter();
GridView2.DeleteRow(e.RowIndex);
var time = (HiddenField)GridView2.Rows[e.RowIndex].FindControl("Time");
var date = (HiddenField)GridView2.Rows[e.RowIndex].FindControl("Session Date");
var name = (HiddenField)GridView2.Rows[e.RowIndex].FindControl("Name");
string delete_command = "DELETE FROM Booking WHERE SessionTime=" + time + " and SessionDate=" + date + "and name=" + name;
GridView2.DataBind();
//qta.deletebooking();
}
protected void bntAceptar_Click(object sender, EventArgs e)
{
try
{
DataSetTableAdapters.QueriesTableAdapter obj = new DataSetTableAdapters.QueriesTableAdapter();
String NombreUsuario = obj.Login(Convert.ToInt32(txtUser.Text), txtPass.Text).ToString();
if (!NombreUsuario.Equals(""))
{
Response.Redirect("Reportes.aspx");
}
}
catch
{
lblBien.Text = "No Hubo Suerte";
}
}
protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
{
DataSetTableAdapters.QueriesTableAdapter qta = new DataSetTableAdapters.QueriesTableAdapter();
GridView1.EditIndex = e.NewEditIndex;
DataTable dt = (DataTable)Session["TaskTable"];
GridViewRow row = GridView1.Rows[e.NewEditIndex];
dt.Rows[row.DataItemIndex]["Name"] = ((TextBox)(row.Cells[1].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["SessionDate"] = ((TextBox)(row.Cells[2].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Email"] = ((TextBox)(row.Cells[3].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Time"] = ((TextBox)(row.Cells[3].Controls[0])).Text;
dt.Rows[row.DataItemIndex]["Status"] = ((DropDownList)(row.Cells[3].Controls[0])).SelectedIndex;
GridView2.EditIndex = -1;
//Bind data to the GridView control.
GridView2.DataBind();
}
