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 SaveA_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog
{
Filter = "Excel file (*.xlsx)|*.xlsx",
InitialDirectory = @"C:\Users\lenovo\Desktop\movies"
};
StatAnnee statAnnee = new StatAnnee(Variable, Wilaya);
_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 Anuelles.";
ws.Cells[2, 1] = "La Wilaya :";
ws.Cells[2, 2] = ((WilayaAlgerie)(statAnnee.Wilaya - 1)).ToString();
ws.Cells[3, 1] = "Le variable meteorologique :";
ws.Cells[3, 2] = nomVariable;
ws.Cells[5, 1] = "La valeur maximale :";
ws.Cells[5, 2] = statAnnee.Max.Item4;
ws.Cells[5, 3] = "Atteint le " + statAnnee.Max.Item1 + " " + ((Month)(statAnnee.Max.Item2 - 1)).ToString() + " " + statAnnee.Max.Item3;
ws.Cells[6, 1] = "La valeur minimale :";
ws.Cells[6, 2] = statAnnee.Min.Item4;
ws.Cells[6, 3] = "Atteint le " + statAnnee.Min.Item1 + " " + ((Month)(statAnnee.Min.Item2 - 1)).ToString() + " " + statAnnee.Min.Item3;
ws.Cells[8, 1] = "L'année ";
ws.Cells[8, 2] = "La valeur moyenne ";
int i = 9;
foreach (Tuple <int, float> stat in statAnnee.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();
}
}
