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