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