void Onb2Click(object sender, RoutedEventArgs e)
{
InsertDataWindow insertdata = new InsertDataWindow(false, cne.Text, EditWindow.current.filiere);
insertdata.Show();
img.Source = null;
img = null;
GC.Collect();
}
private void addStudent_Click(object sender, RoutedEventArgs e)
{
InsertDataWindow ins = new InsertDataWindow(true, "", filiere);
ins.Show();
}
public InsertDataWindow(Boolean ajoute, string cneCard, int selecedFiliere)
{
InitializeComponent();
this.selectedFiliere = selecedFiliere;
this.cneCard = cneCard;
op = new OpenFileDialog();
if (countWindow > 0)
{
currentInsertWindow.Close();
currentInsertWindow = this;
}
countWindow++; // fentres active actuelement
//connexion au server
string SaadServer = "DESKTOP-SL2AUNJ";
connString = "Data Source =" + SaadServer + "; Initial Catalog = Gestion_Etudiant; Integrated Security = true;";
con = new SqlConnection();
con.ConnectionString = connString;
con.Open();
this.ajoute = ajoute;
currentInsertWindow = this;
existingCNE = new List <string>();
SqlCommand comm = new SqlCommand("Select cne From Etudiant", con);
SqlDataReader read = comm.ExecuteReader();
while (read.Read())
{
existingCNE.Add(read.GetString(0));
}
read.Close();
//test si la fenetre est pour l'ajout ou bien pour la modification
if (ajoute)
{
modifier.Visibility = Visibility.Collapsed;
title.Text = "Ajouter un Etudiant";
comm = new SqlCommand("Select * From Etudiant where cne = '" + cneCard + "'", con);
read = comm.ExecuteReader();
while (read.Read())
{
photoPath = read.GetString(5);
}
read.Close();
}
else
{
ajouter.Visibility = Visibility.Hidden;
title.Text = "Modifier cet Etudiant";
//felling the informations of the clicked student to modify
comm = new SqlCommand("Select * From Etudiant where cne = '" + cneCard + "'", con);
read = comm.ExecuteReader();
while (read.Read())
{
cneField.Text = read.GetString(0);
nomField.Text = read.GetString(1);
prenomField.Text = read.GetString(2);
if (read[3].ToString() == "M")
{
sexeComboBox.SelectedIndex = 0;
}
else
{
sexeComboBox.SelectedIndex = 1;
}
dateField.SelectedDate = read.GetDateTime(4);
photoPath = read.GetString(5);
photoExtension = photoPath.Substring(photoPath.LastIndexOf('.'), photoPath.Length - photoPath.LastIndexOf('.'));
emailField.Text = read.GetString(6);
anneeComboBox.SelectedIndex = read.GetInt32(8) - 1;
}
read.Close();
}
}