private void WriteFailed(DbCommand sp, FailedEmailDto email)
{
_dbLayer.AddParameter(sp, "@questionnaire_FK", ParameterDirection.Input, DbType.Int32, email.QuestionnaireFK);
_dbLayer.AddParameter(sp, "@email_text", ParameterDirection.Input, DbType.String,email.EmailText);
_dbLayer.AddParameter(sp, "@email_format", ParameterDirection.Input, DbType.String, email.EmailFormat);
}
private FailedEmailDto ReadFailed(IDataReader reader, ref bool alreadyRead)
{
FailedEmailDto retval = null;
int questionnaireFK = reader.GetInt32(0);
string emailText = reader.GetString(1);
DateTime failureDate = reader.GetDateTime(2);
string emailFormat = reader.GetString(3);
retval = new FailedEmailDto((long)questionnaireFK, emailText, failureDate, emailFormat);
return retval;
}
public void CreateFailedEmail(FailedEmailDto email)
{
DbCommand sp = null;
DbConnection connection = null;
IDataReader reader = null;
try
{
connection = _dbLayer.GetConnection();
sp = connection.CreateCommand();
sp.CommandText = "insert_failed_email";
sp.CommandType = CommandType.StoredProcedure;
WriteFailed(sp, email);
_dbLayer.AddReturnParameter(sp);
sp.ExecuteNonQuery();
int code = _dbLayer.GetReturnValue(sp);
if (code < 0)
{
Trace.WriteLine("EmailDao.CreateFailedEmail(" + email + "): returned " + code);
throw new Exception(code.ToString());
}
else
{
Trace.WriteLine("EmailDao.CreateFailedEmail(" + email + "): returned " + code);
}
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
if (sp != null)
{
sp.Dispose();
}
if (connection != null)
{
_dbLayer.ReturnConnection(connection);
}
else
{
_dbLayer.ReturnConnection(connection, true);
}
}
}
