public static void addEmploye(Employe settings) { var bd = new dbProjetE2ProdEntities(); var ajout = new tblEmploye(); var lstTypeTest = new List<tblTypeTest>(); var tt = from e in bd.tblTypeTest select e; int i = 0; foreach (tblTypeTest item in tt) { foreach (TypeTest ty in settings.lstEmTypeTest) { if (item.CodeTypeTest == ty.codeTypeTest) { ajout.tblTypeTest.Add(item); i++; break; } } if (settings.lstEmTypeTest.Count == i) break; } ajout.IdEmp = settings.idEmp; ajout.PrenomEmp = settings.prenomEmp; ajout.NomEmp = settings.nomEmp; ajout.CourrielEmp = settings.courrielEmp; ajout.NoTelPrincipal = settings.noTelPrincipal; ajout.NoTelSecondaire = settings.noTelSecondaire; ajout.AdressePostale = settings.adressePostale; ajout.DateEmbaucheEmp = settings.dateEmbaucheEmp; ajout.CompetenceParticuliere = settings.competenceParticuliere; ajout.Statut = settings.statut; ajout.CommentaireEmp = settings.commentaireEmp; //ajout.tblTypeTest = lstTypeTest; bd.tblEmploye.Add(ajout); try { bd.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); MessageBox.Show("Une erreur est survenue lors de l'ajout du nouvel employe", "Erreur système", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void addEmploye(Employe settings) { var bd = new dbProjetE2ProdEntities(); var add = new tblEmploye(); var lstTypeTest = new List<tblTypeTest>(); var tt = from e in bd.tblTypeTest select e; int i = 0; foreach (tblTypeTest item in tt) { foreach (TypeTest ty in settings.lstEmTypeTest) { if (item.CodeTypeTest == ty.codeTypeTest) { lstTypeTest.Add(item); i++; break; } } if (settings.lstEmTypeTest.Count == i) break; } add.IdEmp = settings.idEmp; add.PrenomEmp = settings.prenomEmp; add.NomEmp = settings.nomEmp; add.CourrielEmp = settings.courrielEmp; add.NoTelPrincipal = settings.noTelPrincipal; add.NoTelSecondaire = settings.noTelSecondaire; add.AdressePostale = settings.adressePostale; add.DateEmbaucheEmp = settings.dateEmbaucheEmp; add.CompetenceParticuliere = settings.competenceParticuliere; add.Statut = settings.statut; add.CommentaireEmp = settings.commentaireEmp; add.tblTypeTest = lstTypeTest; bd.tblEmploye.Add(add); try { bd.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } }
public Employe(int _id, string _pre, string _nom, string _cou, string _telP, string _telS, string _adre, DateTime _dat, string _comp, string _sta, string _comm, tblEmploye _emp) { IdEmp = _id; PrenomEmp = _pre; NomEmp = _nom; CourrielEmp = _cou; NoTelPrincipal = _telP; NoTelSecondaire = _telS; AdressePostale = _adre; DateEmbaucheEmp = _dat; CompetenceParticuliere = _comp; Statut = _sta; CommentaireEmp = _comm; LstEmTypeTest = new List<TypeTest>(); }
public Employe(tblEmploye _emp) { IdEmp = _emp.IdEmp; PrenomEmp = _emp.PrenomEmp; NomEmp = _emp.NomEmp; CourrielEmp = _emp.CourrielEmp; NoTelPrincipal = _emp.NoTelPrincipal; NoTelSecondaire = _emp.NoTelSecondaire; AdressePostale = _emp.AdressePostale; DateEmbaucheEmp = _emp.DateEmbaucheEmp; CompetenceParticuliere = _emp.CompetenceParticuliere; Statut = _emp.Statut; CommentaireEmp = _emp.CommentaireEmp; TblE = _emp; LstEmTypeTest = new List<TypeTest>(); }
public Employe() { IdEmp = 0; PrenomEmp = ""; NomEmp = ""; CourrielEmp = ""; NoTelPrincipal = ""; NoTelSecondaire = ""; AdressePostale = ""; DateEmbaucheEmp = DateTime.Now; CompetenceParticuliere = ""; Statut = "n"; CommentaireEmp = ""; TblE = null; LstEmTypeTest = new List<TypeTest>(); }
public Employe(tblEmploye _emp) { IdEmp = _emp.IdEmp; PrenomEmp = _emp.PrenomEmp; NomEmp = _emp.NomEmp; CourrielEmp = _emp.CourrielEmp; NoTelPrincipal = _emp.NoTelPrincipal; NoTelSecondaire = _emp.NoTelSecondaire; AdressePostale = _emp.AdressePostale; DateEmbaucheEmp = _emp.DateEmbaucheEmp; CompetenceParticuliere = _emp.CompetenceParticuliere; Statut = _emp.Statut; CommentaireEmp = _emp.CommentaireEmp; LstEmTypeTest = new List<TypeTest>(); foreach (tblTypeTest item in _emp.tblTypeTest) { TypeTest tt = new TypeTest(item); LstEmTypeTest.Add(tt); } }
private void Enregistrer() { try { //List<tblEmploye> lstEmploye = new List<tblEmploye>(); tblEmploye tmpEmp = new tblEmploye(); List<tblTypeTest> lstTypeTest = new List<tblTypeTest>(); tblEquipe tmpequipe = new tblEquipe(); string stringChef; AllChefEquipe ChefEquipe = new AllChefEquipe(); stringChef = cboxChefEquipe.SelectedItem.ToString(); ChefEquipe = rEquipeSQL.getUNChefEquipe(stringChef); tmpequipe.IdChefEquipe = ChefEquipe.IdEmp; tmpequipe.NomEquipe = txtNomEquipe.Text; tmpequipe.CommentaireEquipe = rTxtCommentaire.Text; tmpequipe.CodeProjet = cboxProjet.Text; foreach (TreeNode item in lstTreeSelectEmploye.Nodes) { tmpEmp = (tblEmploye)item.Tag; tmpequipe.tblEmploye1.Add(tmpEmp); } foreach (TreeNode item in lstTreeSelectTest.Nodes) { tblTypeTest tmpTest = new tblTypeTest(); tmpTest = (tblTypeTest)item.Tag; tmpequipe.tblTypeTest.Add(tmpTest); } int noEquipe; if (ModifEnabled == false) { tmpequipe.Statut = "A"; noEquipe = rEquipeSQL.addEquipe(tmpequipe); } else { noEquipe = equipeAModifier.IdEquipe; tmpequipe.IdEquipe = noEquipe; tmpequipe.Statut = equipeAModifier.Statut; noEquipe = rEquipeSQL.setEquipe(tmpequipe); } frmGes.afficherDonnees(noEquipe); this.Close(); } catch (Exception) { MessageBox.Show("Il y a eu une erreur lors de l'enregistrement, S.V.P. vérifier que les champs suivant sont bien remplit : Projet, NomEquipe et Chef d'équipe."); } }
public List<string[]> chargerDonnees() { string[] row; List<string[]> lstRows = new List<string[]>(); var lstBrut = rEquipeSQL.getListeEquipe(); lstEquipe = new List<equipe>(); tblEmploye chef = new tblEmploye(); tblTypeTest t = new tblTypeTest(); List<tblTypeTest> lstTypeTest = new List<tblTypeTest>(); foreach (var item in lstBrut) { //lstEquipe.Add(new equipe(item)); chef = rEquipeSQL.getChefEquipe(item.IdChefEquipe); //test = rEquipeSQL.getListTestEquipe(item.tblTypeTest); //lstTypeTest = item.tblTypeTest.ToList<tblTypeTest>(); //t = lstTypeTest.First(); //string n = test(item.tblTypeTest); string n = ""; int i = 0; foreach (var temp in item.tblTypeTest) { if (i == 0) { n = temp.NomTypeTest; } else { } i++; } string e = ""; i = 0; foreach (var temp in item.tblEmploye1) { if (i == 0) { e = temp.PrenomEmp + " " + temp.NomEmp; } else { } i++; } row = new string[] { item.CodeProjet, item.IdEquipe.ToString(), item.NomEquipe, chef.PrenomEmp + " " + chef.NomEmp, n, e}; lstRows.Add(row); } return lstRows; }