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"); } }