public static MailCommand GetMailCommand(MailCommandDataSet mailCommandDataSet, string command)
{
MailCommand result = new MailCommand();
DataRow[] dr = mailCommandDataSet.Tables[0].Select("Command='" + command + "'");
if (dr.Length == 0)
{
throw new Exception("No command found for " + command);
}
if (dr.Length > 1)
{
throw new Exception("Too many command found for " + command);
}
result.Command = dr[0]["Command"].ToString();
result.Connection = dr[0]["Connection"].ToString();
result.Description = dr[0]["Description"].ToString();
result.SqlCommandText = dr[0]["SqlCommandText"].ToString();
result.CommandType = CommandType.MailCommand;
return(result);
}
public static MailCommandDataSet GetMailCommandDataSet()
{
MailCommandDataSet result = new MailCommandDataSet();
string filePath = Helper.GetMailCommandListFileName();
result.ReadXml(filePath);
return(result);
}