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);