public void ImportData() { try { var dialog = new OpenFileDialog(); var file = dialog.ShowDialog(); if (file == true) { var result = dialog.FileName; var ovimport = new ExcelImport(new DynamicPath(result)); var data = ovimport.ImportDataFromType(result, type); if (data != null) { var count = data.Count; var confirmation = MessageBox.Show($"{count} documents trouvés, voulez-vous continuer!", "Confirmation", MessageBoxButton.YesNo); if (confirmation == MessageBoxResult.Yes) { foreach (var item in data) { item.AddedAtUtc = DateTime.Now; // item.isLocal = false; try { // item.Series = item.MyModule()?.Id; } catch {} item.Save(); item.Submit(); // item.Save(); } //var mi = typeof(BaseMongoRepository).GetMethod("AddMany"); //var gen = mi.MakeGenericMethod(type); //gen.Invoke(DS.db, new object[] { data }); // DS.db.AddMany<t>(data); MessageBox.Show("Terminé"); Actualiser(); } } else { MessageBox.Show("Aucun document trouvé"); return; } } } catch (Exception s) { MessageBox.Show(s.Message); return; } }
public void ImportData() { try { var dialog = new OpenFileDialog(); var file = dialog.ShowDialog(); if (file == true) { var result = dialog.FileName; var ovimport = new ExcelImport(new DynamicPath(result)); var data = ovimport.ImportDataFromType(result, type); if (data != null) { int?count = null; try { count = data.Count(); } catch { } var confirmation = DataHelpers.ShowMessage($"{count} {_("documents trouvés")}, {_("voulez-vous continuer!")}", _("Confirmation"), MessageBoxButton.YesNo); if (confirmation == MessageBoxResult.Yes) { foreach (dynamic item in data) { item.AddedAtUtc = DateTime.Now; // item.isLocal = false; try { // item.Series = item.MyModule()?.Id; item.ForceIgniorValidatUnique = true; if ((item).Save()) { (item).Submit(); } else { throw new Exception(_("une erreur s'est produite!")); } } catch (Exception s) { DataHelpers.ShowMessageError(s); var shouldStop = DataHelpers.ShowMessage(_("une erreur s'est produite voulez-vous annuler?"), _("Erreur"), MessageBoxButton.YesNo, MessageBoxImage.Error); if (shouldStop == MessageBoxResult.Yes) { break; } else { continue; } } // item.Save(); } //var mi = typeof(BaseMongoRepository).GetMethod("AddMany"); //var gen = mi.MakeGenericMethod(type); //gen.Invoke(DS.db, new object[] { data }); // DS.db.AddMany<t>(data); DataHelpers.ShowMessage(_("Terminé")); Actualiser(); } } else { DataHelpers.ShowMessage(_("Aucun document trouvé")); return; } } } catch (Exception s) { DataHelpers.ShowMessage(s.Message); return; } }