public static void SaveEtudiant(DataRow etudiantRow)
{
using (ConnectdsTableAdapters.etudiantTableAdapter etudiantAdpt = new ConnectdsTableAdapters.etudiantTableAdapter())
{
etudiantAdpt.Update(etudiantRow);
}
}
/// <summary>
/// Retourne la liste des étudiants disponibles en fonction des dates d'un job
/// </summary>
/// <param name="debut"></param>
/// <param name="fin"></param>
/// <returns></returns>
public static List <Connectds.etudiantRow> GetPeriodeList(DateTime debut, DateTime fin)
{
Connectds ds = new Connectds();
using (ConnectdsTableAdapters.etudiantTableAdapter etudiantAdpt = new ConnectdsTableAdapters.etudiantTableAdapter())
{
etudiantAdpt.Fill(ds.etudiant);
}
using (ConnectdsTableAdapters.periodeTableAdapter periodeAdpt = new ConnectdsTableAdapters.periodeTableAdapter())
{
periodeAdpt.Fill(ds.periode);
}
List <Connectds.periodeRow> periodeList = ds.periode.Where(p => p.debut_periode <= debut && p.fin_periode >= fin).ToList();
List <Connectds.etudiantRow> etudiantList = ds.etudiant.ToList();
List <Connectds.etudiantRow> rechercheEtudiantList = new List <Connectds.etudiantRow>();
foreach (var periode in periodeList)
{
foreach (var etudiant in etudiantList)
{
if (periode.etudiant_id == etudiant.etudiant_id)
{
rechercheEtudiantList.Add(etudiant);
}
}
}
return(rechercheEtudiantList);
}
public static void AddEtudiant(Connectds.etudiantRow etudiantRow)
{
using (ConnectdsTableAdapters.etudiantTableAdapter etudiantAdpt = new ConnectdsTableAdapters.etudiantTableAdapter())
{
etudiantAdpt.Insert(etudiantRow.nom_etudiant, etudiantRow.prenom_etudiant, etudiantRow.date_naissance_etudiant, etudiantRow.sexe_etudiant, etudiantRow.adresse_etudiant, etudiantRow.telephone_etudiant, etudiantRow.email_etudiant, etudiantRow.langues_etudiant,
etudiantRow.type_etudes_etudiant, etudiantRow.annee_scolaire_etudiant, etudiantRow.ecole_etudiant, etudiantRow.permis_voiture_etudiant, etudiantRow.hobbies_etudiant, etudiantRow.experience_etudiant, etudiantRow.domaine_recherche_etudiant,
etudiantRow.remarque_etudiant, etudiantRow.statut_etudiant, etudiantRow.date_creation_etudiant);
}
}
public static Connectds.etudiantDataTable GetEtudiantDT()
{
Connectds.etudiantDataTable dt = new Connectds.etudiantDataTable();
using (ConnectdsTableAdapters.etudiantTableAdapter etudiantAdpt = new ConnectdsTableAdapters.etudiantTableAdapter())
{
etudiantAdpt.Fill(dt);
}
return(dt);
}
public static Connectds.etudiantRow GetEtudiant(int etudiant_id)
{
Connectds.etudiantDataTable etudiantDT = new Connectds.etudiantDataTable();
using (ConnectdsTableAdapters.etudiantTableAdapter etudiantAdpt = new ConnectdsTableAdapters.etudiantTableAdapter())
{
etudiantAdpt.Fill(etudiantDT);
}
Connectds.etudiantRow etudiantRow = etudiantDT.FindByetudiant_id(etudiant_id);
return(etudiantRow);
}
public static void DeleteEtudiant(int etudiant_id)
{
Connectds.etudiantDataTable etudiantDT = new Connectds.etudiantDataTable();
using (ConnectdsTableAdapters.etudiantTableAdapter etudiantAdpt = new ConnectdsTableAdapters.etudiantTableAdapter())
{
etudiantAdpt.Fill(etudiantDT);
Connectds.etudiantRow etudiantRow = etudiantDT.FindByetudiant_id(etudiant_id);
etudiantRow.Delete();
etudiantAdpt.Update(etudiantDT);
}
}
/// <summary>
/// Remplit un dataset de toutes les tables de la Base de données
/// </summary>
/// <returns></returns>
public static Connectds GetDS()
{
Connectds ds = new Connectds();
using (ConnectdsTableAdapters.entrepriseTableAdapter entrepriseAdpt = new ConnectdsTableAdapters.entrepriseTableAdapter())
{
entrepriseAdpt.Fill(ds.entreprise);
}
using (ConnectdsTableAdapters.etudiantTableAdapter etudiantAdpt = new ConnectdsTableAdapters.etudiantTableAdapter())
{
etudiantAdpt.Fill(ds.etudiant);
}
using (ConnectdsTableAdapters.jobTableAdapter jobAdpt = new ConnectdsTableAdapters.jobTableAdapter())
{
jobAdpt.Fill(ds.job);
}
using (ConnectdsTableAdapters.periodeTableAdapter periodeAdpt = new ConnectdsTableAdapters.periodeTableAdapter())
{
periodeAdpt.Fill(ds.periode);
}
return(ds);
}
