private void button_Annuler_MouseClick(object sender, MouseEventArgs e) { Liste_des_propositions ldp = new Liste_des_propositions(); ldp.Show(this); this.Hide(); }
private void ListePropositions_Click(object sender, EventArgs e) { ApplicationState.id_acheteur = textBox6.Text; Liste_des_propositions ldp = new Liste_des_propositions(); ldp.Show(this); }
private void Supprimer_Click(object sender, EventArgs e) { ApplicationState.id_visite = listView2.SelectedItems[0].SubItems[0].Text; //string nomBase = "IMMOBILLY_JACKYTEAM"; string ChaineBd = "Provider=SQLOLEDB;Data Source=INFO-joyeux;Initial Catalog=IMMOBILLY_JACKYTEAM;Persist Security Info=True; Integrated Security=sspi;"; OleDbConnection dbConnection = new OleDbConnection(ChaineBd); dbConnection.Open(); string sql = "DELETE FROM Visite where code_Visite = '" + ApplicationState.id_visite + "' "; OleDbCommand cmd = new OleDbCommand(sql, dbConnection); cmd.ExecuteNonQuery(); MessageBox.Show("Supprime"); Liste_des_propositions ldp = new Liste_des_propositions(); ldp.Show(this); this.Hide(); }
private void button_Valider_MouseClick(object sender, MouseEventArgs e) { //string nomBase = "IMMOBILLY_JACKYTEAM"; string ChaineBd = "Provider=SQLOLEDB;Data Source=INFO-joyeux;Initial Catalog=IMMOBILLY_JACKYTEAM;Persist Security Info=True; Integrated Security=sspi;"; OleDbConnection dbConnection = new OleDbConnection(ChaineBd); dbConnection.Open(); string sql2 = "Insert into Visite ( Code_Proposition,Date)"; string sql3 = "values('" + ApplicationState.id_proposition + "', '" + dateTimePicker2.Value + "' ) "; string sql4 = sql2 + sql3; OleDbCommand cmd2 = new OleDbCommand(sql4, dbConnection); cmd2.ExecuteNonQuery(); MessageBox.Show("Saved"); Liste_des_propositions ldp = new Liste_des_propositions(); ldp.Show(this); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { Liste_des_propositions ldp = new Liste_des_propositions(); ldp.Show(this); }