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