private void buttonAddUpdate_Click(object sender, EventArgs e) { Projet pj = new Projet(); string nomP = IhmManager.projetSelect.idProjet; pj.idProjet = textBox1.Text; pj.dateProjet = dateTimePicker1.Value; pj.lienSnvProjet = textBox2.Text; IhmManager.persSelect = (Personnel)comboBox1.SelectedValue; pj.personnel = IhmManager.persSelect; if (IhmManager.ajouter) { int nbligne = projetManager.ajouterProjet(pj); if (nbligne > 0) { MessageBox.Show("Ajout effectué avec succès !"); this.Close(); } ; } else { int nbligne = projetManager.modifierProjetByNom(pj, nomP); if (nbligne > 0) { MessageBox.Show("Modifcation effectuée avec succès !"); this.Close(); } ; } }
public ActionResult FinishProjet(int id) { var _context = new DbCaimanContext(); Projet projetF = _context.Projets.FirstOrDefault(proId => proId.ProjetId == id); return(View(projetF)); }
public ProjetsVueModele() { _maListeProjets = new ObservableCollection <Projet>(); DateTime dateDebut = new DateTime(01 / 02 / 2000); DateTime dateFin = new DateTime(01 / 02 / 2019); Projet Argo = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo1 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo2 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo3 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo4 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo5 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo6 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo7 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo8 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo9 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo10 = new Projet("Argo", dateDebut, dateFin, 1000); Projet Argo11 = new Projet("Argo", dateDebut, dateFin, 1000); MaListeProjets.Add(Argo); MaListeProjets.Add(Argo1); MaListeProjets.Add(Argo2); MaListeProjets.Add(Argo3); MaListeProjets.Add(Argo4); MaListeProjets.Add(Argo5); MaListeProjets.Add(Argo6); MaListeProjets.Add(Argo7); MaListeProjets.Add(Argo8); MaListeProjets.Add(Argo9); MaListeProjets.Add(Argo10); MaListeProjets.Add(Argo11); }
// Méthode pour supprimer un projet dans la Bdd public static bool DelProjet(Projet pr) { using (SqlConnection sqlConnect = GetConnection()) { using (SqlCommand sqlCde = new SqlCommand()) { sqlCde.Connection = sqlConnect; string strsql = "DelProjet"; try { sqlCde.CommandType = CommandType.StoredProcedure; sqlCde.CommandText = strsql; sqlCde.Parameters.Add(new SqlParameter("@IdProjet", SqlDbType.Int)).Value = pr.CodeProjet; int n = sqlCde.ExecuteNonQuery(); if (n == 1) { MessageBox.Show("Projet supprimé"); } return(true); } catch (Exception ex) { throw new DAOException(ex.Message); } } } }
// GET: Projets/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Projet projet = db.Projet.Find(id); ProjectsViewModel projetviewmodel = new ProjectsViewModel() { ID = projet.ID, ID_Initiative = projet.ID_Initiative, Nom_projet = projet.Nom_projet, Description = projet.Description, Objectif_projet = projet.Objectif_projet, Date_debut = projet.Date_debut.Value, Date_fin = projet.Date_fin.Value }; if (projet == null) { return(HttpNotFound()); } ViewBag.ID_Initiative = new SelectList(db.Initiatives, "ID", "Nom_init", projetviewmodel.ID_Initiative); return(View(projetviewmodel)); }
internal void GetDeleteProject(Projet SelectedProject) { Projet p = lstProject.Find(s => s.NomProject.Equals(SelectedProject.NomProject)); lstProject.Remove(p); Functions.CreateFileProjet(); }
public void UpdateProject(Projet pr) { var index = lstProject.FindIndex(p => p.NomProject.Equals(pr.NomProject)); lstProject[index] = pr; Functions.CreateFileProjet(); }
public IActionResult Index() { /* * List<Projet> lstProjet = ReferentielManager.Instance.GetAllProjet(); * List<File> lstFile = ReferentielManager.Instance.GetAllFile(); * * if (lstProjet == null) * lstProjet = new List<Projet>(); * * ViewBag.Projet = lstProjet.Count(); * ViewBag.Fichier = (lstFile == null ? 0 : lstFile.Count()); * * ViewBag.getListProgressProject = lstProjet; * */ ViewBag.Projet = 10; ViewBag.Fichier = 10; Projet projet = new Projet() { Id = 1, Description = "test", Date = DateTime.Now, Nom = "Net5", Progress = "23%" }; List <Projet> lst = new List <Projet>(); lst.Add(projet); ViewData["LstProjects"] = lst; return(View()); }
/// <summary> /// Méthode qui permet de créer un nouveau projet avec un client et un commercial pour ref /// </summary> /// <param name="projet"></param> public void InsertProjet(Projet projet) { string SQLQuery = "INSERT INTO projet(refProjet, nom, dateCreation, dateModification, refClient, refCommercial)" + "VALUES (@refProjet, @nom, @dateCreation, @dateModification, @refClient, @refCommercial)"; // Ouverture de la connexion conn.LiteCo.Open(); using (SQLiteCommand command = new SQLiteCommand(SQLQuery, conn.LiteCo)) { try { command.Parameters.AddWithValue("@refProjet", projet.reference); command.Parameters.AddWithValue("@nom", projet.nom); command.Parameters.AddWithValue("@dateCreation", DateTime.Now); command.Parameters.AddWithValue("@dateModification", DateTime.Today); command.Parameters.AddWithValue("@refClient", projet.client.reference); command.Parameters.AddWithValue("@refCommercial", projet.commercial.reference); command.ExecuteNonQuery(); Trace.WriteLine("#### INSERT NOUVEAU PROJET DATA SUCCESS ####"); } catch (SQLiteException ex) { Trace.WriteLine(" \n ################################################# ERREUR INSERTION NOUVEAU PROJET ################################################# \n" + ex.ToString() + "\n"); } } conn.LiteCo.Close(); }
public async Task <IActionResult> Edit(int id, [Bind("ID,nom")] Projet projet) { if (id != projet.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(projet); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProjetExists(projet.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(projet)); }
public void Load() { XmlDocument xmlDoc = new XmlDocument(); // xmlDoc is the new xml document. xmlDoc.LoadXml(GameAsset.text); // load the file. XmlNodeList projetsList = xmlDoc.GetElementsByTagName("projet"); // array of the level nodes. foreach (XmlNode node in projetsList) { taille++; } TabProjets = new Projet[taille]; taille = 0; foreach (XmlNode node in projetsList) { TabProjets[taille] = new Projet(); TabProjets[taille].typeProjet = int.Parse(node.SelectSingleNode("typeProjet").InnerText); TabProjets[taille].name = node.SelectSingleNode("name").InnerText; TabProjets[taille].imagePath = node.SelectSingleNode("imagePath").InnerText; TabProjets[taille].description = node.SelectSingleNode("description").InnerText; TabProjets[taille].tempsRequis = int.Parse(node.SelectSingleNode("temps").InnerText); TabProjets[taille].xpPoste1 = int.Parse(node.SelectSingleNode("xpPoste1").InnerText); TabProjets[taille].xpPoste2 = int.Parse(node.SelectSingleNode("xpPoste2").InnerText); TabProjets[taille].xpPoste3 = int.Parse(node.SelectSingleNode("xpPoste3").InnerText); TabProjets[taille].xpPoste4 = int.Parse(node.SelectSingleNode("xpPoste4").InnerText); print("projet " + (taille + 1) + " chargé"); taille++; } }
public IActionResult Create(string Nom, string Description, List <string> states, List <int> files, List <Task> task) { Projet projet = new Projet(); if (ModelState.IsValid) { projet.Nom = Nom; projet.Description = Description; projet.Date = DateTime.Now; projet.Progress = "0%"; Projet projetResult = ReferentielManager.Instance.AddProjet(projet); //recupertion des utilisateurs foreach (string item in states) { ReferentielManager.Instance.InsertUsersByProjectId(projetResult.Id, item); } // recuperation des fichiers foreach (int item in files) { ReferentielManager.Instance.InsertFilesByProjectId(projetResult.Id, item); } foreach (Task item in task) { Task result = ReferentielManager.Instance.AddTask(item); ReferentielManager.Instance.InsertTaskByProjectId(projetResult.Id, result.Id); } } return(RedirectToAction("Index", "Project")); }
public IActionResult Post([FromBody] Projet projet) { using (var scope = new TransactionScope()) { projet.UserId = new Guid(User.FindFirstValue(ClaimTypes.NameIdentifier)); _projetRepository.InsertProjet(projet); scope.Complete(); } Projet p = _projetRepository.GetProjetByID(projet.Id); //Notification if (p.ChefId != null) { var notification = new Notification { Nom = "Notification", Description = $"{p.Responsable.Nom} {p.Responsable.Prenom}" + "vous a ajouté en tant que chef de projet.", DateCreation = DateTime.Now, SourceId = p.Id, UserId = (Guid)p.ChefId }; //Error _notificationRepository.InsertNotification(notification); _notificationRepository.Notification(notification.UserId, notification); } //return ProjetDTO projetDTO = _mapper.Map <ProjetDTO>(projet); return(new OkObjectResult(projet)); }
public static void ProjetEncours() { List <Projet> lstProj = new List <Projet>(); DataBase.ConnexionToDataBase(); req = "SELECT p.* FROM projet p where DT_FIN_REEL is null;"; dataReader = DataBase.DBSelect(req); while (dataReader.Read()) { Projet p; p = new Projet(dataReader[0].ToString(), dataReader[3].ToString(), dataReader[4].ToString(), dataReader[5].ToString(), dataReader[6].ToString(), dataReader[7].ToString(), Convert.ToDateTime(dataReader[8].ToString()), Convert.ToDateTime(dataReader[9].ToString())); lstProj.Add(p); } DataBase.FermeDataReader(dataReader); sessionUser.setListProj(lstProj); }
public static List <Projet> FindAll() { Projet myItem = null; List <Projet> listItem = new List <Projet>(); StringBuilder mySql = new StringBuilder(); mySql.Append("SELECT "); mySql.Append(GetSelectFields() + " "); mySql.Append("FROM `Projet` projet "); mySql.Append("WHERE 1 "); using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString)) { MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection); myCommand.CommandType = CommandType.Text; myConnection.Open(); using (MySqlDataReader myReader = myCommand.ExecuteReader()) { if (myReader.HasRows) { while (myReader.Read()) { myItem = LoadADO(myReader); listItem.Add(myItem); } } myReader.Close(); } myConnection.Close(); } return(listItem); }
public ProjectControl(Projet project) { _project = project; InitializeComponent(); title.Text = project.nomProjet; this.Focus(); }
public static Projet Update(Projet myItem) { using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString)) { StringBuilder mySql = new StringBuilder(); mySql.Append("UPDATE `Projet` SET "); mySql.Append("`libelle` = @libelle, "); mySql.Append("`idTheme` = @idTheme, "); mySql.Append("`urlProd` = @urlProd, "); mySql.Append("`urlTest` = @urlTest "); mySql.Append("WHERE `id` = @id "); MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection); myCommand.CommandType = CommandType.Text; myCommand.Parameters.AddWithValue("@id", myItem.id); myCommand.Parameters.AddWithValue("@libelle", myItem.libelle); myCommand.Parameters.AddWithValue("@idTheme", myItem.idTheme); myCommand.Parameters.AddWithValue("@urlProd", myItem.urlProd); myCommand.Parameters.AddWithValue("@urlTest", myItem.urlTest); myConnection.Open(); myCommand.ExecuteNonQuery(); myConnection.Close(); } return(myItem); }
public static Projet Load(int id) { Projet myItem = null; StringBuilder mySql = new StringBuilder(); mySql.Append("SELECT "); mySql.Append(GetSelectFields() + " "); mySql.Append("FROM `Projet` projet "); mySql.Append("WHERE `id` = @id "); using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString)) { MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection); myCommand.CommandType = CommandType.Text; myCommand.Parameters.AddWithValue("@id", id); myConnection.Open(); using (MySqlDataReader myReader = myCommand.ExecuteReader()) { if (myReader.HasRows) { myReader.Read(); myItem = LoadADO(myReader); } myReader.Close(); } myConnection.Close(); } return(myItem); }
private void FormGestUserProjet_Load(object sender, EventArgs e) { p = classAdministration.projetModif; lblNomProjet.Text = p.nom_Projet; loadList(); }
public async Task <IActionResult> Post([FromBody] Projet projet) { _context.Projets.Add(projet); await _context.SaveChangesAsync(); return(Ok()); }
private void AssemblerDescription(CVSection environnementSection, Projet projet) { var paragraphs = environnementSection.Nodes.Cast <XmlDocParagraph>().ToList(); var paragraphsText = paragraphs.Select(x => x.GetParagraphText()); projet.Description = String.Join("", paragraphsText); }
/// <summary> /// Function to prepare the display of a single project /// </summary> /// <param name="id">the id of the project which will be displayed</param> /// <returns>a view with it's view model</returns> public IActionResult Project(int?id) { Dal dal = new Dal(); Collaborateurs c = dal.GetCollaborateurs(HttpContext.User.Identity.Name); Projet projectToDisplay = dal.GetProjet((int)id); projectToDisplay.ClientNavigation = dal.GetClient(projectToDisplay.Client); projectToDisplay.ResponsableNavigation = dal.GetCollaborateurs(projectToDisplay.Responsable); projectToDisplay.Tache = dal.GetTaskByProjects(projectToDisplay.Id, c.Id); bool IsProjectManagerTemp = dal.IsProjectManager(HttpContext.User.Identity.Name, projectToDisplay.Id); if (id.HasValue) { pId = (int)id; var model = new ProjectViewModel { Project = projectToDisplay, IsProjectManager = IsProjectManagerTemp }; return(View("Project", model)); } return(View("Error")); }
public async Task <IActionResult> Edit(int id, [Bind("Nom,Description,Pays,SecteurId,BudgetRequis")] Projet projet) { if (id != projet.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(projet); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProjetExists(projet.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } ViewData["SecteurId"] = new SelectList(_context.SecteurActivite, "id", "nomSecteur", projet.SecteurId); return(View(projet)); }
public void Update(Projet Entity) { if (Entity != null) { using (Crownfunding_EditionEntities Context = new Crownfunding_EditionEntities()) { Projet Modifie = new Projet(); Projet AUpdate = Context.Projet.Find(Entity.Id); foreach (PropertyInfo item in AUpdate.GetType().GetProperties()) { var EntityValue = Entity.GetType().GetProperty(item.Name).GetValue(Entity); if (item.GetValue(AUpdate) != EntityValue) { Modifie.GetType().GetProperty(item.Name).SetValue(Modifie, EntityValue); } else { Modifie.GetType().GetProperty(item.Name).SetValue(Modifie, item.GetValue(AUpdate)); } } Context.Entry(AUpdate).CurrentValues.SetValues(Modifie); Context.SaveChanges(); } } else { throw new ArgumentException("La méthode update n'a pas fonctionné"); } }
public JsonResult Update(Projet projet) { ProjetBusiness projetBusiness = new ProjetBusinessImp(); projetBusiness.UpdateProjet(projet); return(Json("true")); }
/// <summary> /// Modify existing values for a project in the DB based on the ID /// </summary> /// <param name="project">The value which should replace the existing ones</param> /// <returns>True is the values have been correctly added</returns> public bool ModifyProject(Projet project) { Projet entity = bdd.Projet.Find(project.Id); if (entity == null) { return(false); } entity.Nom = project.Nom; entity.Debut = project.Debut; entity.Echeance = project.Echeance; entity.Client = project.Client; entity.ClientNavigation = bdd.Client.Find(project.Client); entity.Responsable = project.Responsable; entity.ResponsableNavigation = bdd.Collaborateurs.Find(project.Responsable); if (entity.ResponsableNavigation == null || entity.ClientNavigation == null) { return(false); } bdd.Entry(entity).CurrentValues.SetValues(project); bdd.SaveChanges(); var temp = bdd.Client.Find(project.Id); return(true); }
public static Projet Insert(Projet myItem) { using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString)) { StringBuilder mySql = new StringBuilder(); mySql.Append("INSERT INTO `Projet` "); mySql.Append("(`libelle`, `idTheme`, "); mySql.Append("`urlProd`, `urlTest` )"); mySql.Append(" VALUES "); mySql.Append("(@libelle, @idTheme, "); mySql.Append("@urlProd, @urlTest );"); mySql.Append("SELECT LAST_INSERT_ID(); "); MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection); myCommand.CommandType = CommandType.Text; myCommand.Parameters.AddWithValue("@libelle", myItem.libelle); myCommand.Parameters.AddWithValue("@idTheme", myItem.idTheme); myCommand.Parameters.AddWithValue("@urlProd", myItem.urlProd); myCommand.Parameters.AddWithValue("@urlTest", myItem.urlTest); myConnection.Open(); myItem.id = iZyMySQL.GetIntFromDBInt(myCommand.ExecuteScalar()); myConnection.Close(); } return myItem; }
public static void ProjetEnCoursUSer() { List <Projet> lstProj = new List <Projet>(); DataBase.ConnexionToDataBase(); req = "SELECT Distinct p.* FROM projet p, user_projet up where up.code_projet = p.code_projet and p.DT_FIN_REEL is null and up.id_user = '******' or p.id_user ='******' and p.DT_FIN_REEL is null ;"; dataReader = DataBase.DBSelect(req); while (dataReader.Read()) { Projet p; p = new Projet(dataReader[0].ToString(), dataReader[3].ToString(), dataReader[4].ToString(), dataReader[5].ToString(), dataReader[6].ToString(), dataReader[7].ToString(), Convert.ToDateTime(dataReader[8].ToString()), Convert.ToDateTime(dataReader[9].ToString())); lstProj.Add(p); } DataBase.FermeDataReader(dataReader); sessionUser.setListProj(lstProj); }
public IActionResult Create(Projet item) { _context.Projets.Add(item); _context.SaveChanges(); return(CreatedAtRoute("GetProjet", new { id = item.ProjetID }, item)); }
public void DeleteProjet(int id) { Projet TrouveProjet = bdd.projets.FirstOrDefault(projets => projets.Id == id); bdd.projets.Remove(TrouveProjet); bdd.SaveChanges(); }
public static Projet Insert(Projet myItem) { using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString)) { StringBuilder mySql = new StringBuilder(); mySql.Append("INSERT INTO `Projet` "); mySql.Append("(`libelle`, `idTheme`, "); mySql.Append("`urlProd`, `urlTest` )"); mySql.Append(" VALUES "); mySql.Append("(@libelle, @idTheme, "); mySql.Append("@urlProd, @urlTest );"); mySql.Append("SELECT LAST_INSERT_ID(); "); MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection); myCommand.CommandType = CommandType.Text; myCommand.Parameters.AddWithValue("@libelle", myItem.libelle); myCommand.Parameters.AddWithValue("@idTheme", myItem.idTheme); myCommand.Parameters.AddWithValue("@urlProd", myItem.urlProd); myCommand.Parameters.AddWithValue("@urlTest", myItem.urlTest); myConnection.Open(); myItem.id = iZyMySQL.GetIntFromDBInt(myCommand.ExecuteScalar()); myConnection.Close(); } return(myItem); }
/// <summary> /// Initializes a new instance of the <see cref="ProjetAmelio"/> class. /// </summary> /// <param name="p">The p.</param> public ProjetAmelio(Projet p) { base.Civilite1 = p.Civilite1; base.Civilite2 = p.Civilite2; base.Nom1 = p.Nom1; base.Nom2 = p.Nom2; base.Prenom1 = p.Prenom1; base.Prenom2 = p.Prenom2; base.Adresse = p.Adresse; base.CodePostal = p.CodePostal; base.Ville = p.Ville; base.IdProjet = p.IdProjet; base.Telephone = p.Telephone; base.DateDuMariage = p.DateDuMariage; base.Budget = p.Budget; base.Email = p.Email; }
public static Projet Update(Projet myItem) { using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString)) { StringBuilder mySql = new StringBuilder(); mySql.Append("UPDATE `Projet` SET "); mySql.Append("`libelle` = @libelle, "); mySql.Append("`idTheme` = @idTheme, "); mySql.Append("`urlProd` = @urlProd, "); mySql.Append("`urlTest` = @urlTest "); mySql.Append("WHERE `id` = @id "); MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection); myCommand.CommandType = CommandType.Text; myCommand.Parameters.AddWithValue("@id", myItem.id); myCommand.Parameters.AddWithValue("@libelle", myItem.libelle); myCommand.Parameters.AddWithValue("@idTheme", myItem.idTheme); myCommand.Parameters.AddWithValue("@urlProd", myItem.urlProd); myCommand.Parameters.AddWithValue("@urlTest", myItem.urlTest); myConnection.Open(); myCommand.ExecuteNonQuery(); myConnection.Close(); } return myItem; }
private static Projet LoadADO(MySqlDataReader myReader) { Projet myItem = new Projet(); myItem.id = iZyMySQL.GetIntFromDBInt(myReader["projet_id"]); myItem.libelle = iZyMySQL.GetStringFromDBString(myReader["projet_libelle"]); myItem.idTheme = iZyMySQL.GetIntFromDBInt(myReader["projet_idTheme"]); myItem.urlProd = iZyMySQL.GetStringFromDBString(myReader["projet_urlProd"]); myItem.urlTest = iZyMySQL.GetStringFromDBString(myReader["projet_urlTest"]); return myItem; }