public void StatAnnee()
{
StatAnnee statAnnee = new StatAnnee(Variable, Wilaya);
if (statAnnee.Tableau == null || statAnnee.Tableau.Count < 1)
{
MessageBoxAlert.Show("Manque des données", "Il y'a un manque de donnée dans cette wilaya!");
}
else
{
UserDate.DisplayDateStart = statAnnee.startDate;
UserDate.DisplayDateEnd = statAnnee.endDate;
for (int i = statAnnee.startDate.Year; i <= statAnnee.endDate.Year; i++)
{
System.Windows.Controls.Button bnYear = new System.Windows.Controls.Button {
Margin = new Thickness(3, 0, 3, 3), Style = this.FindResource("AccentedSquareButtonStyle") as System.Windows.Style, Content = i.ToString()
};
bnYear.Click += BnYear_Click;
wrapYear.Children.Add(bnYear);
}
if (Variable != 1)
{
Diagramme diagramme = new Diagramme(statAnnee.Tableau)
{
Height = 300, Width = 650
};
Courbe courbe = new Courbe(statAnnee.Tableau)
{
Height = 300, Width = 650
};
TabViewAD.Content = diagramme;
TabViewAC.Content = courbe;
Moy.Text = ((int)statAnnee.moyenne).ToString() + " " + UniteMesure;
Record2.Text = "Max " + statAnnee.Max.Item4 + " " + UniteMesure;
Record1.Text = "Min " + statAnnee.Min.Item4 + " " + UniteMesure;
}
else
{
StatAnnee statAnnee1 = new StatAnnee(2, Wilaya);
Doublecourbe courbe = new Doublecourbe(statAnnee.Tableau, statAnnee1.Tableau)
{
Height = 300, Width = 650
};
TabViewAC.Content = courbe;
Moy.Text = ((int)((statAnnee.moyenne + statAnnee1.moyenne) / 2)).ToString() + " " + UniteMesure;
Record2.Text = "Max " + statAnnee1.Max.Item4 + " " + UniteMesure + " " + statAnnee1.Max.Item3 + " " + (Month)(statAnnee1.Max.Item2 - 1) + " " + statAnnee1.Max.Item1;
Record1.Text = "Min " + statAnnee.Min.Item4 + " " + UniteMesure + " " + statAnnee.Min.Item3 + " " + (Month)(statAnnee.Min.Item2 - 1) + " " + statAnnee.Min.Item1;
}
}
}
private void SaveJ_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog
{
Filter = "Excel file (*.xlsx)|*.xlsx",
InitialDirectory = @"C:\Users\lenovo\Desktop\movies"
};
StatJour statJour = new StatJour(Variable, Wilaya, AnneeJour, Mois);
_Application excel = new _Excel.Application();
if (saveFileDialog.ShowDialog() == true)
{
string filename = System.IO.Path.GetFileName(saveFileDialog.FileName);
String path = System.IO.Path.GetDirectoryName(saveFileDialog.FileName);
Workbook wb = excel.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
Worksheet ws = wb.Worksheets[1];
ws.Cells[1, 1] = "Les statistiques journaliere.";
ws.Cells[2, 1] = "La Wilaya :";
ws.Cells[2, 2] = ((WilayaAlgerie)(statJour.Wilaya - 1)).ToString();
ws.Cells[3, 1] = "Le variable meteorologique :";
ws.Cells[3, 2] = nomVariable;
ws.Cells[4, 1] = "L'année :";
ws.Cells[4, 2] = statJour.Annee;
ws.Cells[5, 1] = "Le mois :";
ws.Cells[5, 2] = ((Month)(statJour.Mois - 1)).ToString();
ws.Cells[7, 1] = "La valeur maximale :";
ws.Cells[7, 2] = statJour.Max.Item2;
ws.Cells[7, 3] = "Atteint le " + statJour.Max.Item1 + " " + ((Month)(statJour.Mois - 1)).ToString();
ws.Cells[8, 1] = "La valeur minimale :";
ws.Cells[8, 2] = statJour.Min.Item2;
ws.Cells[8, 3] = "Atteint le " + statJour.Min.Item1 + " " + ((Month)(statJour.Mois - 1)).ToString();
ws.Cells[10, 1] = "Le jour";
ws.Cells[10, 2] = "La valeur ";
int i = 11;
foreach (Tuple <int, float> stat in statJour.Tableau)
{
ws.Cells[i, 1] = stat.Item1;
ws.Cells[i, 2] = stat.Item2;
i++;
}
MessageBoxAlert.Show("Fin du sauvgarde", "Les Resultats sont bien enregistrés \n Le chemin du fichier : " + path + "\\" + filename);
excel.DisplayAlerts = false;
wb.SaveAs(path + "\\" + filename);
wb.Close();
excel.Quit();
}
}
public void StatJour()
{
StatJour statJour = new StatJour(Variable, Wilaya, AnneeJour, Mois);
if (statJour.Tableau == null || statJour.Tableau.Count < 1)
{
MessageBoxAlert.Show("Manque des données", "Il y'a un manque de donnée dans ce mois!");
}
else
{
if (Variable != 1)
{
Diagramme diagramme = new Diagramme(statJour.Tableau)
{
Height = 300, Width = 650
};
Courbe courbe = new Courbe(statJour.Tableau)
{
Height = 300, Width = 650
};
TabViewJD.Content = diagramme;
TabViewJC.Content = courbe;
Record2J.Text = "Max " + statJour.Max.Item2 + " " + UniteMesure;
Record1J.Text = "Min " + statJour.Min.Item2 + " " + UniteMesure;
}
else
{
StatJour statJour1 = new StatJour(2, Wilaya, AnneeJour, Mois);
Doublecourbe courbe = new Doublecourbe(statJour.Tableau, statJour1.Tableau)
{
Height = 300, Width = 650
};
TabViewJC.Content = courbe;
Record2J.Text = "Max " + statJour1.Max.Item2 + " " + UniteMesure + " " + AnneeJour + " " + (Month)(Mois - 1) + " " + statJour1.Max.Item1;
Record1J.Text = "Min " + statJour.Min.Item2 + " " + UniteMesure + " " + AnneeJour + " " + (Month)(Mois - 1) + " " + statJour.Min.Item1;
}
Grid3text.Text = (Month)(Mois - 1) + "," + AnneeJour;
Btn3text.Text = (Month)(Mois - 1) + "," + AnneeJour;
}
}
public void StatMois()
{
StatMois statMois = new StatMois(Variable, Wilaya, AnneeMon);
if (statMois.Tableau == null || statMois.Tableau.Count < 1)
{
MessageBoxAlert.Show("Manque des données", "Il y'a un manque de donnée dans cet année!");
}
else
{
if (Variable != 1)
{
Diagramme diagramme = new Diagramme(statMois.Tableau)
{
Height = 300, Width = 650
};
Courbe courbe = new Courbe(statMois.Tableau)
{
Height = 300, Width = 650
};
TabViewMD.Content = diagramme;
TabViewMC.Content = courbe;
Record2M.Text = "Max " + statMois.Max.Item3 + " " + UniteMesure;
Record1M.Text = "Min " + statMois.Min.Item3 + " " + UniteMesure;
}
else
{
StatMois statMois1 = new StatMois(2, Wilaya, AnneeMon);
Doublecourbe courbe = new Doublecourbe(statMois.Tableau, statMois1.Tableau)
{
Height = 300, Width = 650
};
TabViewMC.Content = courbe;
Record2M.Text = "Max " + statMois1.Max.Item3 + " " + UniteMesure + " " + AnneeMon + " " + (Month)(statMois1.Max.Item2 - 1) + " " + statMois1.Max.Item1;
Record1M.Text = "Min " + statMois.Min.Item3 + " " + UniteMesure + " " + AnneeMon + " " + (Month)(statMois.Min.Item2 - 1) + " " + statMois.Min.Item1;
}
Grid2text.Text = AnneeMon + "";
Bouton2text.Text = AnneeMon + "";
}
}
