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