public static void Insert(Satisfaction Satisfaction) { //Connection SqlConnection connection = DataBase.connection; //Requete String requete = @"INSERT INTO Satisfaction (IdentifiantEntretien, Ambiance, Materiel, Secteur, Cadre, Futur, MesIdees, ReunionService, LaDirection, EvolutionMission, MonService, MonSite, AutreSite) VALUES (@IdentifiantEntretien, @Ambiance, @Materiel, @Secteur, @Cadre, @Futur, @MesIdees, @ReunionService, @LaDirection, @EvolutionMission, @MonService, @MonSite, @AutreSite) SELECT SCOPE_IDENTITY() ;"; //Commande SqlCommand commande = new SqlCommand(requete, connection); //Parametres commande.Parameters.AddWithValue("IdentifiantEntretien", Satisfaction.IdentifiantEntretien); commande.Parameters.AddWithValue("Ambiance ", Satisfaction.Ambiance); commande.Parameters.AddWithValue("Materiel ", Satisfaction.Materiel); commande.Parameters.AddWithValue("Secteur ", Satisfaction.Secteur); commande.Parameters.AddWithValue("Cadre ", Satisfaction.Cadre); commande.Parameters.AddWithValue("Futur ", Satisfaction.Futur); commande.Parameters.AddWithValue("MesIdees ", Satisfaction.MesIdees); commande.Parameters.AddWithValue("ReunionService ", Satisfaction.ReunionService); commande.Parameters.AddWithValue("LaDirection ", Satisfaction.LaDirection); commande.Parameters.AddWithValue("EvolutionMission ", Satisfaction.EvolutionMission); commande.Parameters.AddWithValue("MonService ", Satisfaction.MonService); commande.Parameters.AddWithValue("MonSite ", Satisfaction.MonSite); commande.Parameters.AddWithValue("AutreSite ", Satisfaction.AutreSite); //Execution connection.Open(); commande.ExecuteNonQuery(); connection.Close(); }
private void Graphique_Load(object sender, EventArgs e) { chart1.Dock = DockStyle.Fill; chart1.Palette = ChartColorPalette.SeaGreen; chart1.Titles.Add("Title1"); chart1.Titles["Title1"].Text = "Graphique"; ChartArea chartarea = new ChartArea(); chartarea.Name = "NewChartArea"; chart1.ChartAreas.Add("NewChartArea"); Legend legend = new Legend(); legend.Name = "legend1"; legend.Title = "Satisfaction de moi et de la SPPP"; chart1.Legends.Add("legend1"); Series series1 = new Series(); series1.LegendText = "Zone de notification"; series1.Name = "series1"; chart1.Series.Add("series1"); chart1.Series["series1"].Legend = "legend1"; chart1.Series["series1"].IsVisibleInLegend = true; Satisfaction satisfaction = new Satisfaction(); satisfaction.Ambiance = 1 ; satisfaction.Materiel = 2; satisfaction.Secteur= 3; satisfaction.Cadre = 4; satisfaction.Futur = 5; Double[] doubltte = new Double[] { satisfaction.Ambiance , satisfaction.Materiel , satisfaction.Secteur, satisfaction.Cadre, satisfaction.Futur }; String[] strinnng = new String[] { "Ambiance", "Materiel", "Secteur", "Cadre", "Futur" }; chart1.Series["series1"].Points.DataBindXY(strinnng, doubltte); chart1.Series["series1"].ChartType = SeriesChartType.Radar; }
/// <summary> /// Récupère une Satisfaction à partir d'un identifiant de client /// </summary> /// <param name="Identifiant">Identifant de Satisfaction</param> /// <returns>Un Satisfaction </returns> public static Satisfaction Get(Int32 identifiant) { //Connection SqlConnection connection = DataBase.connection; //Commande String requete = @"SELECT Identifiant, Ambiance, Materiel, Secteur, Cadre, Futur, MesIdees, ReunionService, LaDirection, EvolutionMission, MonService, MonSite, AutreSite FROM Satisfaction WHERE Identifiant = @Identifiant"; SqlCommand commande = new SqlCommand(requete, connection); //Paramètres commande.Parameters.AddWithValue("Identifiant", identifiant); //Execution connection.Open(); SqlDataReader dataReader = commande.ExecuteReader(); dataReader.Read(); //1 - Création du Satisfaction Satisfaction satisfaction = new Satisfaction(); satisfaction.IdentifiantEntretien = dataReader.GetInt32(0); satisfaction.Ambiance = dataReader.GetInt16(1); satisfaction.Materiel = dataReader.GetInt16(2); satisfaction.Secteur = dataReader.GetInt16(3); satisfaction.Cadre = dataReader.GetInt16(4); satisfaction.Futur = dataReader.GetInt16(5); satisfaction.MesIdees = dataReader.GetInt16(6); satisfaction.ReunionService = dataReader.GetInt16(7); satisfaction.LaDirection = dataReader.GetInt16(8); satisfaction.EvolutionMission = dataReader.GetString(9); satisfaction.MonService = dataReader.GetString(10); satisfaction.MonSite = dataReader.GetString(11); satisfaction.AutreSite = dataReader.GetString(12); dataReader.Close(); connection.Close(); return satisfaction; }
private void Graphique_Load(object sender, EventArgs e) { chartGraphiqueHierarchie.Dock = DockStyle.Fill; chartGraphiqueHierarchie.Palette = ChartColorPalette.EarthTones; chartGraphiqueHierarchie.Titles.Add("Title1"); chartGraphiqueHierarchie.Titles["Title1"].Text = "Graphique"; ChartArea chartarea = new ChartArea(); chartarea.Name = "NewChartArea"; chartGraphiqueHierarchie.ChartAreas.Add("NewChartArea"); Legend legend = new Legend(); legend.Name = "legend1"; legend.Title = "Ma hiérarchie et moi "; chartGraphiqueHierarchie.Legends.Add("legend1"); Series series1 = new Series(); series1.LegendText = "Zone de notification"; series1.Name = "series1"; chartGraphiqueHierarchie.Series.Add("series1"); chartGraphiqueHierarchie.Series["series1"].Legend = "legend1"; chartGraphiqueHierarchie.Series["series1"].IsVisibleInLegend = true; Satisfaction satisfaction = new Satisfaction(); satisfaction.MesIdees = 3; satisfaction.ReunionService = 2; satisfaction.LaDirection = 4; Double[] doubltte = new Double[] { satisfaction.MesIdees, satisfaction.ReunionService, satisfaction.LaDirection}; String[] strinnng = new String[] { "Mes Idées", "Réunion de Service", "La Direction"}; chartGraphiqueHierarchie.Series["series1"].Points.DataBindXY(strinnng, doubltte); chartGraphiqueHierarchie.Series["series1"].ChartType = SeriesChartType.Radar; }
public static void Update(Satisfaction Satisfaction) { //Connection SqlConnection connection = DataBase.connection; //Requete String requete = @"UPDATE Satisfaction SET (Ambiance=@Ambiance, Materiel=@Materiel, Secteur=@Secteur, Cadre=@Cadre, Futur=@Futur, MesIdees=@MesIdees, ReunionService=@ReunionService, LaDirection=@LaDirection, EvolutionMission=@EvolutionMission, MonService=@MonService, MonSite=@MonSite, AutreSite=@AutreSite) WHERE IdentifiantEntretien=@IdentifiantEntretien ;"; //Commande SqlCommand commande = new SqlCommand(requete, connection); //Parametres commande.Parameters.AddWithValue("IdentifiantEntretien", Satisfaction.IdentifiantEntretien); commande.Parameters.AddWithValue("Ambiance ", Satisfaction.Ambiance); commande.Parameters.AddWithValue("Materiel ", Satisfaction.Materiel); commande.Parameters.AddWithValue("Secteur ", Satisfaction.Secteur); commande.Parameters.AddWithValue("Cadre ", Satisfaction.Cadre); commande.Parameters.AddWithValue("Futur ", Satisfaction.Futur); commande.Parameters.AddWithValue("MesIdees ", Satisfaction.MesIdees); commande.Parameters.AddWithValue("ReunionService ", Satisfaction.ReunionService); commande.Parameters.AddWithValue("LaDirection ", Satisfaction.LaDirection); commande.Parameters.AddWithValue("EvolutionMission ", Satisfaction.EvolutionMission); commande.Parameters.AddWithValue("MonService ", Satisfaction.MonService); commande.Parameters.AddWithValue("MonSite ", Satisfaction.MonSite); commande.Parameters.AddWithValue("AutreSite ", Satisfaction.AutreSite); //Execution connection.Open(); commande.ExecuteNonQuery(); connection.Close(); }
/// <summary> /// Récupère une liste de Satisfaction à partir de la base de données /// </summary> /// <returns>Une liste de client</returns> public static List<Satisfaction> List() { //Récupération de la chaine de connexion //Connection SqlConnection connection = DataBase.connection; //Commande String requete = "SELECT IdentifiantEntretien, Ambiance, Materiel, Secteur, Cadre, Futur, MesIdees, ReunionService, LaDirection, EvolutionMission, MonService, MonSite, AutreSite FROM Satisfaction"; connection.Open(); SqlCommand commande = new SqlCommand(requete, connection); //execution SqlDataReader dataReader = commande.ExecuteReader(); List<Satisfaction> list = new List<Satisfaction>(); while (dataReader.Read()) { //1 - Créer un Satisfaction à partir des donner de la ligne du dataReader Satisfaction satisfaction = new Satisfaction(); satisfaction.IdentifiantEntretien = dataReader.GetInt32(0); satisfaction.Ambiance = dataReader.GetInt16(1); satisfaction.Materiel = dataReader.GetInt16(2); satisfaction.Secteur = dataReader.GetInt16(3); satisfaction.Cadre = dataReader.GetInt16(4); satisfaction.Futur = dataReader.GetInt16(5); satisfaction.MesIdees = dataReader.GetInt16(6); ; satisfaction.ReunionService = dataReader.GetInt16(7); satisfaction.LaDirection = dataReader.GetInt16(8); satisfaction.EvolutionMission = dataReader.GetString(9); satisfaction.MonService = dataReader.GetString(10); satisfaction.MonSite = dataReader.GetString(11); satisfaction.AutreSite = dataReader.GetString(12); //2 - Ajouter ce Satisfaction à la list de client list.Add(satisfaction); } dataReader.Close(); connection.Close(); return list; }