private void DeltaCon_StateChange(object sender, StateChangeEventArgs e) { if (!bclosing && e.CurrentState != ConnectionState.Connecting && (e.CurrentState == ConnectionState.Closed || e.CurrentState == ConnectionState.Broken)) { DeltaCon.Open(); } }
private bool connecter() { string ConStr = ""; DeltaCon.Close(); DeltaConTmp1.Close(); deltaConTmp2.Close(); deltaConMod.Close(); ConStr = "SERVER=" + Inif.ReadString("BDD", "hostname") + "; Allow User Variables=True; DATABASE=" + baseInit + "; UID=" + Inif.ReadString("BDD", "user") + "; PASSWORD="******"BDD", "password") + "; PORT=" + Inif.ReadString("BDD", "port") + ";default command timeout=600;ConnectionTimeout=600"; DeltaCon.ConnectionString = DeltaConTmp1.ConnectionString = deltaConMod.ConnectionString = deltaConTmp2.ConnectionString = ConStr; //server=localhost;User Id=root;password=za;Persist Security Info=True;database=deltareal ConStr = "server=" + Inif.ReadString("BDD", "hostname") + "; DATABASE=" + baseInit + "; User ID=" + Inif.ReadString("BDD", "user") + "; PASSWORD="******"BDD", "password") + "; Persist Security Info=True" + ";default command timeout=600;ConnectionTimeout=600"; try { Cursor.Current = Cursors.WaitCursor; DeltaCon.Open(); DeltaConTmp1.Open(); deltaConTmp2.Open(); deltaConMod.Open(); DeltaSQLTmp.Connection = DeltaConTmp1; //DeltaSQLCon.Connection = DeltaConTmp1; Cursor.Current = Cursors.Default; this.ActiveControl = edUser; this.StatusLabel.Text = "Connection à la base réussie !"; Properties.Settings.Default["deltarealConnectionString"] = ConStr; return(true); } catch { //var result = MessageBox.Show(this, "Connexion échouée ! Veuillez vérifier les paramètres !", "Connexion action la Base de Données."); Util.AfficherErreur("Connexion à la base échouée ! Veuillez vérifier les paramètres !"); DeltaCon.Close(); DeltaConTmp1.Close(); deltaConTmp2.Close(); deltaConMod.Close(); return(false); //System.Windows.Forms.Application.Exit(); } }
private void button5_Click(object sender, EventArgs e) { //connecter(); DeltaSQLCon.CommandText = "SELECT nomprenom, username, password, initials, idcollaborateur FROM " + baseInit + ".Collaborateur WHERE username = '******' AND password = '******'"; MySqlDataReader myReader = DeltaSQLCon.ExecuteReader(); if (myReader.Read()) { //var result = MessageBox.Show(myReader.GetString(myReader.GetOrdinal("nomprenom")) + ". Vous êtes connecté !"); Menu1.Enabled = true; ToolBar1.Enabled = true; panel1.Enabled = true; panel3.Visible = false; this.StatusLabel.Text = "Accès réussi de : " + myReader.GetString(myReader.GetOrdinal("nomprenom")) + "!"; lUser = myReader.GetString(myReader.GetOrdinal("nomprenom")); InitUser = myReader.GetString(myReader.GetOrdinal("initials")); idUser = myReader.GetInt32(myReader.GetOrdinal("idcollaborateur")); } else { Util.AfficherErreur("Attention ! Login ou Mot de pass incorrect ! Veuillez rééssayer !"); edUser.Focus(); myReader.Close(); return; } myReader.Close(); szU = Inif.ReadString("BDD", "user"); szH = Inif.ReadString("BDD", "Hostname"); szP = Inif.ReadString("BDD", "password"); //if (cb_base.SelectedIndex > 0) //{ bclosing = true; DeltaCon.Close(); DeltaConTmp1.Close(); deltaConTmp2.Close(); deltaConMod.Close(); string ConStr = "SERVER=" + Inif.ReadString("BDD", "hostname") + "; Allow User Variables=True; DATABASE=" + basefact + "; UID=" + Inif.ReadString("BDD", "user") + "; PASSWORD="******"BDD", "password") + "; PORT=" + Inif.ReadString("BDD", "port") + ";default command timeout=600;ConnectionTimeout=600"; DeltaCon.ConnectionString = DeltaConTmp1.ConnectionString = deltaConMod.ConnectionString = deltaConTmp2.ConnectionString = ConStr; Properties.Settings.Default["deltarealConnectionString"] = ConStr; bclosing = false; DeltaCon.Open(); DeltaConTmp1.Open(); deltaConTmp2.Open(); deltaConMod.Open(); myReader.Close(); Util.RemplirCombo(cmbentreprisesource, "SELECT identreprise, if (entreprise.iddeltareal > 0, concat(clidelta.socligne1, ' ', clidelta.socligne2), concat(entreprise.socligne1, ' ', entreprise.socligne2)) as entreprise FROM fact_entreprise entreprise left join " + baseInit + ".client clidelta ON clidelta.idclient = entreprise.iddeltareal ORDER BY identreprise", DeltaSQLCon, mySqlDataAdapter1); if (cmbentreprisesource.Items.Count == 0) { Util.AfficherErreur("Il n'y a pas encore d'entreprise enregistré ! Veuillez vérifier."); bt_marchandises.Enabled = bt_debiteur.Enabled = bt_facture.Enabled = false; } else { for (int i = 0; i < cmbentreprisesource.Items.Count; i++) { cmbentreprise.Items.Add(cmbentreprisesource.GetItemText(cmbentreprisesource.Items[i])); } cmbentreprise.SelectedItem = cmbentreprise.Items[0]; } this.Text = "DeltaFact v.1.2" + " - Base : " + basefact + " - Entreprise : " + cmbentreprisesource.Text; }