private void Ajouter_Enseignant_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
Dal_Departement Dal_Dept = new Dal_Departement();
dt = Dal_Dept.GetAllDepartementsDataTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
this.Cbx_Dept.Items.Add(dt.Rows[i]["Code"]);
}
}
private void Btn_Importer_Click(object sender, EventArgs e)
{
var fileContent = string.Empty;
var filePath = string.Empty;
using (OpenFileDialog Ofd = new OpenFileDialog()
{
Filter = "Fichiers Excel | *.xls; *.xlsx; *.xlsm", ValidateNames = true, Multiselect = false
})
{
if (Ofd.ShowDialog() == DialogResult.OK)
{
//Get the path of specified file
filePath = Ofd.FileName;
Dal_Departement Dal_Dept = new Dal_Departement();
List <Departements> DeptList = Dal_Dept.GetAllDepartementsList();
Dal_Ens.GetDataFromExcelFile(filePath, out MydataTabX, out MydataTabY, out MydataTabA, out MydataTabB, out MydataTabC);
for (int i = 0; i < MydataTabA.Length; i++)
{
Departements Dept = new Departements(MydataTabB[i], MydataTabC[i]);
if (!DeptList.Contains(Dept))
{
Dal_Dept.AddDepartement(Dept);
}
Enseignants Ens = new Enseignants(MydataTabX[i], MydataTabY[i], MydataTabA[i], "En cours", Dept);
Dal_Ens.AddEnseignant(Ens);
fillDgvEns();
}
MessageBox.Show("Données importées avec succès", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
/* //Read the contents of the file into a stream
* var fileStream = Ofd.OpenFile();
*
* using (StreamReader reader = new StreamReader(fileStream))
* {
* fileContent = reader.ReadToEnd();
* }
*/
}
}
// MessageBox.Show(fileContent, "File Content at path: " + filePath, MessageBoxButtons.OK);
}
