private void GetExcelImportTemplate()
{
string excelFileTemplate = ModelInfoSelected.ModelName + "_Template_" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
var dialog = new SaveFileDialog()
{
FileName = excelFileTemplate,
Filter = "Excel Files(*.xlsx)|*.xlsx|All(*.*)|*"
};
if (dialog.ShowDialog() == true)
{
DataTable tempTable = (new DataTable()).FromHeaders(ModelInfoSelected.ModelProperties);
bool exportResult = ExcelProvider.Export(tempTable, dialog.FileName);
BBCodeBlock codeBlock = new BBCodeBlock();
if (exportResult)
{
codeBlock.BBCode = string.Format("Succesfully imported excel {0} model data template.\nFile: {1}.\n[color=Green]Open file?[/color]", ModelInfoSelected.ModelName, dialog.FileName);
var dlg = new ModernDialog
{
Title = "Import Excel Template",
Content = codeBlock
};
dlg.Buttons = new[] { dlg.YesButton, dlg.NoButton };
bool?result = dlg.ShowDialog();
if (result != null && result.Value)
{
Process.Start(dialog.FileName);
}
}
else
{
codeBlock.BBCode = string.Format("Error importing excel {0} model data template.\nFile: {1}.\n[color=Red]Please try again.[/color]", ModelInfoSelected.ModelName, dialog.FileName);
var dlg = new ModernDialog
{
Title = "Import Excel Template",
Content = codeBlock
};
dlg.Buttons = new[] { dlg.OkButton };
dlg.ShowDialog();
}
}
}
private void ExportToFile(object parameter)
{
if (parameter == null)
{
return;
}
string exportType = parameter.ToString().ToUpper();
string filter = string.Empty;
switch (exportType)
{
case "EXCEL":
exportType = exportType.ToLower();
filter = "Excel Files(*.xlsx)|*.xlsx|All(*.*)|*";
break;
case "CSV":
exportType = exportType.ToLower();
filter = "Csv Files(*.csv)|*.csv|All(*.*)|*";
break;
default:
return;
}
string excelFile = ModelInfoSelected.ModelName + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
var dialog = new SaveFileDialog()
{
FileName = excelFile,
Filter = filter
};
if (dialog.ShowDialog() == true)
{
excelFile = dialog.FileName;
bool exportResult = false;
string title = string.Empty;
if (exportType == "excel")
{
exportResult = ExcelProvider.Export(ModuleItems, excelFile);
title = "Export To Excel";
}
else
{
exportResult = CsvProvider.Export(ModuleItems, excelFile);
title = "Export To Csv";
}
BBCodeBlock codeBlock = new BBCodeBlock();
if (exportResult)
{
codeBlock.BBCode = string.Format("Succesfully exported {0} model data to {1}.\nFile: {2}.\n[color=Green]Open file?[/color]", ModelInfoSelected.ModelName, exportType, excelFile);
var dlg = new ModernDialog
{
Title = title,
Content = codeBlock
};
dlg.Buttons = new[] { dlg.YesButton, dlg.NoButton };
bool?result = dlg.ShowDialog();
if (result != null && result.Value)
{
Process.Start(excelFile);
}
}
else
{
codeBlock.BBCode = string.Format("Error exporting {0} model data to {1}.\nFile: {2}.\n[color=Red]Please try again.[/color]", ModelInfoSelected.ModelName, exportType, excelFile);
var dlg = new ModernDialog
{
Title = title,
Content = codeBlock
};
dlg.Buttons = new[] { dlg.OkButton };
dlg.ShowDialog();
}
}
}
