public List <OffreEmploiDal> GetAll()
{
List <OffreEmploiDal> la = new List <OffreEmploiDal>();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "select * from VueOffreEmploi";
con.Open();
using (SqlDataReader read = command.ExecuteReader())
{
while (read.Read())
{
OffreEmploiDal a = new OffreEmploiDal();
a.offreEmploiId = (int)read["offreEmploiId"];
a.fonction = (string)read["fonction"];
a.jobDescription = (string)read["jobDescription"];
a.diplomeMin = (string)read["diplomeMin"];
//a.clientPwd = (string)read["biereImage"];
//a.brasserieId = (int)read["brasserieId"];
a.nomBrasserie = (string)read["nomBrasserie"];
a.experienceMin = (int)read["experienceMin"];
a.mailRecrutement = (string)read["mailRecrutement"];
la.Add(a);
}
}
}
}
return(la);
}
public OffreEmploiDal GetOne(int id)
{
OffreEmploiDal a = new OffreEmploiDal();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "select * from VueOffreEmploi where offreEmploiId=@id";
command.Parameters.AddWithValue("id", id);
con.Open();
using (SqlDataReader read = command.ExecuteReader())
{
while (read.Read())
{
a.offreEmploiId = (int)read["offreEmploiId"];
a.fonction = (string)read["fonction"];
a.jobDescription = (string)read["jobDescription"];
a.diplomeMin = (string)read["diplomeMin"];
//a.clientPwd = (string)read["biereImage"];
//a.brasserieId = (int)read["brasserieId"];
a.nomBrasserie = (string)read["nomBrasserie"];
a.experienceMin = (int)read["experienceMin"];
a.mailRecrutement = (string)read["mailRecrutement"];
}
}
}
}
return(a);
}
public static OffreEmploiDal GetEmploiDal(this OffreEmploiAPI offreEmploiAPI)
{
OffreEmploiDal offreEmploiDal = new OffreEmploiDal();
offreEmploiDal.diplomeMin = offreEmploiAPI.diplomeMin;
offreEmploiDal.experienceMin = offreEmploiAPI.experienceMin;
offreEmploiDal.fonction = offreEmploiAPI.fonction;
offreEmploiDal.jobDescription = offreEmploiAPI.jobDescription;
offreEmploiDal.mailRecrutement = offreEmploiAPI.mailRecrutement;
offreEmploiDal.nomBrasserie = offreEmploiAPI.nomBrasserie;
offreEmploiDal.offreEmploiId = offreEmploiAPI.offreEmploiId;
return(offreEmploiDal);
}
