public EmploiDal GetOne(int id)
{
EmploiDal b = new EmploiDal();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "Select * from OffreEmploi where offreEmploiId=@id";
command.Parameters.AddWithValue("id", id);
con.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
b.offreEmploiId = (int)dataReader["offreEmploiId"];
b.brasserieId = (int?)dataReader["brasserieId"];
b.jobDescription = (string)dataReader["jobDescription"];
b.fonction = (string)dataReader["fonction"];
b.diplomeMin = (string)dataReader["diplomeMin"];
b.experienceMin = (int)dataReader["experienceMin"];
}
}
}
}
return(b);
}
public List <EmploiDal> GetAll()
{
List <EmploiDal> lb = new List <EmploiDal>();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "Select * from OffreEmploi";
con.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
EmploiDal b = new EmploiDal();
b.offreEmploiId = (int)dataReader["offreEmploiId"];
b.brasserieId = (int?)dataReader["brasserieId"];
b.jobDescription = (string)dataReader["jobDescription"];
b.fonction = (string)dataReader["fonction"];
b.diplomeMin = (string)dataReader["diplomeMin"];
b.experienceMin = (int)dataReader["experienceMin"];
lb.Add(b);
}
}
}
}
return(lb);
}
public int Create(EmploiDal parametre)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "AddOffreEmploiBis";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pid = new SqlParameter();
pid.ParameterName = "ID";
pid.Value = 0;
pid.Direction = System.Data.ParameterDirection.Output;
command.Parameters.AddWithValue(nameof(parametre.fonction), parametre.fonction);
command.Parameters.AddWithValue(nameof(parametre.jobDescription), parametre.jobDescription);
command.Parameters.AddWithValue(nameof(parametre.diplomeMin), parametre.diplomeMin);
command.Parameters.AddWithValue(nameof(parametre.experienceMin), parametre.experienceMin);
command.Parameters.Add(pid);
con.Open();
command.ExecuteNonQuery();
int id = (int)command.Parameters["ID"].Value;
return(id);
}
}
}
public static EmploiDal GetEmploiDal(this EmploiWPF wpf)
{
EmploiDal dal = new EmploiDal();
dal.brasserieId = wpf.brasserieId;
dal.diplomeMin = wpf.diplomeMin;
dal.experienceMin = wpf.experienceMin;
dal.fonction = wpf.fonction;
dal.jobDescription = wpf.jobDescription;
dal.offreEmploiId = wpf.offreEmploiId;
return(dal);
}
public static EmploiWPF GetEmploiWPF(this EmploiDal dal)
{
EmploiWPF wpf = new EmploiWPF();
wpf.brasserieId = dal.brasserieId;
wpf.diplomeMin = dal.diplomeMin;
wpf.experienceMin = dal.experienceMin;
wpf.fonction = dal.fonction;
wpf.jobDescription = dal.jobDescription;
wpf.offreEmploiId = dal.offreEmploiId;
return(wpf);
}
public void Update(EmploiDal parametre)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "EditOffreEmploi";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue(nameof(parametre.offreEmploiId), parametre.offreEmploiId);
command.Parameters.AddWithValue(nameof(parametre.fonction), parametre.fonction);
command.Parameters.AddWithValue(nameof(parametre.jobDescription), parametre.jobDescription);
command.Parameters.AddWithValue(nameof(parametre.diplomeMin), parametre.diplomeMin);
command.Parameters.AddWithValue(nameof(parametre.experienceMin), parametre.experienceMin);
con.Open();
command.ExecuteNonQuery();
}
}
}
