public BrasserieDal Get()
{
BrasserieDal brasserie = new BrasserieDal();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "Select * from Brasserie";
con.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
brasserie.brasserieId = (int)reader["brasserieId"];
brasserie.brasseriePresentation = (string)reader["brasseriePresentation"];
brasserie.mailInfon = (string)reader["mailInfon"];
brasserie.mailRecrutement = (string)reader["mailRecrutement"];
brasserie.nomBrasserie = (string)reader["nomBrasserie"];
}
}
}
}
return(brasserie);
}
public static BrasserieDal GetBrasserieDal(this BrasserieWPF wpf)
{
BrasserieDal dal = new BrasserieDal();
dal.brasserieId = wpf.brasserieId;
dal.brasseriePresentation = wpf.brasseriePresentation;
dal.mailInfon = wpf.mailInfon;
dal.mailRecrutement = wpf.mailRecrutement;
dal.nomBrasserie = wpf.nomBrasserie;
return(dal);
}
public static BrasserieWPF GetBrasserieWPF(this BrasserieDal dal)
{
BrasserieWPF wpf = new BrasserieWPF();
wpf.brasserieId = dal.brasserieId;
wpf.brasseriePresentation = dal.brasseriePresentation;
wpf.mailInfon = dal.mailInfon;
wpf.mailRecrutement = dal.mailRecrutement;
wpf.nomBrasserie = dal.nomBrasserie;
return(wpf);
}
public void Update(BrasserieDal parametre)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "EditBrasserie";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue(nameof(parametre.brasserieId), parametre.brasserieId);
command.Parameters.AddWithValue(nameof(parametre.brasseriePresentation), parametre.brasseriePresentation);
command.Parameters.AddWithValue("mailIfon", parametre.mailInfon);
command.Parameters.AddWithValue(nameof(parametre.mailRecrutement), parametre.mailRecrutement);
command.Parameters.AddWithValue(nameof(parametre.nomBrasserie), parametre.nomBrasserie);
con.Open();
command.ExecuteNonQuery();
}
}
}
