public static void ExecuteQuery(string query)
{
MySqlCommand mySqlCommand = new MySqlCommand(query, DBConfig.Connection);
try
{
//MySqlDataReader reader = mySqlCommand.ExecuteReader();
mySqlCommand.ExecuteNonQuery();
DBConfig.CloseConnection();
Console.WriteLine("Query has been successfully executed.");
}
catch (Exception ex)
{
DBConfig.CloseConnection();
Console.WriteLine("ERROR: " + ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(txtFirstName.Text) &&
!String.IsNullOrEmpty(txtLastName.Text) &&
!String.IsNullOrEmpty(txtEmail.Text) &&
!String.IsNullOrEmpty(txtEmailReenter.Text) &&
!String.IsNullOrEmpty(txtPassword.Text))
{
if (txtEmail.Text == txtEmailReenter.Text)
{
Application["FirstName"] = txtFirstName.Text;
Application["LastName"] = txtLastName.Text;
Application["Email"] = txtEmail.Text;
Application["Password"] = txtPassword.Text;
DBConfig.InsertUser(txtFirstName.Text, txtLastName.Text, txtEmail.Text, txtPassword.Text);
Response.Redirect("Result.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DBConfig.Init();
}
