private void btnregister_Click(object sender, EventArgs e)
{
var connection = DatabaseConnection.CreateConnection();
var Int = (txtInt.Text == "Int") ? 0 : Int32.Parse(txtInt.Text);
var Ext = (txtExt.Text == "Ext") ? 0 : Int32.Parse(txtExt.Text);
String query = String.Format("Insert into Users(name,password,phone,suburb,postal_code,street," +
"ext_number,int_number) values('{0}','{1}','{2}','{3}','{4}','{5}',{6},{7})",
txtusr.Text, CreateMD5.Hash(txtpass.Text), txtmail.Text, cmbBoxAlc.Text,
txtcp.Text, txtcalle.Text, Int, Ext);
var check = String.Format("Select * from Users where name='{0}' " +
"and password='******'", txtusr.Text, CreateMD5.Hash(txtpass.Text));
if (DatabaseConnection.ReadResult(connection, check) == "")
{
if (!DatabaseConnection.ExecuteCommand(connection, query))
{
errorlbl("Algo salió mal. Vuelve a intentar");
}
else
{
MessageBox.Show("Te has registrado con éxito", "Registro exitoso",
MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
else
{
errorlbl("Usuario existente");
}
}
private static bool InsertUsers()
{
var aux1 = "INSERT INTO Users (name, password, phone, suburb, "
+ "postal_code, street, ext_number) "
+ $"VALUES ('Admin', '{CreateMD5.Hash("hola123.,")}', '5555555555', 'C.U.', "
+ "'04330', 'Investigación Cientifica', 10)";
var aux2 = "INSERT INTO Users (name, password, phone, suburb, "
+ "postal_code, street, ext_number, int_number) "
+ $"VALUES ('Test', '{CreateMD5.Hash("123456")}', '5000000000', 'Zacatenco', "
+ "'25250', 'Queso', 10, 5)";
var connection = DatabaseConnection.CreateConnection();
return(DatabaseConnection.ExecuteCommand(connection, aux1) &&
DatabaseConnection.ExecuteCommand(connection, aux2));
}
private void Login()
{
var connection = DatabaseConnection.CreateConnection();
var loginQuery = $"SELECT id FROM Users WHERE name = '{this.txtusr.Text}' AND password = '******'";
var reader = DatabaseConnection.GetResultReader(connection, loginQuery);
if (reader.Read())
{
this.Hide();
var id = reader[0].ToString();
reader.Close();
//MessageBox.Show(id);
Form1 ventana = new Form1(id);
ventana.ShowDialog();
this.Close();
}
else
{
errorlbl("Usuario o contraseña no validos");
}
}
