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;
}
}
