private void afficheur_Ent(IQueryable list) { panel.Children.Clear(); foreach (Entretien recup in list) { Recrutement r = (from rp in db.Recrutement where rp.matricule == recup.matricule select rp).FirstOrDefault(); if (r != null) { var flip = new User8(); flip.set(r.matricule); flip.ninom.Text = r.nom_dm; flip.poste.Text = r.int_post; TextBlock txt4 = new TextBlock(); DateTime date = new DateTime(); date = (DateTime)recup.date; flip.date.Text = date.ToShortDateString(); flip.numtel.Text = "0" + r.num.ToString(); flip.email.Text = r.Adr_mail; panel.Children.Add(flip); flip.experience.Text = recup.exp; flip.Q1.Text = recup.Q1; flip.eva_q1.Text = ((int)recup.evaQ1).ToString(); flip.Q2.Text = recup.Q2; flip.eva_q2.Text = ((int)recup.evaQ2).ToString(); flip.etape_suiv.Text = recup.etape_suiv; } } }
private void add_rec(object sender, RoutedEventArgs e) { string connectString = $@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename={System.IO.Path.GetDirectoryName(Assembly.GetEntryAssembly().Location)}\ProjetBDD.mdf;Integrated Security=True;Connect Timeout=30"; // initialitation de la preimiere fenetre et tout ce qui doit apparaitre en premier ... DataClasses1DataContext db = new DataClasses1DataContext(connectString); if (nom.Text != "" && num.Text != "" && poste.Text != "" && adr.Text != "") { Recrutement rec = new Recrutement(); rec.nom_dm = nom.Text; rec.num = Convert.ToInt32(num.Text); rec.int_post = poste.Text; rec.Adr_mail = adr.Text; db.Recrutement.InsertOnSubmit(rec); db.SubmitChanges(); alert_text.Text = " Bien ajouté"; alert.IsOpen = true; } else { alert_text.Text = "fiche incomplète"; alert.IsOpen = true; } }
private void planif(object sender, RoutedEventArgs e) { string connectString = $@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename={System.IO.Path.GetDirectoryName(Assembly.GetEntryAssembly().Location)}\ProjetBDD.mdf;Integrated Security=True;Connect Timeout=30"; // initialitation de la preimiere fenetre et tout ce qui doit apparaitre en premier ... DataClasses1DataContext db = new DataClasses1DataContext(connectString); Recrutement re = (from recup in db.Recrutement where recup.matricule == id select recup).FirstOrDefault(); DateTime dt = new DateTime(); dt = (DateTime)date.SelectedDate; if (date.SelectedDate != null && DateTime.Today.DayOfYear < dt.DayOfYear) { re.date_ent_ = dt; db.SubmitChanges(); alert_text.Text = "bien planifier"; alert.IsOpen = true; } else { alert_text.Text = "veiller introduire la date "; alert.IsOpen = true; } }
public async Task <ActionResult <Recrutement> > PostRecrutement(Recrutement recrutement) { _context.recrutements.Add(recrutement); await _context.SaveChangesAsync(); return(CreatedAtAction("GetRecrutement", new { id = recrutement.Id }, recrutement)); }
public async Task <IActionResult> PutRecrutement(int id, Recrutement recrutement) { if (id != recrutement.Id) { return(BadRequest()); } _context.Entry(recrutement).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RecrutementExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
///////--------------------------------- Validation de l'entretien -----------------------------////// private void validation(object sender, RoutedEventArgs e) { string connectString = $@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename={System.IO.Path.GetDirectoryName(Assembly.GetEntryAssembly().Location)}\ProjetBDD.mdf;Integrated Security=True;Connect Timeout=30"; // initialitation de la preimiere fenetre et tout ce qui doit apparaitre en premier ... DataClasses1DataContext db = new DataClasses1DataContext(connectString); //------------------------------- Creation du Profil de l'entretien-------------------------- if (expe.Text != "" && Q1.Text != "" && evQ1.Text != "" && Q2.Text != "" && evQ2.Text != "" && statu.Text != "" && etape.Text != "" && comnt.Text != "" && Salaire.Text != "" && date_et.SelectedDate != null) { Entretien personne = new Entretien(); personne.matricule = this.identifant; personne.exp = expe.Text; personne.Q1 = Q1.Text; personne.evaQ1 = Convert.ToInt32(evQ1.Text); personne.Q2 = Q2.Text; personne.evaQ2 = Convert.ToInt32(evQ2.Text); personne.date = (DateTime)date_et.SelectedDate; personne.salaire_des = Convert.ToInt32(Salaire.Text); personne.statut = statu.Text; personne.etape_suiv = etape.Text; personne.comment = comnt.Text; db.Entretien.InsertOnSubmit(personne); db.SubmitChanges(); alert_text.Text = "Bien ajouté"; alert.IsOpen = true; //----- Supprimer la date de l'entretien apres evaluation Recrutement rec = (from recup in db.Recrutement where recup.matricule == identifant select recup).FirstOrDefault(); rec.date_ent_ = null; db.SubmitChanges(); this.Close(); } else { alert_text.Text = "Fiche incomplète"; alert.IsOpen = true; } }