public List <Template> LoadTemplates()
{
try
{
return(TemplateDocument.Load());
}
catch (Exception ex)
{
AddIn.Error(ex);
return(new List <Template>());
}
}
public override void Execute()
{
DialogHost dialogHost = new DialogHost();
var templates = TemplateDocument.Load();
var viewModel = new SqlTemplateOptionViewModel(templates);
if (dialogHost.Show <SqlTemplateOptionView>(viewModel) == DialogResult.OK)
{
TemplateDocument.Save(viewModel.Templates.ToList());
}
}
public static void Save(List <Template> templates)
{
try
{
TemplateDocument doc = new TemplateDocument();
doc.Templates.AddRange(templates);
File.WriteAllText(_templatePath, doc.ToXml());
SqlInsertTemplateAction.Templates = templates;
}
catch (Exception ex)
{
EventLog.WriteEntry("Laan SSMS AddIn", ex.ToString(), EventLogEntryType.Error);
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
}
public static void Save(List<Template> templates)
{
try
{
TemplateDocument doc = new TemplateDocument();
doc.Templates.AddRange(templates);
File.WriteAllText(_templatePath, doc.ToXml());
SqlTemplating.Templates = templates;
}
catch (Exception ex)
{
EventLog.WriteEntry("Laan SSMS AddIn", ex.ToString(), EventLogEntryType.Error);
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK);
}
}
