public static void Add(Postulant postulant)
{
SqlConnection sqlConnection = DataManager.Get();
try
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "Add",
CommandType = System.Data.CommandType.StoredProcedure,
Connection = sqlConnection
};
cmd.Parameters.Add(new SqlParameter("@id", postulant.Id));
cmd.Parameters.Add(new SqlParameter("@nom", postulant.Nom));
cmd.Parameters.Add(new SqlParameter("@Courriel", postulant.Courriel));
cmd.Parameters.Add(new SqlParameter("@Langages", postulant.Langages));
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
sqlConnection.Close();
MessagesErreur(ex);
}
sqlConnection.Close();
}
public static List <Postulant> GetByLangages(int nbMatch, string lPostes)
{
List <Postulant> postulants = new List <Postulant>();
SqlConnection sqlConnection = DataManager.Get();
try
{
sqlConnection.Open();
SqlCommand cmd = new SqlCommand
{
CommandText = "GetAll",
//CommandText = "GetByLangages",
CommandType = System.Data.CommandType.StoredProcedure,
Connection = sqlConnection
};
//cmd.Parameters.Add(new SqlParameter("@nbMatch", nbMatch));
//cmd.Parameters.Add(new SqlParameter("@lPostes", lPostes));
SqlDataReader reader = cmd.ExecuteReader();
Postulant postulant;
while (reader.Read())
{
postulant = new Postulant()
{
Id = int.Parse(reader["ID"].ToString()),
Nom = reader["NOM"].ToString(),
Courriel = reader["COURRIEL"].ToString(),
Langages = reader["LANGAGES"].ToString()
};
if (postulant.IsMatch(nbMatch, lPostes))
{
postulants.Add(postulant);
}
}
}
catch (SqlException ex)
{
sqlConnection.Close();
MessagesErreur(ex);
return(null);
}
sqlConnection.Close();
return(postulants);
}
static PostulantDAO()
{
Postulant p1 = new Postulant
{
Nom = "Judith Adame",
Courriel = "*****@*****.**",
Langages = "Java, JEE, Nodejs, js"
};
Postulant p2 = new Postulant
{
Nom = "Yuni",
Courriel = "*****@*****.**",
Langages = "ajax, jquery, javascript, js"
};
Postulant p3 = new Postulant
{
Nom = "Mohamed",
Courriel = "*****@*****.**",
Langages = "Java, JEE, Nodejs, js, ajax, jquery, js"
};
}
public static Postulant GetById(string id)
{
SqlConnection sqlConnection = DataManager.Get();
Postulant postulant = null;
try {
sqlConnection.Open();
SqlCommand cmd = new SqlCommand {
CommandText = "GetById",
CommandType = System.Data.CommandType.StoredProcedure,
Connection = sqlConnection
};
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
postulant = new Postulant()
{
Id = int.Parse(reader["ID"].ToString()),
Nom = reader["NOM"].ToString(),
Courriel = reader["COURRIEL"].ToString(),
Langages = reader["LANGAGES"].ToString()
};
}
}
catch (SqlException ex)
{
sqlConnection.Close();
MessagesErreur(ex);
return(null);
}
sqlConnection.Close();
return(postulant);
}
public void Update(string id, Postulant postulant)
{
PostulantDAO.Update(id, postulant);
}
public void Add(Postulant postulant) => PostulantDAO.Add(postulant);
