public static double GetMoyenneModule(int Num)
{
double Nds = 0, Nexam = 0, MoyMod;
cmd = new MySqlCommand(" Select DS, Examen from notes where IdEtudiant = ?", Connexion.Connect());
MySqlParameter P = new MySqlParameter("NumInscription", Num);
cmd.Parameters.Add(P);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Nds = reader.GetDouble("DS");
Nexam = reader.GetDouble("Examen");
}
MoyMod = (0.3 * Nds) + (0.7 * Nexam);
reader.Close();
return(MoyMod);
}
public static void AddNotes()
{
Notes N = new Notes(), Nt = new Notes();
Nt = ExamenView.GetNotesEtudiant(N);
cmd = new MySqlCommand(" Insert into notes values (@IdEtudiant,@IdModule,@DS,@Examen)", Connexion.Connect());
cmd.Parameters.AddWithValue("@IdEtudiant", Nt.IdEtudiant);
cmd.Parameters.AddWithValue("@IdModule", Nt.IdModule);
cmd.Parameters.AddWithValue("@DS", Nt.DS);
cmd.Parameters.AddWithValue("@Examen", Nt.Examen);
cmd.ExecuteNonQuery();
}
public static Etudiant GetEtudiant(int Num)
{
Etudiant Et = new Etudiant();
cmd = new MySqlCommand(" select * from etudiant where NumInscription = ?", Connexion.Connect());
cmd.Parameters.Add(new MySqlParameter("NumInscription", Num));
lire = cmd.ExecuteReader();
while (lire.Read())
{
Et.NumInst = lire.GetInt32("NumInscription");
Et.Nom = lire.GetString("Nom");
Et.DateNaiss = lire.GetDateTime("DateNaiss");
}
Console.WriteLine(" Num : " + Et.NumInst + "\n Nom : " + Et.Nom + "\n Date naissance : " + Et.DateNaiss);
lire.Close();
return(Et);
}
public static void AddEtudiant()
{
Etudiant E = new Etudiant();
Etudiant Et = new Etudiant();
Et = ExamenView.GetInfoEtudiant(E);
cmd = new MySqlCommand(" Insert into etudiant values (@NumInscription, @Nom, @DateNaissance)", Connexion.Connect());
cmd.Parameters.AddWithValue("@NumInscription", Et.NumInst);
cmd.Parameters.AddWithValue("@Nom", Et.Nom);
cmd.Parameters.AddWithValue("@DateNaissance", Et.DateNaiss);
cmd.ExecuteNonQuery();
}
public static void DetailsNotes(int Num)
{
int code = 1;
cmd = new MySqlCommand(" Select m.Intitule,n.DS,n.Examen from module m inner join notes n on m.Code = n.IdModule where IdEtudiant = ?", Connexion.Connect());
MySqlParameter P = new MySqlParameter("IdEtudiant", Num);
cmd.Parameters.Add(P);
MySqlDataReader Lire = cmd.ExecuteReader();
Console.WriteLine(" Code Titre DS Examen Moyenne");
while (Lire.Read())
{
Console.WriteLine(" " + code + " " + Lire["Intitule"].ToString() + " " + Lire.GetDouble("DS") + " " + Lire.GetDouble("Examen") + " " + ExamenDAL.GetMoyenneModule(Num));
code++;
}
Lire.Close();
}
public static void En_Tete(int Num)
{
cmd = new MySqlCommand(" Select * from etudiant where NumInscription = ?", Connexion.Connect());
MySqlParameter P = new MySqlParameter("NumInscription", Num);
cmd.Parameters.Add(P);
MySqlDataReader Lire = cmd.ExecuteReader();
while (Lire.Read())
{
Console.WriteLine(" Num inscription : " + Lire.GetDouble("NumInscription"));
Console.WriteLine(" Nom : " + Lire.GetString("Nom"));
Console.WriteLine(" Date de naissance : " + Lire.GetString("DateNaissance"));
}
Lire.Close();
}