protected void Page_Load(object sender, EventArgs e) { if (Session["code_utilisateur"] == null) { Response.Redirect("login.aspx"); } if (!IsPostBack) { // bind chart type names to ddl ddlChartType.DataSource = Enum.GetNames(typeof(SeriesChartType)); ddlChartType.DataBind(); foreach (ListItem ite in ddlChartType.Items) { if (ite.Text == "Column") { ite.Selected = true; } } AstreeDonnees a = new AstreeDonnees(); UtilisateurDB user = a.GetUser(Convert.ToInt16(Session["code_utilisateur"].ToString())); List <statistiquesDB> lsStat = a.GetStatistiques().Where(w => w.Agence == user.code_partenaire.ToString()).ToList(); Session["lstStat"] = lsStat; gv_statistiques.DataSource = lsStat; gv_statistiques.DataBind(); //DataBind(); getAnnee(); getBranche(); getCharte(); } }
private void getBranche() { AstreeDonnees a = new AstreeDonnees(); UtilisateurDB user = a.GetUser(Convert.ToInt16(Session["code_utilisateur"].ToString())); List <statistiquesDB> lsStat = a.GetStatistiques().Where(w => w.Agence == user.code_partenaire.ToString()).ToList(); var lst2 = lsStat.Select(w => w.Branche); List <string> lstBranche = lst2.Distinct().ToList(); List <ListItem> itemsBranche = new List <ListItem>(); itemsBranche.Add(new ListItem("--Choisir--", "--Choisir--")); foreach (string x in lstBranche) { itemsBranche.Add(new ListItem(x, x)); } ddlBranche.Items.AddRange(itemsBranche.ToArray()); }
private void getAnnee() { AstreeDonnees a = new AstreeDonnees(); UtilisateurDB user = a.GetUser(Convert.ToInt16(Session["code_utilisateur"].ToString())); List <statistiquesDB> lsStat = a.GetStatistiques().Where(w => w.Agence == user.code_partenaire.ToString()).ToList(); var lst = lsStat.Select(w => w.Annee); List <double?> lstAnnee = lst.Distinct().ToList(); List <ListItem> itemsAnnee = new List <ListItem>(); itemsAnnee.Add(new ListItem("--Choisir", "--Choisir")); foreach (int x in lstAnnee) { itemsAnnee.Add(new ListItem(x.ToString(), x.ToString())); } ddlAnnee.Items.AddRange(itemsAnnee.ToArray()); }
protected void ddlBranche_SelectedIndexChanged(object sender, EventArgs e) { ddlSousBranche.Items.Clear(); AstreeDonnees a = new AstreeDonnees(); UtilisateurDB user = a.GetUser(Convert.ToInt16(Session["code_utilisateur"].ToString())); List <statistiquesDB> lsStat = a.GetStatistiques().Where(w => w.Agence == user.code_partenaire.ToString()).ToList(); var lst = lsStat.Where(w => w.Branche == ddlBranche.SelectedValue).Select(w => w.SousBranche); List <string> lstSousBranche = lst.Distinct().ToList(); List <ListItem> itemsSousBranche = new List <ListItem>(); itemsSousBranche.Add(new ListItem("--Choisir--", "--Choisir--")); foreach (string x in lstSousBranche) { itemsSousBranche.Add(new ListItem(x, x)); } ddlSousBranche.Items.AddRange(itemsSousBranche.ToArray()); getCharte(); }
private void getCharte() { AstreeDonnees a = new AstreeDonnees(); UtilisateurDB user = a.GetUser(Convert.ToInt16(Session["code_utilisateur"].ToString())); List <statistiquesDB> lsStat = a.GetStatistiques().Where(w => w.Agence == user.code_partenaire.ToString()).ToList(); string annee = ""; if (ddlAnnee.SelectedIndex == 0) { } else { annee = ddlAnnee.SelectedValue; if (ddlBranche.SelectedIndex > 0) { lsStat = a.GetStatistiques().Where(w => (w.Agence == user.code_partenaire.ToString()) && (w.Branche == ddlBranche.SelectedValue) && w.Annee == Convert.ToInt16(annee)).ToList(); } else { lsStat = a.GetStatistiques().Where(w => (w.Annee == Convert.ToInt16(annee) && (w.Agence == user.code_partenaire.ToString()))).ToList(); } gv_statistiques.DataSource = lsStat; gv_statistiques.DataBind(); } string branch = ""; if (ddlBranche.SelectedIndex == 0) { } else { branch = ddlBranche.SelectedValue; if (ddlAnnee.SelectedIndex > 0) { lsStat = a.GetStatistiques().Where(w => (w.Agence == user.code_partenaire.ToString()) && (w.Branche == branch.ToString()) && (w.Annee == Convert.ToInt16(annee))).ToList(); } else { lsStat = a.GetStatistiques().Where(w => (w.Agence == user.code_partenaire.ToString()) && (w.Branche == branch.ToString())).ToList(); } string sousBranch = ""; if (ddlSousBranche.SelectedIndex <= 0) { } else { lsStat = a.GetStatistiques().Where(w => (w.Agence == user.code_partenaire.ToString()) && (w.Branche == branch.ToString()) && (w.SousBranche == ddlSousBranche.SelectedValue.ToString().Trim()) && (w.Annee == Convert.ToInt16(annee))).ToList(); gv_statistiques.DataSource = lsStat; gv_statistiques.DataBind(); } gv_statistiques.DataSource = lsStat; gv_statistiques.DataBind(); } int i = 0; string[] x = new string[lsStat.Count]; decimal[] y = new decimal[lsStat.Count]; decimal[] z = new decimal[lsStat.Count]; decimal[] u = new decimal[lsStat.Count]; decimal[] o = new decimal[lsStat.Count]; string[] b = new string[lsStat.Count]; foreach (statistiquesDB t in lsStat) { if (t.Mois == 1) { x[i] = "Janvier"; } if (t.Mois == 2) { x[i] = "Février"; } if (t.Mois == 3) { x[i] = "Mars"; } if (t.Mois == 4) { x[i] = "Avril"; } if (t.Mois == 5) { x[i] = "Mai"; } if (t.Mois == 6) { x[i] = "Juin"; } if (t.Mois == 7) { x[i] = "Juillet"; } if (t.Mois == 8) { x[i] = "Aout"; } if (t.Mois == 9) { x[i] = "Septembre"; } if (t.Mois == 10) { x[i] = "Octobre"; } if (t.Mois == 11) { x[i] = "Novembre"; } if (t.Mois == 12) { x[i] = "Décembre"; } y[i] = Convert.ToDecimal(t.Sinistre); i = i + 1; //if (ddlAnnee.SelectedValue.) //{ //} chartSinistre.Series["serieSinistre"].Points.DataBindXY(x, y); //chartSinistre.Series["serieSinistre"].ChartType = SeriesChartType.Column; chartSinistre.Series["serieSinistre"].ChartTypeName = ddlChartType.SelectedValue; chartSinistre.ChartAreas["ChartAreaSinistre"].Area3DStyle.Enable3D = cbUse3D.Checked; chartSinistre.ChartAreas["ChartAreaSinistre"].Area3DStyle.Inclination = Convert.ToInt32(rblInclinationAngle.SelectedValue); chartSinistre.Legends["Default"].Enabled = true; } ////Prime i = 0; foreach (statistiquesDB t in lsStat) { // x[i] = t.Mois; z[i] = Convert.ToDecimal(t.Prime); i = i + 1; chartPrime.Series["seriePrime"].Points.DataBindXY(x, z); //chartPrime.Series["seriePrime"].ChartType = SeriesChartType.Column; chartPrime.Series["seriePrime"].ChartTypeName = ddlChartType.SelectedValue; chartPrime.ChartAreas["ChartAreaPrime"].Area3DStyle.Enable3D = cbUse3D.Checked; chartPrime.ChartAreas["ChartAreaPrime"].Area3DStyle.Inclination = Convert.ToInt32(rblInclinationAngle.SelectedValue); chartPrime.Legends["Default"].Enabled = true; } ////Comission i = 0; foreach (statistiquesDB t in lsStat) { u[i] = Convert.ToDecimal(t.Comission); i = i + 1; chartComission.Series["serieComission"].Points.DataBindXY(x, u); //chartPrime.Series["seriePrime"].ChartType = SeriesChartType.Column; chartComission.Series["serieComission"].ChartTypeName = ddlChartType.SelectedValue; chartComission.ChartAreas["ChartAreaComission"].Area3DStyle.Enable3D = cbUse3D.Checked; chartComission.ChartAreas["ChartAreaComission"].Area3DStyle.Inclination = Convert.ToInt32(rblInclinationAngle.SelectedValue); chartComission.Legends["Default"].Enabled = true; } ////SP i = 0; foreach (statistiquesDB t in lsStat) { //x[i] = t.Mois; o[i] = Convert.ToDecimal(t.SP); i = i + 1; chartSP.Series["serieSP"].Points.DataBindXY(x, o); //chartSP.Series["serieSP"].ChartType = SeriesChartType.Column; chartSP.Series["serieSP"].ChartTypeName = ddlChartType.SelectedValue; chartSP.ChartAreas["ChartAreaSP"].Area3DStyle.Enable3D = cbUse3D.Checked; chartSP.ChartAreas["ChartAreaSP"].Area3DStyle.Inclination = Convert.ToInt32(rblInclinationAngle.SelectedValue); chartSP.Legends["Default"].Enabled = true; } // // // // // // // // // // // // // // // // // // // // // // //Sinistre // i = 0; // foreach (statistiquesDB t in lsStat) // { // b[i] = t.Branche; // y[i] = Convert.ToDecimal(t.Sinistre); // i = i + 1; // chartSinistre.Series["serieSinistre"].Points.DataBindXY(b, y); // //chartSinistre.Series["serieSinistre"].ChartType = SeriesChartType.Column; // chartSinistre.Series["serieSinistre"].ChartTypeName = ddlChartType.SelectedValue; // chartSinistre.ChartAreas["ChartAreaSinistre"].Area3DStyle.Enable3D = cbUse3D.Checked; // chartSinistre.ChartAreas["ChartAreaSinistre"].Area3DStyle.Inclination = Convert.ToInt32(rblInclinationAngle.SelectedValue); // chartSinistre.Legends["Default"].Enabled = true; // } // ////Prime // i = 0; // foreach (statistiquesDB t in lsStat) // { // b[i] = t.Branche; // z[i] = Convert.ToDecimal(t.Prime); // i = i + 1; // chartPrime.Series["seriePrime"].Points.DataBindXY(b, z); // //chartPrime.Series["seriePrime"].ChartType = SeriesChartType.Column; // chartPrime.Series["seriePrime"].ChartTypeName = ddlChartType.SelectedValue; // chartPrime.ChartAreas["ChartAreaPrime"].Area3DStyle.Enable3D = cbUse3D.Checked; // chartPrime.ChartAreas["ChartAreaPrime"].Area3DStyle.Inclination = Convert.ToInt32(rblInclinationAngle.SelectedValue); // chartPrime.Legends["Default"].Enabled = true; // } //////Comission //i = 0; // foreach (statistiquesDB t in lsStat) // { // b[i] = t.Branche; // u[i] = Convert.ToDecimal(t.Comission); // i = i + 1; // chartComission.Series["serieComission"].Points.DataBindXY(b, u); // //chartPrime.Series["seriePrime"].ChartType = SeriesChartType.Column; // chartComission.Series["serieComission"].ChartTypeName = ddlChartType.SelectedValue; // chartComission.ChartAreas["ChartAreaComission"].Area3DStyle.Enable3D = cbUse3D.Checked; // chartComission.ChartAreas["ChartAreaComission"].Area3DStyle.Inclination = Convert.ToInt32(rblInclinationAngle.SelectedValue); // chartComission.Legends["Default"].Enabled = true; // } // ////SP // i = 0; // foreach (statistiquesDB t in lsStat) // { // b[i] = t.Branche; // o[i] = Convert.ToDecimal(t.SP); // i = i + 1; // chartSP.Series["serieSP"].Points.DataBindXY(b, o); // //chartSP.Series["serieSP"].ChartType = SeriesChartType.Column; // chartSP.Series["serieSP"].ChartTypeName = ddlChartType.SelectedValue; // chartSP.ChartAreas["ChartAreaSP"].Area3DStyle.Enable3D = cbUse3D.Checked; // chartSP.ChartAreas["ChartAreaSP"].Area3DStyle.Inclination = Convert.ToInt32(rblInclinationAngle.SelectedValue); // chartSP.Legends["Default"].Enabled = true; // } }