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