public EtudiantPage()
{
InitializeComponent();
etudiantOperation = new EtudiantOperationImpl(App.Connection);
filiereOperation = new FiliereOperationImpl(App.Connection);
imageOperationImpl = new ImageOperationImpl(App.Connection);
//image.Source = ImageSource.FromFile(Height > Width ? "icon.png" : "Cute.jpg");
img = new Model.Image();
//traitementImage();
List <Filiere> filieres = filiereOperation.ReadFilieres();
foreach (var fil in filieres)
{
listFiliere.Add(fil.Nom_filiere);
}
picker.ItemsSource = listFiliere;
listEtudiantModel = new ObservableCollection <Etudiant>(etudiantOperation.ReadEtudiants());
listEtudiantModelForView = new ObservableCollection <EtudiantForView>();
listEtudiantModelForView2 = new ObservableCollection <EtudiantForView>();
Remplir();
DisplayAlert("col", listEtudiantModel.Count.ToString(), "pok");
/*foreach (var img in imageOperationImpl.ReadImages())
* {
* img.ImageSource = imageOperationImpl.CreateSource(img.Content);
* }*/
/*foreach (var etu in listEtudiantModel)
* {
* Model.Image i=imageOperationImpl.ReadImage(etu.Image);
*
* }*/
ListEtudiants.ItemsSource = listEtudiantModelForView;
BindingContext = listEtudiantModelForView;
}
public Statistiques()
{
InitializeComponent();
filiereOperation = new FiliereOperationImpl(App.Connection);
etudiantOperationImpl = new EtudiantOperationImpl(App.Connection);
entries = new List <Entry>();
using (SQLite.SQLiteConnection connection = new SQLite.SQLiteConnection(App.DB_PATH1))
{
var etudiants = connection.Table <Etudiant>().OrderBy(o => o.Id_fil).ToList();
int i = 1;
foreach (var fil in filiereOperation.ReadFilieres())
{
int c = etudiants.Count(etu => etu.Id_fil == fil.Id_fil);
string col = "#" + i.ToString() + "c3e" + i.ToString() + "0";
entries.Add(
new Entry(c)
{
Label = fil.Nom_filiere.ToString(),
ValueLabel = c.ToString(),
Color = SKColor.Parse(col)
});
i += 2;
}
/*int idf = etudiants.First<Etudiant>().Id_fil;
*
* int cpt = 1;
* for (int i = 0; i < etudiants.Count; i++)
* {
* if (etudiants.ElementAt<Etudiant>(i).Id_fil == idf) cpt++;
* else
* {
* entries.Add(
* new Entry(cpt)
* {
* Label = idf.ToString(),
* ValueLabel = cpt.ToString(),
* Color = SKColor.Parse("#2c3e50")
* });
* idf = etudiants.ElementAt<Etudiant>(i).Id_fil;
* cpt = 1;
* }
*
* }*/
//string col = "#" + cpt.ToString() + "c3e" + cpt.ToString() + "0";
if (entries != null)
{
chart.Chart = new BarChart {
Entries = entries
}
}
;
}
}
public ModifierFiliere(Filiere f)
{
InitializeComponent();
filireOpration = new FiliereOperationImpl(App.Connection);
f1 = f;
id.Text = f.Id_fil.ToString();
nom.Text = f.Nom_filiere;
resp.Text = f.Responsbale;
date.Date = f.Date_creation;
}
public EtudiantProfil(Etudiant e)
{
InitializeComponent();
etudiantOperation = new EtudiantOperationImpl(App.Connection);
imageOperationImpl = new ImageOperationImpl(App.Connection);
filiereOperationImpl = new FiliereOperationImpl(App.Connection);
etudiant = e;
ee = new EtudiantForView();
ee.Adresse = etudiant.Adresse;
ee.Cne = etudiant.Cne;
ee.Date_naissance = etudiant.Date_naissance;
ee.Id_fil = etudiant.Id_fil;
ee.Image = etudiant.Image;
Model.Image img = new Model.Image();
//DisplayAlert("ss", "e.image="+e.Image.ToString(), "okkk");
img = imageOperationImpl.ReadImage(e.Image);
ImageWithSource imageWithSource = new ImageWithSource(img);
imageWithSource.ImageSource = imageOperationImpl.CreateSource(img.Content);
ee.ImageWithSource = imageWithSource;
ee.Nom = etudiant.Nom;
ee.Prenom = etudiant.Prenom;
ee.Sexe = etudiant.Sexe;
ee.Telephone = etudiant.Telephone;
//etudiant = ee;
nom.Text = etudiant.Nom;
prenom.Text = etudiant.Prenom;
adresse.Text = etudiant.Adresse;
tel.Text = etudiant.Telephone;
Filiere f = new Filiere();
f.Id_fil = ee.Id_fil;
sexe.Text = etudiant.Sexe;
date.Text = etudiant.Date_naissance.ToLongDateString();
image.Source = ee.MyProperty;
try
{
filiere.Text = filiereOperationImpl.ReadFilieres().SingleOrDefault(fil => fil.Id_fil == f.Id_fil).Nom_filiere;
}
catch (Exception ex) { };
}
public AjoutEtudiant()
{
InitializeComponent();
traitementImage();
/*listFiliere.Add("All");
* listFiliere.Add("Info");
* listFiliere.Add("GTR");
* listFiliere.Add("Indus");*/
filiereOperation = new FiliereOperationImpl(App.Connection);
imageOperationImpl = new ImageOperationImpl(App.Connection);
etudiantOperationImpl = new EtudiantOperationImpl(App.Connection);
List <Filiere> filieres = filiereOperation.ReadFilieres();
//listFiliere.Add(" ");
foreach (var fil in filieres)
{
listFiliere.Add(fil.Nom_filiere);
}
picker.ItemsSource = listFiliere;
img = new Model.Image();
}
public AjoutEtudiant(Etudiant e)
{
Etudiant etudiant = e;
InitializeComponent();
filiereOperation = new FiliereOperationImpl(App.Connection);
imageOperationImpl = new ImageOperationImpl(App.Connection);
etudiantOperationImpl = new EtudiantOperationImpl(App.Connection);
/*listFiliere.Add("All");
* listFiliere.Add("Info");
* listFiliere.Add("GTR");
* listFiliere.Add("Indus");*/
List <Filiere> filieres = filiereOperation.ReadFilieres();
//listFiliere.Add(" ");
foreach (var fil in filieres)
{
listFiliere.Add(fil.Nom_filiere);
}
picker.ItemsSource = listFiliere;
traitementImage();
nom.Text = etudiant.Nom;
prenom.Text = etudiant.Prenom;
date.Date = etudiant.Date_naissance;
cne.Text = Convert.ToString(etudiant.Cne);
adresse.Text = etudiant.Adresse;
tel.Text = etudiant.Telephone;
sexe.Text = etudiant.Sexe;
//picker.SelectedItem= filiereOperation.ReadFilieres().SingleOrDefault(fil=>fil.Id_fil== etudiant.Id_fil).Nom_filiere;
img = imageOperationImpl.ReadImage(etudiantOperationImpl.ReadEtudiant(e.Cne).Image);
ImageWithSource imageWithSource = new ImageWithSource(img);
imageWithSource.ImageSource = imageOperationImpl.CreateSource(img.Content);
image.Source = imageWithSource.ImageSource;
}
public AjouterFiliere()
{
InitializeComponent();
filireOpration = new FiliereOperationImpl(App.Connection);
f1 = new Filiere();
}
public FilierePage()
{
InitializeComponent();
filireOpration = new FiliereOperationImpl(App.Connection);
}
