private void button1_Click(object sender, EventArgs e)
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM APPORDER WHERE idOrder = {textBox1.Text}");
MessageBox.Show("Se ha eliminado la orden con exito.");
}
private void button1_Click(object sender, EventArgs e)
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM ADDRESS WHERE idAddress = {Convert.ToInt32(textBox1.Text)}");
MessageBox.Show("Se ha eliminado al producto con exito");
}
private void button1_Click(object sender, EventArgs e)
{
try
{
String user = "", password = "", confirm = "";
var tab = ConnectionDB.ExecuteQuery($"SELECT username FROM APPUSER where username = '******'");
foreach (DataRow dr in tab.Rows)
{
user = dr[0].ToString();
}
if (user.Equals(""))
{
MessageBox.Show("El usuario no existe");
}
else
{
var tab2 = ConnectionDB.ExecuteQuery($"SELECT password FROM APPUSER where username = '******'");
foreach (DataRow dr in tab2.Rows)
{
password = dr[0].ToString();
}
if (password.Equals(textBox2.Text))
{
var tab3 = ConnectionDB.ExecuteQuery(
$"SELECT userType FROM APPUSER where username = '******'");
foreach (DataRow dr in tab3.Rows)
{
confirm = dr[0].ToString();
}
if (confirm.Equals("True"))
{
label1.Visible = false;
label3.Visible = false;
textBox1.Visible = false;
textBox2.Visible = false;
button1.Visible = false;
button2.Visible = false;
current = new Admin();
tableLayoutPanel1.Controls.Add(current, 0, 0);
tableLayoutPanel1.SetColumnSpan(current, 2);
tableLayoutPanel1.SetRowSpan(current, 4);
}
else
{
label1.Visible = false;
label3.Visible = false;
textBox1.Visible = false;
textBox2.Visible = false;
button1.Visible = false;
button2.Visible = false;
current = new Normal();
tableLayoutPanel1.Controls.Add(current, 0, 0);
tableLayoutPanel1.SetColumnSpan(current, 2);
tableLayoutPanel1.SetRowSpan(current, 4);
}
}
else
{
throw new WrongPasswordException("Contraseña equivocada");
}
}
}
catch (WrongPasswordException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void button1_Click(object sender, EventArgs e)
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM PRODUCT WHERE name = '{textBox1.Text}'");
MessageBox.Show("Se ha eliminado al producto con exito");
}
private void button1_Click(object sender, EventArgs e)
{
ConnectionDB.ExecuteNonQuery($"UPDATE ADDRESS SET address = '{textBox2.Text}'" +
$"WHERE idAddress = {Convert.ToInt32(textBox1.Text)}");
MessageBox.Show("Se ha modificado la dirección con exito");
}
