private void LandingPageLogin_Click(object sender, EventArgs e) { //Redirect button to registrationpage Login.LoginForm LoginForm = new Login.LoginForm(); LoginForm.Tag = this; Hide(); LoginForm.Show(this); }
private void cancel_Click(object sender, EventArgs e) { Login.LoginForm form = new Login.LoginForm(); this.Hide(); form.Show(); }
private void button1_Click(object sender, EventArgs e) { if (!razonSocial.Text.Equals("") && !cuit.Text.Equals("") && !direccion.Text.Equals("") && !codigoPostal.Text.Equals("") && !email.Text.Equals("")) { if (!BDSQL.existeString(razonSocial.Text, "MERCADONEGRO.Empresas", "Razon_Social")) { if (!BDSQL.existeString(cuit.Text, "MERCADONEGRO.Empresas", "CUIT")) { if (Interfaz.esNumerico(telefono.Text, System.Globalization.NumberStyles.Integer) || telefono.Text.Equals("")) { if (!BDSQL.existeTelefono(Convert.ToInt32(telefono.Text))) { registrarEmpresa(username, password, razonSocial.Text, cuit.Text, telefono.Text, direccion.Text, codigoPostal.Text, ciudad.Text, email.Text, nombreContacto.Text, Interfaz.obtenerFecha()); MessageBox.Show("Alta finalizada. Puede ingresar al sistema.", "Registro exitoso"); Login.LoginForm form = new Login.LoginForm(); this.Hide(); form.Show(); } else { MessageBox.Show("Teléfono existente.", "Error"); } } else { MessageBox.Show("Teléfono inválido existente.", "Error"); } } else { MessageBox.Show("CUIT ya existente.", "Error"); } } else { MessageBox.Show("Razón Social ya existente.", "Error"); } } else { MessageBox.Show("Debe completar los campos solicitados.", "Error"); } }
private void button1_Click(object sender, EventArgs e) { if (cbTipoDocumento.SelectedIndex != -1 && !numeroDocumento.Text.Equals("") && !nombre.Text.Equals("") && !apellido.Text.Equals("") && !email.Text.Equals("") && !direccion.Text.Equals("") && !codigoPostal.Text.Equals("") && cbDia.SelectedIndex != -1 && cbMes.SelectedIndex != -1 && cbAno.SelectedIndex != -1) { if (Interfaz.esNumerico(numeroDocumento.Text, System.Globalization.NumberStyles.Integer)) { if (!BDSQL.existenSimultaneamente(numeroDocumento.Text, cbTipoDocumento.SelectedItem.ToString(), "MERCADONEGRO.Clientes", "Num_Doc", "Tipo_Doc")) { if (Interfaz.esNumerico(telefono.Text, System.Globalization.NumberStyles.Integer) || telefono.Text.Equals("")) { if (!BDSQL.existeTelefono(Convert.ToInt32(telefono.Text))) { registrarCliente(username, password, cbTipoDocumento.SelectedItem.ToString(), numeroDocumento.Text, nombre.Text, apellido.Text, email.Text, telefono.Text, direccion.Text, codigoPostal.Text, fechaNacimiento(cbDia.SelectedItem.ToString(), cbMes.SelectedItem.ToString(), cbAno.SelectedItem.ToString())); MessageBox.Show("Alta finalizada. Puede ingresar al sistema.", "Registro exitoso"); Login.LoginForm form = new Login.LoginForm(); this.Hide(); form.Show(); } else { MessageBox.Show("Teléfono existente.", "Error"); } } else { MessageBox.Show("Teléfono inválido.", "Error"); } } else { MessageBox.Show("Datos identificatorios (Tipo de documento, Número de documento) ya existentes.", "Error"); } } else { MessageBox.Show("Número de documento inválido.", "Error"); } } else { MessageBox.Show("Debe completar los campos solicitados.", "Error"); } }
private void RegisterButton_Click(object sender, EventArgs e) { string user = RegisterPageUsername.Text; string pass = RegisterPagePassword.Text; string n = RegisterPageName.Text; string dob = RegisterPageDoB.Value.ToString("yyyy-MM-dd"); string h = RegisterPageHeight.Text; string w = RegisterPageWeight.Text; decimal a = RegisterPageActivity.Value; string g = ""; while (true) { if (RegisterPageRadioButtonMale.Checked == true) { g = RegisterPageRadioButtonMale.Text; break; } else { g = RegisterPageRadioButtonFemale.Text; break; } } if (register.IsRegisterInfoInput(user, pass, dob, n, h, w)) { try { MySqlConnection conR = DietTracker.DatabaseConnect.OpenDefaultDBConnection(); //First it writes to the user table MySqlCommand registerCommand = new MySqlCommand(); registerCommand.CommandText = "INSERT INTO diettracker.users (Username, Name, Gender, DoB, Height, Weight, Activity)" + "VALUES ('" + user + "', '" + n + "', '" + g + "', '" + dob + "', '" + h + "', '" + w + "', '" + a + "');"; registerCommand.Connection = conR; conR.Open(); registerCommand.ExecuteNonQuery(); conR.Close(); //It then takes the ID from the user table to use it MySqlCommand idCommand = new MySqlCommand(); idCommand.CommandText = "SELECT ID FROM users WHERE Username = '******';"; idCommand.Connection = conR; conR.Open(); MySqlDataReader IDRead = idCommand.ExecuteReader(); IDRead.Read(); string UserID = IDRead.GetString(0); var ID = String.Format("{0}", UserID); UserID = ID; conR.Close(); //It inserts into the password table the password and the ID that corresponded to the user table MySqlCommand passwordCommand = new MySqlCommand(); passwordCommand.CommandText = "INSERT INTO diettracker.password (Password, ForeignID) " + "VALUES ('" + pass + "', '" + UserID + "');"; passwordCommand.Connection = conR; conR.Open(); passwordCommand.ExecuteNonQuery(); conR.Close(); var dateTimeToday = DateTime.Today.ToString("yyyy-MM-dd"); MySqlCommand dayCommand = new MySqlCommand(); dayCommand.CommandText = "INSERT INTO diettracker.day (Date, Weight, Calories, UserID)" + "VALUES ('" + dateTimeToday + "', '" + w + "', '0', '" + user + "');"; dayCommand.Connection = conR; conR.Open(); dayCommand.ExecuteNonQuery(); conR.Close(); MessageBox.Show("User Successfully created!"); Login.LoginForm loginForm = new Login.LoginForm(); loginForm.Tag = this; Hide(); loginForm.Show(this); } catch (MySqlException ex) { //MessageBox.Show("Something happened" + ex); switch (ex.Number) { case 0: MessageBox.Show("Cannot connect to server."); break; case 1062: MessageBox.Show("That Username is already in use"); break; case 1264: MessageBox.Show("You can't be higher than 255 cm (Come on, you're not that tall)"); break; } } catch (Exception) { MessageBox.Show("Something unexpected happened"); } } }