public void chargementsection(DataGridView data1)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("SELECT * FROM section", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementprevision(DataGridView data1)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select Top 100 codeprev,montantprev,codeanne,annee,codecl,codefrais,frais,codeoption,optioneleve,codesection,section,RefEcole,nomEcol from liste_prevision", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementreste(DataGridView data1)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select * from total_paiement", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargement_horaire(GridControl data1, string Annee)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select Top 100 codeaffect,codeclasse,classe,codeop,optioneleve,codejours, design_jours, ccours,heure_debut, heure_fin, codeens, NomEns, postnomEns,codeanne, code_section, section,affectation, annee, RefEcole, nomEcol from horaire where codeanne = '" + Annee + "' ", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargement_detail_horaire(DataGridView data1)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select codedetail,lundi,mardi,mercredi,jeudi,vendredi,samedi from Detail_horaire ", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementEns(DataGridView data1)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select matriculeEns,NomEns,postnomEns,prenomEns,sexeEns,Mail,numtel,Domaine,qualification,etacivil from Enseignant", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementpaiement(GridControl data1, string Annee)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select Top 100 * from view_paiement_vrai where codennee= '" + Annee + "' ", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementeleve(DataGridView data1)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("SELECT codeeleve,nom,postnom,prenom,sexe,dateNaiss,avenue,quartier,commune,ville,nationalite,nom_tutaire,profession_tutaire,num_tutaire,LieuNaiss FROM Eleve", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementcotation(DataGridView data1, string Annee)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select Top 100 * from liste_cote where codeanne = '" + Annee + "'", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementcours(DataGridView data1)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select codecours,cours from cours", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementinscription(DataGridView data1, string Annee)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select top 100 codeinscription,codeeleve,nom,postnom,prenom,Classe,codeoption,optioneleve,annee,codesection,section,division,Designation_classe,Designation_annee,num_tutaire,RefEcole,nomEcol from liste_inscription where annee = '" + Annee + "' ", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public void chargementaffectation(DataGridView data1, string Annee)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select Top 100 codeaffect,maxima,codecours,codeanne,codeens,NomEns,postnomEns,Code_classe,classe,code_section,section,codeop,optioneleve,code_periode,des_periode,Annee,NumCours,RefEcole,nomEcol from liste_affectation where codeanne = '" + Annee + "' ", myconn);
adpt1.Fill(table);
data1.DataSource = table;
myconn.Close();
}
public DataTable chargement_quartier()
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select * from quartier", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
public DataTable chargement_recherche_inscription(string Annee)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select codeinscription,nom,postnom,prenom,Classe,codesection,section,codeoption,optioneleve,annee from liste_inscription where annee = '" + Annee + "' ", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
public DataTable chargementeleve_message(string Annee)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("SELECT * FROM viewEleveMessagerie where annee= '" + Annee + "' ", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
public DataTable chargement_utilisateur()
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select code,nom,fonction,pass from utilisateur1", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
public DataTable chargement_proclamation()
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select * from Pourcentage_General", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
//========================================================================================
//PROCEDURE DE LA MISE A JOURS
public DataTable chargement_mise_a_jours()
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("exec mise_a_jours", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
public DataTable chargement_historique_bibliothque()
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select * from historique_biblitheque", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
public DataTable chargement_recherche_emprunt_livre(string Annee)
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select * from recharche_emprunt where codeanne = '" + Annee + "' ", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
// GESTION DE LA CAISSE
//=========================================================================================
public DataTable chargement_solde_caisse()
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter(" SELECT * FROM return_solde()", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
public DataTable chargement_livre()
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("select Top 100 code_livre,titre_livre,auteur,etat_livre,nombre_livre from livre", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}
public DataTable chargementEns_message()
{
connexion ap = new connexion();
ap.connect();
myconn = new SqlConnection(ap.chemin);
myconn.Open();
DataTable table = new DataTable();
adpt1 = new SqlDataAdapter("SELECT matriculeEns,NomEns,postnomEns,prenomEns,numtel FROM Enseignant ", myconn);
adpt1.Fill(table);
myconn.Close();
return(table);
}