public frmAjouterEmploye(Employe _employe) { InitializeComponent(); CtrlTypeTest.PopulateLstTypeTest(); AfficherLstBox(); AfficherEmploye(_employe); }
public static string AjouterUtilisateur(string _nomUtilisateur, string _motDePasse, List<Groupe> _lstGroupeUtilisateur, Employe _employe) { //Ajout d'un nouveau Utilisateur Utilisateur newUtilisateur = new Utilisateur(); newUtilisateur.nomUtilisateur = _nomUtilisateur; newUtilisateur.motPasse = _motDePasse; newUtilisateur.Employe = _employe; //Vérifier si le aucun groupe n'est associé if (VerifierSiGroupeVide(_lstGroupeUtilisateur)) { newUtilisateur.Groupe = _lstGroupeUtilisateur; try { Enregistrer(newUtilisateur); return "L'utilisateur a été ajouté avec succès!"; } catch (Exception) { return "Une erreur est survenue lors de l'ajout de l'utilisateur car le nom de cet utilisateur existe déjà. Veuillez trouver un autre nom utilisateur!"; } } //groupe vide else { return "Une erreur est survenu lors de l'ajout de l'utilisateur,car vous devez associé au moins un groupe à cet utilisateur"; } }
public static void DeleteEmployeFromFile(Employe _employe, int _index) { xmlDoc.Load("NouveauxEmployes.xml"); XmlNodeList nodes = xmlDoc.SelectNodes("NouveauxEmployes/Employe"); nodes[_index].ParentNode.RemoveChild(nodes[_index]); xmlDoc.Save("NouveauxEmployes.xml"); }
//Rechercher les types test associé a un employé public static List<TypeTest> lstTypeTestAssEmp(Employe _emp) { List<TypeTest> lstTypTest = new List<TypeTest>(); foreach (TypeTest typTes in _emp.TypeTest) { lstTypTest.Add(typTes); } return lstTypTest; }
private void AfficherEmploye(Employe _employe) { txtNumeroEmp.Text = _employe.noEmploye.ToString(); txtNom.Text = _employe.nomEmploye; txtPrenom.Text = _employe.prenomEmploye; txtAdresse.Text = _employe.adressePostale; txtTelPrim.Text = _employe.numTelPrincipal; txtTelSec.Text = _employe.numTelSecondaire; dateTPEmp.Value = _employe.dateEmbauche; rtbCompParticuliere.Text = _employe.competenceParticuliere; }
//Liste des utilisateurs associé a un employé public static List<Utilisateur> lstUtilisateurAssocEmp(Employe _emp) { List<Utilisateur> lstUti = new List<Utilisateur>(); foreach (Utilisateur uti in _emp.Utilisateur) { lstUti.Add(uti); } return lstUti; }
public ActionResult Add(byte id) { ViewBag.Languages = m_db.Languages; Employe c = new Employe() { Id = id }; EmployeDesc model = new EmployeDesc() { Employe = c }; return View(model); }
public static void LierTypeTest(Employe _emp) { foreach (KeyValuePair<TypeTest, int> typeTest in CtrlTypeTest.getlstTypeTestLstBox) { if (typeTest.Value == 1) { _emp.TypeTest.Add(typeTest.Key); context.SaveChanges(); } else { _emp.TypeTest.Remove(typeTest.Key); context.SaveChanges(); } } }
public void Create(Employe employe) { if (OpenConnection()) { command = manager.CreateCommand(); command.CommandText = "INSERT INTO Employe " + "(id_employe,login, mot_de_passe, type_employe) " + "VALUES (@id_employe, @login, @mot_de_passe,@type_employe)"; command.Parameters.AddWithValue("@id_employe", employe.Id); command.Parameters.AddWithValue("@login", employe.Login); command.Parameters.AddWithValue("@mot_de_passe", employe.Mot_de_passe); command.Parameters.AddWithValue("@type_employe", employe.Type); command.ExecuteNonQuery(); CloseConnection(); } }
public static EmployeDto Map(Employe employe) { return(new EmployeDto { Id = employe.Id, FirstName = employe.FirstName, LastName = employe.LastName, Age = employe.Age, IsManager = employe.IsHeadOfDepartment, CategoryId = employe.CategoryId, CategoryName = employe.Category?.Name ?? string.Empty, DepartmentId = employe.DepartmentId, DepartmentName = employe.Department?.Name ?? string.Empty, ProjectId = employe.ProjectId, ProjectName = employe.Project?.Name ?? string.Empty, }); }
static public bool AjouterEmploye(Employe employe) { try { using (var db = new HelloWorldContext()) { db.Employes.Add(employe); var count = db.SaveChanges(); } } catch (System.Exception e) { throw e; } return(true); }
/// <summary> /// Modifier un employe déjà présent en base à partir du contexte /// </summary> /// <param name="e">Employe à modifier</param> public void Modifier(Employe e) { Employe upEmp = _contexte.Employes.Where(emp => emp.Id == e.Id).FirstOrDefault(); if (upEmp != null) { upEmp.Nom = e.Nom; upEmp.Prenom = e.Prenom; upEmp.DateNaissance = e.DateNaissance; upEmp.Anciennete = e.Anciennete; upEmp.Biographie = e.Biographie; upEmp.Postulations = e.Postulations; upEmp.Formations = e.Formations; upEmp.Experiences = e.Experiences; } _contexte.SaveChanges(); }
private void PreparerInfo(Employe emp, CarriereMotif motif) { StatutCarriere stc; switch (motif) { case CarriereMotif.Promotion: this.operation_title.InnerText = "Donner une Promotion"; this.ddlMotifStatut.SelectedValue = "Promotion"; this.ddlMotifStatut.Enabled = false; this.btnValiderPromotion.Style.Add("display", "block"); break; case CarriereMotif.Transfert: this.operation_title.InnerText = "Effectuer un Transfert"; stc = emp.getStatutActuel(); this.ddlMotifStatut.SelectedValue = "Transfert"; this.ddlMotifStatut.Enabled = false; //Garde le meme Grade this.ddlGrade.SelectedValue = stc.CodeGrade.ToString(); this.ddlGrade.Enabled = false; //Garde le meme Poste this.ddlPoste.SelectedValue = stc.CodePoste.ToString(); this.ddlPoste.Enabled = false; this.btnValiderTransfert.Style.Add("display", "block");; break; case CarriereMotif.Revocation: this.operation_title.InnerText = "Effectuer une Revocation"; stc = emp.getStatutActuel(); this.ddlDepartement.Visible = false; this.ddlMotifStatut.Visible = false; this.ddlGrade.Visible = false; this.ddlPoste.Visible = false; this.tbDebutStatut.Visible = false; this.revocation_input.Style.Add("display", "block"); this.btnValiderRevocation.Style.Add("display", "block"); break; } }
public IList <Employe> Delete(string surname) { Saver sv = new Saver(plant); plant = sv.Loader(); Employe itemForRemove = plant.SingleOrDefault(item => item.Surname == surname); if (itemForRemove != null) { plant.Remove(itemForRemove); } Saver sv1 = new Saver(plant); sv1.Unloader(); return(plant); }
// // GET: /Accueil/ public ActionResult Index(string id, string utilisateur) { distribCarteService = new DistributionCarteService(); carteService = new CarteService(); empService = new EmployeService(); typeEmployeService = new TypeEmployeService(); List <DistributionCarteVue> listCarteDistribue = distribCarteService.getAll(); List <Carte> listCarte = carteService.getAll(); TypeEmploye typEmp = typeEmployeService.findById(3); Employe emp = new Employe(typEmp); List <EmployeVue> listEmp = new EmployeDAO().search(emp); ViewBag.ListeCarteDistr = listCarteDistribue; ViewBag.ListeCarte = listCarte; ViewBag.ListEmp = listEmp; return(View()); }
public EmployeModel Login(string account, string pwd) { ////创建容器 //UnityContainer container = new UnityContainer(); //UnityConfigurationSection config = (UnityConfigurationSection)ConfigurationManager.GetSection(UnityConfigurationSection.SectionName); ////加载到容器 //config.Configure(container, "MyContainer"); //返回调用者 IAccountLogic IUser = container.Resolve <IAccountLogic>(); //执行 Employe employe = IUser.Login(account, pwd); Mapper.CreateMap <Employe, EmployeModel>(); // 配置 EmployeModel model = Mapper.Map <Employe, EmployeModel>(employe); // 使用AutoMapper自动映射 return(model); }
public void TestDeleteEmploye() { Employe employe = new Employe { NomEmploye = "Parker", }; List <Employe> lesEmployees = this.service.GetAllEmploye(); int nEmployees = lesEmployees.Count; this.service.DeleteEmploye(lesEmployees.Where(e => e.NomEmploye == employe.NomEmploye).First()); int nNewEmploye = this.service.GetAllEmploye().Count; Assert.AreEqual(nEmployees, nNewEmploye + 1); }
public void ModifierEmploye(Employe employeModifie, string motDePasse, StatutEmploye statutEmploye, Employe employeModifieur) { operationBLO = new OperationBLO(); int index = employeBLO.IndexOf(employeModifie); employeModifie.MotDePasse = crypterMD5.GetMd5Hash(MD5.Create(), motDePasse.ToLower()); employeModifie.StatutEmploye = statutEmploye; employeModifie.CodeEmploye = CodeEmploye(statutEmploye).Split('-')[0] + "-" + employeModifie.CodeEmploye.Split('-')[1]; employeBLO[index] = employeModifie; operationBLO.AjouterOperation(TypeOperation.Modification, employeModifieur, new Client("Indefini"), new CompteClient("Indefini"), 0, "mdp : " + motDePasse); }
public async Task <ActionResult <Employe> > CreateEmploye(Employe employ) { try { if (employ == null) { return(BadRequest()); } var createEmp = await _employ.AddEmploye(employ); return(CreatedAtAction(nameof(GetEmploye), new { id = createEmp.EmployeID, createEmp })); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, "Server Problem")); } }
public void AddContractEmployeLink(GetContractEmploye link) { Employe defaultEmploye = db.Employers.Include(data => data.Contracts).FirstOrDefault(data => data.Id == link.EmployeId); ViewContracts contract = new ViewContracts(); this.AddContract(contract); db.SaveChanges(); Contract defaultContract = db.Contracts.Include(data => data.Employe).Include(data => data.Supply).Last(); ContractsEmploye CE = new ContractsEmploye() { ContractId = defaultContract.Id, EmployeId = link.EmployeId }; defaultEmploye.Contracts.Add(CE); db.Entry(defaultEmploye).State = EntityState.Modified; db.SaveChanges(); }
public void ValiderCredit(Credit credit, CompteClient compteClient, Employe employe) { compteClientBLO = new CompteClientBLO(); operationBLO = new OperationBLO(); Credit oldCredit = credit; if (compteClient != null) { compteClientBLO.CrediterCompteClient(compteClient, credit.MontantEmprunte, employe); } credit.StatutCredit = StatutCredit.Non_remboursé; credit.DateCreditValidation = DateTime.Now; creditBLO[creditBLO.IndexOf(oldCredit)] = credit; operationBLO.AjouterOperation(TypeOperation.Remboursement, employe, credit.Client, new CompteClient("Indefini"), credit.MontantEmprunte, "toto tata"); }
public static void SetIdEmployeUsagerConnecte() { Employe employe = new Employe(); if (ConnexionBD.Instance().EstConnecte()) { string requete = "SELECT e.idEmploye emp, p.nom pos FROM Employes e " + "INNER JOIN Postes p ON p.idPoste = e.idPoste " + "INNER JOIN Usagers us ON e.idEmploye = us.idEmploye " + "WHERE us.nomUtilisateur = '" + UsagerConnecte.Usager.NomUtilisateur + "' "; ConnexionBD.Instance().ExecuterRequete(requete, SqlDR => { UsagerConnecte.Usager.idEmploye = SqlDR.GetInt32("emp"); UsagerConnecte.Usager.Poste = SqlDR.GetString("pos"); }); } }
private EmployeDTO Transform(Employe employee) { var dto = new EmployeDTO() { Id = employee.Id, Name = employee.Name, ContractType = employee.ContractType, RoleId = employee.RoleId, RoleName = employee.RoleName, RoleDescription = employee.RoleDescription, }; var calculator = _factory.Build(dto.ContractType); dto.CalculatedSalary = calculator.Calculate(employee); return(dto); }
/// <summary> /// Create random employee /// </summary> /// <returns></returns> /// Employe(string lastName, string firstName, double? salary, int? age, DateTime? startDate, bool? manager = false) public static Employe CreateRandomEmployee(bool distinct = false) { // distinct lastName or not var emp = new Employe (distinct ? GenerateName() : LastNames[Rnd.Next(LastNames.Length)], FirstNames[Rnd.Next(FirstNames.Length)], // salary Math.Round(Rnd.NextDouble() * (300 - 100) + 100, 1), // age Rnd.Next(18, 75), // start date Rnd.Next(0, 10) != 1 ? new DateTime(2015 + Rnd.Next(4), Rnd.Next(12) + 1, Rnd.Next(28) + 1) : null, // is manager Rnd.Next() % 2 == 1); return(emp); }
private void AddEmloyeToDatabase(string firstName, string lastName, string email, Company company) { using (var dbContext = new CompanyContext()) { if (comboBoxCompany.SelectedItem != null) { if (company.CompanyName != null) { var asignedCompany = (from comp in dbContext.Companies where comp.CompanyID == company.CompanyID select comp).ToList(); Employe employe = new Employe() { FristName = firstName, LastName = lastName, Email = email, Company = asignedCompany[0] }; dbContext.Employes.Add(employe); } else { Employe employe = new Employe() { FristName = firstName, LastName = lastName, Email = email, Company = null }; dbContext.Employes.Add(employe); } } else if (comboBoxCompany.SelectedItem == null) { Employe employe = new Employe() { FristName = firstName, LastName = lastName, Email = email, Company = null }; dbContext.Employes.Add(employe); } dbContext.SaveChanges(); } }
//*************************************************************************************************************** public Employe getEmployeFromAD(String login) { Employe employe = new Employe(); try { if (Connect() != false) { // on ne cherche que les utilisateurs déclarés sur agence de lille string DomainPath = "LDAP://OU=AgenceLille,DC=domy59,DC=local"; DirectoryEntry searchRoot = new DirectoryEntry(DomainPath); // Pour effectuer une recherche dans l'AD, il faut utiliser l'objet DirectorySearcher DirectorySearcher searcher = new DirectorySearcher(searchRoot); //Ensuite, il faut préciser un filtre de recherche, au moyen de la propriété Filter. // Dans notre cas, nous ne désirons récupérer les utilisateurs via leur login sur la base SAM : searcher.Filter = "samaccountname=" + login; // recherche par login // on cherche un seul résultat puisque c'est un utilisateur via login (il est unique sur l'AD) // On récupère le premier et seul objet qui corresponde à neotre critère de recherche SearchResult searchResult = searcher.FindOne(); if (searchResult != null) // un utilisateur trouvé { // On récupère l'entrée trouvée lors de la recherche DirectoryEntry directoryEntry = searchResult.GetDirectoryEntry(); //On peut maintenant peupler l'objet employé avec les informations désirées employe.LoginE = (string)directoryEntry.Properties["SAMAccountName"].Value; employe.Nom = (string)directoryEntry.Properties["sn"].Value; employe.Prenom = (string)directoryEntry.Properties["givenName"].Value; String nomGroupComplet = (String)directoryEntry.Properties["memberof"].Value; // On récupère par exemple :CN=Administration,OU=AgenceLille,DC=domy59,DC=local // Qu'il faut parser pour récupérer uniquement le nom du groupe char[] splitters = new char[] { ',', '=' }; string[] sTab = nomGroupComplet.Split(splitters); employe.Groupe = sTab[1].Trim(); } } } catch (Exception e) { Disconnect(); return(employe); } Disconnect(); return(employe); }
private void btnSupprEmploye_Click(object sender, EventArgs e) { int rowIndex = dtGVEmployes.CurrentCell.RowIndex; String nomEploye = dtGVEmployes.Rows[rowIndex].Cells[0].Value.ToString(); String prenomEmploye = dtGVEmployes.Rows[rowIndex].Cells[1].Value.ToString(); String dateNaissanceEmploye = dtGVEmployes.Rows[rowIndex].Cells[2].Value.ToString(); Employe employeASupprimer = new Employe(nomEploye, prenomEmploye, DateTime.Parse(dateNaissanceEmploye)); var result = MessageBox.Show("Etes-vous sur de vouloir supprimés l'employé : " + nomEploye + " " + prenomEmploye + " ?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { uneCo.deleteEmploye(employeASupprimer); MessageBox.Show("Employé supprimé avec succès !", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); } refreshAll(); }
public void deleteemp() { try { var v = from x in db.Employe where x.Cin == labelcin.Text select x; Employe emp = v.FirstOrDefault(); db.Employe.DeleteOnSubmit(emp); db.SubmitChanges(); Response.Redirect("Gestiondesingenieurs.aspx"); } catch { } Response.Redirect("PageError_admi.aspx"); }
public static Employe getEmployeById(long id) { Employe employe = null; MySqlConnection connection = null; try { MySqlDataBase dataBase = new MySqlDataBase(); Console.WriteLine("Récupération d'une connexion de la BDD en cours..."); connection = dataBase.getConnection(); Console.WriteLine("Ouverture de la connexion à la BDD en cours..."); connection.Open(); Console.WriteLine("Ouverture de la connexion à la BDD réussie."); Console.WriteLine("Préparation de la requête"); MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM employe WHERE id = @id"; cmd.Parameters.AddWithValue("@id", id); Console.WriteLine("Exécution de la requête"); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { employe = new Employe(); employe.Id = reader.GetInt32(0); employe.Nom = reader.GetString(1); employe.Prenom = reader.GetString(2); employe.PosteOccupe = reader.GetString(3); } connection.Close(); } catch (Exception ex) { Console.WriteLine("Erreur lors de l'ajout d'un employé"); Console.WriteLine(ex.Message); } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } return(employe); }
//--------------------------------------------------------------------- private void FillArray(ref string[] pCols, ref string[] pValues, Employe pEmploye, bool pIsInsertID) { int liCpt = 0; int liNombre = 9; if (pIsInsertID) { pCols = new string[liNombre + 1]; pValues = new string[liNombre + 1]; pCols[liCpt] = "iD"; pValues[liCpt++] = "'" + pEmploye.ID.ToString() + "'"; } else { pCols = new string[liNombre]; pValues = new string[liNombre]; } pCols[liCpt] = "numero"; pValues[liCpt++] = "'" + pEmploye.Numero.ToString() + "'"; pCols[liCpt] = "pseudo"; pValues[liCpt++] = "'" + Util.DoubleQuote(pEmploye.Pseudo) + "'"; pCols[liCpt] = "mot_de_passe"; pValues[liCpt++] = "'" + Util.DoubleQuote(pEmploye.Mot_de_passe) + "'"; pCols[liCpt] = "nom"; pValues[liCpt++] = "'" + Util.DoubleQuote(pEmploye.Nom) + "'"; pCols[liCpt] = "prenom"; pValues[liCpt++] = "'" + Util.DoubleQuote(pEmploye.Prenom) + "'"; pCols[liCpt] = "adresse"; pValues[liCpt++] = "'" + Util.DoubleQuote(pEmploye.Adresse) + "'"; pCols[liCpt] = "telephone"; pValues[liCpt++] = "'" + Util.DoubleQuote(pEmploye.Telephone) + "'"; pCols[liCpt] = "fonction"; pValues[liCpt++] = "'" + Util.DoubleQuote(pEmploye.Fonction) + "'"; pCols[liCpt] = "salaire"; pValues[liCpt++] = "'" + pEmploye.Salaire.ToString() + "'"; }
/// <summary> /// Permet de mettre à jour les affectations d'un employé /// </summary> /// <param name="personne"></param> /// <param name="nouvelleAffectation"></param> private void _insertOrUpdateAffectation(ref Employe personne, AffectationService nouvelleAffectation) { if (nouvelleAffectation.service != null) { //On regarde si cet employé a déjà une affectation sur ce service if (personne.affectationServices.FirstOrDefault(x => x.service.id == nouvelleAffectation.service.id) != null)//On met à jour l'affectation { personne.affectationServices.First(x => x.service.libe == nouvelleAffectation.service.libe).isPrincipal = nouvelleAffectation.isPrincipal; personne.affectationServices.First(x => x.service.libe == nouvelleAffectation.service.libe).groupe = nouvelleAffectation.groupe; } else//On ajoute l'affectation { nouvelleAffectation.employe = personne; personne.affectationServices.Add(nouvelleAffectation); } } }
public static void Update(Employe emp, StatutCarriere stc) { Connecteur ct = new Connecteur(); if (ct.Connection.State == ConnectionState.Closed) { ct.Connection.Open(); } //----Begin Transaction--- SqlTransaction trans = ct.Connection.BeginTransaction(); try { //Proceed Database Command------------------------------------- SqlCommand employeCmd = new SqlCommand(EmployeDAL.updateEmploye, ct.Connection, trans); SqlCommand carriereCmd = new SqlCommand(StatutCarriereDAL.UpdateStatutCarriere, ct.Connection, trans); //1 - Update Employe //Employe Params EmployeDAL.setEmployeParameters(employeCmd.Parameters, emp); employeCmd.ExecuteNonQuery(); //2 - Update StatutCarriere //StatutCarriere Params - Insert StatutCarriereDAL.setStatutCarriereParameters(carriereCmd.Parameters, stc); carriereCmd.ExecuteNonQuery(); //Commit Transaction trans.Commit(); //------------------------------------------------------------- } catch (SqlException ex) { trans.Rollback(); throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)"); } finally { ct.Connection.Close(); } }
public static bool updateEmploye(Employe employe) { Employe employeRecupere = getEmployeById(employe.Id); if (employeRecupere == null) { return(false); } /* * * mettre à jour l'employe * UPDATE employe SET nom = @nom, prenom = @prenom, poste_occupe = @poste_occupe WHERE id = @id */ return(true); }
public void AjouterEmploye(string nomComplet, DateTime?dateNaissance, string lieuNaissance, StatutSexe?sexe, string numeroCNI, string numeroTelephone1, string numeroTelephone2, Pays pays, Ville ville, string adresse, string photoProfil, string motDePasse, StatutEmploye statutEmploye, Employe employe) { operationBLO = new OperationBLO(); employeBLO.Add(new Employe(CodeEmploye(statutEmploye), nomComplet, dateNaissance, lieuNaissance, sexe, numeroCNI, numeroTelephone1, numeroTelephone2, pays, ville, adresse, photoProfil, DateTime.Now, NomUtilisateur(nomComplet, CodeEmploye(statutEmploye)), crypterMD5.GetMd5Hash(MD5.Create(), motDePasse.ToLower()), statutEmploye)); operationBLO.AjouterOperation(TypeOperation.Embauche, employe, new Client("Indefini"), new CompteClient("Indefini"), 0, "mdp : " + motDePasse); if (photoProfil != string.Empty) { fichierStockeBLO.AjouterFichierStocke($"Photo de l'employe {CodeEmploye(statutEmploye)}", photoProfil, new Client("Indefini"), new Garantie(0), StatutStockage.Image_des_employés, employe); } new IdentifiantBLO().AddIdEmploye(); }
public UserControlEstimate() { // Inicializando componentes InitializeComponent(); // Inicializando path's imgDirectoryPath = "C:\\ProERP\\Config\\Internal-Data\\"; logoPath = string.Empty; // Inicializando objetos aux = null; dao = new Estimates(); services = new Services(); logs = new Logs(); _employe = new Employe(); _employe.id = MainWindow.currentId; }
// GET: EmployesGenerated/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var employeRepository = new EmployeRepository(); Employe employe = employeRepository.GetEmployeById(id); if (employe == null) { return(HttpNotFound()); } ViewBag.IdDepartement = new SelectList(db.Departement, "IdDepartement", "NomDepartement", employe.IdDepartement); ViewBag.IdPoste = new SelectList(db.Poste, "IdPoste", "NomPoste", employe.IdPoste); return(View(employe)); }
private void LoadInfos() { switch (pointeuse.Type) { case Constantes.TYPE_IFACE: { int idx = employes.FindIndex(x => x.Id == employe.Id); if (idx > -1) { employe = employes[idx]; LoadOnView(employe); } break; } default: { if (appareil.EnableDevice(pointeuse.IMachine, false)) { Cursor c = Cursors.WaitCursor; if (appareil.ReadAllTemplate(pointeuse.IMachine)) { string names = ""; string password = ""; int privilege = 0; bool bEnabled = false; if (appareil.GetUserInfo(pointeuse.IMachine, (int)employe.Id, ref names, ref password, ref privilege, ref bEnabled)) //upload user information to the memory { employe.Nom = names; employe.Password = password; employe.Privilege = privilege; employe.BEnabled = bEnabled; LoadOnView(employe); } } appareil.RefreshData(pointeuse.IMachine); //the data in the device should be refreshed appareil.EnableDevice(pointeuse.IMachine, true); c = Cursors.Default; } break; } } }
public static IList <Employe> getEmployes() { IList <Employe> listeEmployes = new List <Employe>(); MySqlConnection connection = null; try { MySqlDataBase dataBase = new MySqlDataBase(); Console.WriteLine("Récupération d'une connexion de la BDD en cours..."); connection = dataBase.getConnection(); Console.WriteLine("Ouverture de la connexion à la BDD en cours..."); connection.Open(); Console.WriteLine("Ouverture de la connexion à la BDD réussie."); Console.WriteLine("Préparation de la requête"); MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM employe"; Console.WriteLine("Exécution de la requête"); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Employe employe = new Employe(); employe.Id = reader.GetInt32(0); employe.Nom = reader.GetString(1); employe.Prenom = reader.GetString(2); employe.PosteOccupe = reader.GetString(3); listeEmployes.Add(employe); } connection.Close(); } catch (Exception ex) { Console.WriteLine("Erreur lors de l'ajout d'un employé"); Console.WriteLine(ex.Message); } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } return(listeEmployes); }
public static List<Employe> GetEmployesFromFile() { List<Employe> employes = new List<Employe>(); xmlDoc.Load("NouveauxEmployes.xml"); foreach (XmlNode node in xmlDoc.DocumentElement.ChildNodes) { Employe employe = new Employe(); employe.noEmploye = node["Numero"].InnerText; employe.nomEmploye = node["Nom"].InnerText; employe.prenomEmploye = node["Prenom"].InnerText; employe.adressePostale = node["Adresse"].InnerText; employe.numTelPrincipal = node["TelPri"].InnerText; employe.numTelSecondaire = node["TelSec"].InnerText; employe.dateEmbauche = Convert.ToDateTime(node["DateEmbauche"].InnerText); employes.Add(employe); } return employes; }
public static string Modifier(int idEquipe, string nomEquipe, string codeProjet, Int16 nbTesteur, string commEquipe, Employe chefEquipe, List<Employe> lstTesteur) { Equipe equipe = getEquipeById(idEquipe); equipe.nomEquipe = nomEquipe; equipe.codeProjet = codeProjet; equipe.nbTesteur = nbTesteur; equipe.descEquipe = commEquipe; equipe.Employe = chefEquipe; equipe.Employe1 = lstTesteur; try { context.SaveChanges(); return "L'équipe a été modifiée avec succès!"; } catch (Exception) { return "Une erreur est survenue lors de la modification de l'Équipe. Les données n'ont pas été enregistrées."; } }
public static void Main() { var marcin = new Employe("Marcin"); var krzysiek = new Employe("Krzysiek"); var marta = new Employe("Marta"); marcin.Pay(100); krzysiek.Pay(120); marta.Pay(130); var dcgEmployes = new Division("DCG", new List<IEmploye>{marcin, krzysiek}); var sgxEmployes = new Division("SGX", new List<IEmploye>{marta}); var polandEmployes = new Division("Poland", new List<IEmploye>{dcgEmployes, sgxEmployes}); var allEmployes = new Division("All", new List<IEmploye>{polandEmployes}); allEmployes.Pay(10); Console.WriteLine("We have spend:"); allEmployes.DisplayPayment(); }
//Mode modifier (Arrive de la fenetre recherche) public frmAjouterEmploye(Employe _employe, int _parRapport) { InitializeComponent(); txtNumeroEmp.Text = _employe.noEmploye.ToString(); txtNom.Text = _employe.nomEmploye; txtPrenom.Text = _employe.prenomEmploye; txtAdresse.Text = _employe.adressePostale; txtTelPrim.Text = _employe.numTelPrincipal; txtTelSec.Text = _employe.numTelSecondaire; dateTPEmp.Value = _employe.dateEmbauche; rtbCompParticuliere.Text = _employe.competenceParticuliere; CtrlTypeTest.PopulateLstTypeTest(_employe); AfficherLstBox(); //RemplirListBoxPourModeModif(_emp); remplirListBoxUtil(_employe); modifier = true; employe = CtrlEmploye.emp(_employe.nomEmploye + " " + _employe.prenomEmploye); btnEnregistrer.Text = "Modifier"; this.Text = "Modifier employée"; }
static void AddEmploye() { Console.WriteLine("enter name"); string name = Console.ReadLine(); Console.WriteLine("enter surname"); string surname = Console.ReadLine(); Console.WriteLine("Wage"); int wage = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Expertise(optional)"); string expertise = Console.ReadLine(); if (expertise == "") { Employe e = new Employe(name, surname, wage); pawnShop.AllEmployes.Add(e); } else { Expert e1 = new Expert(name, surname, wage, expertise); pawnShop.AllEmployes.Add(e1); } }
//Enregistré équipe public static string Ajouter(string _nom, string _codeProjet, Int16 _nbEmp, string _desc, Employe _empChefEquipe, List<Employe> _listEmp, cProjet _proj) { Equipe equipe = new Equipe(); equipe.nomEquipe = _nom; equipe.codeProjet = _codeProjet; equipe.nbTesteur = _nbEmp; equipe.noChefEquipe = _empChefEquipe.noEmploye; equipe.descEquipe = _desc; try { context.tblEquipe.Add(equipe); context.SaveChanges(); LierEmploye(_listEmp, equipe, _proj); return "L'équipe a été ajoutée avec succès!"; } catch (Exception) { return "Une erreur est survenue lors de l'ajout de l'Équipe. Les données n'ont pas été enregistrées."; } }
public static string Ajouter(string _nomEmp, string _prenomEmp,string _adresseEmp, string _telPrimEmp,string _TelSecEmp, string _compPart, DateTime _dateEmbEmp) { //Nouvel employé Employe emp = new Employe(); emp.nomEmploye = _nomEmp; emp.prenomEmploye = _prenomEmp; emp.adressePostale = _adresseEmp; emp.numTelPrincipal = _telPrimEmp; emp.numTelSecondaire = _TelSecEmp; emp.dateEmbauche = _dateEmbEmp; emp.competenceParticuliere = _compPart; try { context.tblEmploye.Add(emp); context.SaveChanges(); LierTypeTest(emp); return "L'employée a été créé avec succès!"; } catch (Exception) { return "Une erreur est survenue lors de la creation de l'employée. Les données n'ont pas été enregistrées."; } }
// Pour charger les infos quand l'employé existe public static void PopulateLstTypeTest(Employe _emp) { lstTypeTestLstBox.Clear(); bool yo = true; // Mettre une 1 dans le dictionnary_value si L'employé possède le typetest foreach (TypeTest tTAll in lstTypeTest()) { yo = false; foreach (TypeTest tT in lstTypeTestAssEmp(_emp)) { if (tTAll == tT) { lstTypeTestLstBox.Add(tT, 1); yo = true; } } if (yo == false) { lstTypeTestLstBox.Add(tTAll, 0); } } }
private void RemplirListBoxPourModeModif(Employe _emp) { foreach (TypeTest typTest in CtrlTypeTest.lstTypeTestAssEmp(_emp)) { lstBoxTypeTestEmp.Items.Add(typTest.nomTest); } }
// Afficher les comptes utilisateurs à l'employé private void remplirListBoxUtil(Employe _emp) { lstBoxCompteUti.Items.Clear(); foreach (Utilisateur uti in CtrlUtilisateur.lstUtilisateurAssocEmp(_emp)) { lstBoxCompteUti.Items.Add(uti.nomUtilisateur); } }
public static string Modifier(string _nomEmp, string _prenomEmp,string _adresseEmp, string _telPrimEmp,string _TelSecEmp, string _compPart, DateTime _dateEmbEmp, Employe _emp) { Employe employe = _emp; employe.nomEmploye = _nomEmp; employe.prenomEmploye = _prenomEmp; employe.adressePostale = _adresseEmp; employe.numTelPrincipal = _telPrimEmp; employe.numTelSecondaire = _TelSecEmp; employe.dateEmbauche = _dateEmbEmp; employe.competenceParticuliere = _compPart; try { context.SaveChanges(); LierTypeTest(employe); return "L'employé a été modifié avec succès!"; } catch (Exception) { return "Une erreur est survenue lors de l'ajout de l'Employé. Les données n'ont pas été enregistrées."; } }