private async Task<object> LoadFormData(IForm formData, ISpreadsheetControl spreadsheetControl)
{
var data = await Repo.GetFile(formData.file_id);
var excelData = data != null ? data.contents : null;
if (excelData == null)
{
this.ShowFlyoutMessageBox("Информация", "Не удалось загрузить данные формы", FlyoutCommand.OK);
spreadsheetControl.CreateNewDocument();
return null;
}
using (var ms = new MemoryStream(excelData))
{
var format = DocumentFormat.OpenXml;
spreadsheetControl.LoadDocument(ms, format);
spreadsheetControl.Document.History.IsEnabled = true;
spreadsheetControl.Document.Worksheets.ActiveWorksheet = spreadsheetControl.Document.Worksheets.FirstOrDefault();
}
return null;
}
private async Task<object> LoadTemplate(form form, ISpreadsheetControl spreadsheetControl)
{
if (form.template_file_id == null)
{
this.ShowFlyoutMessageBox("Информация", string.Format("У формы {0} отсутствует шаблон", form), FlyoutCommand.OK);
spreadsheetControl.CreateNewDocument();
return null;
}
var template = await Repo.GetFile(form.template_file_id.Value);
var excelData = template != null ? template.contents : null;
if (excelData == null)
{
this.ShowFlyoutMessageBox("Информация", "Не удалось загрузить шаблон", FlyoutCommand.OK);
spreadsheetControl.CreateNewDocument();
return null;
}
using (var ms = new MemoryStream(excelData))
{
var format = DocumentFormat.OpenXml;
spreadsheetControl.LoadDocument(ms, format);
spreadsheetControl.Document.History.IsEnabled = true;
spreadsheetControl.Document.Worksheets.ActiveWorksheet = spreadsheetControl.Document.Worksheets.FirstOrDefault();
}
return null;
}