private void ImportInterop()
{
Excel.Workbook workbook;
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
try
{
workbook = app.Workbooks.Open(OpenFile());
}
catch (Exception ex)
{
return;
}
string wk = "[" + Xlsheetname + "$]";
Excel.Worksheet worksheet = NameXl(workbook, wk);
var range = worksheet.UsedRange;
try
{
int i = 0;
pBChargerEtu.Visibility = Visibility.Visible;
pBChargerEtu.Maximum = range.Rows.Count - 1;
for (int row = 0; row < range.Rows.Count - 1; row++)
{
pBChargerEtu.Dispatcher.Invoke(() => pBChargerEtu.Value = row, System.Windows.Threading.DispatcherPriority.Background);//rr
//Apb.Value = Apb.Value + 1;
System.Threading.Thread.Sleep(1);
if (range.Cells[row + 1, 1].Value.ToString() != "")
{
string[] data = new string[range.Columns.Count];
for (int col = 0; col <= range.Columns.Count - 1; col++)
{
if (col != 3)
{
data[col] = range.Cells[row + 2, col + 1].Value.ToString();;
//MessageBox.Show(range.Cells[row+2, col+1].Value.ToString());
}
else
{
data[col] = range.Cells[row + 2, col + 1].Value.ToString();
//data[col] = DateTime.ParseExact(range.Cells[row + 2, col + 1].Value, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString();
}
}
try
{
String d = DateTime.ParseExact(data[3], "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None).ToString("yyyy-MM-dd");
if (Controleur.Vmodele.InsertEtudiant(data[0], data[1], d, data[2], Hash(GenerateMdp()), data[4], data[5]) == 1)
{
i++;
try
{
string mdp = GenerateMdp();
Controleur.Vmodele.ChangePassword(Controleur.Vmodele.ReturnLoginEmailLastId().Rows[0].ItemArray.ElementAt(0).ToString(), Hash(mdp));
Mail.CreateMessage(Controleur.Vmodele.ReturnLoginEmailLastId().Rows[0].ItemArray.ElementAt(1).ToString(), "Réinitialisation de votre mot de passe Chevloc", "Bonjour " + Controleur.Vmodele.ReturnLoginEmailLastId().Rows[0].ItemArray.ElementAt(2).ToString() + ",\n\nVoici votre nouveau mot de passe : " + mdp + "\nVous pourrez le changer sur nore site " + Mail.site + ", rubrique \"profil\".\n\nL'équipe Chevloc");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
catch (Exception ex)
{
}
}
}
workbook.Close();
app.Quit();
KillProcess();
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(app);
MessageBox.Show("Insertion de " + i + " étudiants.", "", MessageBoxButton.OK);
pBChargerEtu.Visibility = Visibility.Hidden;
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}