public TypeBiereDal GetOne(int id)
{
TypeBiereDal b = new TypeBiereDal();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "Select * from TypeBiere where typeBiereId=@id";
command.Parameters.AddWithValue("id", id);
con.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
b.typeBiereId = (int)dataReader["typeBiereId"];
b.typeBiereDefinition = (string)dataReader["typeBiereDefinition"];
b.typeBiereNom = (string)dataReader["typeBiereNom"];
}
}
}
}
return(b);
}
public List <TypeBiereDal> GetAll()
{
List <TypeBiereDal> lb = new List <TypeBiereDal>();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "Select * from TypeBiere";
con.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
TypeBiereDal b = new TypeBiereDal();
b.typeBiereId = (int)dataReader["typeBiereId"];
b.typeBiereDefinition = (string)dataReader["typeBiereDefinition"];
b.typeBiereNom = (string)dataReader["typeBiereNom"];
lb.Add(b);
}
}
}
}
return(lb);
}
public static TypeBiereDal GetTypeBiereDal(this TypeBiereWPF wpf)
{
TypeBiereDal dal = new TypeBiereDal();
dal.typeBiereDefinition = wpf.typeBiereDefinition;
dal.typeBiereId = wpf.typeBiereId;
dal.typeBiereNom = wpf.typeBiereNom;
return(dal);
}
public static TypeBiereWPF GetTypeBiereWPF(this TypeBiereDal dal)
{
TypeBiereWPF wpf = new TypeBiereWPF();
wpf.typeBiereDefinition = dal.typeBiereDefinition;
wpf.typeBiereId = dal.typeBiereId;
wpf.typeBiereNom = dal.typeBiereNom;
return(wpf);
}
public void Update(TypeBiereDal parametre)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "EditTypeBiere";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue(nameof(parametre.typeBiereId), parametre.typeBiereId);
command.Parameters.AddWithValue(nameof(parametre.typeBiereNom), parametre.typeBiereNom);
command.Parameters.AddWithValue(nameof(parametre.typeBiereDefinition), parametre.typeBiereDefinition);
con.Open();
command.ExecuteNonQuery();
}
}
}
public int Create(TypeBiereDal parametre)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "AddTypeBiereBis";
SqlParameter pid = new SqlParameter();
pid.ParameterName = "ID";
pid.Value = 0;
pid.Direction = System.Data.ParameterDirection.Output;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue(nameof(parametre.typeBiereNom), parametre.typeBiereNom);
command.Parameters.AddWithValue(nameof(parametre.typeBiereDefinition), parametre.typeBiereDefinition);
command.Parameters.Add(pid);
con.Open();
command.ExecuteNonQuery();
int id = (int)command.Parameters["ID"].Value;
return(id);
}
}
}
