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