private void Visualiser_Click(object sender, EventArgs e) { Fiche_Bien fb = new Fiche_Bien(); fb.Show(this); this.Hide(); }
private void Button_Annuler_MouseClick(object sender, MouseEventArgs e) { textBox1.Text = ApplicationState.id_bien; Fiche_Bien fb = new Fiche_Bien(); fb.Show(this); this.Hide(); }
private void Visualiser_Click(object sender, EventArgs e) { ApplicationState.id_bien = id_bien_selectionne; Fiche_Bien fb = new Fiche_Bien(); fb.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(); DateTime a = dateTimePicker1.Value; string statuts = " "; if (Disponible.Checked == true) { statuts = "D"; Sous_Sein.Checked = false; Retire.Checked = false; Vendu.Checked = false; } else if (Sous_Sein.Checked == true) { statuts = "S"; Disponible.Checked = false; Vendu.Checked = false; Retire.Checked = false; } else if (Vendu.Checked == true) { statuts = "V"; Disponible.Checked = false; Sous_Sein.Checked = false; Retire.Checked = false; } else if (Retire.Checked == true) { statuts = "R"; Disponible.Checked = false; Sous_Sein.Checked = false; Vendu.Checked = false; } string garage = " "; string cave = " "; if (Garage.Checked == true) { garage = "true"; } if (Cave.Checked == true) { cave = "true"; } string sql = "UPDATE Bien SET Surface_habitable ='" + textBox2.Text + "', Surface_parcelle ='" + textBox3.Text + "' ,Nb_piéces ='" + numericUpDown1.Value + "', Nb_chambres ='" + numericUpDown2.Value + "' , Nb_Salle_de_bain ='" + numericUpDown3.Value + "' , Garage ='" + garage + "' , Cave ='" + cave + "' , Prix_vendeur ='" + textBox4.Text + "' ,Adresse ='" + textBox12.Text + "', Date_Mise_en_Vente = '" + dateTimePicker1.Value + "' ,Commentaire = '" + textBox9.Text.Replace("'", "''") + "',Statut = '" + statuts + "' , code_ville = (select code_ville from ville where upper(nom_ville) = '" + textBox11.Text + "' and Code_Postal = '" + textBox10.Text + "') WHERE Code_bien = '" + textBox1.Text + "' "; OleDbCommand cmd = new OleDbCommand(sql, dbConnection); cmd.ExecuteNonQuery(); MessageBox.Show("Saved"); textBox1.Text = ApplicationState.id_bien; Fiche_Bien fb = new Fiche_Bien(); fb.Show(this); this.Hide(); }