public List <Offre> RetrieveOffresBySelection(string idSociete, string idRegion, string idPoste, string idContrat, string nbrJour) { OffreDataAccess dataAccess = new OffreDataAccess(); List <Offre> offres = new List <Offre>(); DataTable schemaTable = dataAccess.SelectBySelection(Convert.ToInt32(idSociete), Convert.ToInt32(idRegion), Convert.ToInt32(idPoste), Convert.ToInt32(idContrat), Convert.ToInt32(nbrJour)); foreach (DataRow row in schemaTable.Rows) { Offre offre = new Offre { Id = Convert.ToInt32(row["ID_OFFRE"]), DatePublication = Convert.ToDateTime(row["DATE_PUBLICATION"]), Description = row["DESCRIPTION"].ToString(), LienAnnonce = row["LIEN_ANNONCE"].ToString() }; offre.MySelection.MySociete.Id = Convert.ToInt32(row["ID_SOCIETE"]); offre.MySelection.MySociete.Nom = row["NOM_SOCIETE"].ToString(); offre.MySelection.MyContrat.Id = Convert.ToInt32(row["ID_CONTRAT"]); offre.MySelection.MyContrat.Nom = row["TYPE_CONTRAT"].ToString(); offre.MySelection.MyRegion.Id = Convert.ToInt32(row["ID_REGION"]); offre.MySelection.MyRegion.Nom = row["NOM_REGION"].ToString(); offre.MySelection.MyPoste.Id = Convert.ToInt32(row["ID_POSTE"]); offre.MySelection.MyPoste.Nom = row["TYPE_POSTE"].ToString(); offres.Add(offre); } offres.Sort(); return(offres); }
public static bool Delete(this OffreManager offreManager, Offre offre) { OffreDataAccess dataAccess = new OffreDataAccess(); int rowCount = 0; try { rowCount = dataAccess.Delete(offre); } catch (ExceptionDataAccess e) { MessageBox.Show($"Erreur dans la récupérations des données, {e.Message}", "ERREUR", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Warning); } return(rowCount > 0); }
public static int Create(this OffreManager offreManager, Offre offre) { OffreDataAccess dataAccess = new OffreDataAccess(); int idSociete = 0; try { idSociete = dataAccess.Insert(offre); } catch (Exception e) { MessageBox.Show($"Erreur dans la récupérations des données, {e.Message}", "ERREUR", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Warning); } return(idSociete); }