public Entities.Etablissement SelectById(int id)
{
DataTable dt = new DataTable();
Entities.Etablissement Etab = new Entities.Etablissement();
try
{
Program.Connection.Open();
string StrSQL = "Select * from Etablissement where IdEtablissement=" + id + "";
SqlDataAdapter da = new SqlDataAdapter(StrSQL, Program.Connection);
da.Fill(dt);
Etab.IdEtablissement = int.Parse(dt.Rows[0][0].ToString());
Etab.NomEtablissement = dt.Rows[0][1].ToString();
Etab.Pays = dt.Rows[0][2].ToString();
Etab.Ville = dt.Rows[0][3].ToString();
Program.Connection.Close();
return(Etab);
}
catch (Exception e)
{
Program.Connection.Close();
MessageBox.Show(e.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return(Etab);
}
public void InsertEtablissement(Entities.Etablissement Etab)
{
string StrSQL = "INSERT INTO Etablissement (NomEtablissement, Pays, Ville) VALUES(@NomEtablissement, @Pays, @Ville)";
SqlCommand cmd = new SqlCommand(StrSQL, Program.Connection);
cmd.Parameters.Add("@NomEtablissement", SqlDbType.NVarChar).Value = Etab.NomEtablissement;
cmd.Parameters.Add("@Pays", SqlDbType.NVarChar).Value = Etab.Pays;
cmd.Parameters.Add("@Ville", SqlDbType.NVarChar).Value = Etab.Ville;
try
{
Program.Connection.Open();
cmd.ExecuteNonQuery();
Program.Connection.Close();
}
catch (Exception e)
{
Program.Connection.Close();
MessageBox.Show(e.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void UpdateEtablissement(int id, Entities.Etablissement Etab)
{
string StrSQL = "update Etablissement set NomEtablissement=@NomEtablissement, Pays=@Pays, Ville=@Ville where IdEtablissement=@IdEtablissement";
SqlCommand cmd = new SqlCommand(StrSQL, Program.Connection);
cmd.Parameters.Add("@NomEtablissement", SqlDbType.NVarChar).Value = Etab.NomEtablissement;
cmd.Parameters.Add("@Pays", SqlDbType.NVarChar).Value = Etab.Pays;
cmd.Parameters.Add("@Ville", SqlDbType.NVarChar).Value = Etab.Ville;
cmd.Parameters.Add("@IdEtablissement", SqlDbType.Int).Value = id;
try
{
Program.Connection.Open();
cmd.ExecuteNonQuery();
Program.Connection.Close();
}
catch (Exception e)
{
Program.Connection.Close();
MessageBox.Show(e.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
