private void buttonSelectionRechercheEtudiant_Click(object sender, EventArgs e) { // Petit "bricolage" qui permet d'outrepasser les protections du DataSet concernant la FK etudiant_id. Utilisation de l'ID n°1 de la table étudiant // comme valeur "null" if (jobRow.etudiant_id == 1) { Connectds.jobDataTable dt = new Connectds.jobDataTable(); dt = EntrepriseManager.GetJobDT(); jobRow = dt.Last <Connectds.jobRow>(); } int value; if (dataGridViewRechercheEtudiant.SelectedRows.Count == 1) { Int32.TryParse(dataGridViewRechercheEtudiant.SelectedCells[0].Value.ToString(), out value); jobRow.etudiant_id = value; jobRow.statut_job = true; EntrepriseManager.SaveJob(jobRow); this.Close(); Job jobDetail = new Job(jobRow); jobDetail.MdiParent = HomePage.ActiveForm; jobDetail.Show(); } else { MessageBox.Show("Veuillez sélectionner un étudiant", "Attention", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public static void AddJob(Connectds.jobRow jobRow) { using (ConnectdsTableAdapters.jobTableAdapter jobAdpt = new ConnectdsTableAdapters.jobTableAdapter()) { jobAdpt.Insert(jobRow.titre_job, jobRow.descriptif_job, jobRow.profil_job, jobRow.date_debut_job, jobRow.date_fin_job, jobRow.horaire_job, jobRow.remuneration_job, jobRow.permis_voiture_job, jobRow.remarque_job, jobRow.statut_job, jobRow.date_publication_job, jobRow.entreprise_id, jobRow.etudiant_id); } }
public static Connectds.jobRow GetJob(int job_id) { Connectds.jobDataTable jobDT = new Connectds.jobDataTable(); using (ConnectdsTableAdapters.jobTableAdapter jobAdpt = new ConnectdsTableAdapters.jobTableAdapter()) { jobAdpt.Fill(jobDT); } Connectds.jobRow jobRow = jobDT.FindByjob_id(job_id); return(jobRow); }
public static void DeleteJob(int job_id) { Connectds.jobDataTable jobDT = new Connectds.jobDataTable(); using (ConnectdsTableAdapters.jobTableAdapter jobAdpt = new ConnectdsTableAdapters.jobTableAdapter()) { jobAdpt.Fill(jobDT); Connectds.jobRow jobRow = jobDT.FindByjob_id(job_id); jobRow.Delete(); jobAdpt.Update(jobDT); } }
private void PopulateAndBind(int jobID) { ds = EntrepriseManager.GetDS(); comboBoxEntreprise.DataSource = ds; comboBoxEntreprise.ValueMember = "entreprise.entreprise_id"; comboBoxEntreprise.DisplayMember = "entreprise.nom_entreprise"; if (id != -1) { jobRow = EntrepriseManager.GetJob(id); comboBoxEntreprise.SelectedValue = jobRow.entreprise_id; comboBoxEntreprise.Enabled = false; if (!jobRow.Isetudiant_idNull()) { etudiantRow = EtudiantManager.GetEtudiant(jobRow.etudiant_id); textBoxEtudiantJob.Text = etudiantRow.etudiant_id + " - " + etudiantRow.nom_etudiant + " " + etudiantRow.prenom_etudiant; } textBoxJobID.Text = jobID.ToString(); buttonValiderJob.Text = "Modifier"; } else { if (entrepriseID != -1) { comboBoxEntreprise.SelectedValue = entrepriseID; } Connectds.jobDataTable jobDT = new Connectds.jobDataTable(); jobRow = (Connectds.jobRow)jobDT.NewjobRow(); //Tentative de contourner les contraintes de FK not null du DataSet: //jobRow.Setetudiant_idNull(); jobRow.etudiant_id = 1; comboBoxEntreprise.DropDownStyle = ComboBoxStyle.DropDownList; jobRow.titre_job = string.Empty; jobRow.descriptif_job = string.Empty; jobRow.profil_job = string.Empty; jobRow.date_debut_job = DateTime.Now; jobRow.date_fin_job = DateTime.Now; jobRow.horaire_job = string.Empty; jobRow.remuneration_job = 0; jobRow.permis_voiture_job = false; jobRow.remarque_job = string.Empty; jobRow.date_publication_job = DateTime.Now; jobRow.statut_job = false; labelJob.Visible = false; textBoxJobID.Visible = false; } textBoxIntituleJob.DataBindings.Add("Text", jobRow, "titre_job"); textBoxDescriptif.DataBindings.Add("Text", jobRow, "descriptif_job"); textBoxProfilJob.DataBindings.Add("Text", jobRow, "profil_job"); datePickerDebutJob.DataBindings.Add("Value", jobRow, "date_debut_job"); datePickerFinJob.DataBindings.Add("Value", jobRow, "date_fin_job"); textBoxHoraireJob.DataBindings.Add("Text", jobRow, "horaire_job"); numericUpDownSalaireJob.DataBindings.Add("Value", jobRow, "remuneration_job"); textBoxRmqJob.DataBindings.Add("Text", jobRow, "remarque_job"); datePickerPublicationJob.DataBindings.Add("Value", jobRow, "date_publication_job"); // création du binding pour le radiobutton "Oui" (permis) var permisJobBinding = new Binding("Checked", jobRow, "permis_voiture_job"); // Format = lecture à partir du datasource, retourne "true" s'il lit la valeur true permisJobBinding.Format += (s, args) => args.Value = ((bool)args.Value) == true; // Parse = écriture dans le datasource, retourne la valeur true s'il lit true, sinon il retourne false permisJobBinding.Parse += (s, args) => args.Value = (bool)args.Value ? true : false; // Binding: radioButtonPermisOuiJob.DataBindings.Add(permisJobBinding); // création du binding pour le radiobutton "Non" (permis) var permisJobNonBinding = new Binding("Checked", jobRow, "permis_voiture_job"); // Format = lecture à partir du datasource, retourne "true" s'il lit la valeur false permisJobNonBinding.Format += (s, args) => args.Value = ((bool)args.Value) == false; // Parse = écriture dans le datasource, retourne la valeur false s'il lit true, sinon il retourne true permisJobNonBinding.Parse += (s, args) => args.Value = (bool)args.Value ? false : true; // Binding: radioButtonPermisNonJob.DataBindings.Add(permisJobNonBinding); }
/// <summary> /// Constructeur qui permet d'afficher les détails d'un job passé en paramètre /// </summary> /// <param name="jobRow"></param> public Job(Connectds.jobRow jobRow) { InitializeComponent(); this.id = jobRow.job_id; PopulateAndBind(id); }
public RechercheEtudiant(Connectds.jobRow jobRow) { this.jobRow = jobRow; InitializeComponent(); PopulateAndBind(jobRow.date_debut_job, jobRow.date_fin_job); }