public void CreateCallSpecs()
{
var names = CannedMessages.GetResources();
List <string> known = new List <string>();
foreach (var name in names)
{
if (name.EndsWith(".json"))
{
var info = CannedMessages.GetResourceFormat(name);
string resourceFormat = info.ResourceFormat;
int index = resourceFormat.IndexOf('?');
if (index >= 0)
{
resourceFormat = resourceFormat.Substring(0, index);
}
string key = info.Method + ": " + resourceFormat;
if (!known.Contains(key))
{
known.Add(key);
Console.WriteLine("{0}\t\t{1}\t\t{2}", resourceFormat, info.Method, info.RequestUrl);
}
;
}
}
}
private void cannedMessagesToolStripMenuItem_Click(object sender, EventArgs e)
{
using (CannedMessages f = new CannedMessages())
{
f.ShowDialog(this);
}
}
/// <summary>
/// Return an existing record for email purposes. There is
/// no exception handling to assert if the record requested exists
/// as the intent is to work with primary keys that exists.
/// </summary>
/// <param name="pIdentifier"></param>
/// <returns></returns>
public CannedMessages Read(int pIdentifier)
{
mHasException = false;
var result = new CannedMessages();
using (var cn = new SqlConnection()
{
ConnectionString = ConnectionString
})
{
using (var cmd = new SqlCommand()
{
Connection = cn
})
{
cmd.CommandText = $"SELECT [Description],HtmlMessage,TextMessage FROM EmailTesting.dbo.CannedMessages WHERE id = {pIdentifier}";
try
{
cn.Open();
var reader = cmd.ExecuteReader();
reader.Read();
result.Description = reader.GetString(0);
result.HtmlMessage = reader.GetString(1);
result.TextMessage = reader.GetString(2);
}
catch (Exception e)
{
mHasException = true;
mLastException = e;
}
}
}
return(result);
}
private void cannedMessagesToolStripMenuItem_Click(object sender, EventArgs e)
{
using (CannedMessages f = new CannedMessages())
{
f.ShowDialog(this);
}
}
